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