/// <summary> /// 村级工作组 /// </summary> /// <param name="request"></param> /// <returns></returns> public List <DSVillageWorkingGroupViewModel> VillageGroupPersLiableList(VillageGroupPersLiableList request) { List <DSVillageWorkingGroupViewModel> _list = null; 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 <VillageWorkingGroup>(); if (list[0].adcd.Contains("00000000000")) { //市 _list = db.SqlList <DSVillageWorkingGroupViewModel>("EXEC VillageWorkingGroupList @adcd", new { adcd = list[0].adcd.Substring(0, 4) }); } else if (list[0].adcd.Contains("000000000")) { //县 _list = db.SqlList <DSVillageWorkingGroupViewModel>("EXEC VillageWorkingGroupList @adcd", new { adcd = list[0].adcd.Substring(0, 6) }); } else { } } return(_list); } }
//村级工作组 public List <DSVillageWorkingGroupViewModel> POST(VillageGroupPersLiableList request) { return(DataShareManager.VillageGroupPersLiableList(request)); }