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