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
}
