public bool ImportPeople(List <string> strs, string unitcode, string pid, out string errorMsg) { errorMsg = string.Empty; using (var db = dbFactory.Open()) { using (var dbTran = db.OpenTransaction()) { try { foreach (var item in strs) { t_D_UserTableSix six = new t_D_UserTableSix() { gzjl = item, staitc = 0, unitcode = unitcode, pid = pid }; db.Insert(six); } dbTran.Commit(); return(true); } catch (Exception ex) { dbTran.Rollback(); errorMsg = ex.Message; return(false); } } } }
public ActionResult Save(ApplyQualifySixSaveModel model) { ControllerResult result = ControllerResult.SuccResult; List <ApplyQualifSixData> peoples = new List <ApplyQualifSixData>(); var root = XElement.Parse(model.gridStr); // var updataPath = XElement.Parse(model.updatapath); List <int?> Ids = new List <int?>();//存储所有的人员编号,方便在后续的对数据库的操作中对人员编号赋值 var customId = repOne.GetById(model.PId).unitCode; foreach (var rowElem in root.Elements("row")) { var id = (int?)rowElem.Attribute("id"); if (Ids.Contains(id))//如果已经有这个人员信息,直接下一个 { continue; } Ids.Add(id); var text = (string)rowElem; var index = 0; ApplyQualifSixData people = new ApplyQualifSixData(); foreach (var cellElem in rowElem.Elements("cell")) { switch (index) { case 0: people.xm = (string)cellElem; break; case 1: people.xb = (string)cellElem; break; case 2: people.nl = (string)cellElem; break; case 3: people.zw = (string)cellElem; break; case 4: people.xl = (string)cellElem; break; case 5: people.zy = (string)cellElem; break; case 6: people.zc = (string)cellElem; break; case 7: people.sfzhm = (string)cellElem; break; case 8: people.sgzsh = (string)cellElem; break; case 9: people.csjflb = (string)cellElem; break; case 10: people.csjfnx = (string)cellElem; break; case 11: people.shbxzh = (string)cellElem; break; case 12: people.xlpath = (string)cellElem; break; case 13: people.zcpath = (string)cellElem; break; case 14: people.sfzhmpath = (string)cellElem; break; case 15: people.sgzshpath = (string)cellElem; break; } index++; } peoples.Add(people); } using (var db = dbFactory.Open()) { using (var dbTrans = db.OpenTransaction()) { try { db.Delete <t_D_UserTableSix>(t => t.pid == model.PId && t.unitcode == customId); var index = 0; foreach (var item in peoples) { t_D_UserTableSix oneSxi = new t_D_UserTableSix() { PeopleId = Ids[index], gzjl = item.ToJson(), unitcode = customId, pid = model.PId, staitc = 0 }; db.Insert(oneSxi); index++; } dbTrans.Commit(); } catch (Exception ex) { dbTrans.Rollback(); result.ErroMsg = ex.Message; result = ControllerResult.FailResult; } } } return(Content(result.ToJson())); }