/// <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> /// <param name="sender"></param> /// <param name="e"></param> private void sbtRowAdd_Click(object sender, EventArgs e) { //1.检查栏位数据信息 //2.检查是否重复:同工单,同料号,同批次号 //3.插入数据到界面数据清单表中 bool _bool = CheckParameter();//1.检查栏位数据信息 if (_bool == false) { return; } //判定是否存在领料单号 MaterialReqOrReturnEntity materialReqOrReturnEntity = new MaterialReqOrReturnEntity(); DataSet dsCheckNum = materialReqOrReturnEntity.GetCountByNumToCheck(txtNum.Text.Trim(), 0); if (_status == "New") { if (Convert.ToInt32(dsCheckNum.Tables[0].Rows[0]["COUNT"].ToString()) > 0) { //MessageBox.Show("已经存在该领料单号请重新输入!", "系统错误提示"); MessageBox.Show(StringParser.Parse("${res:FanHai.Hemera.Addins.ReturnMaterialCtrl.msg.0001}"), StringParser.Parse("${res:Global.SystemInfo}")); return; } } if (Convert.ToDecimal(txtSum.Text.Trim()) < Convert.ToDecimal(txtIssueQty.Text.Trim())) { //MessageBox.Show("退料数量不能大于线上仓总量!", "系统提示"); MessageBox.Show(StringParser.Parse("${res:FanHai.Hemera.Addins.ReturnMaterialCtrl.msg.0002}"), StringParser.Parse("${res:Global.SystemInfo}")); return; } if (_bool == false) { return; } //2.判断新增数据是否在列表中有重复? DataTable dtSource = this.gcInf.DataSource as DataTable; if (dtSource != null) { DataRow[] drs = dtSource.Select("AUFNR='" + lueWorkOrderNo.Text.Trim() + "'AND MATNR= '" + lueMaterialCode.Text.Trim() + "'AND MBLNR= '" + lueMblnr.Text.Trim() + "'"); if (drs.Length >= 1) { //MessageBox.Show("数据表中存在重复数据!", "系统提示"); MessageBox.Show(StringParser.Parse("${res:FanHai.Hemera.Addins.ReturnMaterialCtrl.msg.0003}"), StringParser.Parse("${res:Global.SystemInfo}")); return; } } else { lueFactoryRoom.Properties.ReadOnly = true; lueOperation.Properties.ReadOnly = true; lueStoreName.Properties.ReadOnly = true; lueWorkOrderNo.Properties.ReadOnly = true; txtNum.Properties.ReadOnly = true; } //3.插入数据到界面数据清单表中 GetInfToGvlist(); }
private bool CheckNumTrueOrFalse(string _num) { //判定是否存在领料单号 MaterialReqOrReturnEntity materialReqOrReturnEntity = new MaterialReqOrReturnEntity(); DataSet dsCheckNum = materialReqOrReturnEntity.GetCountByNumToCheck(txtNum.Text.Trim(), 1); if (Convert.ToInt32(dsCheckNum.Tables[0].Rows[0]["COUNT"].ToString()) > 0) { return(true); } else { return(false); } }