private void 审核MEO创建申请单ToolStripMenuItem_Click(object sender, EventArgs e) { if (dgv2.RowCount != 0 && dgv2.SelectedRows.Count != 0) { if (MessageBox.Show("确定要审核选中的创建申请吗?", "确认信息", MessageBoxButtons.OKCancel) == DialogResult.OK) { for (int i = 0; i < dgv2.RowCount; i++) { if (dgv2.Rows[i].Selected == true) { string requireid = dgv2.Rows[i].Cells["require_id"].Value.ToString(); if (MEOmain.ApproveMEO(int.Parse(requireid), "4") != 1) { MessageBox.Show("审核MEO单据失败!!", "错误提示"); return; } } } MessageBox.Show("审核MEO单据成功!!", "操作提示"); //刷新数据 btn_query_Click(sender, e); //this.Hide(); } } }
public MaterialRequireUpdate(string cur_meoid, string cur_state) { InitializeComponent(); MEOID = cur_meoid; MEOSTATE = cur_state; meolist = MEOmain.Find(int.Parse(MEOID)); }
private void toolStripMenuItem2_Click(object sender, EventArgs e) { if (dgv1.RowCount != 0) { if (MessageBox.Show("确定要退回此申请吗?", "确认信息", MessageBoxButtons.OKCancel) == DialogResult.OK) { for (int i = 0; i < dgv1.RowCount; i++) { if (dgv1.Rows[i].Selected == true) { string requireid = dgv1.Rows[i].Cells["meolineno"].Value.ToString(); string partid = dgv1.Rows[i].Cells["id"].Value.ToString(); if (MEOmain.ApproveMEO(int.Parse(requireid), "N") != 1) { MessageBox.Show("退回MEO单据成功!!", "操作提示"); return; } } } MessageBox.Show("退回MEO单据失败!!", "错误提示"); //刷新数据 btn_query_Click(sender, e); //this.Hide(); } } }
/// <summary> /// 取得已下MEO的数量 /// </summary> public decimal GetMEOqty(int partid, string pid) { //partNo=cmb_partno.SelectedValue.ToString(); //Site = cmb_site.SelectedValue.ToString(); //string isInv = InventoryPart.GetIsInventory(Site, partNo); //if (isInv == "1") // checkBox1.Checked = true; //else // checkBox1.Checked = false; decimal invQty = MEOmain.GetMEOqty(partid, pid); return(invQty); }
public void listviewTitleBind() { dgv1.AutoGenerateColumns = false; if (MEOID != "0") { tn_meono.Enabled = true; MEOmain meolist = MEOmain.Find(int.Parse(MEOID)); if (meolist != null) { tn_meono.Text = meolist.REQUIRE_NO; cmb_site.SelectedValue = meolist.CONTRACT; //tb_project.Text = meolist.PROJECT_ID; //tb_user.Text = meolist.CREATER; txt_designcode.Text = meolist.INFORMATION; txt_remark.Text = meolist.REMARK; //dateTimePicker1.Value = meolist.CREATE_DATE; cmb_discipline.SelectedValue = meolist.DISCIPLINEID; List <MEOsub> meosublist = MEOsub.FindMEOList(MEOID); if (meosublist.Count != 0) { for (int i = 0; i < meosublist.Count; i++) { dgv1.Rows.Add(1); dgv1.Rows[i].Cells["MEO_ID"].Value = MEOID; dgv1.Rows[i].Cells["零件号"].Value = meosublist[i].PART_NO; dgv1.Rows[i].Cells["申请数量"].Value = meosublist[i].REQUIRE_QTY; dgv1.Rows[i].Cells["需求日期"].Value = meosublist[i].REQUIRE_DATE; dgv1.Rows[i].Cells["需求原因"].Value = meosublist[i].REASON_CODE; dgv1.Rows[i].Cells["MEO_ERP"].Value = meosublist[i].MEO_ERP; dgv1.Rows[i].Cells["零件描述"].Value = meosublist[i].PART_NAME; dgv1.Rows[i].Cells["单位"].Value = meosublist[i].UNIT_MEAS; //dgv1.Rows[i].Cells["单位"].Value = meosublist[i].UNIT_MEAS; //dgv1.Rows[i].Cells["inventory_qty"].Value = GetInventory(pp.PART_NO, pp.CONTRACT); //dgv1.Rows[i].Cells["meo_qty"].Value = GetMEOqty(pp.ID, ecprojectid); //dgv1.Rows[i].Cells["prediction_qty"].Value = GetParaqty(pp.ID, ecprojectid); } } } } else { dgv1.Rows.Add(5); for (int i = 0; i < 5; i++) { dgv1.Rows[i].Cells["MEO_ID"].Value = MEOID; dgv1.Rows[i].Cells["需求原因"].Value = "1001"; } } SetRowNo(); }
private void btn_save_Click(object sender, EventArgs e) { if (ProjectId == string.Empty) { MessageBox.Show("请选择项目"); return; } if (Str_Area == string.Empty) { MessageBox.Show("请选择区域"); return; } if (ActivityName == string.Empty) { MessageBox.Show("请选择分项"); return; } string Site = cmb_site.SelectedValue.ToString(); if (Site == string.Empty) { MessageBox.Show("请选择域"); return; } int rowcou = dgv1.RowCount; if (rowcou == 0) { MessageBox.Show("请选择所要申请的材料", "操作提示"); return; } rowcou = dgv1.RowCount; //for (int i = 0; i < rowcou; i++) //{ // if (dgv1.Rows[i].Cells["序号"].Value == null) // { // MessageBox.Show("第" + (i + 1) + "行请填写材料", "提示"); // return; // } //} SetRowNo(); for (int i = 0; i < rowcou; i++) { #region 检查必填项以及数据的合法性 string rowid = dgv1.Rows[i].Cells["行"].Value.ToString(); if (dgv1.Rows[i].Cells["申请数量"].Value != null) { if (!BaseClass.validateNum(dgv1.Rows[i].Cells["申请数量"].Value.ToString().Trim())) { MessageBox.Show("第 " + rowid + " 行申请数量请填写数字", "提示"); dgv1.Rows[i].Selected = true; return; } if (dgv1.Rows[i].Cells["申请数量"].Value.ToString().Trim().Contains("-")) { MessageBox.Show("第 " + rowid + " 行申请数量为负,请检查", "提示"); dgv1.Rows[i].Selected = true; return; } } else { MessageBox.Show("第 " + rowid + " 行请填写申请数量", "提示"); //dgv1.Rows[i].Selected = true; dgv1.CurrentCell = dgv1.Rows[i].Cells["申请数量"]; return; } if (dgv1.Rows[i].Cells["MEO_ERP"].Value != null) { if (!BaseClass.validateNum(dgv1.Rows[i].Cells["MEO_ERP"].Value.ToString().Trim())) { MessageBox.Show("第 " + rowid + " 行MEO号请填写数字", "提示"); dgv1.Rows[i].Selected = true; return; } } else { //if (MEOID != "0") //{ // MessageBox.Show("第 " + rowid + " 行请填写MEO号", "提示"); // //dgv1.Rows[i].Selected = true; // dgv1.CurrentCell = dgv1.Rows[i].Cells["MEO_ERP"]; // return; //} } if (dgv1.Rows[i].Cells["需求日期"].Value == null) { MessageBox.Show("第 " + rowid + " 行请填写需求日期", "提示"); dgv1.Rows[i].Selected = true; return; } if (dgv1.Rows[i].Cells["需求原因"].Value == null) { MessageBox.Show("第 " + rowid + " 行请填写需求原因", "提示"); dgv1.Rows[i].Selected = true; return; } if (dgv1.Rows[i].Cells["需求日期"].Value != null) { if (Convert.ToDateTime(dgv1.Rows[i].Cells["需求日期"].Value.ToString()) < DateTime.Today) { MessageBox.Show("第 " + rowid + " 行需求日期不能小于当前日期", "提示"); dgv1.Rows[i].Selected = true; return; } } if (dgv1.Rows[i].Cells["MEO_ERP"].Value != null) { string partno = dgv1.Rows[i].Cells["零件号"].Value.ToString(); if (MEOsub.meomssExistERP(dgv1.Rows[i].Cells["MEO_ERP"].Value.ToString(), partno) == 0) { MessageBox.Show("第 " + rowid + " 行ERP中的MEO号不存在", "提示"); dgv1.Rows[i].Selected = true; return; } } #endregion } MEOmain MM_MEO = new MEOmain(); string contractno = cmb_site.SelectedValue.ToString(); MM_MEO.CONTRACT = contractno; string drawinfor = txt_designcode.Text.Trim(); MM_MEO.SYSTEM_ID = Str_Area; MM_MEO.REQUIRE_NO = MakeMEOManual(int.Parse(cmb_discipline.SelectedValue.ToString())); MM_MEO.INFORMATION = drawinfor; MM_MEO.CREATER = User.cur_user; MM_MEO.PARTTYPE_ID = Str_FX; MM_MEO.DISCIPLINEID = cmb_discipline.SelectedValue.ToString(); MM_MEO.PROJECT_ID = ProjectId; MM_MEO.ECPROJECTID = ProjectSystem.FindProjectid(ProjectId).ToString(); MM_MEO.ERP_DISCIPLINE = Str_Discipline; MM_MEO.ERP_PARTTYPE = ActivityName; #region 新增保存MEO if (MEOID == "0") { int mmreqid = MM_MEO.REQUIRE_Add(); if (mmreqid > 0) { #region 保存MEO从表 for (int i = 0; i < rowcou; i++) { //string partid = dgv1.Rows[i].Cells["序号"].Value.ToString(); string partno = dgv1.Rows[i].Cells["零件号"].Value.ToString(); string unitmeas = dgv1.Rows[i].Cells["单位"].Value.ToString(); string part_desc = dgv1.Rows[i].Cells["零件描述"].Value.ToString(); string reqdate = dgv1.Rows[i].Cells["需求日期"].Value.ToString(); string reqreason = dgv1.Rows[i].Cells["需求原因"].Value.ToString(); string preQty = dgv1.Rows[i].Cells["申请数量"].Value.ToString().Trim(); string remark = dgv1.Rows[i].Cells["备注"].Value.ToString(); decimal fpreQty = decimal.Parse(preQty); MEOsub MM_submeo = new MEOsub(); MM_submeo.REQUIRE_QTY = decimal.Round(fpreQty, 2); //MM_submeo.PART_ID = int.Parse(partid); MM_submeo.REQUIRE_DATE = Convert.ToDateTime(reqdate); MM_submeo.REASON_CODE = reqreason; MM_submeo.CREATER = User.cur_user; MM_submeo.REQUIRE_ID = mmreqid; MM_submeo.PROJECT_ID = ProjectId; MM_submeo.PART_NO = partno; MM_submeo.UNIT_MEAS = unitmeas; MM_submeo.PART_NAME = part_desc; MM_submeo.REMARK = remark; MM_submeo.REQUIRELINE_Add(); } MEOID = mmreqid.ToString(); MessageBox.Show("保存MEO成功!", "提示"); lbl_manual.Visible = true; tb_manul.Visible = true; tb_manul.Text = MM_MEO.REQUIRE_NO; return; #endregion } else { MessageBox.Show("保存失败!", "提示"); return; } } #endregion #region 更新保存MEO //if (MEOID != "0") //{ // MM_MEO.REQUIRE_ID = int.Parse(MEOID); // MM_MEO.REQUIRE_Update(); // MM_MEO.MEODelete(int.Parse(MEOID)); // #region 更新保存MEO从表 // for (int i = 0; i < rowcou; i++) // { // //string partid = dgv1.Rows[i].Cells["序号"].Value.ToString(); // string reqdate = dgv1.Rows[i].Cells["需求日期"].Value.ToString(); // string reqreason = dgv1.Rows[i].Cells["需求原因"].Value.ToString(); // string preQty = dgv1.Rows[i].Cells["申请数量"].Value.ToString().Trim(); // string meonoerp = ""; // if (dgv1.Rows[i].Cells["MEO_ERP"].Value != null) // { // meonoerp = dgv1.Rows[i].Cells["MEO_ERP"].Value.ToString().Trim(); // } // decimal fpreQty = decimal.Parse(preQty); // MEOsub MM_submeo = new MEOsub(); // MM_submeo.REQUIRE_QTY = decimal.Round(fpreQty, 2); // //MM_submeo.PART_ID = int.Parse(partid); // MM_submeo.REQUIRE_DATE = Convert.ToDateTime(reqdate); // MM_submeo.REASON_CODE = reqreason; // MM_submeo.CREATER = User.cur_user; // MM_submeo.REQUIRE_ID = int.Parse(MEOID); // MM_submeo.PROJECT_ID = ProjectId; // MM_submeo.MEO_ERP = meonoerp; // MM_submeo.REQUIRELINE_Add(); // } // MessageBox.Show("保存MEO成功!", "提示"); // #endregion //} #endregion // QuerydataBind(); }