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