public bool Post(NoVerifySaveCountryPerson request) { return(CountryPerson.SaveCountryPerson(request)); }
public bool SaveCountryPerson(NoVerifySaveCountryPerson requset) { using (var db = DbFactory.Open()) { if (string.IsNullOrEmpty(adcd)) { throw new Exception("请重新登录"); } if (!ValidatorHelper.IsMobile(requset.Mobile)) { throw new Exception("手机号码输入错误,请重新输入"); } var info = new CountryPerson(); var log = new operateLog(); log.userName = RealName; log.operateTime = DateTime.Now; if (requset.Id != 0) { info.Id = requset.Id; //log.operateMsg = "更新" + requset.name + "的镇级责任人信息"; } //else //{ // var model = GetCountryPersonInfo(requset.name); // if (model != null) // throw new Exception("已存在"); // //log.operateMsg = "新增" + requset.name + "的镇级责任人信息"; //} info.UserName = requset.name; info.CreateTime = DateTime.Now; info.Phone = requset.Mobile; info.Position = requset.Position; info.Post = requset.Post; info.Year = DateTime.Now.Year; info.Remark = requset.Remark; info.Country = RealName; info.UpdateName = requset.name; info.UpdateTime = DateTime.Now; info.CreateName = requset.name; info.adcd = adcd; var oldInfo = db.Single <CountryPerson>(x => x.Id == requset.Id); if (requset.Id != 0) { info.AuditNums = oldInfo.AuditNums + 1; info.OldData = JsonTools.ObjectToJson(oldInfo); info.NewData = JsonTools.ObjectToJson(info); #region 日志 try { var adcdInfo = db.Single <ADCDInfo>(w => w.adcd == oldInfo.adcd); StringBuilder sb = new StringBuilder(); sb.Append("在栏目{组织责任/县级防汛防台责任人}下,更新数据{"); sb.Append("县级adcd:" + adcdInfo.adnm + ""); sb.Append("姓名:" + oldInfo.UserName + ""); sb.Append("创建的时间:" + oldInfo.CreateTime + ""); sb.Append("电话:" + oldInfo.Phone + ""); sb.Append("岗位:" + oldInfo.Position + ""); sb.Append("职务:" + oldInfo.Post + ""); sb.Append("年份:" + oldInfo.Year + ""); sb.Append("标记:" + oldInfo.Remark + ""); sb.Append("县的名字:" + oldInfo.Country + ""); sb.Append("更改人的名字:" + oldInfo.UpdateName + ""); sb.Append("更改的时间:" + oldInfo.UpdateTime + ""); sb.Append("创建的人:" + oldInfo.CreateName + ""); 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 //"select * from CountryPerson where Phone='" + info.Phone + "' and Position='" + info.Position + "' and UserName='******' and " var r = db.Single <CountryPerson>(w => w.Phone == requset.Mobile && w.Position == info.Position && w.UserName == info.UserName && w.Remark == info.Remark && w.Post == info.Post); if (r != null) { return(false); } else { return(db.Update(info) == 1); } } else { int count; var list = db.Select <AuditCounty>("select * from dbo.AuditCounty where CountyADCD='" + adcd + "' "); if (list.Count == 0) { count = 1; } else { count = Convert.ToInt32(list[0].AuditNums) + 1; } info.AuditNums = count; info.OldData = ""; info.NewData = ""; #region 日志 try { StringBuilder sb = new StringBuilder(); var adcdInfo = db.Single <ADCDInfo>(w => w.adcd == info.adcd); 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 if (db.Select <CountryPerson>("select * from CountryPerson where Phone='" + info.Phone + "' and Position='" + info.Position + "' and UserName='******'").ToList().Count == 1) { return(false); } else { return(db.Insert(info) == 1); } } } }