| | |
| | | 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(); |
| | |
| | | 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); |