public bool DelectCountryPerson(DeleteCountryPerson request) { var result = false; using (var db = DbFactory.Open()) { ArrayList arr = new ArrayList(); string[] arrs = request.ids.Split(','); List <AdcdItems> _ListAdcdItems = new List <AdcdItems>(); AdcdItems _AdcdItems = null; for (int i = 0; i < arrs.Length; i++) { var id = int.Parse(arrs[i]); arr.Add(id); #region 日志 var info = db.Single <CountryPerson>(w => w.Id == id); var adcdInfo = db.Single <ADCDInfo>(w => w.adcd == info.adcd); try { StringBuilder sb = new StringBuilder(); sb.Append("在栏目{组织责任/县级防汛防台责任人}下,删除数据{"); sb.Append("县级adcd:" + adcdInfo.adnm + ""); sb.Append("姓名:" + info.UserName + ""); sb.Append("创建的时间:" + info.CreateTime + ""); sb.Append("电话:" + info.Phone + ""); sb.Append("岗位:" + info.Position + ""); sb.Append("职务:" + info.Post + ""); sb.Append("年份:" + info.Year + ""); sb.Append("标记:" + info.Remark + ""); sb.Append("县的名字:" + info.Country + ""); sb.Append("更改人的名字:" + info.UpdateName + ""); sb.Append("更改的时间:" + info.UpdateTime + ""); sb.Append("创建的人:" + info.CreateName + ""); sb.Append("}"); logHelper.WriteLog(sb.ToString(), OperationTypeEnums.新增); } catch (Exception ex) { } #endregion _AdcdItems = new AdcdItems() { adcdId = adcdInfo.Id, phone = info.Phone, username = info.UserName, adcd = adcdInfo.adcd }; _ListAdcdItems.Add(_AdcdItems); } result = db.Delete <CountryPerson>(x => Sql.In(x.Id, arr)) > 0; if (result) { _IAppRegPersonUpdate.AppRegPersonDelMore(new AppRegPersonDelMore() { countyadcd = _AdcdItems.adcd, AdcdIds = _ListAdcdItems }); } return(result); } }
//public string AddChangePersons(AddChangePersons requset) //{ // using (var db = DbFactory.Open()) // { // var builder = requset.information; // //第一版更改批量导入暂时不用 // //var requestAddChangePersonList = JsonTools.Deserialize<List<RequestAddChangePerson>>(builder); // //var countryPersonList = new List<CountryPerson>(); // //foreach (var info in requestAddChangePersonList) // //{ // // var countryPerson = new CountryPerson(); // // countryPerson.UserName = info.Name; // // countryPerson.Phone =info.Phone; // // countryPerson.CountryName = RealName; // // countryPerson.PostionId = info.Id; // // countryPerson.AllowChanges = null; // // countryPersonList.Add(countryPerson); // //} // //db.InsertAll(countryPersonList); // return "yes"; // } //} #endregion #region 执行批量插入数据的方法 public ReturnInsertStatus InsertExeclCountryPerson(CountryImportExcel request) { using (var db = DbFactory.Open()) { var postList = db.Select <Model.Post.Post>(x => x.PostType == GrassrootsFloodCtrlEnums.ZZTXEnums.县级防汛防台责任人.ToString()); //获取数据 var newpath = System.Web.HttpContext.Current.Server.MapPath(request.filePath); //将数据转化table //var dt = Common.ExcelHelper.GetDataTable(newpath); //dt.Rows.RemoveAt(0); Workbook workbook = new Workbook(); workbook.Open(newpath); Cells cells = workbook.Worksheets[0].Cells; var dt = cells.ExportDataTable(0, 0, cells.MaxDataRow + 1, cells.MaxColumn + 1, true); dt.Rows.RemoveAt(0); //table传list var insertExeclCountryPersonList = DtChangeList(dt); //核对数据有没有重复和手机号是否正确 var returnCheckInsert = CheckInsertData(insertExeclCountryPersonList, postList); if (returnCheckInsert.Status) { int checkCount; var auditing = db.Select <AuditCounty>("select * from dbo.AuditCounty where CountyADCD='" + adcd + "'"); if (auditing.Count == 0) { checkCount = 1; } else { checkCount = Convert.ToInt32(auditing[0].AuditNums) + 1; } //插入数据库的List var countryPersonList = GetCountryPerson(insertExeclCountryPersonList, request, checkCount); if (countryPersonList != null) { db.InsertAll(countryPersonList); logHelper.WriteLog(logMsgName + countryPersonList.Count, OperationTypeEnums.新增); List <AdcdItems> _list = new List <AdcdItems>(); var adcdinfo = db.Single <ADCDInfo>(w => w.adcd == countryPersonList.FirstOrDefault().adcd); countryPersonList.ForEach(w => { AdcdItems _model = new AdcdItems() { adcdId = adcdinfo.Id, phone = w.Phone, username = w.UserName }; _list.Add(_model); }); //_IAppRegPersonUpdate.AppRegPersonSaveMore( new AppRegPersonSaveMore() { AdcdIds=_list }); //if (logHelper.WriteLog(logMsgName + countryPersonList.Count, OperationTypeEnums.新增)) //{ throw new Exception("插入日志"); } } } return(returnCheckInsert); } }
/// <summary> /// 删除镇级防汛防台责任人 /// </summary> /// <param name="ids"></param> /// <returns></returns> public bool DelTown(string ids) { bool r = false; using (var db = DbFactory.Open()) { ArrayList arr = new ArrayList(); string[] arrs = ids.Split(','); List <AdcdItems> _ListAdcdItems = new List <AdcdItems>(); AdcdItems _AdcdItems = null; for (int i = 0; i < arrs.Length; i++) { var id = int.Parse(arrs[i]); arr.Add(id); #region 日志 var _f = db.Single <TownPersonLiable>(w => w.Id == id); var adcdInfo = db.Single <ADCDInfo>(w => w.adcd == _f.adcd); StringBuilder sb = new StringBuilder(); sb.Append("在栏目{组织责任/乡(镇、街道)防汛防台责任人}下,删除了数据{"); sb.Append("村ADCD:" + adcdInfo.adnm + ";"); sb.Append("姓名:" + _f.Name + ";"); sb.Append("创建时间:" + _f.CreateTime + ";"); sb.Append("手机:" + _f.Mobile + ";"); sb.Append("职务:" + _f.Position + ";"); sb.Append("岗位:" + _f.Post + ";"); sb.Append("年度:" + _f.Year + ";"); sb.Append("备注:" + _f.Remark + ";"); sb.Append("}"); _ILogHelper.WriteLog(sb.ToString(), OperationTypeEnums.除); #endregion _AdcdItems = new AdcdItems() { adcdId = adcdInfo.Id, phone = _f.Mobile, username = _f.Name, adcd = adcdInfo.adcd }; _ListAdcdItems.Add(_AdcdItems); } r = db.Delete <TownPersonLiable>(x => Sql.In(x.Id, arr)) > 0; //if (r) //{ // _IAppRegPersonUpdate.AppRegPersonDelMore(new AppRegPersonDelMore() { townadcd=_AdcdItems.adcd, AdcdIds = _ListAdcdItems }); //} return(r); } }
/// <summary> /// 批量导入更新 /// </summary> /// <param name="request"></param> /// <returns></returns> public BaseResult AppRegPersonSaveMore(AppRegPersonSaveMore request) { BaseResult br = new BaseResult(); using (var db = DbFactory.Open()) { try { //取出现有数据 var reqList = request.AdcdIds.Select(w => w.adcdId).Distinct().ToArray(); var regList = db.Select <AppGetReg>(w => Sql.In(w.AdcdId, reqList)); //找出新数据 List <AdcdItems> _newlist = new List <AdcdItems>(); request.AdcdIds.ForEach(w => { var f = regList.Where(x => x.Mobile == w.phone && UserName == w.username && x.AdcdId == w.adcdId).ToList(); if (f == null || f.Count == 0) { AdcdItems _items = new AdcdItems() { adcdId = w.adcdId, phone = w.phone, username = w.username }; _newlist.Add(_items); } }); //遍历更新 if (_newlist.Count > 0) { _newlist.ForEach(w => { AppRegPersonSaveOne(new ServiceModel.Route.AppRegPersonSaveOne() { hanphone = w.phone, username = w.username, adcdid = w.adcdId }); }); } } catch (Exception ex) { br.IsSuccess = false; br.ErrorMsg = ex.Message; } return(br); } }