/// <summary>根据领料单号查询领料单信息 /// 根据领料单号查询领料单信息 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void smbSelect_Click(object sender, EventArgs e) { MaterialReqOrReturnEntity materialReqOrReturnEntity = new MaterialReqOrReturnEntity(); string _numForSelect = txtNumForSelect.Text.Trim(); DataTable dtRequistion = new DataTable(); DataTable dtRequistionDetail = new DataTable(); if (string.IsNullOrEmpty(_numForSelect)) { //MessageBox.Show("领料单号不能为空!","系统错误提示"); MessageBox.Show(StringParser.Parse("${res:FanHai.Hemera.Addins.MaterialRequisitionCtrl.msg.0015}"), StringParser.Parse("${res:Global.SystemInfo}")); return; } //判定是否存在领料单号 DataSet dsCheckNum = materialReqOrReturnEntity.GetCountByNumToCheck(_numForSelect, 1); if (Convert.ToInt32(dsCheckNum.Tables[0].Rows[0]["COUNT"].ToString()) < 1) { //MessageBox.Show("不存在该领料单号请重新输入!", "系统错误提示"); MessageBox.Show(StringParser.Parse("${res:FanHai.Hemera.Addins.MaterialRequisitionCtrl.msg.0016}"), StringParser.Parse("${res:Global.SystemInfo}")); return; } DataSet dsMaterialRequisitionInf = materialReqOrReturnEntity.GetMatRequisitionInfByNum(_numForSelect); if (dsMaterialRequisitionInf != null || dsMaterialRequisitionInf.Tables.Count > 0) { dtRequistion = dsMaterialRequisitionInf.Tables["WST_STORE_MATERIAL_REQUISITION"]; dtRequistionDetail = dsMaterialRequisitionInf.Tables["WST_STORE_MATERIAL_REQUISITION_DETAIL"]; if (dtRequistion.Rows.Count > 0 && dtRequistionDetail.Rows.Count > 0) { string status = GetStatus(dtRequistion.Rows[0]["STATUS"].ToString()); txtNum.Text = dtRequistion.Rows[0]["MBLNR"].ToString(); lueFactoryRoom.EditValue = dtRequistion.Rows[0]["FACTORYKEY"].ToString(); lueFactoryRoom.Text = dtRequistion.Rows[0]["FACTORYNAME"].ToString(); lueOperation.Text = dtRequistion.Rows[0]["PROCESS"].ToString(); lueStoreName.EditValue = dtRequistion.Rows[0]["STORE_KEY"].ToString(); lueStoreName.Text = dtRequistion.Rows[0]["STORE_NAME"].ToString(); lueWorkOrderNo.Text = dtRequistion.Rows[0]["AUFNR"].ToString(); txtCreator.Text = dtRequistion.Rows[0]["CREATOR"].ToString(); tetCreateTime.EditValue = dtRequistion.Rows[0]["CREATE_TIME"].ToString(); txtStatus.Text = status; for (int i = 0; i < dtRequistionDetail.Rows.Count; i++) { dtRequistionDetail.Rows[i]["ROWNUMBER"] = i + 1; } gcInf.DataSource = dtRequistionDetail; if (status.Equals("已创建")) { _status = "Select"; } else { _status = "Pass"; } Status(_status); } } }
/// <summary> 插入数据到界面数据清单表中 /// 插入数据到界面数据清单表中 /// </summary> private void GetInfToGvlist() { MaterialReqOrReturnEntity materialReqOrReturnEntity = new MaterialReqOrReturnEntity(); string _workOrder = lueWorkOrderNo.Text.Trim(); string _mat = lueMaterialCode.Text.Trim(); string _matDesc = txtMaterialDescription.Text.Trim(); string _qty = txtIssueQty.Text.Trim(); string _unit = txtUnit.Text.Trim(); string _supplier = lueSupplierName.Text.Trim(); string _creator = txtCreator.Text.Trim(); DataTable dtSource = gcInf.DataSource as DataTable; string _memo = txtMemo.Text.Trim(); DataTable dt = new DataTable(); if (dtSource == null) { DataSet dsMaterialRequisitionInf = materialReqOrReturnEntity.GetMatRequisitionInfByNum(""); if (dsMaterialRequisitionInf != null || dsMaterialRequisitionInf.Tables.Count > 0) { dt = dsMaterialRequisitionInf.Tables["WST_STORE_MATERIAL_REQUISITION_DETAIL"].Clone(); } } else { dt = dtSource.Clone(); } DataRow dr = dt.NewRow(); dr["AUFNR"] = _workOrder; dr["MATNR"] = _mat; dr["MATXT"] = _matDesc; dr["QTY"] = _qty; dr["ERFME"] = _unit; dr["LLIEF"] = _supplier; dr["MEMO"] = _memo; dr["CREATOR"] = _creator; dt.Rows.Add(dr); if (dtSource == null) { dtSource = dt; } else { dtSource.Merge(dt, true); } int j = 1; for (int i = 0; i < dtSource.Rows.Count; i++) { if (dtSource.Rows[i].RowState != DataRowState.Deleted && dtSource.Rows[i].RowState != DataRowState.Detached) { dtSource.Rows[i]["ROWNUMBER"] = j.ToString(); j++; } } gcInf.DataSource = dtSource; lueMaterialCode.Select(); lueMaterialCode.SelectAll(); lueFactoryRoom.Properties.ReadOnly = true; lueOperation.Properties.ReadOnly = true; lueStoreName.Properties.ReadOnly = true; lueWorkOrderNo.Properties.ReadOnly = true; }