private void lueMaterialCode_EditValueChanged(object sender, EventArgs e)
{
string materialName = Convert.ToString(this.lueMaterialCode.GetColumnValue("MATERIAL_NAME"));
//string unit = Convert.ToString(this.lueMaterialCode.GetColumnValue("UNIT"));
this.txtMaterialDescription.Text = materialName;
//this.txtUnit.Text = unit;
MaterialReqOrReturnEntity entity = new MaterialReqOrReturnEntity();
DataSet ds = entity.GetMaterialstTui("", lueMaterialCode.Text.Trim(), "");
if (string.IsNullOrEmpty(entity.ErrorMsg))
{
lueMblnr.Properties.DataSource = ds.Tables[0];
this.lueMblnr.Properties.DisplayMember = "MBLNR";
this.lueMblnr.Properties.ValueMember = "MBLNR";
this.lueMblnr.ItemIndex = 0;
this.lueMblnr.Properties.PopupFormSize = new Size(200, 120);
}
else
{
this.lueMblnr.Properties.DataSource = null;
this.lueMblnr.EditValue = string.Empty;
this.lueMblnr.Text = string.Empty;
}
}
/// <summary>
/// 过账操作
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void tspPass_Click(object sender, EventArgs e)
{
MaterialReqOrReturnEntity materialReqOrReturnEntity = new MaterialReqOrReturnEntity();
//if (MessageBox.Show(StringParser.Parse("是否对当前退料单进行过账？"),
// StringParser.Parse("${res:Global.SystemInfo}"), MessageBoxButtons.OKCancel) == DialogResult.OK)
if (MessageBox.Show(StringParser.Parse(StringParser.Parse("${res:FanHai.Hemera.Addins.ReturnMaterialCtrl.msg.0021}")),
StringParser.Parse("${res:Global.SystemInfo}"), MessageBoxButtons.OKCancel) == DialogResult.OK)
{
if (txtStatus.Text == "已创建")
{
DataSet dsReturn = materialReqOrReturnEntity.UpdateStatusTui(txtNum.Text.Trim(), PropertyService.Get(PROPERTY_FIELDS.USER_NAME_MZ));
if (string.IsNullOrEmpty(materialReqOrReturnEntity.ErrorMsg))
{
//MessageBox.Show("退料单" + txtNum.Text.Trim() + "过账成功！", "系统提示");
MessageBox.Show(StringParser.Parse("${res:FanHai.Hemera.Addins.ReturnMaterialCtrl.msg.0022}")
+ txtNum.Text.Trim()
+ StringParser.Parse("${res:FanHai.Hemera.Addins.ReturnMaterialCtrl.msg.0023}"), StringParser.Parse("${res:Global.SystemInfo}"));
_status = "New";
txtStatus.Text = "已过账";
Status(_status);
}
else
{
MessageBox.Show(materialReqOrReturnEntity.ErrorMsg, StringParser.Parse("${res:Global.SystemInfo}"));
}
}
}
}
/// <summary>物料号变更带出物料描述和单位
/// 物料号变更带出物料描述和单位
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void lueMaterialCode_EditValueChanged(object sender, EventArgs e)
{
string materialName = Convert.ToString(this.lueMaterialCode.GetColumnValue("MATERIAL_NAME"));
this.txtMaterialDescription.Text = materialName;
MaterialReqOrReturnEntity entity = new MaterialReqOrReturnEntity();
DataSet ds = entity.GetMaterialstTui(lueWorkOrderNo.Text.Trim(), lueMaterialCode.Text.Trim(), "");
if (string.IsNullOrEmpty(entity.ErrorMsg))
{
lueMblnr.Properties.DataSource = ds.Tables[0];
this.lueMblnr.Properties.DisplayMember = "MBLNR";
this.lueMblnr.Properties.ValueMember = "MBLNR";
this.lueMblnr.ItemIndex = 0;
this.lueMblnr.Properties.PopupFormSize = new Size(200, 120);
}
string llief = Convert.ToString(this.lueMblnr.GetColumnValue("LLIEF"));
string sumqty = Convert.ToString(this.lueMblnr.GetColumnValue("SUMQTY"));
string unit = Convert.ToString(this.lueMblnr.GetColumnValue("UNIT"));
lueSupplierName.Text = llief;
txtSum.Text = sumqty;
txtUnit.Text = unit;
}
/// <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);
}
}
/// <summary>
/// 过账操作
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void tspPass_Click(object sender, EventArgs e)
{
MaterialReqOrReturnEntity materialReqOrReturnEntity = new MaterialReqOrReturnEntity();
//if (MessageBox.Show(StringParser.Parse("是否对当前领料单进行过账？"),
// StringParser.Parse("${res:Global.SystemInfo}"), MessageBoxButtons.OKCancel) == DialogResult.OK)
if (MessageBox.Show(StringParser.Parse("${res:FanHai.Hemera.Addins.MaterialRequisitionCtrl.msg.0023}"),
StringParser.Parse("${res:Global.SystemInfo}"), MessageBoxButtons.OKCancel) == DialogResult.OK)
{
if (CheckNumTrueOrFalse(txtNum.Text.Trim()) == false)
{
//MessageBox.Show("领料单" + txtNum.Text.Trim() + "不存在！", "系统提示");
MessageBox.Show(StringParser.Parse("${res:FanHai.Hemera.Addins.MaterialRequisitionCtrl.msg.0024}")
+ txtNum.Text.Trim()
+ StringParser.Parse("${res:FanHai.Hemera.Addins.MaterialRequisitionCtrl.msg.0025}"), StringParser.Parse("${res:Global.SystemInfo}"));
return;
}
if (txtStatus.Text == "已创建")
{
DataSet dsReturn = materialReqOrReturnEntity.UpdateStatus(txtNum.Text.Trim(), PropertyService.Get(PROPERTY_FIELDS.USER_NAME_MZ));
if (string.IsNullOrEmpty(materialReqOrReturnEntity.ErrorMsg))
{
//领料单 已成功过账！
MessageBox.Show(StringParser.Parse("${res:FanHai.Hemera.Addins.MaterialRequisitionCtrl.msg.0024}")
+ txtNum.Text.Trim()
+ StringParser.Parse("${res:FanHai.Hemera.Addins.MaterialRequisitionCtrl.msg.0026}"), StringParser.Parse("${res:Global.SystemInfo}"));
_status = "New";
Status(_status);
}
else
{
MessageBox.Show(materialReqOrReturnEntity.ErrorMsg, StringParser.Parse("${res:Global.SystemInfo}"));
}
}
else
{
//MessageBox.Show("当前领料单状态为'" + txtStatus.Text + "'！不能过账", StringParser.Parse("${res:Global.SystemInfo}"));
MessageBox.Show(StringParser.Parse("${res:FanHai.Hemera.Addins.MaterialRequisitionCtrl.msg.0027}")
+ txtStatus.Text
+ StringParser.Parse("${res:FanHai.Hemera.Addins.MaterialRequisitionCtrl.msg.0028}"), StringParser.Parse("${res:Global.SystemInfo}"));
}
}
}
/// <summary>绑定物料编码。
/// 绑定物料编码。
/// </summary>
private void BindMaterialCode()
{
string orderNumber = this.lueWorkOrderNo.Text;
this.lueMaterialCode.EditValue = string.Empty;
this.txtMaterialDescription.Text = string.Empty;
MaterialReqOrReturnEntity entity = new MaterialReqOrReturnEntity();
DataSet ds = entity.GetMaterials(orderNumber);
if (string.IsNullOrEmpty(entity.ErrorMsg))
{
this.lueMaterialCode.Properties.DataSource = ds.Tables[0];
this.lueMaterialCode.Properties.DisplayMember = "MATERIAL_CODE";
this.lueMaterialCode.Properties.ValueMember = "MATERIAL_KEY";
this.lueMaterialCode.ItemIndex = 0;
}
else
{
this.lueMaterialCode.Properties.DataSource = null;
this.lueMaterialCode.EditValue = string.Empty;
this.txtMaterialDescription.Text = string.Empty;
}
}
/// <summary>保存领料单
/// 保存领料单
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void tspSave_Click(object sender, EventArgs e)
{
MaterialReqOrReturnEntity materialReqOrReturnEntity = new MaterialReqOrReturnEntity();
if (gcInf.DataSource as DataTable == null)
{
//MessageBox.Show("没有需要保存的信息！", "系统错误提示");
MessageBox.Show(StringParser.Parse("${res:FanHai.Hemera.Addins.MaterialRequisitionCtrl.msg.0017}"), StringParser.Parse("${res:Global.SystemInfo}"));
return;
}
try
{
//if (MessageBox.Show(StringParser.Parse("是否保存领料单信息？"),
// StringParser.Parse("${res:Global.SystemInfo}"), MessageBoxButtons.OKCancel) == DialogResult.OK)
if (MessageBox.Show(StringParser.Parse("${res:FanHai.Hemera.Addins.MaterialRequisitionCtrl.msg.0018}"),
StringParser.Parse("${res:Global.SystemInfo}"), MessageBoxButtons.OKCancel) == DialogResult.OK)
{
#region 新增领料单信息，抬头表，从表，数据记录表
if (_status == "New")
{
//数据绑定
DataTable dtInKo = new DataTable();
dtInKo.Columns.Add("MBLNR");
dtInKo.Columns.Add("FACTORYKEY");
dtInKo.Columns.Add("FACTORYNAME");
dtInKo.Columns.Add("PROCESS");
dtInKo.Columns.Add("STORE_KEY");
dtInKo.Columns.Add("STORE_NAME");
dtInKo.Columns.Add("AUFNR");
dtInKo.Columns.Add("CREATOR");
DataRow dr = dtInKo.NewRow();
dr["MBLNR"] = txtNum.Text.Trim();
dr["FACTORYKEY"] = lueFactoryRoom.EditValue.ToString();
dr["FACTORYNAME"] = lueFactoryRoom.Text.Trim();
dr["PROCESS"] = lueOperation.Text.Trim();
dr["STORE_KEY"] = lueStoreName.EditValue.ToString();
dr["STORE_NAME"] = lueStoreName.Text.Trim();
dr["AUFNR"] = lueWorkOrderNo.Text.Trim();
dr["CREATOR"] = txtCreator.Text.Trim();
dtInKo.Rows.Add(dr);
dtInKo.TableName = "WST_STORE_MATERIAL_REQUISITION";
DataTable dtInPo = new DataTable();
DataView dv = gvInf.DataSource as DataView;
if (dv != null)
{
dtInPo = dv.Table;
}
dtInPo.TableName = "WST_STORE_MATERIAL_REQUISITION_DETAIL";
DataSet dsIn = new DataSet();
dsIn.Merge(dtInKo);
dsIn.Merge(dtInPo);
DataSet dsReturn = materialReqOrReturnEntity.CreateRequistionKoPo(dsIn);
if (string.IsNullOrEmpty(materialReqOrReturnEntity.ErrorMsg))
{
//MessageBox.Show("保存成功！", "系统提示");
MessageBox.Show(StringParser.Parse("${res:FanHai.Hemera.Addins.MaterialRequisitionCtrl.msg.0019}"), StringParser.Parse("${res:Global.SystemInfo}"));
_status = "Save";
txtStatus.Text = "已创建";
Status(_status);
}
else
{
MessageBox.Show(materialReqOrReturnEntity.ErrorMsg, StringParser.Parse("${res:Global.SystemInfo}"));
}
return;
}
#endregion
#region 修改领料单记录，抬头表不变，从表新增新记录修改删除记录状态，修改领料信息数据
else if (_status == "Edit")
{
if (!txtStatus.Text.Equals("已创建"))
{
//MessageBox.Show("此领料单已过帐或删除，不能修改！", "系统提示");
MessageBox.Show(StringParser.Parse("${res:FanHai.Hemera.Addins.MaterialRequisitionCtrl.msg.0020}"), StringParser.Parse("${res:Global.SystemInfo}"));
return;
}
if (this.gvInf.State == GridState.Editing && this.gvInf.IsEditorFocused && this.gvInf.EditingValueModified)
{
this.gvInf.SetFocusedRowCellValue(this.gvInf.FocusedColumn, this.gvInf.EditingValue);
}
this.gvInf.UpdateCurrentRow();
DataView dv = gvInf.DataSource as DataView;
DataTable dt = new DataTable();
if (dv != null)
{
dt = dv.Table;
}
DataSet dsSave = new DataSet();
DataTable _dt_Insert = dt.GetChanges(DataRowState.Added);
DataTable _dt_Delete = dt.GetChanges(DataRowState.Deleted);
string _editer = PropertyService.Get(PROPERTY_FIELDS.USER_NAME_MZ);
string _mblnr = txtNum.Text.Trim();
if (_dt_Insert == null && _dt_Delete == null)
{
//MessageBox.Show("没有需要保存的数据！", "系统提示");
MessageBox.Show(StringParser.Parse("${res:FanHai.Hemera.Addins.MaterialRequisitionCtrl.msg.0021}"), StringParser.Parse("${res:Global.SystemInfo}"));
_status = "Save";
txtStatus.Text = "已创建";
Status(_status);
return;
}
if (_dt_Insert != null && _dt_Insert.Rows.Count > 0)
{
_dt_Insert.TableName = "INSERT";
dsSave.Merge(_dt_Insert, true, MissingSchemaAction.Add);
}
if (_dt_Delete != null && _dt_Delete.Rows.Count > 0)
{
_dt_Delete.RejectChanges();
_dt_Delete.TableName = "DELETE";
dsSave.Merge(_dt_Delete, true, MissingSchemaAction.Add);
}
DataSet dsReturn = materialReqOrReturnEntity.UpdateRequistionKoPo(dsSave, _editer, _mblnr);
if (string.IsNullOrEmpty(materialReqOrReturnEntity.ErrorMsg))
{
//MessageBox.Show("修改成功！", "系统提示");
MessageBox.Show(StringParser.Parse("${res:FanHai.Hemera.Addins.MaterialRequisitionCtrl.msg.0022}"), StringParser.Parse("${res:Global.SystemInfo}"));
_status = "Save";
txtStatus.Text = "已创建";
Status(_status);
}
else
{
MessageBox.Show(materialReqOrReturnEntity.ErrorMsg, StringParser.Parse("${res:Global.SystemInfo}"));
return;
}
}
#endregion
((DataView)gvInf.DataSource).Table.AcceptChanges();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, StringParser.Parse("${res:Global.SystemInfo}"));
}
}
/// <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;
}
