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(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 listSource = EntityHelper.GetData( "com.steering.pss.crm.server.CrmMatZcServer.Query", new object[] { judgeStoveNo, startDate, endDate }, this.ob); crmMatZcEntityBindingSource.DataSource = listSource; } private void updateIsFlag() { this.ultraGrid1.UpdateData(); IQueryable 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(); } } } }