1

duhe

2023-07-24 4e9ec8d46bc8edb7cda3f6633f4bdd6b9bbc0085

 DAL/»ù´¡×ÊÁÏ/ÆäËû»ù´¡×ÊÁÏ/ClsGy_MateMould_Ctl.cs

@@ -1,4 +1,5 @@
using System;
using DBUtility;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
@@ -57,15 +58,35 @@
            try
            {
                oCn.BeginTran();
                //插入子表

               
                //插入表
                foreach (Model.ClsGy_MateMould_Model oSub in DetailColl)
                {
                    DataSet Ds;
                    Int64 HInterID = 1;
                    Ds = oCn.RunProcReturn("select MAX(HInterID) HInterID from Gy_MateMouldInfo", "Gy_MateMouldInfo");
                    if (Ds.Tables[0].Rows.Count != 0 && ClsPub.isLong(Ds.Tables[0].Rows[0]["HInterID"].ToString()) != 0)
                    {
                        HInterID = ClsPub.isLong(Ds.Tables[0].Rows[0]["HInterID"].ToString());
                        HInterID += 1;
                    }

                    DataSet Cs;
                    Int64 HEntryID = 1;
                    Cs = oCn.RunProcReturn("select MAX(HEntryID) HEntryID from Gy_MateMouldInfo", "Gy_MateMouldInfo");
                    if (Cs.Tables[0].Rows.Count != 0 && ClsPub.isLong(Cs.Tables[0].Rows[0]["HEntryID"].ToString()) != 0)
                    {
                        HEntryID = ClsPub.isLong(Cs.Tables[0].Rows[0]["HEntryID"].ToString());
                        HEntryID += 1;
                    }

                    oCn.RunProc("Insert into Gy_MateMouldInfo " +
                        " (HMaterID,HRelationID,HUnitID" +
                        " (HInterID,HEntryID,HMaterID,HRelationID,HUnitID" +
                        ",HBeginDate,HEndDate" +
                        ",HUsed,HRemark,HMaker,HMakeDate)" +
                        " values(" + oSub.HMaterID.ToString() + "," + oSub.HRelationID.ToString() + "," + oSub.HUnitID.ToString() +
                        ",'" + oSub.HBeginDate.ToShortDateString() + "','" + oSub.HEndDate.ToShortDateString() + "'," + Convert.ToString(oSub.HUsed ? 1 : 0) + ",'" + oSub.HRemark + "','" + oSub.HMaker + "','" + oSub.HMakeDate + "') ");
                        ",HUsed,HRemark,HMaker,HMakeDate,HType,HMouldQty,HProcID)" +
                        " values(" + HInterID + "," + HEntryID + "," + oSub.HMaterID.ToString() + "," + oSub.HRelationID.ToString() + "," + oSub.HUnitID.ToString() +
                        ",'" + oSub.HBeginDate.ToShortDateString() + "','" + oSub.HEndDate.ToShortDateString() + "'," + Convert.ToString(oSub.HUsed ? 1 : 0) + ",'" + oSub.HRemark + "','" + oSub.HMaker + "','" + oSub.HMakeDate + "','" + 1 + "','" + 1 + "','" + 1 + "') ");
                }
                oCn.Commit();
                return true;
@@ -83,17 +104,40 @@
            try
            {
                oCn.BeginTran();
                DeleteByID(sItemID);        //删除记录
                //插入表
                //DeleteByID(sItemID);        //删除记录
                ////插入表
                foreach (Model.ClsGy_MateMould_Model oSub in DetailColl)
                {
                    oCn.RunProc("Insert into Gy_MateMouldInfo " +
                        " (HMaterID,HRelationID,HUnitID" +
                        ",HBeginDate,HEndDate" +
                        ",HUsed,HRemark,HMaker,HMakeDate)" +
                        " values(" + oSub.HMaterID.ToString() + "," + oSub.HRelationID.ToString() + "," + oSub.HUnitID.ToString() +
                        ",'" + oSub.HBeginDate.ToShortDateString() + "','" + oSub.HEndDate.ToShortDateString() + "'," + Convert.ToString(oSub.HUsed ? 1 : 0) + ",'" + oSub.HRemark + "','" + oSub.HMaker + "','" + oSub.HMakeDate + "') ");
                    //    oCn.RunProc("Insert into Gy_MateMouldInfo " +
                    //        " (HMaterID,HRelationID,HUnitID" +
                    //        ",HBeginDate,HEndDate" +
                    //        ",HUsed,HRemark,HMaker,HMakeDate)" +
                    //        " values(" + oSub.HMaterID.ToString() + "," + oSub.HRelationID.ToString() + "," + oSub.HUnitID.ToString() +
                    //        ",'" + oSub.HBeginDate.ToShortDateString() + "','" + oSub.HEndDate.ToShortDateString() + "'," + Convert.ToString(oSub.HUsed ? 1 : 0) + ",'" + oSub.HRemark + "','" + oSub.HMaker + "','" + oSub.HMakeDate + "') ");
                    oCn.RunProc("Update Gy_MateMouldInfo set " +
                       "HRemark='" + oSub.HRemark + "'" +
                       ",HMaterID='" + oSub.HMaterID + "'" +
                       ",HRelationID='" + oSub.HRelationID + "'" + 
                       ",HUnitID='" + oSub.HUnitID + "'" +
                       //",HStopflag=" + Convert.ToString(HStopflag ? 1 : 0) +
                       //",HUseFlag=" + Convert.ToString(HUseFlag ? 1 : 0) +
                       //",HMakeTime= getdate()" +
                       //",HMakeEmp='" + HMakeEmp + "'" +
                       /*",HRemark='" + HRemark + */"Where HItemID ='" + sItemID + "'", ref DBUtility.ClsPub.sExeReturnInfo);
                }
                //oCn.RunProc("Update Gy_MateMouldInfo set " +
                //       " HMaterID='" + oSub.HMaterID.ToString() + "'" +
                //       ",HRelationID='" + oSub.HRelationID.ToString() + "'" +
                //       ",HUnitID='" + oSub.HUnitID.ToString() + "'" +
                //       ",HTechParamID='" + HTechParamID + "'" +
                //       ",HTechParamUnitID='" + HTechParamUnitID + "'" +
                //       ",HDeptID='" + HDeptID + "'" +
                //       ",HRemark='" + oSub.HRemark + "'" +
                //       //",HStopflag=" + Convert.ToString(HStopflag ? 1 : 0) +
                //       //",HUseFlag=" + Convert.ToString(HUseFlag ? 1 : 0) +
                //       //",HMakeTime= getdate()" +
                //       //",HMakeEmp='" + HMakeEmp + "'" +
                //       /*",HRemark='" + HRemark + */"Where HItemID ='" + sItemID + "'", ref DBUtility.ClsPub.sExeReturnInfo);
                oCn.Commit();
                return true;
            }