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; using CoreFS.CA06; using Core.Mes.Client.Comm.Tool; using com.steering.pss.plnsaleord.order.model; using System.Collections; using Core.Mes.Client.Comm.Control; using Infragistics.Win.UltraWinGrid; using Core.Mes.Client.Comm.Server; using Core.Mes.Client.Comm; namespace Core.StlMes.Client.PlnSaleOrd { public partial class FrmPlnOrdCraftModifyLog : FrmBase { public FrmPlnOrdCraftModifyLog() { this.IsLoadUserView = true; InitializeComponent(); EntityHelper.ShowGridCaption(ultraGridLog.DisplayLayout.Bands[0]); System.Threading.Thread t = new System.Threading.Thread(setGridColunmName); t.Start(); } private void setGridColunmName() { System.Threading.Thread.Sleep(3000); if (!this.IsDisposed) { EntityHelper.ShowGridCaption(ultraGridLog.DisplayLayout.Bands[0]); } } /// /// 系统菜单 /// /// /// public override void ToolBar_Click(object sender, string ToolbarKey) { base.ToolBar_Click(sender, ToolbarKey); switch (ToolbarKey) { case "Query": DoQuery(); break; case "Delete": DoDelete(); break; case "Export": DoExport(); break; case "Close": //关闭 this.Close(); break; } } private void FrmPlnOrdCraftModifyLog_Load(object sender, EventArgs e) { ultraDateTimeDayFrom.Value = DateTime.Now.AddMonths(-1); ultraDateTimeDayBackTo.Value = DateTime.Now; PlanComm.setGridActivation(this.ultraGridLog.DisplayLayout.Bands[0], "CHC"); } /// /// 查询 /// private void DoQuery() { ArrayList ary = new ArrayList(); if (ultraCheckEditorOrdNo.Checked) { ary.Add(ultraTextEditorOrdNo.Text.Trim().ToUpper()); } else { ary.Add(""); } if (this.ultraCheckEditorCraft.Checked) { ary.Add(this.ultraTextEditorCraft.Text.Trim()); } else { ary.Add(""); } if (this.ultraCheckEditorDate.Checked) { if (ultraDateTimeDayFrom.DateTime > ultraDateTimeDayFrom.DateTime) { MessageUtil.ShowError("查询日期区间有误,请重新选择!"); return; } ary.Add(this.ultraDateTimeDayFrom.DateTime.ToString("yyyy-MM-dd")); ary.Add(this.ultraDateTimeDayBackTo.DateTime.ToString("yyyy-MM-dd")); } else { ary.Add("1000-01-01"); ary.Add("9999-12-31"); } bindingSourceCraftLog.DataSource = EntityHelper.GetData( "com.steering.pss.plnsaleord.order.CorePlnOrdCraftModifyLog.queryCraftLog", new object[] { ary }, this.ob); } /// /// 删除日志 /// private void DoDelete() { try { ultraGridLog.UpdateData(); ArrayList list = new ArrayList(); IQueryable checkRows = this.ultraGridLog.Rows.AsQueryable().Where(" CHC = 'True' "); if (checkRows.Count() == 0) { MessageUtil.ShowTips("未勾选任何记录!"); return; } foreach (UltraGridRow uRow in checkRows) { list.Add(uRow.Cells["CrfEditLogId"].Value.ToString()); } if (list.Count <= 0) { return; } if (ServerHelper.SetData("com.steering.pss.plnsaleord.order.CorePlnOrdCraftModifyLog.deleteCraftLog", new object[] { list }, this.ob) > 0) { MessageUtil.ShowTips("删除成功!"); } else { MessageUtil.ShowTips("删除失败!"); } } catch (Exception ex) { if (!(ex is MESException)) { MessageBox.Show(ex.Message); } } DoQuery(); } /// /// 导出 /// private void DoExport() { GridHelper.ulGridToExcel(ultraGridLog, "工艺变更记录"); } #region private void ultraCheckEditorDate_CheckedChanged(object sender, EventArgs e) { if (ultraCheckEditorDate.Checked) { ultraDateTimeDayFrom.Enabled = true; ultraDateTimeDayBackTo.Enabled = true; } else { ultraDateTimeDayFrom.Enabled = false; ultraDateTimeDayBackTo.Enabled = false; } } private void ultraCheckEditorOrdNo_CheckedChanged(object sender, EventArgs e) { if (ultraCheckEditorOrdNo.Checked) { ultraTextEditorOrdNo.Enabled = true; } else { ultraTextEditorOrdNo.Enabled = false; } } private void ultraCheckEditorCraft_CheckedChanged(object sender, EventArgs e) { if (ultraCheckEditorCraft.Checked) { this.ultraTextEditorCraft.Enabled = true; } else { ultraTextEditorCraft.Enabled = false; } } private void ultraDateTimeDayFrom_ValueChanged(object sender, EventArgs e) { ultraDateTimeDayBackTo.MinDate = ultraDateTimeDayFrom.DateTime.Date; } private void ultraDateTimeDayBackTo_ValueChanged(object sender, EventArgs e) { ultraDateTimeDayFrom.MaxDate = ultraDateTimeDayBackTo.DateTime.AddDays(1).Date.AddSeconds(-1); } private void ultraGridLog_AfterSelectChange(object sender, AfterSelectChangeEventArgs e) { foreach (UltraGridRow uRow in ultraGridLog.Selected.Rows) { if (uRow.GetType() != typeof(Infragistics.Win.UltraWinGrid.UltraGridGroupByRow)) { uRow.Cells["CHC"].Value = true; } } } #endregion } }