zzr99
2022-04-21 055b64bfcdcb83aafa2986566df3fba49ed2eb98
DAL/»ù´¡×ÊÁÏ/ÆäËû»ù´¡×ÊÁÏ/ClsGy_StdWorkTimes_Ctl.cs
@@ -86,20 +86,19 @@
                oCn.BeginTran();
                //插入表
                foreach (Model.ClsGy_StdWorkTimes_Model oSub in DetailColl)
              foreach (Model.ClsGy_StdWorkTimes_Model oSub in DetailColl)
                {
                    string sql = string.Format(@"Update Gy_StdWorkTimes set" +
                        "HMaterID=" + oSub.HMaterID.ToString() +
                        "HProcID=" + oSub.HProcID.ToString() +
                        "HStdWorkTimes=" + oSub.HStdWorkTimes.ToString() +
                        "HUpperlimit=" + oSub.HUpperlimit.ToString() +
                        "HLowerlimit=" + oSub.HLowerlimit.ToString() +
                        "HStopflag=" + Convert.ToString(oSub.HStopflag ? 1 : 0) +
                        "HMaker='" + oSub.HMaker + "'" +
                        "HMakeDate='" + oSub.HMakeDate + "'" +
                        "HRemark='" + oSub.HRemark.ToString() + "'" +
                        "HUSEORGID=" + oSub.HUSEORGID +
                         " where HInterID=" + sItemID);
                        " HMaterID=" + oSub.HMaterID.ToString() +
                        ",HProcID=" + oSub.HProcID.ToString() +
                        ",HStdWorkTimes=" + oSub.HStdWorkTimes.ToString() +
                        ",HUpperlimit=" + oSub.HUpperlimit.ToString() +
                        ",HLowerlimit=" + oSub.HLowerlimit.ToString() +
                        ",HMaker='" + oSub.HMaker + "'" +
                        ",HMakeDate='" + oSub.HMakeDate + "'" +
                        ",HRemark='" + oSub.HRemark.ToString() + "'" +
                        ",HUSEORGID=" + oSub.HUSEORGID +
                         " where HItemID=" + sItemID);
                    oCn.RunProc(sql);
                }
                oCn.Commit();
@@ -132,7 +131,7 @@
                    oSub.HRemark = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HRemark"]);
                    oSub.HMaker = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HMaker"]);
                    oSub.HMakeDate = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HMakeDate"]);
                    oSub.HStopflag = (bool)DsSub.Tables[0].Rows[i]["HStopflag"];
                    oSub.HStopflag = ((DsSub.Tables[0].Rows[i]["HStopflag"].ToString() == "1")?true:false);
                    oSub.HUSEORGID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HUSEORGID"]);
                    DetailColl.Add(oSub);