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