新增缓存列表编辑功能调用方法

yxj

2023-06-27 d84c1704ee8cbabe8e3d8cfd7f29ca81a9b9f1e5

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

@@ -66,7 +66,7 @@
                DeleteRelation(ref sReturn, lngBillKey);
                //鍒犻櫎瀛愯〃
                DeleteBillSub(lngBillKey);
                DeleteBillSub2(lngBillKey);
                //DeleteBillSub2(lngBillKey);
                //鎻掑叆瀛愯〃
                omodel.HInterID = lngBillKey;
                //鎻掑叆瀛愯〃
@@ -87,21 +87,21 @@
                      ") ");
                }

                //閰嶄欢椤圭洰
                foreach (Model.ClsSc_MouldDotCheckBillSub_Item oSub in DetailCol)
                {
                    oCn.RunProc("Insert into Sc_MouldDotCheckBillSub_Item " +
                    " (HInterID,HEntryID,HCloseMan,HEntryCloseDate,HCloseType,HRemark" +
                    ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" +
                    ",HMaterID,HUnitID" +
                    ",HQty,HQtyMust" +
                    ") values("
                    + omodel.HInterID.ToString() + "," + oSub.HEntryID.ToString() + ",'" + oSub.HCloseMan + "'," + oSub.HEntryCloseDate.ToShortDateString() + "," + 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.HMaterID.ToString() + "," + oSub.HUnitID.ToString() +
                    "," + oSub.HQty.ToString() + "," + oSub.HQtyMust.ToString() +
                    ") ");
                }
                ////閰嶄欢椤圭洰
                //foreach (Model.ClsSc_MouldDotCheckBillSub_Item oSub in DetailCol)
                //{
                //    oCn.RunProc("Insert into Sc_MouldDotCheckBillSub_Item " +
                //    " (HInterID,HEntryID,HCloseMan,HEntryCloseDate,HCloseType,HRemark" +
                //    ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" +
                //    ",HMaterID,HUnitID" +
                //    ",HQty,HQtyMust" +
                //    ") values("
                //    + omodel.HInterID.ToString() + "," + oSub.HEntryID.ToString() + ",'" + oSub.HCloseMan + "'," + oSub.HEntryCloseDate.ToShortDateString() + "," + 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.HMaterID.ToString() + "," + oSub.HUnitID.ToString() +
                //    "," + oSub.HQty.ToString() + "," + oSub.HQtyMust.ToString() +
                //    ") ");
                //}
                //
                //foreach (Model.ClsSc_MouldDotCheckBillSub oSub in DetailColl)
                //{
@@ -166,21 +166,21 @@
                      ") ");
                }

                //閰嶄欢椤圭洰
                foreach (Model.ClsSc_MouldDotCheckBillSub_Item oSub in DetailCol)
                {
                    oCn.RunProc("Insert into Sc_MouldDotCheckBillSub_Item " +
                    " (HInterID,HEntryID,HCloseMan,HEntryCloseDate,HCloseType,HRemark" +
                    ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" +
                    ",HMaterID,HUnitID" +
                    ",HQty,HQtyMust" +
                    ") values("
                    + omodel.HInterID.ToString() + "," + oSub.HEntryID.ToString() + ",'" + oSub.HCloseMan + "'," + oSub.HEntryCloseDate.ToShortDateString() + "," + 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.HMaterID.ToString() + "," + oSub.HUnitID.ToString() +
                    "," + oSub.HQty.ToString() + "," + oSub.HQtyMust.ToString() +
                    ") ");
                }
                ////閰嶄欢椤圭洰
                //foreach (Model.ClsSc_MouldDotCheckBillSub_Item oSub in DetailCol)
                //{
                //    oCn.RunProc("Insert into Sc_MouldDotCheckBillSub_Item " +
                //    " (HInterID,HEntryID,HCloseMan,HEntryCloseDate,HCloseType,HRemark" +
                //    ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" +
                //    ",HMaterID,HUnitID" +
                //    ",HQty,HQtyMust" +
                //    ") values("
                //    + omodel.HInterID.ToString() + "," + oSub.HEntryID.ToString() + ",'" + oSub.HCloseMan + "'," + oSub.HEntryCloseDate.ToShortDateString() + "," + 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.HMaterID.ToString() + "," + oSub.HUnitID.ToString() +
                //    "," + oSub.HQty.ToString() + "," + oSub.HQtyMust.ToString() +
                //    ") ");
                //}
                //
                //foreach (Model.ClsSc_MouldDotCheckBillSub oSub in DetailColl)
                //{