销售报价单 列表 和 编辑 页面； （见原型设计） 增加 客户拜访记录单 列表 和 编辑 页面； 工艺路线，产品工艺参数 车间管理：岗位技能清单，员...

zrg

2025-03-17 6ca4391a35cb940a5a27fd45811cce2d07f04b78

 DAL/ClsGy_MaterialMouldBillMain.cs

@@ -53,7 +53,8 @@
                    "', HWorkCenterID = '" + omodel.HWorkCenterID +
                    "', HEquipID  = '" + omodel.HEquipID +
                    "', HOrgID     = '" + omodel.HOrgID +
                    "' where HInterID = " + omodel.HInterID;
                    "', HProcID     = " + omodel.HProcID +
                    " where HInterID = " + omodel.HInterID;

                oCn.RunProc(mainSql);
                //删除关联
@@ -70,7 +71,7 @@
                            "" +
                            "" +
                            "(HInterID,HEntryID,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType" +
                            ",HMouldID,HQty,HMouldQty,HRate) " +
                            ",HMouldID,HQty,HMouldQty,HRate,HMouldType,HMouldPriority,HCubicleQty) " +
                            " values(" +
                            "" + omodel.HInterID.ToString() +
                            "," + oSub.HEntryID.ToString() +
@@ -81,8 +82,11 @@
                            "','" + oSub.HMouldID +
                            "'," + oSub.HQty +
                            "," + oSub.HMouldQty +
                            ",'" + oSub.HRate +
                            "')";
                            ",'" + oSub.HRate + 
                            "','" + oSub.HMouldType +
                           "','" + oSub.HMouldPriority +
                           "'," + oSub.HCubicleQty +
                           ")";
                    oCn.RunProc(subSql);
                }

@@ -126,7 +130,7 @@
                //插入主表
                string mainSql = "insert into Gy_MaterialMouldBillMain" +
                    "(HYear,HPeriod,HBillType,HBillSubType,HInterID,HDate,HBillNo,HRemark,HMaker,HMakeDate" +
                    ",HDeptID,HEmpID,HMaterID,HWorkCenterID,HEquipID,HOrgID ) " +
                    ",HDeptID,HEmpID,HMaterID,HWorkCenterID,HEquipID,HOrgID,HProcID) " +
                    "values(" +
                    "" + omodel.HYear.ToString() +
                    "," + omodel.HPeriod.ToString() +
@@ -143,8 +147,9 @@
                    ",'" + omodel.HMaterID +
                    "','" + omodel.HWorkCenterID +
                    "','" + omodel.HEquipID +
                     "','" + omodel.HOrgID +
                    "')";
                    "','" + omodel.HOrgID +
                    "'," + omodel.HProcID +
                    ")";

                oCn.RunProc(mainSql);

@@ -156,7 +161,7 @@
                           "" +
                           "" +
                           "(HInterID,HEntryID,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType" +
                           ",HMouldID,HQty,HMouldQty,HRate) " +
                           ",HMouldID,HQty,HMouldQty,HRate,HMouldType,HMouldPriority,HCubicleQty) " +
                           " values(" +
                           "" + omodel.HInterID.ToString() +
                           "," + oSub.HEntryID.ToString() +
@@ -168,7 +173,10 @@
                           "'," + oSub.HQty +
                           "," + oSub.HMouldQty +
                           ",'" + oSub.HRate +
                           "')";
                           "','" + oSub.HMouldType +
                           "','" + oSub.HMouldPriority +
                           "'," + oSub.HCubicleQty +
                           ")";
                    oCn.RunProc(subSql);
                }
                sReturn = "新增单据成功！";