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 System.Collections; using Infragistics.Win.UltraWinGrid; using Infragistics.Win; using CoreFS.CA06; using CoreFS.SA06; using Core.Mes.Client.Comm.Server; using Core.Mes.Client.Comm.Control; using Core.Mes.Client.Comm; namespace Core.StlMes.Client.Plan.Order { /// /// 合同撤消接收日志查询界面 /// @author:杨天海 /// @version:v1.1 /// @date:2015.06.22 /// public partial class FrmSaleOrderlog : FrmBase { public FrmSaleOrderlog() { InitializeComponent(); } private void checkBoxForReqDELVRY_EDATE_CheckedChanged(object sender, EventArgs e) { if (checkBoxForReqDELVRY_EDATE.Checked) { ctrlForQueryDELVRY_EDATEFrom.Enabled = true; ctrlForQueryDELVRY_EDATETo.Enabled = true; } else { ctrlForQueryDELVRY_EDATEFrom.Enabled = false; ctrlForQueryDELVRY_EDATETo.Enabled = false; } } private void checkBoxForReqORDER_NO_CheckedChanged(object sender, EventArgs e) { if (checkBoxForReqORDER_NO.Checked) { ctrlForQueryORDER_NO.Enabled = true; } else { ctrlForQueryORDER_NO.Enabled = false; } } private void ctrlForQueryDELVRY_EDATEFrom_ValueChanged(object sender, EventArgs e) { ctrlForQueryDELVRY_EDATETo.MinDate = ctrlForQueryDELVRY_EDATEFrom.DateTime.Date; } private void ctrlForQueryDELVRY_EDATETo_ValueChanged(object sender, EventArgs e) { ctrlForQueryDELVRY_EDATEFrom.MaxDate = ctrlForQueryDELVRY_EDATETo.DateTime.AddDays(1).Date.AddSeconds(-1); } /// /// 初始化加载 /// /// /// private void FrmSaleOrderlog_Load(object sender, EventArgs e) { ctrlForQueryDELVRY_EDATEFrom.Value = DateTime.Now.AddMonths(-1); ctrlForQueryDELVRY_EDATETo.Value = DateTime.Now; ultraDateTimeDayBack.Value = DateTime.Now.AddMonths(-1); ultraDateTimeDayBackTo.Value = DateTime.Now; doQuery(); } /// /// 系统菜单 /// /// /// public override void ToolBar_Click(object sender, string ToolbarKey) { base.ToolBar_Click(sender, ToolbarKey); switch (ToolbarKey) { case "Query": doQuery(); break; case "Delete": Delete(); break; case "Export": doExport(); break; case "Close": //关闭 this.Close(); break; } } /// /// 查询 /// private void doQuery() { try { ArrayList param = new ArrayList(); string strDayback = "1000/01/01"; //退回日期 string strDaybackTo = "9999/12/3"; //退回日期 string strOrderNo = ""; //合同号 string strDateForm = "1000/01/01"; //交货结束日期从,默认最小日期 string strDateTo = "9999/12/31"; //交货结束日期到,默认最大日期 if (checkBoxDayBack.Checked) { strDayback = ultraDateTimeDayBack.DateTime.ToString("yyyy/MM/dd"); strDaybackTo = ultraDateTimeDayBackTo.DateTime.ToString("yyyy/MM/dd"); } if (checkBoxForReqORDER_NO.Checked) { strOrderNo = ctrlForQueryORDER_NO.Text.Trim(); } if (checkBoxForReqDELVRY_EDATE.Checked) { if (ctrlForQueryDELVRY_EDATEFrom.DateTime > ctrlForQueryDELVRY_EDATETo.DateTime) { Core.Mes.Client.Comm.Tool.MessageUtil.ShowError("查询日期区间有误,请重新选择!"); return; } strDateForm = ctrlForQueryDELVRY_EDATEFrom.DateTime.ToString("yyyy/MM/dd"); strDateTo = ctrlForQueryDELVRY_EDATETo.DateTime.ToString("yyyy/MM/dd"); } param.Add(strDayback); param.Add(strDaybackTo); param.Add(strOrderNo); param.Add(strDateForm); param.Add(strDateTo); DataTable dt = ServerHelper.GetData("com.steering.pss.plan.order.CoreSaleOrderOP.queryCancelLog", new object[] { param }, this.ob); GridHelper.CopyDataToDatatable(dt, dataTable1, true); PlanComm.setGridActivation(ultraGrid1.DisplayLayout.Bands[0], "CHECK"); } catch (Exception ex) { if (ex is MESException) { MessageBox.Show(((MESException)ex).ExceptionInfo); } else { MessageBox.Show(ex.Message); } } } /// /// 删除日志 /// private void Delete() { try { bool isChecked = false; ArrayList list = new ArrayList(); foreach (UltraGridRow uRow in ultraGrid1.Rows) { if (Convert.ToBoolean(uRow.Cells["CHECK"].Text)) { ArrayList param = new ArrayList(); isChecked = true; param.Add(uRow.Cells["BACKLOG_ID"].Value.ToString()); list.Add(param); } } ///如果没有勾选预处理的条目,提示。 if (!isChecked) { Core.Mes.Client.Comm.Tool.MessageUtil.ShowTips("未勾选条目,请重新选择!"); return; } if (ServerHelper.SetData("com.steering.pss.plan.order.CoreSaleOrderOP.updateDeletelog", new object[] { list }, this.ob) > 0) { Core.Mes.Client.Comm.Tool.MessageUtil.ShowTips("删除成功!"); } else { Core.Mes.Client.Comm.Tool.MessageUtil.ShowTips("删除失败!"); } } catch (Exception ex) { if (ex is MESException) { MessageBox.Show(((MESException)ex).ExceptionInfo); } else { MessageBox.Show(ex.Message); } } doQuery(); } /// /// 导出 /// private void doExport() { GridHelper.ulGridToExcel(ultraGrid1, "销售合同回退日志"); } private void checkBoxDayBack_CheckedChanged(object sender, EventArgs e) { if (checkBoxDayBack.Checked) { ultraDateTimeDayBack.Enabled = true; ultraDateTimeDayBackTo.Enabled = true; } else { ultraDateTimeDayBack.Enabled = false; ultraDateTimeDayBackTo.Enabled = false; } } private void ultraDateTimeDayBack_ValueChanged(object sender, EventArgs e) { ultraDateTimeDayBackTo.MinDate = ultraDateTimeDayBack.DateTime.Date; } private void ultraDateTimeDayBackTo_ValueChanged(object sender, EventArgs e) { ultraDateTimeDayBack.MaxDate = ultraDateTimeDayBackTo.DateTime.AddDays(1).Date.AddSeconds(-1); } private void ultraGrid1_AfterSelectChange(object sender, AfterSelectChangeEventArgs e) { foreach (UltraGridRow uRow in ultraGrid1.Selected.Rows) { if (uRow.GetType() != typeof(Infragistics.Win.UltraWinGrid.UltraGridGroupByRow)) { uRow.Cells["CHECK"].Value = true; } } } } }