1.取样单增加打印功能 2.模具/设备的pda点检:两条进行提示,一条自动带出点检内容 3.设备工艺参数趋势图:根据流转卡的子表进站出站时间查询工艺参...

zrg

2024-09-13 f187e2cfc181982090b6ab0e8458113dba6ad47b

 DAL/生产管理/模具管理/ClsSc_MouldDotCheckPlanBill.cs

@@ -74,20 +74,16 @@
                omodel.HInterID = lngBillKey;
                foreach (Model.ClsSc_MouldDotCheckPlanBillSub oSub in DetailColl)
                {
                    oCn.RunProc("Insert into Sc_MouldDotCheckPlanBillSub " +
                       " (HInterID,HEntryID" +
                       ",HManagerID" +
                       ",HDotCheckItem,HDotCheckPart,HClaim" +
                       ",HCloseMan,HCloseType,HRemark" +
                       ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" +
                       ",HDotCheckItemClassID,HDotCheckItemMethodID" +
                       ") values("
                       + omodel.HInterID.ToString() + "," + oSub.HEntryID.ToString() +
                       "," + oSub.HManagerID.ToString() +
                       ",'" + oSub.HDotCheckItem + "','" + oSub.HDotCheckPart + "','" + oSub.HClaim + "'" +
                       ",'" + oSub.HCloseMan + "'," + Convert.ToString(oSub.HCloseType ? 1 : 0) + ",'" + oSub.HRemark + "'" +
                       "," + oSub.HSourceInterID.ToString() + "," + oSub.HSourceEntryID.ToString() + ",'" + oSub.HSourceBillNo + "','" + oSub.HSourceBillType + "'," + oSub.HRelationQty.ToString() + "," + oSub.HRelationMoney.ToString() + "," + oSub.HDotCheckItemClassID + "," + oSub.HDotCheckItemMethodID +
                       ") ");
                    oCn.RunProc("INSERT INTO Sc_MouldDotCheckPlanBillSub " +
                         " (HInterID, HEntryID, HSourceInterID, HSourceEntryID, HSourceBillNo, HSourceBillType, HRelationQty, HRelationMoney, " +
                         "  HCloseMan, HCloseType, HRemark, " +
                         "HManagerID, HDotCheckItem, HDotCheckPart, HClaim, " +
                         "  HDotCheckItemClassID, HDotCheckItemMethodID, HDotCheckItemID) " +
                         "VALUES (" + omodel.HInterID.ToString() + ", " + oSub.HEntryID.ToString() + ", " + oSub.HSourceInterID.ToString() + ", " + oSub.HSourceEntryID.ToString() + ", " + "'" + oSub.HSourceBillNo.Replace("'", "''") + "', " + "'" + oSub.HSourceBillType.Replace("'", "''") + "', " + oSub.HRelationQty.ToString() + ", " + oSub.HRelationMoney.ToString() + ", " +
                         "'" + oSub.HCloseMan.Replace("'", "''") + "', " + Convert.ToString(oSub.HCloseType ? 1 : 0) + ", " + "'" + oSub.HRemark.Replace("'", "''") + "'," +
                         " " + oSub.HManagerID.ToString() + ", " + "'" + oSub.HDotCheckItem.Replace("'", "''") + "', " + "'" + oSub.HDotCheckPart.Replace("'", "''") + "', " + "'" + oSub.HClaim.Replace("'", "''") + "', " +
                         oSub.HDotCheckItemClassID.ToString() + ", " + oSub.HDotCheckItemMethodID.ToString() + ", " + oSub.HDotCheckItemID.ToString() +
                         ")");
                }

                ////閰嶄欢椤圭洰
@@ -156,20 +152,16 @@
                //鎻掑叆瀛愯〃    //鐐规椤圭洰
                foreach (Model.ClsSc_MouldDotCheckPlanBillSub oSub in DetailColl)
                {
                    oCn.RunProc("Insert into Sc_MouldDotCheckPlanBillSub " +
                      " (HInterID,HEntryID" +
                      ",HManagerID" +
                      ",HDotCheckItem,HDotCheckPart,HClaim" +
                      ",HCloseMan,HCloseType,HRemark" +
                      ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" +
                      ",HDotCheckItemClassID,HDotCheckItemMethodID" +
                      ") values("
                      + omodel.HInterID.ToString() + "," + oSub.HEntryID.ToString() +
                      "," + oSub.HManagerID.ToString() +
                      ",'" + oSub.HDotCheckItem + "','" + oSub.HDotCheckPart + "','" + oSub.HClaim + "'" +
                      ",'" + oSub.HCloseMan + "'," + Convert.ToString(oSub.HCloseType ? 1 : 0) + ",'" + oSub.HRemark + "'" +
                      "," + oSub.HSourceInterID.ToString() + "," + oSub.HSourceEntryID.ToString() + ",'" + oSub.HSourceBillNo + "','" + oSub.HSourceBillType + "'," + oSub.HRelationQty.ToString() + "," + oSub.HRelationMoney.ToString() + "," + oSub.HDotCheckItemClassID + "," + oSub.HDotCheckItemMethodID +
                      ") ");
                    oCn.RunProc("INSERT INTO Sc_MouldDotCheckPlanBillSub " +
                         " (HInterID, HEntryID, HSourceInterID, HSourceEntryID, HSourceBillNo, HSourceBillType, HRelationQty, HRelationMoney, " +
                         "  HCloseMan, HCloseType, HRemark, " +
                         "HManagerID, HDotCheckItem, HDotCheckPart, HClaim, " +
                         "  HDotCheckItemClassID, HDotCheckItemMethodID, HDotCheckItemID) " +
                         "VALUES (" +omodel.HInterID.ToString() + ", " +oSub.HEntryID.ToString() + ", " +oSub.HSourceInterID.ToString() + ", " +oSub.HSourceEntryID.ToString() + ", " +"'" + oSub.HSourceBillNo+ "', " +"'" + oSub.HSourceBillType + "', " +oSub.HRelationQty.ToString() + ", " +oSub.HRelationMoney.ToString() + ", " +
                         "'" + oSub.HCloseMan + "', " +Convert.ToString(oSub.HCloseType ? 1 : 0) + ", " +"'" + oSub.HRemark + "'," +
                         " " +oSub.HManagerID.ToString() + ", " +"'" + oSub.HDotCheckItem + "', " +"'" + oSub.HDotCheckPart + "', " +"'" + oSub.HClaim + "', " +
                         oSub.HDotCheckItemClassID.ToString() + ", " +oSub.HDotCheckItemMethodID.ToString() + ", " +oSub.HDotCheckItemID.ToString() +
                         ")");
                }

                ////閰嶄欢椤圭洰