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 Core.Mes.Client.Comm.Server; using CoreFS.CA06; using System.Collections; using Core.Mes.Client.Comm.Control; using Infragistics.Win.UltraWinGrid; using Core.Mes.Client.Comm.Tool; using Core.StlMes.Client.Mcp.Control; namespace Core.StlMes.Client.Mcp.Report { public partial class FrmJGMatNoReport : FrmBase { public FrmJGMatNoReport() { InitializeComponent(); this.IsLoadUserView = true; } private void FrmJGMatNoReport_Load(object sender, EventArgs e) { DateTime t = DateTime.Now; DateTime t1 = new DateTime(t.Year, t.Month, 1); RegStartTime.Value = DateTime.Parse(t1.ToString("yyyy-MM-dd 00:00:00")); RegEndTime.Value = DateTime.Parse(t1.AddMonths(1).AddDays(-1).ToString("yyyy-MM-dd 23:59:59")); //框号 DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.Report.FrmJGMatNoReport.getKepNo", null, this.ob); cmbMaterial.DataSource = dt; cmbMaterial.DisplayMember = "KEP_NO"; PipeManageClass.SetComboItemHeight(cmbMaterial); String[] str = this.ValidDataPurviewIds; ArrayList arList = new ArrayList(); //获取用户对应科室ID string User = this.UserInfo.GetDeptid(); string StorageType = "";//根据传递的参数获取仓库类别 string StorageAttr = "";////根据传递的参数获取仓库类型 if (CustomInfo != "") { string[] strflg = CustomInfo.ToString().Split(new char[] { ',' }); StorageType = strflg[0]; StorageAttr = strflg[1]; } DataTable dt1 = ServerHelper.GetData("com.steering.mes.mcp.common.WarehousePermissions.getStoreNo", new object[] { StorageType, StorageAttr, str }, this.ob); cmbWarehous.DataSource = dt1; cmbWarehous.DisplayMember = "STORAGE_NAME"; cmbWarehous.ValueMember = "STORAGE_NO"; PipeManageClass.SetComboItemHeight(cmbWarehous); } public override void ToolBar_Click(object sender, string ToolbarKey) { switch (ToolbarKey) { case "Query": doQuery(); break; case "Export": GridHelper.ulGridToExcel(ultraGrid1, "库存信息"); break; case "Close": this.Close(); break; } } /// /// 查询 /// private void doQuery() { if (!CheckQuery()) return; string strRegStart = ""; string strRegEnd = ""; string strWare = "";//仓库号 //string strMat = "";//框号 string strFurnace = "";//炉号 string strBatch = "";//批号 string strWoid = "";//工单号 ArrayList pram = new ArrayList(); if (chkWarehous.Checked) { strWare = cmbWarehous.Value.ToString(); } //if (chkMaterial.Checked) //{ // strMat = cmbMaterial.Value.ToString(); //} if (chkRegTime.Checked) { strRegStart = RegStartTime.Value.ToString(); strRegEnd = RegEndTime.Value.ToString(); } if (chkFurnace.Checked) { strFurnace = txtFurnace.Text.Trim(); } if (chkBatch.Checked) { strBatch = txtBatch.Text.Trim(); } if (chkWoid.Checked) { strWoid = txtWoid.Text.Trim(); } pram.Add(strWare); pram.Add(""); pram.Add(strFurnace); pram.Add(strRegStart); pram.Add(strRegStart); pram.Add(strRegStart); pram.Add(strRegEnd); pram.Add(strRegEnd); pram.Add(strBatch); pram.Add(strWoid); DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.Report.FrmJGMatNoReport.doQueryInfoResult", new object[] { pram }, ob); GridHelper.CopyDataToDatatable(dt, this.dateMat, true); } private void chkRegTime_CheckedChanged(object sender, EventArgs e) { if (chkBatch.Checked) { txtBatch.Enabled = true; } else { txtBatch.Enabled = false; } if (chkWoid.Checked) { txtWoid.Enabled = true; } else { txtWoid.Enabled = false; } if (chkWarehous.Checked) { cmbWarehous.Enabled = true; } else { cmbWarehous.Enabled = false; } if (chkMaterial.Checked) { cmbMaterial.Enabled = true; } else { cmbMaterial.Enabled = false; } if (chkFurnace.Checked) { txtFurnace.Enabled = true; } else { txtFurnace.Enabled = false; } if (chkRegTime.Checked) { RegStartTime.Enabled = true; RegEndTime.Enabled = true; } else { RegStartTime.Enabled = false; RegEndTime.Enabled = false; } } ///查询时验证必填项 private bool CheckQuery() { if (DataTimeUtil.JudgeTime(DateTime.Parse(RegStartTime.Value.ToString()), DateTime.Parse(RegEndTime.Value.ToString())) == 0) { MessageUtil.ShowTips("开始时间不能大于结束时间!"); return false; } if (chkFurnace.Checked && string.IsNullOrEmpty(txtFurnace.Text.Trim())) { MessageBox.Show("请输入炉号!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return false; } if (chkBatch.Checked && string.IsNullOrEmpty(txtBatch.Text.Trim())) { MessageBox.Show("请输入批号!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return false; } if (chkWoid.Checked && string.IsNullOrEmpty(txtWoid.Text.Trim())) { MessageBox.Show("请输入工单号!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return false; } if (chkWarehous.Checked && string.IsNullOrEmpty(cmbWarehous.Text.Trim())) { MessageBox.Show("请选择仓库号!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return false; } if (chkMaterial.Checked && string.IsNullOrEmpty(cmbMaterial.Text.Trim())) { MessageBox.Show("请选择框号!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return false; } return true; } } }