using Core.Mes.Client.Comm.Control; using Core.Mes.Client.Comm.Server; using Core.Mes.Client.Comm.Tool; using Core.StlMes.Client.YdmPipeManage.Tool; using Core.StlMes.Client.YdmPipeReport.Entity; using Core.StlMes.Client.YdmPipeReport.Tool; using CoreFS.CA06; 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.YdmPipeReport { public partial class FrmMatResume : FrmBase { public FrmMatResume() { InitializeComponent(); } private void FrmMatResume_Load(object sender, EventArgs e) { DateTime now = DateTime.Now; DateTime dt1 = new DateTime(now.Year, now.Month, 1);//当月第一天 DateTime dt2 = dt1.AddMonths(1).AddDays(-1);//当月最后一天 StartTime.Value = DateTime.Parse(dt1.ToString("yyyy-MM-dd") + " 00:00:00"); EndTime.Value = DateTime.Parse(dt2.ToString("yyyy-MM-dd") + " 23:59:59"); EntityHelper.ShowGridCaption(ultraGrid1.DisplayLayout.Bands[0]); //字段显示格式 BaseHelper.setUltraGridColumnMaxInput(ultraGrid1, new string[] { "ACT_WEIGHT", "ACT_LEN" }); BaseHelper.setUltraGridColumnCountInput(ultraGrid1, new string[] { "ACT_COUNT" }); //材料类别 DataTable dtProducFlag = ServerHelper.GetData("com.steering.pss.ydm.pipemanage.FrmPipeMagement.queryMaterialSTyle", new object[] { }, ob); if (dtProducFlag.Rows.Count > 0) { Object[] obj = new Object[] { "", "" }; DataRow dr = dtProducFlag.NewRow(); dr.ItemArray = obj; dtProducFlag.Rows.InsertAt(dr, 0); } BaseMethod.InitComboEditor(TxtProductFlag, dtProducFlag, "BASENAME", "BASECODE"); BaseMethod.InitComboEditor(proFalg, dtProducFlag, "BASENAME", "BASECODE"); BaseHelper.SetComboItemHeight(TxtProductFlag); //材料状态 DataTable dtMagstatus = ServerHelper.GetData("com.steering.pss.ydm.Report.FrmMatResume.queryMaterialStatusflag", null, ob); if (dtMagstatus.Rows.Count > 0) { Object[] obj = new Object[] { "", "" }; DataRow dr = dtMagstatus.NewRow(); dr.ItemArray = obj; dtMagstatus.Rows.InsertAt(dr, 0); } BaseMethod.InitComboEditor(TxtMagstatus, dtMagstatus, "BASENAME", "BASECODE"); BaseMethod.InitComboEditor(matFalg, dtMagstatus, "BASENAME", "BASECODE"); BaseHelper.SetComboItemHeight(TxtMagstatus); } public override void ToolBar_Click(object sender, string ToolbarKey) { switch (ToolbarKey) { case "DoQuery": DoQuery(); break; case "Export"://导出 GridHelper.ulGridToExcel(ultraGrid1, "库存履历报表"); break; case "DoClose": this.Close(); break; } } /// /// 查询 /// private void DoQuery() { if (!QueryValure()) return; string Start = "1900-01-01 00:00:00"; string End = "9900-01-01 00:00:00"; string ordNo = ""; string juNo = ""; string bejNo = ""; string proFlag = ""; string matFlag = ""; string fillFlag = ""; if (chkDate.Checked) { Start = StartTime.Value.ToString(); End = EndTime.Value.ToString(); } if (chkOrder.Checked) { ordNo = cmbOrder.Text.ToString(); } if (chkJudge.Checked) { juNo = cmbJudge.Text.ToString(); } if (chkDepartMent.Checked) { bejNo = cmbDepartMent.Value.ToString(); } if (chkProductFlag.Checked) { if (TxtProductFlag.Text != "") { proFlag = TxtProductFlag.Value.ToString(); } } if (chkMatstatus.Checked) { if (TxtMagstatus.Text != "") { matFlag = TxtMagstatus.Value.ToString(); } } if (chkFill.Checked) { fillFlag = cmbFillFalg.Value.ToString(); } ArrayList list = new ArrayList(); list.Add(Start); list.Add(End); list.Add(ordNo); list.Add(juNo); list.Add(bejNo); list.Add(proFlag); list.Add(matFlag); list.Add(fillFlag); string supplyUnit = this.CustomInfo; List listSource = EntityHelper.GetData( "com.steering.pss.ydm.Report.FrmMatResume.doQuery", new object[] { list , supplyUnit }, this.ob); MatZcTrackEntitySource1.DataSource = listSource; // GridHelper.RefreshAndAutoSize(ultraGrid1); } private void TxtProductFlag_ValueChanged(object sender, EventArgs e) { if (TxtProductFlag.Text == "") { DataTable dtMagstatus = ServerHelper.GetData("com.steering.pss.ydm.Report.FrmMatResume.queryMaterialStatusflag", null, ob); if (dtMagstatus.Rows.Count > 0) { Object[] obj = new Object[] { "", "" }; DataRow dr = dtMagstatus.NewRow(); dr.ItemArray = obj; dtMagstatus.Rows.InsertAt(dr, 0); } BaseMethod.InitComboEditor(TxtMagstatus, dtMagstatus, "BASENAME", "BASECODE"); BaseHelper.SetComboItemHeight(TxtMagstatus); } else { string value = TxtProductFlag.Value.ToString(); DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.pipemanage.FrmPipeInventoryIn.getmagStatus", new object[] { value }, this.ob); if (dt.Rows.Count > 0) { Object[] obj = new Object[] { "", "" }; DataRow dr = dt.NewRow(); dr.ItemArray = obj; dt.Rows.InsertAt(dr, 0); } BaseMethod.InitComboEditor(TxtMagstatus, dt, "BASENAME", "BASECODE"); BaseHelper.SetComboItemHeight(TxtMagstatus); } } private void chkDate_CheckedChanged(object sender, EventArgs e) { if (chkDate.Checked) { StartTime.Enabled = true; EndTime.Enabled = true; } else { StartTime.Enabled = false; EndTime.Enabled = false; } if (chkOrder.Checked) { cmbOrder.Enabled = true; } else { cmbOrder.Enabled = false; } if (chkJudge.Checked) { cmbJudge.Enabled = true; } else { cmbJudge.Enabled = false; } if (chkDepartMent.Checked) { cmbDepartMent.Enabled = true; } else { cmbDepartMent.Enabled = false; } if (chkProductFlag.Checked) { TxtProductFlag.Enabled = true; } else { TxtProductFlag.Enabled = false; } if (chkMatstatus.Checked) { TxtMagstatus.Enabled = true; } else { TxtMagstatus.Enabled = false; } if (chkFill.Checked) { cmbFillFalg.Enabled = true; } else { cmbFillFalg.Enabled = false; } } private bool QueryValure() { if (DataTimeUtil.JudgeTime(DateTime.Parse(StartTime.Value.ToString()), DateTime.Parse(EndTime.Value.ToString())) == 0) { MessageUtil.ShowTips("您所选择的日期区域不对,请重新选择!"); return false; } if (chkOrder.Checked && string.IsNullOrEmpty(cmbOrder.Text.Trim())) { MessageBox.Show("请输入合同号!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return false; } if (chkJudge.Checked && string.IsNullOrEmpty(cmbJudge.Text.Trim())) { MessageBox.Show("请输入炉号!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return false; } if (chkDepartMent.Checked && string.IsNullOrEmpty(cmbDepartMent.Text.Trim())) { MessageBox.Show("请选择销售组织!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return false; } if (chkFill.Checked && string.IsNullOrEmpty(cmbFillFalg.Text.Trim())) { MessageBox.Show("请选择是否补量!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return false; } return true; } } }