public ActionResult ConstractDtlEdit(int?id, int TemplateId)
{
ConstractDtl constractDtl = new ConstractDtl();
if (id.HasValue)
{
constractDtl = db.ConstractDtl.Find(id.Value);
}
ViewBag.TableIds = new SelectList(SearchConstractTemplateTables(TemplateId));
return(PartialView("_PartialConstractDtl", constractDtl));
}
public ActionResult ConstractDtlSave(int?id)
{
ConstractDtl constractDtl = new ConstractDtl();
if (id.HasValue)
{
constractDtl = db.ConstractDtl.Find(id.Value);
TryUpdateModel <ConstractDtl>(constractDtl);
}
else
{
TryUpdateModel <ConstractDtl>(constractDtl);
constractDtl.InDateTime = DateTime.Now;
constractDtl.InUserId = UserInfo.UserId;
db.ConstractDtl.Add(constractDtl);
}
db.SaveChanges();
return(Json(""));
}
public ActionResult ConstractDtlSaveBatch(ConstractDtl constractDtl)
{
string[] tableIds = constractDtl.TableId.Split(';');
string[] column1s = SplitString(constractDtl.Column1, tableIds.Length);
string[] column2s = SplitString(constractDtl.Column2, tableIds.Length);
string[] column3s = SplitString(constractDtl.Column3, tableIds.Length);
string[] column4s = SplitString(constractDtl.Column4, tableIds.Length);
string[] column5s = SplitString(constractDtl.Column5, tableIds.Length);
string[] column6s = SplitString(constractDtl.Column6, tableIds.Length);
string[] column7s = SplitString(constractDtl.Column7, tableIds.Length);
string[] column8s = SplitString(constractDtl.Column8, tableIds.Length);
string[] column9s = SplitString(constractDtl.Column9, tableIds.Length);
string[] column10s = SplitString(constractDtl.Column10, tableIds.Length);
db.Database.ExecuteSqlCommand("delete from ConstractDtl where ConstractId=" + constractDtl.ConstractId);
for (int i = 0; i < tableIds.Length; i++)
{
ConstractDtl item = new ConstractDtl();
item.ConstractId = constractDtl.ConstractId;
item.TableId = tableIds[i];
item.Column1 = column1s[i];
item.Column2 = column2s[i];
item.Column3 = column3s[i];
item.Column4 = column4s[i];
item.Column5 = column5s[i];
item.Column6 = column6s[i];
item.Column7 = column7s[i];
item.Column8 = column8s[i];
item.Column9 = column9s[i];
item.Column10 = column10s[i];
item.InDateTime = DateTime.Now;
item.InUserId = UserInfo.UserId;
db.ConstractDtl.Add(item);
}
db.SaveChanges();
return(Json(""));
}
