public string Add(InvMould model) { #region 新增 string guid = Guid.NewGuid().ToString(); StringBuilder sb = new StringBuilder(); sb.Append("insert into InvMould(guid, cInvCode, iState, cMaker, dCreateDate) "); sb.Append("values(@guid, @cInvCode, @iState, @cMaker, @dCreateDate)"); SqlParameter[] p = new SqlParameter[] { new SqlParameter("@guid", guid), new SqlParameter("@cInvCode", model.cInvCode), new SqlParameter("@iState", model.iState), new SqlParameter("@cMaker", model.cMaker), new SqlParameter("@dCreateDate", DateTime.Now.Date) }; SqlCommand cmd = new SqlCommand(sb.ToString()); cmd.Parameters.AddRange(p); List <SqlCommand> cmdlist = new List <SqlCommand>(); cmdlist.Add(cmd); foreach (DataRow r in model.dtMouldEq.Rows) { sb.Clear(); sb.Append("insert into InvMoulds(guid, MId, EQId, iStep, timeQty) "); sb.Append("values(@guid, @MId, @EQId, @iStep, @timeQty)"); p = new SqlParameter[] { new SqlParameter("@guid", guid), new SqlParameter("@MId", r["MId"]), new SqlParameter("@EQId", r["EQId"]), new SqlParameter("@iStep", r["iStep"]), new SqlParameter("@timeQty", r["timeQty"]) }; cmd = new SqlCommand(sb.ToString()); cmd.Parameters.AddRange(p); cmdlist.Add(cmd); } DbHelperSQL.ExecuteSqlTran(cmdlist.ToArray()); return(guid); #endregion }
public void Update(InvMould model) { #region 更新 string guid = Guid.NewGuid().ToString(); StringBuilder sb = new StringBuilder(); sb.Append("update InvMould set cInvCode = @cInvCode, cModifier = @cModifier,"); sb.Append(" dModifyDate = @dModifyDate where guid = @guid"); SqlParameter[] p = new SqlParameter[] { new SqlParameter("@guid", guid), new SqlParameter("@cInvCode", model.cInvCode), new SqlParameter("@cModifier", model.cModifier), new SqlParameter("@dModifyDate", DateTime.Now.Date) }; SqlCommand cmd = new SqlCommand(sb.ToString()); cmd.Parameters.AddRange(p); List <SqlCommand> cmdlist = new List <SqlCommand>(); cmdlist.Add(cmd); foreach (DataRow r in model.dtMouldEq.Rows) { sb.Clear(); if (r.RowState == DataRowState.Added) { sb.Append("insert into InvMoulds(guid, MId, EQId, iStep, timeQty) "); sb.Append("values(@guid, @MId, @EQId, @iStep, @timeQty)"); p = new SqlParameter[] { new SqlParameter("@guid", guid), new SqlParameter("@MId", r["MId", DataRowVersion.Original]), new SqlParameter("@EQId", r["EQId", DataRowVersion.Original]), new SqlParameter("@iStep", r["iStep", DataRowVersion.Original]), new SqlParameter("@timeQty", r["timeQty", DataRowVersion.Original]) }; cmd = new SqlCommand(sb.ToString()); cmd.Parameters.AddRange(p); cmdlist.Add(cmd); } else if (r.RowState == DataRowState.Modified) { sb.Append("update InvMoulds set MId = @MId, EQId = @EQId,"); sb.Append("iStep = @iStep, timeQty = @timeQty where AutoId = @AutoId"); p = new SqlParameter[] { new SqlParameter("@AutoId", r["AutoId"]), new SqlParameter("@MId", r["MId"]), new SqlParameter("@EQId", r["EQId"]), new SqlParameter("@iStep", r["iStep"]), new SqlParameter("@timeQty", r["timeQty"]) }; cmd = new SqlCommand(sb.ToString()); cmd.Parameters.AddRange(p); cmdlist.Add(cmd); } else if (r.RowState == DataRowState.Deleted) { sb.Append("delete InvMoulds where AutoId = @AutoId"); p = new SqlParameter[] { new SqlParameter("@AutoId", r["AutoId"]), }; cmd = new SqlCommand(sb.ToString()); cmd.Parameters.AddRange(p); cmdlist.Add(cmd); } } DbHelperSQL.ExecuteSqlTran(cmdlist.ToArray()); #endregion }