/// <summary>
/// 村级人员转移清单
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public List <DSVillageTransferPersonViewModel> VillageTransferPersLiableList(VillageTransferPersLiableList request)
{
//List<DSVillageTransferPersonViewModel> _list = new List<DSVillageTransferPersonViewModel>();
List <DataShareReturnModel> list = new List <DataShareReturnModel>();
List <DSVillageTransferPersonViewModel> _list = new List <DSVillageTransferPersonViewModel>();
using (var db = DbFactory.Open())
{
if (string.IsNullOrEmpty(request.username.Trim()) || string.IsNullOrEmpty(request.password.Trim()) || string.IsNullOrEmpty(request.adcd.Trim()))
{
throw new Exception("账号,密码,adcd不能为空！");
}
//var builder = db.From<DatashareUser>();
list = db.SqlList <DataShareReturnModel>("EXEC DataShareGetUser @username,@password", new { UserName = request.username, Password = request.password });
//return list;
if (list != null)
{
var builder = db.From <VillageTransferPerson>();
if (list[0].adcd.Contains("00000000000"))
{
//市
_list = db.SqlList <DSVillageTransferPersonViewModel>("EXEC VillageTransferPersonList @adcd", new { adcd = list[0].adcd.Substring(0, 4) });
}
else if (list[0].adcd.Contains("000000000"))
{
//县
_list = db.SqlList <DSVillageTransferPersonViewModel>("EXEC VillageTransferPersonList @adcd", new { adcd = list[0].adcd.Substring(0, 6) });
}
else
{
}
}
}
return(_list);
}
//村级人员转移清单
public List <DSVillageTransferPersonViewModel> POST(VillageTransferPersLiableList request)
{
return(DataShareManager.VillageTransferPersLiableList(request));
}
