/// <summary>
/// 查询HuoPingBuMenKuCun
/// </summary>
/// <param name="req"></param>
/// <returns></returns>
public SearchListResult <HuoPingBuMenKuCun> SearchList(HuoPingBuMenKuCunReq req)
{
var query = from source in db.HuoPingBuMenKuCun select source;
if (req.projectid != null && req.projectid != 0)
{
query = query.Where(d => d.projectId == req.projectid);
}
if (!string.IsNullOrEmpty(req.projectName))
{
query = query.Where(d => d.projectName.Contains(req.projectName));
}
if (req.HPId != null)
{
query = query.Where(d => d.HPId == req.HPId);
}
if (!string.IsNullOrEmpty(req.HPName))
{
query = query.Where(d => d.HPName.Contains(req.HPName));
}
if (req.CurStock != null)
{
query = query.Where(d => d.CurStock == req.CurStock);
}
if (string.IsNullOrEmpty(req.sidx))
{
req.sidx = "id";
req.sord = "desc";
}
SearchListResult <HuoPingBuMenKuCun> retListResult = query.ToSearchList(req);
return(retListResult);
}
public static SearchListResult <T> ToSearchList <T>(this IQueryable <T> query, BaseSearchReq req, bool isWithOrder = true)
{
#if DEBUG
//query.
// query.Log = (log) => { System.Diagnostics.Debug.WriteLine(log); };
#endif
if (req.rows == 0)
{
req.rows = 100000;
}
if (req.page <= 0)
{
req.page = 1;
}
if (isWithOrder)
{
query = OrderingHelper <T>(query, req.sidx, req.sord == "desc", false);
}
SearchListResult <T> retListResult = new SearchListResult <T>();
retListResult.records = query.Count();
retListResult.rows = query.Skip((req.page - 1) * req.rows).Take(req.rows).ToList();
retListResult.page = req.page;
retListResult.total = (retListResult.records - 1) / req.rows + 1;
return(retListResult);
}
/// <summary>
/// 查询CaipuModel
/// </summary>
/// <param name="req"></param>
/// <returns></returns>
public SearchListResult <CaipuModel> SearchList(CaipuModelReq req)
{
var query = from source in db.CaipuModel select source;
if (!string.IsNullOrEmpty(req.Name))
{
query = query.Where(d => d.Name.Contains(req.Name));
}
if (!string.IsNullOrEmpty(req.CaiType))
{
query = query.Where(d => d.CaiType.Contains(req.CaiType));
}
if (!string.IsNullOrEmpty(req.CanType))
{
query = query.Where(d => d.CanType.Contains(req.CanType));
}
if (req.Step != null)
{
query = query.Where(d => d.Step == req.Step);
}
if (!string.IsNullOrEmpty(req.Peiliao))
{
query = query.Where(d => d.Peiliao.Contains(req.Peiliao));
}
if (!string.IsNullOrEmpty(req.ValidState))
{
query = query.Where(d => d.ValidState.Contains(req.ValidState));
}
if (req.OptId != null)
{
query = query.Where(d => d.OptId == req.OptId);
}
if (!string.IsNullOrEmpty(req.OptName))
{
query = query.Where(d => d.OptName.Contains(req.OptName));
}
if (!string.IsNullOrEmpty(req.Type))
{
query = query.Where(d => d.Type.Contains(req.Type));
}
if (!string.IsNullOrEmpty(req.ServerWeekDay))
{
query = query.Where(d => d.ServerWeekDay.Contains(req.ServerWeekDay));
}
if (!string.IsNullOrEmpty(req.Gongxiao))
{
query = query.Where(d => d.Gongxiao.Contains(req.Gongxiao));
}
if (string.IsNullOrEmpty(req.sidx))
{
req.sidx = "id";
req.sord = "desc";
}
SearchListResult <CaipuModel> retListResult = query.ToSearchList(req);
return(retListResult);
}
/// <summary>
/// 查询SmsLog
/// </summary>
/// <param name="req"></param>
/// <returns></returns>
public SearchListResult <SmsLog> SearchList(SmsLogReq req)
{
var query = from source in db.SmsLog select source;
if (!string.IsNullOrEmpty(req.Type))
{
query = query.Where(d => d.Type.Contains(req.Type));
}
if (req.RefId != null)
{
query = query.Where(d => d.RefId == req.RefId);
}
if (req.SendDateStart != DateTime.MinValue && req.SendDateStart != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.SendDate >= req.SendDateStart);
}
if (req.SendDateEnd != DateTime.MinValue && req.SendDateEnd != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.SendDate >= req.SendDateEnd);
}
if (!string.IsNullOrEmpty(req.Result))
{
query = query.Where(d => d.Result.Contains(req.Result));
}
if (!string.IsNullOrEmpty(req.SmsMsg))
{
query = query.Where(d => d.SmsMsg.Contains(req.SmsMsg));
}
if (!string.IsNullOrEmpty(req.RetCode))
{
query = query.Where(d => d.RetCode.Contains(req.RetCode));
}
if (!string.IsNullOrEmpty(req.State))
{
query = query.Where(d => d.State.Contains(req.State));
}
if (req.projectid != null && req.projectid != 0)
{
query = query.Where(d => d.projectid == req.projectid);
}
if (!string.IsNullOrEmpty(req.ToPhones))
{
query = query.Where(d => d.ToPhones.Contains(req.ToPhones));
}
if (!string.IsNullOrEmpty(req.RefTitle))
{
query = query.Where(d => d.RefTitle.Contains(req.RefTitle));
}
if (string.IsNullOrEmpty(req.sidx))
{
req.sidx = "id";
req.sord = "desc";
}
SearchListResult <SmsLog> retListResult = query.ToSearchList(req);
return(retListResult);
}
public SearchListResult <JMSJieDianMXModel> SearchList(JMSJieDianMXModelReq req)
{
var query = from source in db.JMSJieDianMXModel select source;
if (!string.IsNullOrEmpty(req.JdClassIDStr))
{
string[] cids = req.JdClassIDStr.Split(","[0]);
query = query.Where(d => cids.Contains(d.JdClassID + ""));
}
if (req.JdClassID != null)
{
query = query.Where(d => d.JdClassID == req.JdClassID);
}
if (req.JdID != null)
{
query = query.Where(d => d.JdID == req.JdID);
}
if (!string.IsNullOrEmpty(req.JdMXName))
{
query = query.Where(d => d.JdMXName.Contains(req.JdMXName));
}
if (!string.IsNullOrEmpty(req.JdMXFuJianUrl))
{
query = query.Where(d => d.JdMXFuJianUrl.Contains(req.JdMXFuJianUrl));
}
if (!string.IsNullOrEmpty(req.JdMXFuJianFileClass))
{
query = query.Where(d => d.JdMXFuJianFileClass.Contains(req.JdMXFuJianFileClass));
}
if (!string.IsNullOrEmpty(req.JdMXFuJianJiaMengClass))
{
query = query.Where(d => d.JdMXFuJianJiaMengClass.Contains(req.JdMXFuJianJiaMengClass));
}
if (req.JdMXStateID != null)
{
query = query.Where(d => d.JdMXStateID == req.JdMXStateID);
}
if (!string.IsNullOrEmpty(req.optName))
{
query = query.Where(d => d.optName.Contains(req.optName));
}
if (req.optDateTimeStart != DateTime.MinValue && req.optDateTimeStart != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.optDateTime >= req.optDateTimeStart);
}
if (req.optDateTimeEnd != DateTime.MinValue && req.optDateTimeEnd != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.optDateTime >= req.optDateTimeEnd);
}
if (string.IsNullOrEmpty(req.sidx))
{
req.sidx = "id";
}
SearchListResult <JMSJieDianMXModel> retListResult = query.ToSearchList(req);
return(retListResult);
}
public SearchListResult <JMSJieDianClassObj> SearchList(JMSJieDianClassObjReq req)
{
var query = from source in db.JMSJieDianClassObj select source;
if (req.JmsID != null)
{
query = query.Where(d => d.JmsID == req.JmsID);
}
if (!string.IsNullOrEmpty(req.JmsName))
{
query = query.Where(d => d.JmsName.Contains(req.JmsName));
}
if (req.JdClassModelID != null)
{
query = query.Where(d => d.JdClassModelID == req.JdClassModelID);
}
if (!string.IsNullOrEmpty(req.JdClassModelName))
{
query = query.Where(d => d.JdClassModelName.Contains(req.JdClassModelName));
}
if (req.JdClassPaiXu != null)
{
query = query.Where(d => d.JdClassPaiXu == req.JdClassPaiXu);
}
if (req.JdClassStateID != null)
{
query = query.Where(d => d.JdClassStateID == req.JdClassStateID);
}
if (req.JdClassConfirmID != null)
{
query = query.Where(d => d.JdClassConfirmID == req.JdClassConfirmID);
}
if (req.projectid != null && req.projectid.Value != 0)
{
query = query.Where(d => d.ProjectID == req.projectid);
}
if (!string.IsNullOrEmpty(req.optName))
{
query = query.Where(d => d.optName.Contains(req.optName));
}
if (req.optDateTimeStart != DateTime.MinValue && req.optDateTimeStart != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.optDateTime >= req.optDateTimeStart);
}
if (req.optDateTimeEnd != DateTime.MinValue && req.optDateTimeEnd != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.optDateTime >= req.optDateTimeEnd);
}
if (string.IsNullOrEmpty(req.sidx))
{
req.sidx = "id";
}
SearchListResult <JMSJieDianClassObj> retListResult = query.ToSearchList(req);
return(retListResult);
}
/// <summary>
/// 查询DayType
/// </summary>
/// <param name="req"></param>
/// <returns></returns>
public SearchListResult <DayType> SearchList(DayTypeReq req)
{
var query = from source in db.DayType select source;
if (!string.IsNullOrEmpty(req.DayTypeName))
{
query = query.Where(d => d.DayTypeName.Contains(req.DayTypeName));
}
if (req.ServerDateStart != DateTime.MinValue && req.ServerDateStart != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.ServerDate >= req.ServerDateStart);
}
if (req.ServerDateEnd != DateTime.MinValue && req.ServerDateEnd != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.ServerDate <= req.ServerDateEnd);
}
if (req.OptId != null)
{
query = query.Where(d => d.OptId == req.OptId);
}
if (!string.IsNullOrEmpty(req.OptName))
{
query = query.Where(d => d.OptName.Contains(req.OptName));
}
if (req.CreateDateStart != DateTime.MinValue && req.CreateDateStart != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.CreateDate >= req.CreateDateStart);
}
if (req.CreateDateEnd != DateTime.MinValue && req.CreateDateEnd != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.CreateDate <= req.CreateDateEnd);
}
if (!string.IsNullOrEmpty(req.ValidState))
{
query = query.Where(d => d.ValidState.Contains(req.ValidState));
}
if (!string.IsNullOrEmpty(req.projectids))
{
List <int?> projectids = req.projectids.Split(",".ToCharArray(), StringSplitOptions.RemoveEmptyEntries).Select(
s =>
{
int?temp;
temp = Convert.ToInt32(s);
return(temp);
}).ToList();
query = query.Where(d => projectids.Contains(d.projectid));
}
if (string.IsNullOrEmpty(req.sidx))
{
req.sidx = "id";
req.sord = "desc";
}
SearchListResult <DayType> retListResult = query.ToSearchList(req);
return(retListResult);
}
/// <summary>
/// 查询MenDianZhiBiao
/// </summary>
/// <param name="req"></param>
/// <returns></returns>
public SearchListResult <MenDianZhiBiao> SearchList(MenDianZhiBiaoReq req)
{
var query = from source in db.MenDianZhiBiao select source;
if (req.yueXiaoShou != null)
{
query = query.Where(d => d.yueXiaoShou == req.yueXiaoShou);
}
if (req.jianyeMoney != null)
{
query = query.Where(d => d.jianyeMoney == req.jianyeMoney);
}
if (req.DingdanCount != null)
{
query = query.Where(d => d.DingdanCount == req.DingdanCount);
}
if (req.canguanCount != null)
{
query = query.Where(d => d.canguanCount == req.canguanCount);
}
if (!string.IsNullOrEmpty(req.zhibiaoYear))
{
query = query.Where(d => d.zhibiaoYear.Contains(req.zhibiaoYear));
}
if (!string.IsNullOrEmpty(req.zhibiaoStateID))
{
query = query.Where(d => d.zhibiaoStateID.Contains(req.zhibiaoStateID));
}
if (req.projectid != null && req.projectid != 0)
{
query = query.Where(d => d.projectid == req.projectid);
}
if (!string.IsNullOrEmpty(req.optName))
{
query = query.Where(d => d.optName.Contains(req.optName));
}
if (req.optDateTimeStart != DateTime.MinValue && req.optDateTimeStart != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.optDateTime >= req.optDateTimeStart);
}
if (req.optDateTimeEnd != DateTime.MinValue && req.optDateTimeEnd != SqlDateTime.MinValue.Value)
{
DateTime optDateTimeTemp = req.optDateTimeEnd.AddDays(1);
query = query.Where(d => d.optDateTime < optDateTimeTemp);
}
if (string.IsNullOrEmpty(req.sidx))
{
req.sidx = "id";
req.sord = "desc";
}
SearchListResult <MenDianZhiBiao> retListResult = query.ToSearchList(req);
return(retListResult);
}
/// <summary>
/// 查询HeTongServiceModel
/// </summary>
/// <param name="req"></param>
/// <returns></returns>
public SearchListResult <HeTongServiceModel> SearchList(HeTongServiceModelReq req)
{
var query = from source in db.HeTongServiceModel select source;
if (!string.IsNullOrEmpty(req.projectids))
{
List <int> projectids = req.projectids.Split(",".ToCharArray(), StringSplitOptions.RemoveEmptyEntries).Select(s => Convert.ToInt32(s)).ToList();
query = query.Where(d => d.projectid != null && projectids.Contains(d.projectid.Value));
}
if (req.projectid != null && req.projectid != 0)
{
query = query.Where(d => d.projectid == req.projectid);
}
if (!string.IsNullOrEmpty(req.ProjectName))
{
query = query.Where(d => d.ProjectName.Contains(req.ProjectName));
}
if (req.optid != null)
{
query = query.Where(d => d.optid == req.optid);
}
if (!string.IsNullOrEmpty(req.optName))
{
query = query.Where(d => d.optName.Contains(req.optName));
}
if (!string.IsNullOrEmpty(req.state))
{
query = query.Where(d => d.state.Contains(req.state));
}
if (!string.IsNullOrEmpty(req.ServerName))
{
query = query.Where(d => d.ServerName.Contains(req.ServerName));
}
if (req.lastupdateid != null)
{
query = query.Where(d => d.lastupdateid == req.lastupdateid);
}
if (!string.IsNullOrEmpty(req.Mark))
{
query = query.Where(d => d.Mark.Contains(req.Mark));
}
if (string.IsNullOrEmpty(req.sidx))
{
req.sidx = "id";
req.sord = "desc";
}
SearchListResult <HeTongServiceModel> retListResult = query.ToSearchList(req);
return(retListResult);
}
/// <summary>
/// 查询PingXiangInfo
/// </summary>
/// <param name="req"></param>
/// <returns></returns>
public SearchListResult <PingXiangInfo> SearchList(PingXiangInfoReq req)
{
var query = from source in db.PingXiangInfo select source;
if (!string.IsNullOrEmpty(req.PingXiangName))
{
query = query.Where(d => d.PingXiangName.Contains(req.PingXiangName));
}
if (!string.IsNullOrEmpty(req.GongXiao))
{
query = query.Where(d => d.GongXiao.Contains(req.GongXiao));
}
if (!string.IsNullOrEmpty(req.ShouFeiType))
{
query = query.Where(d => d.ShouFeiType.Contains(req.ShouFeiType));
}
if (!string.IsNullOrEmpty(req.ValidState))
{
query = query.Where(d => d.ValidState.Contains(req.ValidState));
}
if (req.OptId != null)
{
query = query.Where(d => d.OptId == req.OptId);
}
if (!string.IsNullOrEmpty(req.OptName))
{
query = query.Where(d => d.OptName.Contains(req.OptName));
}
if (req.CreateDateStart != DateTime.MinValue && req.CreateDateStart != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.CreateDate >= req.CreateDateStart);
}
if (req.CreateDateEnd != DateTime.MinValue && req.CreateDateEnd != SqlDateTime.MinValue.Value)
{
DateTime tempdate = req.CreateDateEnd.Date.AddDays(1);
query = query.Where(d => d.CreateDate < tempdate);
}
if (!string.IsNullOrEmpty(req.ManagerType))
{
query = query.Where(d => d.ManagerType.Contains(req.ManagerType));
}
if (string.IsNullOrEmpty(req.sidx))
{
req.sidx = "id";
req.sord = "desc";
}
SearchListResult <PingXiangInfo> retListResult = query.ToSearchList(req);
return(retListResult);
}
/// <summary>
/// 查询KeHuJieDianModel
/// </summary>
/// <param name="req"></param>
/// <returns></returns>
public SearchListResult <KeHuJieDianModel> SearchList(KeHuJieDianModelReq req)
{
var query = from source in db.KeHuJieDianModel select source;
if (req.JdClassID != null)
{
query = query.Where(d => d.JdClassID == req.JdClassID);
}
if (!string.IsNullOrEmpty(req.JdName))
{
query = query.Where(d => d.JdName.Contains(req.JdName));
}
if (req.JdPaiXu != null)
{
query = query.Where(d => d.JdPaiXu == req.JdPaiXu);
}
if (req.JdStateID != null)
{
query = query.Where(d => d.JdStateID == req.JdStateID);
}
if (!string.IsNullOrEmpty(req.optName))
{
query = query.Where(d => d.optName.Contains(req.optName));
}
if (req.optDateTimeStart != DateTime.MinValue && req.optDateTimeStart != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.optDateTime >= req.optDateTimeStart);
}
if (req.optDateTimeEnd != DateTime.MinValue && req.optDateTimeEnd != SqlDateTime.MinValue.Value)
{
DateTime optDateTimeTemp = req.optDateTimeEnd.AddDays(1);
query = query.Where(d => d.optDateTime < optDateTimeTemp);
}
if (!string.IsNullOrEmpty(req.KeHuUploadFileState))
{
query = query.Where(d => d.KeHuUploadFileState.Contains(req.KeHuUploadFileState));
}
if (!string.IsNullOrEmpty(req.JdSpecialState))
{
query = query.Where(d => d.JdSpecialState.Contains(req.JdSpecialState));
}
if (string.IsNullOrEmpty(req.sidx))
{
req.sidx = "id";
req.sord = "desc";
}
SearchListResult <KeHuJieDianModel> retListResult = query.ToSearchList(req);
return(retListResult);
}
/// <summary>
/// 查询PaiBanType
/// </summary>
/// <param name="req"></param>
/// <returns></returns>
public SearchListResult <PaiBanType> SearchList(PaiBanTypeReq req)
{
var query = from source in db.PaiBanType select source;
if (!string.IsNullOrEmpty(req.Name))
{
query = query.Where(d => d.Name.Contains(req.Name));
}
if (req.Hours != null)
{
query = query.Where(d => d.Hours == req.Hours);
}
if (req.OptId != null)
{
query = query.Where(d => d.OptId == req.OptId);
}
if (!string.IsNullOrEmpty(req.OptName))
{
query = query.Where(d => d.OptName.Contains(req.OptName));
}
if (req.projectid != null && req.projectid != 0)
{
query = query.Where(d => d.projectid == req.projectid);
}
if (!string.IsNullOrEmpty(req.ProjectName))
{
query = query.Where(d => d.ProjectName.Contains(req.ProjectName));
}
if (req.FromHour != null)
{
query = query.Where(d => d.FromHour == req.FromHour);
}
if (req.ToHour != null)
{
query = query.Where(d => d.ToHour == req.ToHour);
}
if (!string.IsNullOrEmpty(req.ValidState))
{
query = query.Where(d => d.ValidState == req.ValidState);
}
if (string.IsNullOrEmpty(req.sidx))
{
req.sidx = "id";
req.sord = "desc";
}
SearchListResult <PaiBanType> retListResult = query.ToSearchList(req);
return(retListResult);
}
/// <summary>
/// 查询GuYuanGroup
/// </summary>
/// <param name="req"></param>
/// <returns></returns>
public SearchListResult <GuYuanGroup> SearchList(GuYuanGroupReq req)
{
var query = from source in db.GuYuanGroup select source;
if (req.Departmentid != null)
{
query = query.Where(d => d.Departmentid == req.Departmentid);
}
if (!string.IsNullOrEmpty(req.DepartmentName))
{
query = query.Where(d => d.DepartmentName.Contains(req.DepartmentName));
}
if (!string.IsNullOrEmpty(req.GroupName))
{
query = query.Where(d => d.GroupName.Contains(req.GroupName));
}
if (!string.IsNullOrEmpty(req.State))
{
query = query.Where(d => d.State.Contains(req.State));
}
if (!string.IsNullOrEmpty(req.OptName))
{
query = query.Where(d => d.OptName.Contains(req.OptName));
}
if (req.OptId != null)
{
query = query.Where(d => d.OptId == req.OptId);
}
if (req.createdateStart != DateTime.MinValue && req.createdateStart != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.createdate >= req.createdateStart);
}
if (req.createdateEnd != DateTime.MinValue && req.createdateEnd != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.createdate >= req.createdateEnd);
}
if (req.projectid != null && req.projectid != 0)
{
query = query.Where(d => d.ProjectId == req.projectid);
}
if (string.IsNullOrEmpty(req.sidx))
{
req.sidx = "id";
req.sord = "desc";
}
SearchListResult <GuYuanGroup> retListResult = query.ToSearchList(req);
return(retListResult);
}
/// <summary>
/// 查询ChildCareMain
/// </summary>
/// <param name="req"></param>
/// <returns></returns>
public SearchListResult <ChildCareMain> SearchList(ChildCareMainReq req)
{
var query = from source in db.ChildCareMain select source;
if (req.ServerDateStart != DateTime.MinValue && req.ServerDateStart != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.ServerDate >= req.ServerDateStart);
}
if (req.ServerDateEnd != DateTime.MinValue && req.ServerDateEnd != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.ServerDate <= req.ServerDateEnd);
}
if (req.Temperature != null)
{
query = query.Where(d => d.Temperature == req.Temperature);
}
if (req.Weight != null)
{
query = query.Where(d => d.Weight == req.Weight);
}
if (req.OptId != null)
{
query = query.Where(d => d.OptId == req.OptId);
}
if (!string.IsNullOrEmpty(req.OptName))
{
query = query.Where(d => d.OptName.Contains(req.OptName));
}
if (!string.IsNullOrEmpty(req.ChildDesc))
{
query = query.Where(d => d.ChildDesc.Contains(req.ChildDesc));
}
if (req.KhId != null)
{
query = query.Where(d => d.KhId == req.KhId);
}
if (!string.IsNullOrEmpty(req.KhName))
{
query = query.Where(d => d.KhName.Contains(req.KhName));
}
if (string.IsNullOrEmpty(req.sidx))
{
req.sidx = "id";
req.sord = "desc";
}
SearchListResult <ChildCareMain> retListResult = query.ToSearchList(req);
return(retListResult);
}
public SearchListResult <JmsDirectory> SearchList(JmsDirectoryReq req)
{
var query = from source in db.JmsDirectory select source;
if (req.ParentId != null)
{
query = query.Where(d => d.ParentId == req.ParentId);
}
if (!string.IsNullOrEmpty(req.ParentName))
{
query = query.Where(d => d.ParentName.Contains(req.ParentName));
}
if (!string.IsNullOrEmpty(req.Name))
{
query = query.Where(d => d.Name.Contains(req.Name));
}
if (!string.IsNullOrEmpty(req.Right))
{
query = query.Where(d => d.Right.Contains(req.Right));
}
if (!string.IsNullOrEmpty(req.State))
{
query = query.Where(d => d.State.Contains(req.State));
}
if (!string.IsNullOrEmpty(req.DirectoryPath))
{
query = query.Where(d => d.DirectoryPath.Contains(req.DirectoryPath));
}
if (!string.IsNullOrEmpty(req.JmsUploadClassState))
{
query = query.Where(d => d.JmsUploadClassState.Contains(req.JmsUploadClassState));
}
if (req.JmsId != null)
{
query = query.Where(d => d.JmsId == req.JmsId);
}
if (!string.IsNullOrEmpty(req.JmsName))
{
query = query.Where(d => d.JmsName.Contains(req.JmsName));
}
if (string.IsNullOrEmpty(req.sidx))
{
req.sidx = "id";
req.sord = "desc";
}
SearchListResult <JmsDirectory> retListResult = query.ToSearchList(req);
return(retListResult);
}
/// <summary>
/// 查询GuYuanKaoQin
/// </summary>
/// <param name="req"></param>
/// <returns></returns>
public SearchListResult <GuYuanKaoQin> SearchList(GuYuanKaoQinReq req)
{
var query = from source in db.GuYuanKaoQin select source;
if (req.guyuanId != null)
{
query = query.Where(d => d.guyuanId == req.guyuanId);
}
if (!string.IsNullOrEmpty(req.guyuanName))
{
query = query.Where(d => d.guyuanName.Contains(req.guyuanName));
}
if (req.workDateStart != DateTime.MinValue && req.workDateStart != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.workDate >= req.workDateStart);
}
if (req.workDateEnd != DateTime.MinValue && req.workDateEnd != SqlDateTime.MinValue.Value)
{
DateTime workDateTemp = req.workDateEnd.AddDays(1);
query = query.Where(d => d.workDate < workDateTemp);
}
if (!string.IsNullOrEmpty(req.checkType))
{
query = query.Where(d => d.checkType.Contains(req.checkType));
}
if (!string.IsNullOrEmpty(req.checkResult))
{
query = query.Where(d => d.checkResult.Contains(req.checkResult));
}
if (req.checkTimeStart != DateTime.MinValue && req.checkTimeStart != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.checkTime >= req.checkTimeStart);
}
if (req.checkTimeEnd != DateTime.MinValue && req.checkTimeEnd != SqlDateTime.MinValue.Value)
{
DateTime checkTimeTemp = req.checkTimeEnd.AddDays(1);
query = query.Where(d => d.checkTime < checkTimeTemp);
}
if (string.IsNullOrEmpty(req.sidx))
{
req.sidx = "id";
req.sord = "desc";
}
SearchListResult <GuYuanKaoQin> retListResult = query.ToSearchList(req);
return(retListResult);
}
public static SearchListResult <ShouKuanInfo> ToSearchShouKuanInfoList(this IQueryable <ShouKuanInfo> query, BaseSearchReq req)
{
#if DEBUG
//query.
// query.Database.Log = (log) => { System.Diagnostics.Debug.WriteLine(log); };
#endif
query = query.OrderByDescending(d => d.JMSShouKuan.id);
SearchListResult <ShouKuanInfo> retListResult = new SearchListResult <ShouKuanInfo>();
retListResult.records = query.Count();
retListResult.rows = query.Skip((req.page - 1) * req.rows).Take(req.rows).ToList();
retListResult.page = req.page;
retListResult.total = (retListResult.records - 1) / req.rows + 1;
return(retListResult);
}
public SearchListResult <JieDianGengZong> SearchList(JieDianGengZongReq req)
{
var query = from source in db.JieDianGengZong select source;
if (req.jdid != null)
{
query = query.Where(d => d.jdid == req.jdid);
}
if (!string.IsNullOrEmpty(req.jdName))
{
query = query.Where(d => d.jdName.Contains(req.jdName));
}
if (!string.IsNullOrEmpty(req.OptName))
{
query = query.Where(d => d.OptName.Contains(req.OptName));
}
if (req.OptId != null)
{
query = query.Where(d => d.OptId == req.OptId);
}
if (req.OptDateTimeStart != DateTime.MinValue && req.OptDateTimeStart != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.OptDateTime >= req.OptDateTimeStart);
}
if (req.OptDateTimeEnd != DateTime.MinValue && req.OptDateTimeEnd != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.OptDateTime >= req.OptDateTimeEnd);
}
if (!string.IsNullOrEmpty(req.Desc))
{
query = query.Where(d => d.Desc.Contains(req.Desc));
}
if (!string.IsNullOrEmpty(req.State))
{
query = query.Where(d => d.State.Contains(req.State));
}
if (string.IsNullOrEmpty(req.sidx))
{
req.sidx = "id";
req.sord = "desc";
}
SearchListResult <JieDianGengZong> retListResult = query.ToSearchList(req);
return(retListResult);
}
/// <summary>
/// 查询KeRenPeiCan
/// </summary>
/// <param name="req"></param>
/// <returns></returns>
public SearchListResult <KeRenPeiCan> SearchList(KeRenPeiCanReq req)
{
var query = from source in db.KeRenPeiCan select source;
if (!string.IsNullOrEmpty(req.CaiPuIds))
{
query = query.Where(d => d.CaiPuIds.Contains(req.CaiPuIds));
}
if (req.DietSpecialId != null)
{
query = query.Where(d => d.DietSpecialId == req.DietSpecialId);
}
if (!string.IsNullOrEmpty(req.LunchSpecial))
{
query = query.Where(d => d.LunchSpecial.Contains(req.LunchSpecial));
}
if (!string.IsNullOrEmpty(req.SupperSpecial))
{
query = query.Where(d => d.SupperSpecial.Contains(req.SupperSpecial));
}
if (req.CreateDateStart != DateTime.MinValue && req.CreateDateStart != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.CreateDate >= req.CreateDateStart);
}
if (req.CreateDateEnd != DateTime.MinValue && req.CreateDateEnd != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.CreateDate >= req.CreateDateEnd);
}
if (!string.IsNullOrEmpty(req.OptName))
{
query = query.Where(d => d.OptName.Contains(req.OptName));
}
if (req.OptId != null)
{
query = query.Where(d => d.OptId == req.OptId);
}
if (string.IsNullOrEmpty(req.sidx))
{
req.sidx = "id";
req.sord = "desc";
}
SearchListResult <KeRenPeiCan> retListResult = query.ToSearchList(req);
return(retListResult);
}
/// <summary>
/// 查询CaipuModelType
/// </summary>
/// <param name="req"></param>
/// <returns></returns>
public SearchListResult <CaipuModelType> SearchList(CaipuModelTypeReq req)
{
var query = from source in db.CaipuModelType select source;
if (!string.IsNullOrEmpty(req.TypeName))
{
query = query.Where(d => d.TypeName.Contains(req.TypeName));
}
if (req.projectid != null && req.projectid != 0)
{
query = query.Where(d => d.projectid == req.projectid);
}
if (!string.IsNullOrEmpty(req.ProjectName))
{
query = query.Where(d => d.ProjectName.Contains(req.ProjectName));
}
if (req.OptId != null)
{
query = query.Where(d => d.OptId == req.OptId);
}
if (!string.IsNullOrEmpty(req.OptName))
{
query = query.Where(d => d.OptName.Contains(req.OptName));
}
if (req.createdateStart != DateTime.MinValue && req.createdateStart != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.createdate >= req.createdateStart);
}
if (req.createdateEnd != DateTime.MinValue && req.createdateEnd != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.createdate >= req.createdateEnd);
}
if (!string.IsNullOrEmpty(req.ValidState))
{
query = query.Where(d => d.ValidState.Contains(req.ValidState));
}
if (string.IsNullOrEmpty(req.sidx))
{
req.sidx = "id";
req.sord = "desc";
}
SearchListResult <CaipuModelType> retListResult = query.ToSearchList(req);
return(retListResult);
}
public SearchListResult <JMSJieDianModel> SearchList(JMSJieDianModelReq req)
{
var query = from source in db.JMSJieDianModel select source;
if (req.JdClassID != null)
{
query = query.Where(d => d.JdClassID == req.JdClassID);
}
if (!string.IsNullOrEmpty(req.JdName))
{
query = query.Where(d => d.JdName.Contains(req.JdName));
}
if (req.JdPaiXu != null)
{
query = query.Where(d => d.JdPaiXu == req.JdPaiXu);
}
if (req.JdStateID != null)
{
query = query.Where(d => d.JdStateID == req.JdStateID);
}
if (!string.IsNullOrEmpty(req.optName))
{
query = query.Where(d => d.optName.Contains(req.optName));
}
if (req.optDateTimeStart != null && req.optDateTimeStart != DateTime.MinValue && req.optDateTimeStart != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.optDateTime >= req.optDateTimeStart);
}
if (req.optDateTimeEnd != null && req.optDateTimeEnd != DateTime.MinValue && req.optDateTimeEnd != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.optDateTime >= req.optDateTimeEnd);
}
if (!string.IsNullOrEmpty(req.JmsUploadFileState))
{
query = query.Where(d => d.JmsUploadFileState.Contains(req.JmsUploadFileState));
}
query = query.Where(d => d.JdSpecialState == null || d.JdSpecialState == "");
if (string.IsNullOrEmpty(req.sidx))
{
req.sidx = "id";
}
SearchListResult <JMSJieDianModel> retListResult = query.ToSearchList(req);
return(retListResult);
}
public SearchListResult <ChildCarePare> SearchPareList(ChildCareMainReq req)
{
ChildCareMainBLL bll = new ChildCareMainBLL();
var query = (from ccd in db.ChildCareDetail
join cm in db.ChildCareMain on ccd.ChildCareId equals cm.id
select new ChildCarePare {
ChildCareMain = cm, ChildCareDetail = ccd
});
if (!string.IsNullOrEmpty(req.KhName))
{
query = query.Where(d => d.ChildCareMain.KhName.Contains(req.KhName));
}
if (req.KhId != null)
{
query = query.Where(d => d.ChildCareMain.KhId == req.KhId);
}
if (req.ServerDateEnd != DateTime.MinValue && req.ServerDateEnd != SqlDateTime.MinValue.Value)
{
DateTime tempend = req.ServerDateEnd.AddDays(1);
query = query.Where(d => d.ChildCareMain.ServerDate < tempend);
}
if (req.ServerDateStart != DateTime.MinValue && req.ServerDateStart != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.ChildCareMain.ServerDate >= req.ServerDateStart);
}
if (req.projectid != null && req.projectid != 0)
{
query = query.Where(d => d.ChildCareMain.projectid == req.projectid);
}
//所有数据都为空的不需要出来
query = query.Where(d => d.ChildCareDetail.FormulaMilk != null || !string.IsNullOrEmpty(d.ChildCareDetail.DaBian) ||
d.ChildCareDetail.MomMilk != null || d.ChildCareDetail.WeiShui != null || !string.IsNullOrEmpty(d.ChildCareDetail.WeiYao) ||
!string.IsNullOrEmpty(d.ChildCareDetail.XiaoBian) || d.ChildCareDetail.SelfWeiCount != null ||
!string.IsNullOrEmpty(d.ChildCareDetail.Mark));
query = query.OrderBy(q => q.ChildCareMain.KhName);
SearchListResult <ChildCarePare> retListResult = query.OrderByDescending(n => n.ChildCareMain.ServerDate).ToSearchList(req, false);
return(retListResult);
}
public SearchListResult <AccessLogs> SearchList(AccessLogsReq req)
{
var query = from accesslog in db.AccessLogs select accesslog;
if (req.KeyId != null)
{
query = query.Where(d => d.KeyId == req.KeyId);
}
if (!string.IsNullOrEmpty(req.Code))
{
query = query.Where(d => d.Code.Contains(req.Code));
}
if (!string.IsNullOrEmpty(req.AccessClass))
{
query = query.Where(d => d.AccessClass.Contains(req.AccessClass));
}
if (!string.IsNullOrEmpty(req.AccessAction))
{
query = query.Where(d => d.AccessAction.Contains(req.AccessAction));
}
if (!string.IsNullOrEmpty(req.AccessInfo))
{
query = query.Where(d => d.AccessInfo.Contains(req.AccessInfo));
}
if (req.AccessTimeStart != DateTime.MinValue && req.AccessTimeStart != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.AccessTime >= req.AccessTimeStart);
}
if (req.AccessTimeEnd != DateTime.MinValue && req.AccessTimeEnd != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.AccessTime >= req.AccessTimeEnd);
}
if (!string.IsNullOrEmpty(req.AccessPerson))
{
query = query.Where(d => d.AccessPerson.Contains(req.AccessPerson));
}
query = query.OrderByDescending(d => d.Id);
SearchListResult <AccessLogs> retListResult = query.ToSearchList(req);
return(retListResult);
}
/// <summary>
/// 查询KeMu
/// </summary>
/// <param name="req"></param>
/// <returns></returns>
public SearchListResult <KeMu> SearchList(KeMuReq req)
{
var query = from source in db.KeMu select source;
if (!string.IsNullOrEmpty(req.Name))
{
query = query.Where(d => d.Name.Contains(req.Name));
}
if (req.OptId != null)
{
query = query.Where(d => d.OptId == req.OptId);
}
if (!string.IsNullOrEmpty(req.OptName))
{
query = query.Where(d => d.OptName.Contains(req.OptName));
}
if (req.CreateDateStart != DateTime.MinValue && req.CreateDateStart != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.CreateDate >= req.CreateDateStart);
}
if (req.CreateDateEnd != DateTime.MinValue && req.CreateDateEnd != SqlDateTime.MinValue.Value)
{
DateTime CreateDateTemp = req.CreateDateEnd.AddDays(1);
query = query.Where(d => d.CreateDate < CreateDateTemp);
}
if (!string.IsNullOrEmpty(req.ValidState))
{
query = query.Where(d => d.ValidState.Contains(req.ValidState));
}
if (string.IsNullOrEmpty(req.sidx))
{
req.sidx = "id";
req.sord = "desc";
}
SearchListResult <KeMu> retListResult = query.ToSearchList(req);
return(retListResult);
}
/// <summary>
/// 查询guDingZiChan
/// </summary>
/// <param name="req"></param>
/// <returns></returns>
public SearchListResult <guDingZiChan> SearchList(guDingZiChanReq req)
{
var query = from source in db.guDingZiChan select source;
if (!string.IsNullOrEmpty(req.companyName))
{
query = query.Where(d => d.companyName.Contains(req.companyName));
}
if (!string.IsNullOrEmpty(req.ziChanTitle))
{
query = query.Where(d => d.ziChanTitle.Contains(req.ziChanTitle));
}
if (req.pandianDateTimeStart != DateTime.MinValue && req.pandianDateTimeStart != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.pandianDateTime >= req.pandianDateTimeStart);
}
if (req.pandianDateTimeEnd != DateTime.MinValue && req.pandianDateTimeEnd != SqlDateTime.MinValue.Value)
{
DateTime pandianDateTimeTemp = req.pandianDateTimeEnd.AddDays(1);
query = query.Where(d => d.pandianDateTime < pandianDateTimeTemp);
}
if (!string.IsNullOrEmpty(req.optName))
{
query = query.Where(d => d.optName.Contains(req.optName));
}
if (req.optId != null)
{
query = query.Where(d => d.optId == req.optId);
}
if (req.createDateStart != DateTime.MinValue && req.createDateStart != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.createDate >= req.createDateStart);
}
if (req.createDateEnd != DateTime.MinValue && req.createDateEnd != SqlDateTime.MinValue.Value)
{
DateTime createDateTemp = req.createDateEnd.AddDays(1);
query = query.Where(d => d.createDate < createDateTemp);
}
if (!string.IsNullOrEmpty(req.projectids))
{
List <int> projectids = req.projectids.Split(",".ToCharArray(), StringSplitOptions.RemoveEmptyEntries).Select(s => Convert.ToInt32(s)).ToList();
query = query.Where(d => d.projectid != null && projectids.Contains(d.projectid.Value));
}
if (!string.IsNullOrEmpty(req.ProjectName))
{
query = query.Where(d => d.ProjectName.Contains(req.ProjectName));
}
if (!string.IsNullOrEmpty(req.state))
{
query = query.Where(d => d.state.Contains(req.state));
}
if (string.IsNullOrEmpty(req.sidx))
{
req.sidx = "id";
req.sord = "desc";
}
SearchListResult <guDingZiChan> retListResult = query.ToSearchList(req);
return(retListResult);
}
/// <summary>
/// 查询Student
/// </summary>
/// <param name="req"></param>
/// <returns></returns>
public SearchListResult <Student> SearchList(StudentReq req)
{
var query = from source in db.Student select source;
if (!string.IsNullOrEmpty(req.Name))
{
query = query.Where(d => d.Name.Contains(req.Name));
}
if (!string.IsNullOrEmpty(req.Phone))
{
query = query.Where(d => d.Phone.Contains(req.Phone));
}
if (!string.IsNullOrEmpty(req.JobPosition))
{
query = query.Where(d => d.JobPosition.Contains(req.JobPosition));
}
if (req.JmsId != null)
{
query = query.Where(d => d.JmsId == req.JmsId);
}
if (!string.IsNullOrEmpty(req.JmsName))
{
query = query.Where(d => d.JmsName.Contains(req.JmsName));
}
if (req.TrainingStartStart != DateTime.MinValue && req.TrainingStartStart != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.TrainingStart >= req.TrainingStartStart);
}
if (req.TrainingStartEnd != DateTime.MinValue && req.TrainingStartEnd != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.TrainingStart >= req.TrainingStartEnd);
}
if (req.TrainingFinishStart != DateTime.MinValue && req.TrainingFinishStart != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.TrainingFinish >= req.TrainingFinishStart);
}
if (req.TrainingFinishEnd != DateTime.MinValue && req.TrainingFinishEnd != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.TrainingFinish >= req.TrainingFinishEnd);
}
if (!string.IsNullOrEmpty(req.State))
{
query = query.Where(d => d.State.Contains(req.State));
}
if (req.OptId != null)
{
query = query.Where(d => d.OptId == req.OptId);
}
if (!string.IsNullOrEmpty(req.OptName))
{
query = query.Where(d => d.OptName.Contains(req.OptName));
}
if (req.CreateDateStart != DateTime.MinValue && req.CreateDateStart != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.CreateDate >= req.CreateDateStart);
}
if (req.CreateDateEnd != DateTime.MinValue && req.CreateDateEnd != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.CreateDate >= req.CreateDateEnd);
}
if (req.UpdateDateStart != DateTime.MinValue && req.UpdateDateStart != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.UpdateDate >= req.UpdateDateStart);
}
if (req.UpdateDateEnd != DateTime.MinValue && req.UpdateDateEnd != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.UpdateDate >= req.UpdateDateEnd);
}
if (!string.IsNullOrEmpty(req.Note))
{
query = query.Where(d => d.Note.Contains(req.Note));
}
if (string.IsNullOrEmpty(req.sidx))
{
req.sidx = "id";
req.sord = "desc";
}
SearchListResult <Student> retListResult = query.ToSearchList(req);
return(retListResult);
}
/// <summary>
/// 查询CustomerPingXiang
/// </summary>
/// <param name="req"></param>
/// <returns></returns>
public SearchListResult <CustomerPingXiang> SearchList(CustomerPingXiangReq req)
{
var query = from source in db.CustomerPingXiang select source;
if (req.KhId != null)
{
query = query.Where(d => d.KhId == req.KhId);
}
if (!string.IsNullOrEmpty(req.KhName))
{
query = query.Where(d => d.KhName.Contains(req.KhName));
}
if (!string.IsNullOrEmpty(req.PingXiangName))
{
query = query.Where(d => d.PingXiangName.Contains(req.PingXiangName));
}
if (!string.IsNullOrEmpty(req.GongXiao))
{
query = query.Where(d => d.GongXiao.Contains(req.GongXiao));
}
if (req.EatStartStart != DateTime.MinValue && req.EatStartStart != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.EatStart >= req.EatStartStart);
}
if (req.EatStartEnd != DateTime.MinValue && req.EatStartEnd != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.EatStart <= req.EatStartEnd);
}
if (req.EatEndStart != DateTime.MinValue && req.EatEndStart != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.EatEnd >= req.EatEndStart);
}
if (req.EatEndEnd != DateTime.MinValue && req.EatEndEnd != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.EatEnd <= req.EatEndEnd);
}
if (!string.IsNullOrEmpty(req.PeiLiao))
{
query = query.Where(d => d.PeiLiao.Contains(req.PeiLiao));
}
if (!string.IsNullOrEmpty(req.Desc))
{
query = query.Where(d => d.Desc.Contains(req.Desc));
}
if (req.projectid != null && req.projectid != 0)
{
query = query.Where(d => d.ProjectId == req.projectid);
}
if (!string.IsNullOrEmpty(req.ProjectName))
{
query = query.Where(d => d.ProjectName.Contains(req.ProjectName));
}
if (!string.IsNullOrEmpty(req.ValidState))
{
query = query.Where(d => d.ValidState.Contains(req.ValidState));
}
if (req.OptId != null)
{
query = query.Where(d => d.OptId == req.OptId);
}
if (!string.IsNullOrEmpty(req.OptName))
{
query = query.Where(d => d.OptName.Contains(req.OptName));
}
if (req.CreateDateStart != DateTime.MinValue && req.CreateDateStart != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.CreateDate >= req.CreateDateStart);
}
if (req.CreateDateEnd != DateTime.MinValue && req.CreateDateEnd != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.CreateDate >= req.CreateDateEnd);
}
if (req.RoomId != null)
{
query = query.Where(d => d.RoomId == req.RoomId);
}
if (!string.IsNullOrEmpty(req.RoomNumber))
{
query = query.Where(d => d.RoomNumber.Contains(req.RoomNumber));
}
if (string.IsNullOrEmpty(req.sidx))
{
req.sidx = "id";
req.sord = "desc";
}
SearchListResult <CustomerPingXiang> retListResult = query.ToSearchList(req);
return(retListResult);
}
/// <summary>
/// 查询HuoPingCaiGouDan
/// </summary>
/// <param name="req"></param>
/// <returns></returns>
public SearchListResult <HuoPingCaiGouDan> SearchList(HuoPingCaiGouDanReq req)
{
var query = from source in db.HuoPingCaiGouDan select source;
if (!string.IsNullOrEmpty(req.CaiGouDanBianHao))
{
query = query.Where(d => d.CaiGouDanBianHao.Contains(req.CaiGouDanBianHao));
}
if (req.HPCount != null)
{
query = query.Where(d => d.HPCount == req.HPCount);
}
if (req.HPZhongLei != null)
{
query = query.Where(d => d.HPZhongLei == req.HPZhongLei);
}
if (req.HPZongJia != null)
{
query = query.Where(d => d.HPZongJia == req.HPZongJia);
}
if (!string.IsNullOrEmpty(req.CaiGouDanState))
{
query = query.Where(d => d.CaiGouDanState.Contains(req.CaiGouDanState));
}
if (req.CaiGouDateStart != DateTime.MinValue && req.CaiGouDateStart != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.CaiGouDate >= req.CaiGouDateStart);
}
if (req.CaiGouDateEnd != DateTime.MinValue && req.CaiGouDateEnd != SqlDateTime.MinValue.Value)
{
DateTime CaiGouDateTemp = req.CaiGouDateEnd.AddDays(1);
query = query.Where(d => d.CaiGouDate < CaiGouDateTemp);
}
if (!string.IsNullOrEmpty(req.optName))
{
query = query.Where(d => d.optName.Contains(req.optName));
}
if (req.optDateTimeStart != DateTime.MinValue && req.optDateTimeStart != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.optDateTime >= req.optDateTimeStart);
}
if (req.optDateTimeEnd != DateTime.MinValue && req.optDateTimeEnd != SqlDateTime.MinValue.Value)
{
DateTime optDateTimeTemp = req.optDateTimeEnd.AddDays(1);
query = query.Where(d => d.optDateTime < optDateTimeTemp);
}
if (req.CaiGouDanLeiXing != null)
{
query = query.Where(d => d.CaiGouDanLeiXing == req.CaiGouDanLeiXing);
}
if (string.IsNullOrEmpty(req.sidx))
{
req.sidx = "Id";
req.sord = "desc";
}
SearchListResult <HuoPingCaiGouDan> retListResult = query.ToSearchList(req);
return(retListResult);
}
/// <summary>
/// 查询HeTongService
/// </summary>
/// <param name="req"></param>
/// <returns></returns>
public SearchListResult <HeTongService> SearchList(HeTongServiceReq req)
{
var query = from source in db.HeTongService select source;
if (!string.IsNullOrEmpty(req.Name))
{
query = query.Where(d => d.Name.Contains(req.Name));
}
if (req.ServerCount != null)
{
query = query.Where(d => d.ServerCount == req.ServerCount);
}
if (req.CreateDateStart != DateTime.MinValue && req.CreateDateStart != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.CreateDate >= req.CreateDateStart);
}
if (req.CreateDateEnd != DateTime.MinValue && req.CreateDateEnd != SqlDateTime.MinValue.Value)
{
DateTime CreateDateTemp = req.CreateDateEnd.AddDays(1);
query = query.Where(d => d.CreateDate < CreateDateTemp);
}
if (!string.IsNullOrEmpty(req.CreateName))
{
query = query.Where(d => d.CreateName.Contains(req.CreateName));
}
if (req.CreateId != null)
{
query = query.Where(d => d.CreateId == req.CreateId);
}
if (!string.IsNullOrEmpty(req.UpdateUserName))
{
query = query.Where(d => d.UpdateUserName.Contains(req.UpdateUserName));
}
if (req.UpdateUserId != null)
{
query = query.Where(d => d.UpdateUserId == req.UpdateUserId);
}
if (!string.IsNullOrEmpty(req.State))
{
query = query.Where(d => d.State.Contains(req.State));
}
if (req.UpdateDateStart != DateTime.MinValue && req.UpdateDateStart != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.UpdateDate >= req.UpdateDateStart);
}
if (req.UpdateDateEnd != DateTime.MinValue && req.UpdateDateEnd != SqlDateTime.MinValue.Value)
{
DateTime UpdateDateTemp = req.UpdateDateEnd.AddDays(1);
query = query.Where(d => d.UpdateDate < UpdateDateTemp);
}
if (req.HeTongId != null)
{
query = query.Where(d => d.HeTongId == req.HeTongId);
}
if (!string.IsNullOrEmpty(req.HeTongNumber))
{
query = query.Where(d => d.HeTongNumber.Contains(req.HeTongNumber));
}
if (!string.IsNullOrEmpty(req.Mark))
{
query = query.Where(d => d.Mark.Contains(req.Mark));
}
if (string.IsNullOrEmpty(req.sidx))
{
req.sidx = "id";
req.sord = "desc";
}
SearchListResult <HeTongService> retListResult = query.ToSearchList(req);
return(retListResult);
}
/// <summary>
/// 查询DietSpecial
/// </summary>
/// <param name="req"></param>
/// <returns></returns>
public SearchListResult <DietSpecial> SearchList(DietSpecialReq req)
{
var query = from source in db.DietSpecial select source;
if (req.ServerDateStart != DateTime.MinValue && req.ServerDateStart != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.ServerDate >= req.ServerDateStart);
}
if (req.ServerDateEnd != DateTime.MinValue && req.ServerDateEnd != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.ServerDate >= req.ServerDateEnd);
}
if (req.RoomId != null)
{
query = query.Where(d => d.RoomId == req.RoomId);
}
if (!string.IsNullOrEmpty(req.RoomNumber))
{
query = query.Where(d => d.RoomNumber.Contains(req.RoomNumber));
}
if (req.KeHuId != null)
{
query = query.Where(d => d.KeHuId == req.KeHuId);
}
if (!string.IsNullOrEmpty(req.KeHuName))
{
query = query.Where(d => d.KeHuName.Contains(req.KeHuName));
}
if (req.OptId != null)
{
query = query.Where(d => d.OptId == req.OptId);
}
if (!string.IsNullOrEmpty(req.OptName))
{
query = query.Where(d => d.OptName.Contains(req.OptName));
}
if (req.CreatedateStart != DateTime.MinValue && req.CreatedateStart != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.Createdate >= req.CreatedateStart);
}
if (req.CreatedateEnd != DateTime.MinValue && req.CreatedateEnd != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.Createdate >= req.CreatedateEnd);
}
if (!string.IsNullOrEmpty(req.SelectDiet))
{
query = query.Where(d => d.SelectDiet.Contains(req.SelectDiet));
}
if (!string.IsNullOrEmpty(req.OtherDiet))
{
query = query.Where(d => d.OtherDiet.Contains(req.OtherDiet));
}
if (!string.IsNullOrEmpty(req.Desc))
{
query = query.Where(d => d.Desc.Contains(req.Desc));
}
if (!string.IsNullOrEmpty(req.JiShiDesc))
{
query = query.Where(d => d.JiShiDesc.Contains(req.JiShiDesc));
}
if (req.projectid != null)
{
query = query.Where(d => d.ProjectId == req.projectid);
}
if (!string.IsNullOrEmpty(req.StartPersonName))
{
query = query.Where(d => d.StartPersonName.Contains(req.StartPersonName));
}
if (null != req.StartPersonId)
{
query = query.Where(d => d.StartPersonId.Equals(req.StartPersonId));
}
if (!string.IsNullOrEmpty(req.SaveName))
{
query = query.Where(d => d.SaveName.Contains(req.SaveName));
}
if (null != req.SaveId)
{
query = query.Where(d => d.SaveId.Equals(req.SaveId));
}
if (!string.IsNullOrEmpty(req.CenterCheckState))
{
query = query.Where(d => d.CenterCheckState.Contains(req.CenterCheckState));
}
if (string.IsNullOrEmpty(req.sidx))
{
req.sidx = "id";
req.sord = "desc";
}
SearchListResult <DietSpecial> retListResult = query.ToSearchList(req);
return(retListResult);
}
