/// <summary>
/// 村级网格责任人
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public List <DSVillageGridViewModel> VillageGridPersLiableList(VillageGridPersLiableList request)
{
List <DSVillageGridViewModel> _list = new List <DSVillageGridViewModel>();
List <DataShareReturnModel> list = new List <DataShareReturnModel>();
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 f_user = db.Single<UserInfo>(w => w.UserName == request.username.Trim() && w.PassWord == DESHelper.DESEncrypt(request.password.Trim()) && w.adcd == request.adcd.Trim() && w.isEnable == true);
list = db.SqlList <DataShareReturnModel>("EXEC DataShareGetUser @username,@password", new { UserName = request.username, Password = request.password });
if (list != null)
{
var builder = db.From <VillageGridPersonLiable>();
if (list[0].adcd.Contains("00000000000"))
{
//市
_list = db.SqlList <DSVillageGridViewModel>("EXEC VillageGridList @adcd", new { adcd = list[0].adcd.Substring(0, 4) });
}
else if (list[0].adcd.Contains("000000000"))
{
//县
_list = db.SqlList <DSVillageGridViewModel>("EXEC VillageGridList @adcd", new { adcd = list[0].adcd.Substring(0, 6) });
}
else
{
}
}
return(_list);
}
}
//村级网格责任人
public List <DSVillageGridViewModel> POST(VillageGridPersLiableList request)
{
return(DataShareManager.VillageGridPersLiableList(request));
}
