/// <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);
}
}
