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);
}
