From 8b8c9182fb3722fbe9ab6a39c6ae781d66d2a5e6 Mon Sep 17 00:00:00 2001 From: zgq <519541279@qq.com> Date: 星期一, 16 八月 2021 22:39:23 +0800 Subject: [PATCH] 1 --- PlanM/数据导入/Gy_DataIn_RoutingBill.cs | 152 +++++++++++++++++++++++++------------------------- 1 files changed, 76 insertions(+), 76 deletions(-) diff --git "a/PlanM/\346\225\260\346\215\256\345\257\274\345\205\245/Gy_DataIn_RoutingBill.cs" "b/PlanM/\346\225\260\346\215\256\345\257\274\345\205\245/Gy_DataIn_RoutingBill.cs" index 26b6a9e..3488207 100644 --- "a/PlanM/\346\225\260\346\215\256\345\257\274\345\205\245/Gy_DataIn_RoutingBill.cs" +++ "b/PlanM/\346\225\260\346\215\256\345\257\274\345\205\245/Gy_DataIn_RoutingBill.cs" @@ -17,29 +17,29 @@ InitializeComponent(); } - public int HMaterNumberCol = 0; //??????? - public int HProcNoCol = 0; //??????? - public int HProcNameCol = 0; //???? - public int HWorkCenterNameCol = 0; //???????? - public int HWorkQtyCol = 0; //??????? - public int HBeginDayQtyCol = 6; //???????? - public int HBeginFixQtyCol = 7; //???????? - public int HFixPriceCol = 8; //???? С????? - public int HProcPriceCol = 9; //???? - public int HTechnologyParameterCol = 0; //??????? - public int HPicNumCol = 0; //????? - public int HProcCheckNoteCol = 0; //??????????? + public int HMaterNumberCol = 0; //产品代码 + public int HProcNoCol = 0; //工序序号 + public int HProcNameCol = 0; //工序 + public int HWorkCenterNameCol = 0; //工作中心 + public int HWorkQtyCol = 0; //加工数量 + public int HBeginDayQtyCol = 6; //开工固天 + public int HBeginFixQtyCol = 7; //开工余量 + public int HFixPriceCol = 8; //定额 小时工资 + public int HProcPriceCol = 9; //工价 + public int HTechnologyParameterCol = 0; //工艺参数 + public int HPicNumCol = 0; //图纸编号 + public int HProcCheckNoteCol = 0; //本工序确认记录 - public int HPicNumVerCol = 0; //???汾 - public int HPicNumAssembleCol = 0; //?????? - public int HMaterTextureCol = 0; //???? - public int HProductNumCol = 0; //?????? - public int HVerNumCol = 0; //?汾 - public int HMouldNoCol = 0; //????? - public int HProcWorkNumCol = 0; //????? - public int HPassRateCol = 0; //???? + public int HPicNumVerCol = 0; //图号版本 + public int HPicNumAssembleCol = 0; //总装图号 + public int HMaterTextureCol = 0; //材质 + public int HProductNumCol = 0; //成品编号 + public int HVerNumCol = 0; //版本 + public int HMouldNoCol = 0; //模具编号 + public int HProcWorkNumCol = 0; //程序号 + public int HPassRateCol = 0; //良率 // - public const int HBeginRow = 2; //??Ч???????????? + public const int HBeginRow = 2; //有效数据,开始行数 // public DAL.ClsGy_Process_View oProcHlp = new DAL.ClsGy_Process_View(); DAL.ClsGy_WorkCenter_View oCenHlp = new DAL.ClsGy_WorkCenter_View(); @@ -57,7 +57,7 @@ } /// <summary> - /// ????????? + /// 初始化界面 /// </summary> public override void initData() { @@ -70,7 +70,7 @@ base.ModRightNameEdit = base.ModRightName + base.ModRightNameEdit; base.ModRightNameMoney = base.ModRightName + base.ModRightNameMoney; base.ModRightNameQty = base.ModRightName + base.ModRightNameQty; - base.ModCaption = "????·?????"; + base.ModCaption = "工艺路线导入"; this.Text = base.ModCaption; lblCaption.Text = base.ModCaption; // @@ -78,7 +78,7 @@ DBUtility.Gy_BaseFun.SetComboxPeriod(cmbHPeriod); // } - //???? + //导入 public override void Sub_DataIn() { try @@ -86,26 +86,26 @@ string hnumber = ""; string HBillNo = ""; // - HMaterNumberCol = DBUtility.Gy_BaseFun.Fun_GetCol("???????", grdMain); - HProcNoCol = DBUtility.Gy_BaseFun.Fun_GetCol("???????", grdMain); - HProcNameCol = DBUtility.Gy_BaseFun.Fun_GetCol("????", grdMain); - HWorkCenterNameCol = DBUtility.Gy_BaseFun.Fun_GetCol("????????", grdMain); - HWorkQtyCol = DBUtility.Gy_BaseFun.Fun_GetCol("???????", grdMain); - HPicNumCol = DBUtility.Gy_BaseFun.Fun_GetCol("?????", grdMain); - HTechnologyParameterCol = DBUtility.Gy_BaseFun.Fun_GetCol("???????", grdMain); - HProcCheckNoteCol = DBUtility.Gy_BaseFun.Fun_GetCol("???????????", grdMain); - HPicNumVerCol = DBUtility.Gy_BaseFun.Fun_GetCol("???汾", grdMain); - HPicNumAssembleCol = DBUtility.Gy_BaseFun.Fun_GetCol("??????", grdMain); - HMaterTextureCol = DBUtility.Gy_BaseFun.Fun_GetCol("????", grdMain); - HProductNumCol = DBUtility.Gy_BaseFun.Fun_GetCol("??????", grdMain); - HVerNumCol = DBUtility.Gy_BaseFun.Fun_GetCol("?汾", grdMain); - HMouldNoCol = DBUtility.Gy_BaseFun.Fun_GetCol("?????", grdMain); - HProcWorkNumCol = DBUtility.Gy_BaseFun.Fun_GetCol("?????", grdMain); - HBeginFixQtyCol = DBUtility.Gy_BaseFun.Fun_GetCol("????????", grdMain); - HBeginDayQtyCol = DBUtility.Gy_BaseFun.Fun_GetCol("????????", grdMain); - HFixPriceCol = DBUtility.Gy_BaseFun.Fun_GetCol("С?????", grdMain); - HProcPriceCol = DBUtility.Gy_BaseFun.Fun_GetCol("????????", grdMain); - HPassRateCol = DBUtility.Gy_BaseFun.Fun_GetCol("????", grdMain); + HMaterNumberCol = DBUtility.Gy_BaseFun.Fun_GetCol("产品代码", grdMain); + HProcNoCol = DBUtility.Gy_BaseFun.Fun_GetCol("工序序号", grdMain); + HProcNameCol = DBUtility.Gy_BaseFun.Fun_GetCol("工序", grdMain); + HWorkCenterNameCol = DBUtility.Gy_BaseFun.Fun_GetCol("工作中心", grdMain); + HWorkQtyCol = DBUtility.Gy_BaseFun.Fun_GetCol("加工数量", grdMain); + HPicNumCol = DBUtility.Gy_BaseFun.Fun_GetCol("图纸编号", grdMain); + HTechnologyParameterCol = DBUtility.Gy_BaseFun.Fun_GetCol("工艺参数", grdMain); + HProcCheckNoteCol = DBUtility.Gy_BaseFun.Fun_GetCol("本工序确认记录", grdMain); + HPicNumVerCol = DBUtility.Gy_BaseFun.Fun_GetCol("图号版本", grdMain); + HPicNumAssembleCol = DBUtility.Gy_BaseFun.Fun_GetCol("总装图号", grdMain); + HMaterTextureCol = DBUtility.Gy_BaseFun.Fun_GetCol("材质", grdMain); + HProductNumCol = DBUtility.Gy_BaseFun.Fun_GetCol("成品编号", grdMain); + HVerNumCol = DBUtility.Gy_BaseFun.Fun_GetCol("版本", grdMain); + HMouldNoCol = DBUtility.Gy_BaseFun.Fun_GetCol("模具编号", grdMain); + HProcWorkNumCol = DBUtility.Gy_BaseFun.Fun_GetCol("程序号", grdMain); + HBeginFixQtyCol = DBUtility.Gy_BaseFun.Fun_GetCol("开工余量", grdMain); + HBeginDayQtyCol = DBUtility.Gy_BaseFun.Fun_GetCol("开工固天", grdMain); + HFixPriceCol = DBUtility.Gy_BaseFun.Fun_GetCol("小时工资", grdMain); + HProcPriceCol = DBUtility.Gy_BaseFun.Fun_GetCol("单个工价", grdMain); + HPassRateCol = DBUtility.Gy_BaseFun.Fun_GetCol("良率", grdMain); //没有找到列 if (HMaterNumberCol == -1) @@ -251,7 +251,7 @@ if (hnumber == DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HMaterNumberCol].Value)) { - //??????????? + //得到物料内码 if (oMaterHlp.GetInfoByNumber(sHNumber)) { if (BillNew.omodel.HMaterID != oMaterHlp.omodel.HItemID) @@ -266,11 +266,11 @@ else { BillNew.omodel.HMaterID = 0; - MessageBox.Show("??" + i.ToString() + "??," + sHNumber + "????????????????"); + MessageBox.Show("第" + i.ToString() + "行," + sHNumber + "没有找到对应的物料!"); return; } j++; - //д???? + //写入类 WriteClass(i); } @@ -279,18 +279,18 @@ DataSet Ds; ClsCN oCn = new ClsCN(); bool b = false; - // ?ж??????????·?? + // 判断是否存在工艺路线 Ds = oCn.RunProcReturn("Select HMaterID from Gy_RoutingBillMain Where HMaterID=" + BillNew.omodel.HMaterID.ToString(), "Gy_RoutingBillMain"); if (checkadd.Checked == true) { - //if (Ds.Tables[0].Rows.Count == 0)//??? + //if (Ds.Tables[0].Rows.Count == 0)//追加 //{ - //????? ???????????? + //新增前 先删除原来工艺 BillNew.DeleteByMaterID(BillNew.omodel.HMaterID); b = BillNew.AddBill(ref ClsPub.sExeReturnInfo); if (b == false) { - MessageBox.Show("??" + i.ToString() + "??,????" + BillNew.omodel.HMaterNumber + "????????·??????????293???У????" + ClsPub.sExeReturnInfo); + MessageBox.Show("第" + i.ToString() + "行,物料" + BillNew.omodel.HMaterNumber + "新增工艺路线失败!代码293行中,原因:" + ClsPub.sExeReturnInfo); return; } c++; @@ -319,13 +319,13 @@ hnumber = DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HMaterNumberCol].Value); sHNumber = DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HMaterNumberCol].Value); - //???????????? + //审核代码是否合理 if (!DBUtility.ClsPub.AllowNumber(sHNumber)) { - MessageBox.Show("????????в????????????.????????λ?λ???????.????", "???"); + MessageBox.Show("物料代码中不能出现连续‘.’并且首位末位不能为‘.’!", "提示"); return; } - //??????????? + //得到物料内码 if (oMaterHlp.GetInfoByNumber(sHNumber)) { if (BillNew.omodel.HMaterID != oMaterHlp.omodel.HItemID) @@ -382,7 +382,7 @@ } } - //д???? ???? + //写入类 从控件 private bool WriteClass(int row) { string sHNumber = ""; @@ -402,22 +402,22 @@ sBeginDayQty = DBUtility.ClsPub.isSingle(grdMain.Rows[row].Cells[HBeginDayQtyCol].Value); sBeginFixQty = DBUtility.ClsPub.isSingle(grdMain.Rows[row].Cells[HBeginFixQtyCol].Value); sHPassRate = DBUtility.ClsPub.isSingle(grdMain.Rows[row].Cells[HPassRateCol].Value); - //?ж???????? ???? + //判断是否允许 保存 Model.ClsGy_RoutingBillSub oSub = new Model.ClsGy_RoutingBillSub(); - //??????????? + //得到工序内码 if (oProcHlp.GetInfoByName(sHNamePoc)) { oSub.HProcID = oProcHlp.omodel.HItemID; } - //??????????? + //得到车间内码 if (oCenHlp.GetInfoByName(sHNumberCen)) { oSub.HCenterID = oCenHlp.omodel.HItemID; } - //д????? + //写入信息 oSub.HEntryID = j; oSub.HProcNo = DBUtility.ClsPub.isInt(grdMain.Rows[row].Cells[HProcNoCol].Value); @@ -425,7 +425,7 @@ oSub.HWorkQty = sWorkQty; oSub.HPassRate = sHPassRate; oSub.HRemark = ""; - oSub.HTimeUnit = "С?"; + oSub.HTimeUnit = "小时"; oSub.HReadyTime = 0; oSub.HQueueTime = 0; oSub.HMoveTime = 0; @@ -457,7 +457,7 @@ return true; } - //??????? + //检查物料 private bool Checkdata() { bool b = false; @@ -481,53 +481,53 @@ { // int index = i + 1; - //???????????С??????? + //加工数量不能小于等于零 if (sWorkQty <= 0) { - MessageBox.Show("??" + index + "?м??????????С???????", "???"); + MessageBox.Show("第" + index + "行加工数量不能小于等于零!", "提示"); return false; } - //???????С??????? + //良率不能小于等于零 if (sHPassRate <= 0) { - MessageBox.Show("??" + index + "?????????С???????", "???"); + MessageBox.Show("第" + index + "行良率不能小于等于零!", "提示"); return false; } - //???????????? + //审核代码是否合理 if (!DBUtility.ClsPub.AllowNumber(sHNumber)) { - MessageBox.Show("????????в????????????.????????λ?λ???????.????", "???"); + MessageBox.Show("物料代码中不能出现连续‘.’并且首位末位不能为‘.’!", "提示"); return false; } - //??????????? + //得到物料内码 int j = i + HBeginRow; if (!oMaterHlp.GetInfoByNumber(sHNumber)) { - sMsg = "[" + sHNumber + "]?????????"; + sMsg = "[" + sHNumber + "]物料不存在"; if (sErrMsg.Contains(sMsg) == false) { - sErrMsg = sErrMsg + "[" + sHNumber + "]?????????\r\n"; + sErrMsg = sErrMsg + "[" + sHNumber + "]物料不存在\r\n"; } b = true; } - //??????????? + //得到工序内码 if (!oProcHlp.GetInfoByName(sHNamePoc)) { - sMsg = "[" + sHNamePoc + "]????????"; + sMsg = "[" + sHNamePoc + "]工序不存在"; if (sErrMsg.Contains(sMsg) == false) { - sErrMsg = sErrMsg + "[" + sHNamePoc + "]????????\r\n"; + sErrMsg = sErrMsg + "[" + sHNamePoc + "]工序不存在\r\n"; } b = true; } - //??????????????? + //得到工作中心内码 if (!oCenHlp.GetInfoByName(sHNumberCen)) { - sMsg = "[" + sHNumberCen + "]?????????????"; + sMsg = "[" + sHNumberCen + "]工作中心不存在"; if (sErrMsg.Contains(sMsg) == false) { - sErrMsg = sErrMsg + "[" + sHNumberCen + "]?????????????\r\n"; + sErrMsg = sErrMsg + "[" + sHNumberCen + "]工作中心不存在\r\n"; } b = true; -- Gitblit v1.9.1