public BaseResult DownLoadVillage(NoVerifyDownLoadVillage request)
        {
            //if (string.IsNullOrEmpty(adcd))
            //{
            //    throw new Exception("请重新登录");
            //}
            var _year = null != request.year && !string.IsNullOrEmpty(request.year.ToString()) ? request.year : System.DateTime.Now.Year;
            var name  = request.adcdname + _year + "防汛防台工作组" + DateTime.Now.ToString("MMddhhmmss") + new Random(DateTime.Now.Second).Next(10000);
            List <VillageWorkingGroupViewModel> RList = null;

            using (var db = DbFactory.Open())
            {
                var builder = db.From <VillageWorkingGroup>();
                builder.LeftJoin <VillageWorkingGroup, ADCDInfo>((x, y) => x.VillageADCD == y.adcd);
                builder.Where <VillageWorkingGroup>(x => x.Year == _year && x.VillageADCD == request.adcd);
                builder.Select(" ADCDInfo.adnm,VillageWorkingGroup.PersonLiable,VillageWorkingGroup.Post,VillageWorkingGroup.Position,VillageWorkingGroup.HandPhone,VillageWorkingGroup.Remarks");
                RList = db.Select <VillageWorkingGroupViewModel>(builder);
            }
            return(DownLoadBase(name, _year, RList));
        }
Example #2
0
 //BaseResult DownLoadVillage(DownLoadVillage request)
 public BaseResult POST(NoVerifyDownLoadVillage request)
 {
     return(NoVerifyVillageWorkingGroupManage.DownLoadVillage(request));
 }