MES_Client/TGMES/Core.StlMes.Client.YdmBcPipeManage/CRM数据查询/FrmCrmBsStorageServer.cs

using Core.Mes.Client.Comm.Control;
using Core.Mes.Client.Comm.Tool;
using Core.StlMes.Client.YdmBcPipeManage.Entity;
using CoreFS.CA06;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace Core.StlMes.Client.YdmBcPipeManage
{
    public partial class FrmCrmBsStorageServer : FrmBase
    {
        public FrmCrmBsStorageServer()
        {
            InitializeComponent();
            EntityHelper.ShowGridCaption<CrmBsStorageEntity>(ultraGrid1.DisplayLayout.Bands[0]);
            IsLoadUserView = true;
        }

        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "Query":
                    doQuery();
                    break;
                case "Export":
                    doExport();
                    break;
                case "Close":
                    this.Close();
                    break;
            }
        }
        private void doExport()
        {
            GridHelper.ulGridToExcel(ultraGrid1, "crm仓库信息");
        }

        private void doQuery()
        {
            String storageName = "";
            String startDate = "";
            String endDate = "";
            if (judgeStoveNoCheck.Checked)
            {
                storageName = storageNameText.Text;
            }
            if (crateDateCheck.Checked)
            {
                startDate = startDateTime.DateTime.ToString("yyyy-MM-dd") + " 00:00:00"; ;
                endDate = endDateTime.DateTime.ToString("yyyy-MM-dd") + " 23:59:59";
            }
            //if (!judgeStoveNoCheck.Checked && !crateDateCheck.Checked)
            //{
            //    MessageUtil.ShowTips("请选择至少一个筛选条件！");
            //    return;
            //}
            //TimeSpan ts1 = new TimeSpan(DateTime.ParseExact(startDateTime.DateTime.ToString("yyyy-MM-dd"), "yyyy-MM-dd", System.Globalization.CultureInfo.CurrentCulture).Ticks);
            //TimeSpan ts2 = new TimeSpan(DateTime.ParseExact(endDateTime.DateTime.ToString("yyyy-MM-dd"), "yyyy-MM-dd", System.Globalization.CultureInfo.CurrentCulture).Ticks);
            //if (ts2.Subtract(ts1).Days > 7)
            //{
            //    MessageUtil.ShowTips("最大查询7天的数据！");
            //    return;
            //}
            List<CrmBsStorageEntity> listSource = EntityHelper.GetData<CrmBsStorageEntity>(
                "com.steering.pss.crm.server.CrmBsStorageServer.Query", new object[] { storageName, startDate, endDate }, this.ob);
            crmBsStorageEntityBindingSource.DataSource = listSource;
        }
    }
}