public ActionResult GetHref() { int pageIndex = Request["page"] != null?int.Parse(Request["page"]) : 1; int pageSize = Request["rows"] != null?int.Parse(Request["rows"]) : 15; var totalCount = int.MaxValue; var CityID = UserInfo_CityService.LoadEntities(x => x.UserInfo_ID == LoginUser.ID).FirstOrDefault(); string Str = Request["Str"]; //构建搜索条件 UserInfoParam userInfoParam = new UserInfoParam() { C_id = Convert.ToInt32(LoginUser.ID), PageIndex = pageIndex, PageSize = pageSize, TotalCount = totalCount, Str = Str, Tval = Request["Tval"] }; MyhtmlInfoController.SetInfoParam(userInfoParam, T_ItemsService); //MyhtmlInfoController mhc = new MyhtmlInfoController(); //mhc.SetInfoParam //找到所有该人员信息 var savelist = T_SaveHtmlDataService.LoadPageEntities <DateTime>(pageIndex, pageSize, out totalCount, x => x.UserInfo.MasterID == LoginUser.ID && x.DelFlag == Delflag, x => x.SaveTime, false).DefaultIfEmpty(); var ActionInfoList = T_FGJHtmlDataService.LoadSearchFrist(userInfoParam, false, false); var temp = from a in ActionInfoList from b in savelist where b.HtmldataID == a.ID select new { ID = a.ID, HLName = a.HLName, Image_str = (a.Image_str.IndexOf("有") >= 0 ? "有" : "无"), FbTime = a.FbTime, PersonName = a.PersonName, Address = a.Address, photo = a.photo, Laiyuan = a.Laiyuan, FwSumMoney = a.FwSumMoney, FwHuXing = a.FwHuXing, FwLoucheng = a.FwLoucheng, FwZhuangxiu = a.FwZhuangxiu, FwChaoxiang = a.FwChaoxiang, FwNianxian = a.FwNianxian, FwMianji = a.FwMianji, FwBiaoJi = b.BiaoJiId, FwBiaoJiID = b.ID, FwColors = b.T_BiaoJiInfo.Colors, FwUserName = b.UserInfo.UName }; return(Json(new { rows = temp, total = userInfoParam.TotalCount }, JsonRequestBehavior.AllowGet)); }
public object GetJson(UserInfoParam userInfoParam) { var actioninfolist = T_FGJHtmlDataService.LoadSearchFrist(userInfoParam, true, true); #region 基础信息进行查询 if (!string.IsNullOrEmpty(userInfoParam.Zhuanxiu)) { actioninfolist = actioninfolist.Where <T_FGJHtmlData>(u => u.FwZhuangxiu.Contains(userInfoParam.Zhuanxiu)); } if (!string.IsNullOrEmpty(userInfoParam.Pingmu) && userInfoParam.Pingmu.Trim() != "0") { int thiid = int.Parse(userInfoParam.Pingmu); actioninfolist = actioninfolist.Where <T_FGJHtmlData>(u => u.MianjiID == thiid); } if (!string.IsNullOrEmpty(userInfoParam.money) && userInfoParam.money.Trim() != "0") { int thiid = int.Parse(userInfoParam.money); actioninfolist = actioninfolist.Where <T_FGJHtmlData>(u => u.SumMoneyID == thiid); } if (!string.IsNullOrEmpty(userInfoParam.Tingshi) && userInfoParam.Tingshi.Trim() != "0") { int thiid = int.Parse(userInfoParam.Tingshi); actioninfolist = actioninfolist.Where <T_FGJHtmlData>(u => u.HuXingID == thiid); } #endregion #region 根据详细信息进行查询 //if (!string.IsNullOrEmpty(userInfoParam.Mon1.ToString())) //{ // int thiid = int.Parse(userInfoParam.Tingshi); // actioninfolist = actioninfolist.Where<T_FGJHtmlData>(u => u.HuXingID == thiid); //} //if (!string.IsNullOrEmpty(userInfoParam.Mon2.ToString())) //{ // int thiid = int.Parse(userInfoParam.Tingshi); // actioninfolist = actioninfolist.Where<T_FGJHtmlData>(u => u.HuXingID == thiid); //} //if (!string.IsNullOrEmpty(userInfoParam.Pm1.ToString())) //{ // int thiid = int.Parse(userInfoParam.Tingshi); // actioninfolist = actioninfolist.Where<T_FGJHtmlData>(u => u.HuXingID == thiid); //} //if (!string.IsNullOrEmpty(userInfoParam.Pm.ToString())) //{ // int thiid = int.Parse(userInfoParam.Tingshi); // actioninfolist = actioninfolist.Where<T_FGJHtmlData>(u => u.HuXingID == thiid); //} #endregion var UscrClick = T_SeeClickPhotoService.LoadEntities(x => x.UserID == LoginUser.ID).DefaultIfEmpty(); var temp = from a in actioninfolist select new { ID = a.ID, HLName = a.HLName, Image_str = (a.Image_str.IndexOf("有") >= 0 ? "有" : "无"), FbTime = a.FbTime, PersonName = a.PersonName, Address = a.Address, photo = UscrClick.Where(x => x.T_FgjID == a.ID).FirstOrDefault() != null ? a.photo : string.Empty, Laiyuan = a.Laiyuan, FwSumMoney = a.FwSumMoney, FwHuXing = a.FwHuXing, FwLoucheng = a.FwLoucheng, FwZhuangxiu = a.FwZhuangxiu, FwChaoxiang = a.FwChaoxiang, FwNianxian = a.FwNianxian, FwMianji = a.FwMianji }; return(temp); }