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

using Core.Mes.Client.Comm.Control;
using Core.Mes.Client.Comm.Tool;
using Core.StlMes.Client.YdmBcPipeManage.Entity;
using CoreFS.CA06;
using Infragistics.Win.UltraWinGrid;
using System;
using System.Collections;
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 FrmCrmMatZc : FrmBase
    {
        public FrmCrmMatZc()
        {
            InitializeComponent();
            EntityHelper.ShowGridCaption<CrmMatZcEntity>(ultraGrid1.DisplayLayout.Bands[0]);
            IsLoadUserView = true;
            //startDateTime.DateTime = startDateTime.DateTime.AddDays(-7.0);
        }

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

        private void doQuery()
        {
            String judgeStoveNo = "";
            String startDate = "";
            String endDate = "";
            if (judgeStoveNoCheck.Checked)
            {
                judgeStoveNo = judgeStoveNoText.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<CrmMatZcEntity> listSource = EntityHelper.GetData<CrmMatZcEntity>(
                "com.steering.pss.crm.server.CrmMatZcServer.Query", new object[] { judgeStoveNo, startDate, endDate }, this.ob);
            crmMatZcEntityBindingSource.DataSource = listSource;
        }

        private void updateIsFlag()
        {
            this.ultraGrid1.UpdateData();
            IQueryable<UltraGridRow> checkRows = this.ultraGrid1.Rows.AsQueryable().Where(a => a.GetValue("CHK") == "True");
            if (checkRows.Count() == 0)
            {
                MessageUtil.ShowTips("请选择数据!");
                return;
            }
            ArrayList list = new ArrayList();
            foreach (UltraGridRow row in checkRows)
            {
                CrmMatZcEntity entity = row.ListObject as CrmMatZcEntity;
                if (!"产销数据问题".Equals(entity.IsFlag) && !"crm数据问题".Equals(entity.IsFlag))
                {
                    MessageUtil.ShowTips("非数据问题的数据，无法修改状态!");
                    return;
                }
                list.Add(new object[] { entity.InitialId });
            }
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.crm.server.CrmMatZcServer";
            ccp.MethodName = "updateIsFlag";
            ccp.ServerParams = new object[] { list };
            ccp.IfShowErrMsg = false;
            ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp != null)
            {
                if (ccp.ReturnCode == -1)
                {
                    MessageUtil.ShowWarning(ccp.ReturnInfo);
                    return;
                }
                MessageUtil.ShowTips("修改成功！");
                doQuery();
            }

        }
    }
}