/// <summary>
/// 构建查询表达式
/// </summary>
/// <returns></returns>
private Expression <Func <SystemDepartment, Boolean> > BuildSearchCriteria()
{
DynamicLambda <SystemDepartment> bulider = new DynamicLambda <SystemDepartment>();
Expression <Func <SystemDepartment, Boolean> > expr = null;
if (!string.IsNullOrEmpty(Request["Name"]))
{
var data = Request["Name"].Trim();
Expression <Func <SystemDepartment, Boolean> > tmp = t => t.Name.Contains(data);
expr = bulider.BuildQueryAnd(expr, tmp);
}
if (Request["Enabled"] == "0" || Request["Enabled"] == "1")
{
var data = Request["Enabled"] == "1" ? true : false;
Expression <Func <SystemDepartment, Boolean> > tmp = t => t.Enabled == data;
expr = bulider.BuildQueryAnd(expr, tmp);
}
if (!string.IsNullOrEmpty(Request["ParentId"]) && Request["ParentId"] != "0")
{
var data = Convert.ToInt32(Request["ParentId"]);
Expression <Func <SystemDepartment, Boolean> > tmp = t => (t.ParentID == data);
expr = bulider.BuildQueryAnd(expr, tmp);
}
Expression <Func <SystemDepartment, Boolean> > tmpSolid = t => t.IsDeleted == false;
expr = bulider.BuildQueryAnd(expr, tmpSolid);
return(expr);
}
/// <summary>
/// 构建查询表达式
/// </summary>
/// <returns></returns>
private Expression <Func <Role, Boolean> > BuildSearchCriteria(SearchModel search)
{
DynamicLambda <Role> bulider = new DynamicLambda <Role>();
Expression <Func <Role, Boolean> > expr = null;
if (!string.IsNullOrEmpty(Request["Name"]))
{
var data = Request["Name"].Trim();
Expression <Func <Role, Boolean> > tmp = t => t.Name.Contains(data);
expr = bulider.BuildQueryAnd(expr, tmp);
search.Name = data;
}
if (Request["Enabled"] == "0" || Request["Enabled"] == "1")
{
var data = Request["Enabled"] == "1" ? true : false;
Expression <Func <Role, Boolean> > tmp = t => t.Enabled == data;
expr = bulider.BuildQueryAnd(expr, tmp);
search.EnabledStr = Request["Enabled"];
}
Expression <Func <Role, Boolean> > tmpSolid = t => t.IsDeleted == false;
expr = bulider.BuildQueryAnd(expr, tmpSolid);
return(expr);
}
/// <summary>
/// 构建查询表达式
/// </summary>
/// <returns></returns>
private Expression <Func <PROD_GROUP_INDEX, Boolean> > BuildSearchCriteria(string id)
{
DynamicLambda <PROD_GROUP_INDEX> bulider = new DynamicLambda <PROD_GROUP_INDEX>();
Expression <Func <PROD_GROUP_INDEX, Boolean> > expr = null;
/*
* if (!string.IsNullOrEmpty(Request["Name"]))
* {
* var data = Request["Name"].Trim();
* Expression<Func<PROD_GROUP_INDEX, Boolean>> tmp = t => t.Name.Contains(data);
* expr = bulider.BuildQueryAnd(expr, tmp);
* }
* if (!string.IsNullOrEmpty(Request["ParentID"]))
* {
* var data = Request["ParentID"].Trim();
* Expression<Func<PROD_GROUP_INDEX, Boolean>> tmp = t => t.ParentID.Contains(data);
* expr = bulider.BuildQueryAnd(expr, tmp);
* }
* //if (!string.IsNullOrEmpty(id))
* //{
* // Expression<Func<PROD_GROUP_INDEX, Boolean>> tmp = t => t.ParentID == id;
* // expr = bulider.BuildQueryAnd(expr, tmp);
* //}
*
* if (Request["Status"] == "0" || Request["Status"] == "1")
* {
* var data = Request["Status"] == "1" ? 1 : 0;
* Expression<Func<PROD_GROUP_INDEX, Boolean>> tmp = t => t.Status == data;
* expr = bulider.BuildQueryAnd(expr, tmp);
* }*/
Expression <Func <PROD_GROUP_INDEX, Boolean> > tmpSolid = t => t.ParentID == id;
expr = bulider.BuildQueryAnd(expr, tmpSolid);
return(expr);
}
/// <summary>
/// 构建查询表达式
/// </summary>
/// <returns></returns>
private Expression <Func <Device, Boolean> > BuildSearchCriteria()
{
DynamicLambda <Device> bulider = new DynamicLambda <Device>();
Expression <Func <Device, Boolean> > expr = null;
if (!string.IsNullOrEmpty(Request["DeviceCode"]))
{
var data = Request["DeviceCode"].Trim();
Expression <Func <Device, Boolean> > tmp = t => t.DeviceCode.Contains(data);
expr = bulider.BuildQueryAnd(expr, tmp);
}
if (!string.IsNullOrEmpty(Request["Name"]))
{
var data = Request["Name"].Trim();
Expression <Func <Device, Boolean> > tmp = t => t.DeviceName.Contains(data);
expr = bulider.BuildQueryAnd(expr, tmp);
}
if (!string.IsNullOrEmpty(Request["AreaList"]))
{
var data = Request["AreaList"].GetInt(0);
if (data > 0)
{
Expression <Func <Device, Boolean> > tmp = t => t.AreaId == data;
expr = bulider.BuildQueryAnd(expr, tmp);
}
}
Expression <Func <Device, Boolean> > tmpSolid = (t => t.IsDeleted == null || t.IsDeleted.Value == false);
expr = bulider.BuildQueryAnd(expr, tmpSolid);
return(expr);
}
/// <summary>
/// 构建查询表达式
/// </summary>
/// <returns></returns>
private Expression <Func <INFOR_MASTER, Boolean> > BuildSearchCriteria()
{
DynamicLambda <INFOR_MASTER> bulider = new DynamicLambda <INFOR_MASTER>();
Expression <Func <INFOR_MASTER, Boolean> > expr = null;
if (!string.IsNullOrEmpty(Request["Subject"]))
{
var data = Request["Subject"].Trim();
Expression <Func <INFOR_MASTER, Boolean> > tmp = t => t.InforSubject.Contains(data);
expr = bulider.BuildQueryAnd(expr, tmp);
}
if (!string.IsNullOrEmpty(Request["InforCategoryID"]))
{
var data = Request["InforCategoryID"].Trim();
Expression <Func <INFOR_MASTER, Boolean> > tmp = t => t.InforCategoryID.Contains(data);
expr = bulider.BuildQueryAnd(expr, tmp);
}
if (Request["Enabled"] == "0" || Request["Enabled"] == "1")
{
var data = Request["Enabled"] == "1" ? 1 : 0;
Expression <Func <INFOR_MASTER, Boolean> > tmp = t => t.Status == data;
expr = bulider.BuildQueryAnd(expr, tmp);
}
Expression <Func <INFOR_MASTER, Boolean> > tmpSolid = t => 1 == 1;
expr = bulider.BuildQueryAnd(expr, tmpSolid);
return(expr);
}
private Expression <Func <MD.tbl_Common_User, bool> > BuildSearchCriteria(VM.UserInfoSearch searchModel)
{
if (searchModel == null)
{
throw new ArgumentNullException("searchModel is null.");
}
Expression <Func <MD.tbl_Common_User, bool> > expr = null;
DynamicLambda <MD.tbl_Common_User> builder = new DynamicLambda <MD.tbl_Common_User>();
if (searchModel.BeginDate.HasValue)
{
Expression <Func <MD.tbl_Common_User, bool> > temp = s => s.CreatedDate >= searchModel.BeginDate;
expr = builder.BuildQueryAnd(expr, temp);
}
if (searchModel.EndDate.HasValue)
{
Expression <Func <MD.tbl_Common_User, bool> > temp = s => s.CreatedDate <= searchModel.EndDate;
expr = builder.BuildQueryAnd(expr, temp);
}
if (searchModel.LogonName != null)
{
Expression <Func <MD.tbl_Common_User, Boolean> > temp = s => s.LogonName.Contains(searchModel.LogonName);
expr = builder.BuildQueryAnd(expr, temp);
}
if (searchModel.UserName != null)
{
Expression <Func <MD.tbl_Common_User, Boolean> > temp = s => s.UserName.Contains(searchModel.UserName);
expr = builder.BuildQueryAnd(expr, temp);
}
return(expr);
}
/// <summary>
/// 构建查询表达式
/// </summary>
/// <returns></returns>
private Expression <Func <Admin_user, Boolean> > BuildSearchCriteria()
{
DynamicLambda <Admin_user> bulider = new DynamicLambda <Admin_user>();
Expression <Func <Admin_user, Boolean> > expr = null;
if (!string.IsNullOrEmpty(Request["Id"]))
{
var data = Request["Id"].Trim();
Expression <Func <Admin_user, Boolean> > tmp = t => t.Id.Contains(data);
expr = bulider.BuildQueryAnd(expr, tmp);
}
if (!string.IsNullOrEmpty(Request["Name"]))
{
var data = Request["Name"].Trim();
Expression <Func <Admin_user, Boolean> > tmp = t => t.Name.Contains(data);
expr = bulider.BuildQueryAnd(expr, tmp);
}
if (!string.IsNullOrEmpty(Request["Userid"]))
{
var data = Request["Userid"].Trim();
Expression <Func <Admin_user, Boolean> > tmp = t => t.Userid.Contains(data);
expr = bulider.BuildQueryAnd(expr, tmp);
}
if (!string.IsNullOrEmpty(Request["Passid"]))
{
var data = Request["Passid"].Trim();
Expression <Func <Admin_user, Boolean> > tmp = t => t.Passid.Contains(data);
expr = bulider.BuildQueryAnd(expr, tmp);
}
if (!string.IsNullOrEmpty(Request["Usertype"]))
{
var data = Request["Usertype"].Trim();
Expression <Func <Admin_user, Boolean> > tmp = t => t.Usertype.Contains(data);
expr = bulider.BuildQueryAnd(expr, tmp);
}
if (!string.IsNullOrEmpty(Request["Fname"]))
{
var data = Request["Fname"].Trim();
Expression <Func <Admin_user, Boolean> > tmp = t => t.Fname.Contains(data);
expr = bulider.BuildQueryAnd(expr, tmp);
}
if (!string.IsNullOrEmpty(Request["Lname"]))
{
var data = Request["Lname"].Trim();
Expression <Func <Admin_user, Boolean> > tmp = t => t.Lname.Contains(data);
expr = bulider.BuildQueryAnd(expr, tmp);
}
if (!string.IsNullOrEmpty(Request["Mname"]))
{
var data = Request["Mname"].Trim();
Expression <Func <Admin_user, Boolean> > tmp = t => t.Mname.Contains(data);
expr = bulider.BuildQueryAnd(expr, tmp);
}
return(expr);
}
/// <summary>
/// 构建查询表达式
/// </summary>
/// <returns></returns>
private Expression <Func <Privileges, Boolean> > BuildSearchCriteria(int?moduleID)
{
DynamicLambda <Privileges> bulider = new DynamicLambda <Privileges>();
Expression <Func <Privileges, Boolean> > expr = null;
if (moduleID != 0 && moduleID != null)
{
Expression <Func <Privileges, Boolean> > tmpStoreID = t => t.ModuleID == moduleID;
expr = bulider.BuildQueryAnd(expr, tmpStoreID);
}
return(expr);
}
private Expression <Func <MD.Common_Authen_Role, bool> > BuildSearchCriteria(VM.RoleSearchModel search)
{
Expression <Func <MD.Common_Authen_Role, bool> > expr = null;
DynamicLambda <MD.Common_Authen_Role> bulid = new DynamicLambda <MD.Common_Authen_Role>();
if (!string.IsNullOrEmpty(search.RoleName))
{
Expression <Func <MD.Common_Authen_Role, bool> > temp = s => s.RoleName.Contains(search.RoleName);
expr = bulid.BuildQueryAnd(expr, temp);
}
return(expr);
}
/// <summary>
/// 构建查询表达式
/// </summary>
/// <returns></returns>
private Expression <Func <User, Boolean> > BuildSearchCriteria()
{
DynamicLambda <User> bulider = new DynamicLambda <User>();
Expression <Func <User, Boolean> > expr = null;
if (!string.IsNullOrEmpty(Request["LoginName"]))
{
var data = Request["LoginName"].Trim();
Expression <Func <User, Boolean> > tmp = t => t.UserCode.Contains(data);
expr = bulider.BuildQueryAnd(expr, tmp);
}
if (!string.IsNullOrEmpty(Request["FullName"]))
{
var data = Request["FullName"].Trim();
Expression <Func <User, Boolean> > tmp = t => t.UserName.Contains(data);
expr = bulider.BuildQueryAnd(expr, tmp);
}
if (!string.IsNullOrEmpty(Request["Email"]))
{
var data = Request["Email"].Trim();
Expression <Func <User, Boolean> > tmp = t => t.Memo.Contains(data);
expr = bulider.BuildQueryAnd(expr, tmp);
}
if (!string.IsNullOrEmpty(Request["Phone"]))
{
var data = Request["Phone"].Trim();
Expression <Func <User, Boolean> > tmp = t => t.Tel.Contains(data);
expr = bulider.BuildQueryAnd(expr, tmp);
}
if (Request["Enabled"] == "0" || Request["Enabled"] == "1")
{
var data = Request["Enabled"] == "1" ? true: false;
Expression <Func <User, Boolean> > tmp = t => t.Enabled == data;
expr = bulider.BuildQueryAnd(expr, tmp);
}
if (!string.IsNullOrEmpty(Request["StartTime"]))
{
var data = Convert.ToDateTime(Request["StartTime"].Trim());
Expression <Func <User, Boolean> > tmp = t => t.RegisterTime >= data;
expr = bulider.BuildQueryAnd(expr, tmp);
}
if (!string.IsNullOrEmpty(Request["EndTime"]))
{
var data = Convert.ToDateTime(Request["EndTime"].Trim()).AddDays(1);
Expression <Func <User, Boolean> > tmp = t => t.RegisterTime <= data;
expr = bulider.BuildQueryAnd(expr, tmp);
}
Expression <Func <User, Boolean> > tmpSolid = t => t.IsDeleted == false;
expr = bulider.BuildQueryAnd(expr, tmpSolid);
return(expr);
}
/// <summary>
/// 构建查询表达式
/// </summary>
/// <returns></returns>
private Expression <Func <OperateLog, Boolean> > BuildSearchCriteria()
{
DynamicLambda <OperateLog> bulider = new DynamicLambda <OperateLog>();
Expression <Func <OperateLog, Boolean> > expr = null;
if (!string.IsNullOrEmpty(Request["Area"]))
{
var data = Request["Area"].Trim();
Expression <Func <OperateLog, Boolean> > tmp = t => t.Area.Contains(data);
expr = bulider.BuildQueryAnd(expr, tmp);
}
if (!string.IsNullOrEmpty(Request["Controller"]))
{
var data = Request["Controller"].Trim();
Expression <Func <OperateLog, Boolean> > tmp = t => t.Controller.Contains(data);
expr = bulider.BuildQueryAnd(expr, tmp);
}
if (!string.IsNullOrEmpty(Request["Action"]))
{
var data = Request["Action"].Trim();
Expression <Func <OperateLog, Boolean> > tmp = t => t.Action.Contains(data);
expr = bulider.BuildQueryAnd(expr, tmp);
}
if (!string.IsNullOrEmpty(Request["IPAddress"]))
{
var data = Request["IPAddress"].Trim();
Expression <Func <OperateLog, Boolean> > tmp = t => t.IPAddress.Contains(data);
expr = bulider.BuildQueryAnd(expr, tmp);
}
if (!string.IsNullOrEmpty(Request["LoginName"]))
{
var data = Request["LoginName"].Trim();
Expression <Func <OperateLog, Boolean> > tmp = t => t.LoginName.Contains(data);
expr = bulider.BuildQueryAnd(expr, tmp);
}
if (!string.IsNullOrEmpty(Request["StartTime"]))
{
var data = Convert.ToDateTime(Request["StartTime"].Trim());
Expression <Func <OperateLog, Boolean> > tmp = t => t.LogTime >= data;
expr = bulider.BuildQueryAnd(expr, tmp);
}
if (!string.IsNullOrEmpty(Request["EndTime"]))
{
var data = Convert.ToDateTime(Request["EndTime"].Trim()).AddDays(1);
Expression <Func <OperateLog, Boolean> > tmp = t => t.LogTime <= data;
expr = bulider.BuildQueryAnd(expr, tmp);
}
Expression <Func <OperateLog, Boolean> > tmpSolid = t => t.IsDeleted == false;
expr = bulider.BuildQueryAnd(expr, tmpSolid);
return(expr);
}
/// <summary>
/// 构建查询表达式
/// </summary>
/// <returns></returns>
private Expression <Func <Role, Boolean> > BuildSearchCriteria(RoleSearchModel searchModel)
{
DynamicLambda <Role> bulider = new DynamicLambda <Role>();
Expression <Func <Role, Boolean> > expr = null;
if (!string.IsNullOrWhiteSpace(searchModel.RoleName))
{
Expression <Func <Role, Boolean> > tmp = t => t.Name.Contains(searchModel.RoleName);
expr = bulider.BuildQueryAnd(expr, tmp);
}
if (!string.IsNullOrWhiteSpace(searchModel.Disabled))
{
var flage = searchModel.Disabled == "1" ? true : false;
Expression <Func <Role, Boolean> > tmp = t => t.Disabled == flage;
expr = bulider.BuildQueryAnd(expr, tmp);
}
if (!string.IsNullOrWhiteSpace(searchModel.startDate))
{
try
{
DateTime dt = Convert.ToDateTime(searchModel.startDate);
Expression <Func <Role, Boolean> > tmp = t => t.CreateTime >= dt;
expr = bulider.BuildQueryAnd(expr, tmp);
}
catch
{
}
}
if (!string.IsNullOrWhiteSpace(searchModel.endDate))
{
try
{
DateTime dt = Convert.ToDateTime(searchModel.endDate).AddDays(1);
Expression <Func <Role, Boolean> > tmp = t => t.CreateTime < dt;
expr = bulider.BuildQueryAnd(expr, tmp);
}
catch
{
}
}
//Expression<Func<Role, Boolean>> tmpSolid = t => t.IsDeleted == false;
//expr = bulider.BuildQueryAnd(expr, tmpSolid);
return(expr);
}
private Expression <Func <MD.Common.Common_Authen_User, bool> > BuildSearchCriteria(VM.UserSearchModel search)
{
Expression <Func <MD.Common.Common_Authen_User, bool> > expr = null;
DynamicLambda <MD.Common.Common_Authen_User> bulid = new DynamicLambda <MD.Common.Common_Authen_User>();
if (!string.IsNullOrEmpty(search.LogonName))
{
Expression <Func <MD.Common.Common_Authen_User, bool> > temp = s => s.LogonName.Contains(search.LogonName);
expr = bulid.BuildQueryAnd(expr, temp);
}
Expression <Func <MD.Common.Common_Authen_User, bool> > solidFilter = s => (s.Status == 1);
expr = bulid.BuildQueryAnd(expr, solidFilter);
return(expr);
}
private Expression <Func <user, Boolean> > BuildSearchCriteria(SearchModel model)
{
DynamicLambda <user> bulider = new DynamicLambda <user>();
Expression <Func <user, Boolean> > expr = t => t.deleted == 0;
///电话号码
if (!string.IsNullOrEmpty(Request["mobile"]))
{
var data = Request["mobile"].Trim();
Expression <Func <user, Boolean> > tmp = t => t.mobile == data;
expr = bulider.BuildQueryAnd(expr, tmp);
model.mobile = data;
}
return(expr);
}
/// <summary>
/// 构建查询表达式
/// </summary>
/// <returns></returns>
private Expression <Func <Users, Boolean> > BuildSearchCriteria(OneKeySearchModel searchModel)
{
DynamicLambda <Users> bulider = new DynamicLambda <Users>();
Expression <Func <Users, Boolean> > expr = null;
//判断是否是商家的总账号，如果是的话，可以看所有员工的数据，否则只能看自己门店的数据
if (CurrentInfo.IsShopAdmin)
{
//IStoresService storesService = ServiceFactory.Create<IStoresService>();
//List<int> allStoresID = storesService.GetEntities(t => t.ShopId == CurrentInfo.CurrentShop.ID && t.Disabled == false).Select(t => t.ID).ToList();
//foreach (var item in allStoresID)
//{
//}
Expression <Func <Users, Boolean> > tmpStoreID = t => t.ShopsID == CurrentInfo.CurrentShop.ID && t.IsIntention != true;
expr = bulider.BuildQueryAnd(expr, tmpStoreID);
}
else
{
Expression <Func <Users, Boolean> > tmpStoreID = t => t.DefaultStoreID == CurrentInfo.CurrentStore.ID && t.IsIntention != true;
expr = bulider.BuildQueryAnd(expr, tmpStoreID);
}
if (searchModel.SearchStr != null)
{
searchModel.SearchStr = searchModel.SearchStr.Trim();
if (!string.IsNullOrWhiteSpace(searchModel.SearchStr))
{
Expression <Func <Users, Boolean> > tmpUser = t => (t.UserName.Contains(searchModel.SearchStr) ||
t.Phone.Contains(searchModel.SearchStr) ||
t.TEL.Contains(searchModel.SearchStr) ||
t.Idcard.Contains(searchModel.SearchStr) ||
t.WorkNum.Contains(searchModel.SearchStr) ||
t.RealName.Contains(searchModel.SearchStr));
expr = bulider.BuildQueryAnd(expr, tmpUser);
}
}
//如果是意向客户 把测试管理员账号和内部销售的账号过滤掉
if (CurrentInfo.CurrentUser.IsIntention == true)
{
Expression <Func <Users, Boolean> > tmpAdmin = t => t.Remark != "B4内部销售" && t.Remark != "B4内部售后";
expr = bulider.BuildQueryAnd(expr, tmpAdmin);
}
return(expr);
}
/// <summary>
/// 构建查询表达式
/// </summary>
/// <returns></returns>
private Expression<Func<Permission, Boolean>> BuildSearchCriteria()
{
DynamicLambda<Permission> bulider = new DynamicLambda<Permission>();
Expression<Func<Permission, Boolean>> expr = null;
if (!string.IsNullOrEmpty(Request["Name"]))
{
var data = Request["Name"].Trim();
Expression<Func<Permission, Boolean>> tmp = t => t.Name.Contains(data);
expr = bulider.BuildQueryAnd(expr, tmp);
}
Expression<Func<Permission, Boolean>> tmpSolid = t => t.IsDeleted == false;
expr = bulider.BuildQueryAnd(expr, tmpSolid);
return expr;
}
private Expression <Func <ELMAH_Error, bool> > BuildSearchCriteria(ELMAH_Error_SearchModel search)
{
Expression <Func <ELMAH_Error, bool> > expr = null;
DynamicLambda <ELMAH_Error> bulid = new DynamicLambda <ELMAH_Error>();
//if (!string.IsNullOrEmpty(search.StatusCode))
if (search.StatusCode > 0)
{
Expression <Func <ELMAH_Error, bool> > temp = s => (s.StatusCode == search.StatusCode);
expr = bulid.BuildQueryAnd(expr, temp);
}
Expression <Func <ELMAH_Error, bool> > solidFilter = s => (s.Sequence > 0);
expr = bulid.BuildQueryAnd(expr, solidFilter);
return(expr);
}
/// <summary>
/// 账户登录
/// </summary>
/// <param name="loginname">邮箱/用户名/已验证手机</param>
/// <param name="password">登录密码</param>
/// <returns></returns>
public ActionResult Signin(string loginname, string password)
{
DynamicLambda <user> bulider = new DynamicLambda <user>();
Expression <Func <user, Boolean> > expr = x => x.deleted == 0 && x.password == password;
if (true)
{
//邮箱登录
Expression <Func <user, Boolean> > tmp = x => x.email == loginname;
expr = bulider.BuildQueryAnd(expr, tmp);
}
else if (true)
{
//手机号登录
Expression <Func <user, Boolean> > tmp = x => x.mobile == loginname;
expr = bulider.BuildQueryAnd(expr, tmp);
}
else if (true)
{
//用户名登录
Expression <Func <user, Boolean> > tmp = x => x.username == loginname;
expr = bulider.BuildQueryAnd(expr, tmp);
}
else
{
//格式不正确
return(Show(new { }));
}
var userlist = UserService.user.Where(expr).ToList();
if (userlist.Count == 0)
{
//账号或密码不正确
return(Show(new { }));
}
else if (userlist.Count == 1)
{
//登录成功
return(Show(new { }));
}
else
{
//账号异常，封停账号，记录日志
return(Show(new { }));
}
}
private Expression <Func <MD.tbl_Common_Resource, bool> > BuildSearchCriteria(VM.ResourceInfoSearch searchModel)
{
if (searchModel == null)
{
throw new ArgumentNullException("searchModel is null.");
}
Expression <Func <MD.tbl_Common_Resource, bool> > expr = null;
DynamicLambda <MD.tbl_Common_Resource> builder = new DynamicLambda <MD.tbl_Common_Resource>();
if (searchModel.ResourceKey != null)
{
Expression <Func <MD.tbl_Common_Resource, bool> > temp = s => s.ResourceKey.Contains(searchModel.ResourceKey);
expr = builder.BuildQueryAnd(expr, temp);
}
return(expr);
}
/// <summary>
/// 构建查询表达式
/// </summary>
/// <returns></returns>
private Expression <Func <ReceiptHeaderEntity, Boolean> > BuildSearchCriteria()
{
DynamicLambda <ReceiptHeaderEntity> bulider = new DynamicLambda <ReceiptHeaderEntity>();
Expression <Func <ReceiptHeaderEntity, Boolean> > expr = null;
if (!string.IsNullOrEmpty(Request["F_Code"]))
{
var data = Request["F_Code"].Trim();
Expression <Func <ReceiptHeaderEntity, Boolean> > tmp = t => t.F_Code.Contains(data);
expr = bulider.BuildQueryAnd(expr, tmp);
}
Expression <Func <ReceiptHeaderEntity, Boolean> > tmpSolid = t => t.F_DeleteMark == false;
expr = bulider.BuildQueryAnd(expr, tmpSolid);
return(expr);
}
/// <summary>
/// 构建查询表达式
/// </summary>
/// <returns></returns>
private Expression <Func <PROD_GROUP_ITEM, Boolean> > BuildSearchCriteria()
{
DynamicLambda <PROD_GROUP_ITEM> bulider = new DynamicLambda <PROD_GROUP_ITEM>();
Expression <Func <PROD_GROUP_ITEM, Boolean> > expr = null;
/*
* if (Request["Enabled"] == "0" || Request["Enabled"] == "1")
* {
* var data = Request["Enabled"] == "1" ? 1 : 0;
* Expression<Func<PROD_GROUP_ITEM, Boolean>> tmp = t => t.Status == data;
* expr = bulider.BuildQueryAnd(expr, tmp);
* }
*/
Expression <Func <PROD_GROUP_ITEM, Boolean> > tmpSolid = t => 1 == 1;
expr = bulider.BuildQueryAnd(expr, tmpSolid);
return(expr);
}
/// <summary>
/// 构建查询表达式
/// </summary>
/// <returns></returns>
private Expression <Func <PROD_MASTER, Boolean> > BuildSearchCriteria()
{
DynamicLambda <PROD_MASTER> bulider = new DynamicLambda <PROD_MASTER>();
Expression <Func <PROD_MASTER, Boolean> > expr = null;
if (!string.IsNullOrEmpty(Request["ProductName"]))
{
var data = Request["ProductName"].Trim();
Expression <Func <PROD_MASTER, Boolean> > tmp = t => t.ProductName.Contains(data);
expr = bulider.BuildQueryAnd(expr, tmp);
}
if (!string.IsNullOrEmpty(Request["ProductNo"]))
{
var data = Request["ProductNo"].Trim();
Expression <Func <PROD_MASTER, Boolean> > tmp = t => t.ProductNo.Contains(data);
expr = bulider.BuildQueryAnd(expr, tmp);
}
if (Request["Enabled"] == "0" || Request["Enabled"] == "1")
{
var data = Request["Enabled"] == "1" ? 1 : 0;
Expression <Func <PROD_MASTER, Boolean> > tmp = t => t.Status == data;
expr = bulider.BuildQueryAnd(expr, tmp);
}
if (!string.IsNullOrEmpty(Request["StartTime"]))
{
var data = Convert.ToDateTime(Request["StartTime"].Trim());
Expression <Func <PROD_MASTER, Boolean> > tmp = t => t.LeadTime >= data;
expr = bulider.BuildQueryAnd(expr, tmp);
}
if (!string.IsNullOrEmpty(Request["EndTime"]))
{
var data = Convert.ToDateTime(Request["EndTime"].Trim()).AddDays(1);
Expression <Func <PROD_MASTER, Boolean> > tmp = t => t.LeadTime <= data;
expr = bulider.BuildQueryAnd(expr, tmp);
}
Expression <Func <PROD_MASTER, Boolean> > tmpSolid = t => 1 == 1;
expr = bulider.BuildQueryAnd(expr, tmpSolid);
return(expr);
}
/// <summary>
/// 构建查询表达式
/// </summary>
/// <returns></returns>
private Expression <Func <PROD_PROPERTIES, Boolean> > BuildSearchCriteria()
{
DynamicLambda <PROD_PROPERTIES> bulider = new DynamicLambda <PROD_PROPERTIES>();
Expression <Func <PROD_PROPERTIES, Boolean> > expr = null;
/*
* if (!string.IsNullOrEmpty(Request["ProductName"]))
* {
* var data = Request["ProductName"].Trim();
* Expression<Func<PROD_PROPERTIES, Boolean>> tmp = t => t.ProductName.Contains(data);
* expr = bulider.BuildQueryAnd(expr, tmp);
* }
* if (!string.IsNullOrEmpty(Request["Description"]))
* {
* var data = Request["Description"].Trim();
* Expression<Func<PROD_PROPERTIES, Boolean>> tmp = t => t.Description.Contains(data);
* expr = bulider.BuildQueryAnd(expr, tmp);
* }
* if (Request["Enabled"] == "0" || Request["Enabled"] == "1")
* {
* var data = Request["Enabled"] == "1" ? 1 : 0;
* Expression<Func<PROD_PROPERTIES, Boolean>> tmp = t => t.Status == data;
* expr = bulider.BuildQueryAnd(expr, tmp);
* }
*
* if (!string.IsNullOrEmpty(Request["StartTime"]))
* {
* var data = Convert.ToDateTime(Request["StartTime"].Trim());
* Expression<Func<PROD_PROPERTIES, Boolean>> tmp = t => t.LeadTime >= data;
* expr = bulider.BuildQueryAnd(expr, tmp);
* }
* if (!string.IsNullOrEmpty(Request["EndTime"]))
* {
* var data = Convert.ToDateTime(Request["EndTime"].Trim()).AddDays(1);
* Expression<Func<PROD_PROPERTIES, Boolean>> tmp = t => t.LeadTime <= data;
* expr = bulider.BuildQueryAnd(expr, tmp);
* }
*/
Expression <Func <PROD_PROPERTIES, Boolean> > tmpSolid = t => 1 == 1;
expr = bulider.BuildQueryAnd(expr, tmpSolid);
return(expr);
}
private Expression <Func <PROD_CATEGORIES, Boolean> > BuildStairCategories(string cateCode)
{
DynamicLambda <PROD_CATEGORIES> bulider = new DynamicLambda <PROD_CATEGORIES>();
Expression <Func <PROD_CATEGORIES, Boolean> > expr = t => t.Status == 0 && t.IsAvailably;
if (!string.IsNullOrEmpty(cateCode))
{
var list = PROD_CATEGORIESService.PROD_CATEGORIESList
.Where(t => t.CategoryCode.Equals(cateCode))
.Select(t => t.ID);
Expression <Func <PROD_CATEGORIES, Boolean> > tmpSolid = t => list.Contains(t.ParentID);
expr = bulider.BuildQueryAnd(expr, tmpSolid);
}
//if (!string.IsNullOrEmpty(parentID))
//{
// Expression<Func<PROD_CATEGORIES, Boolean>> tmpP = t => t.ParentID.Contains(parentID);
// expr = bulider.BuildQueryAnd(expr, tmpP);
//}
return(expr);
}
/// <summary>
/// 构建查询表达式
/// </summary>
/// <returns></returns>
private Expression <Func <Shops, Boolean> > BuildSearchCriteria(string strSearchkey, string MerchantID)
{
DynamicLambda <Shops> bulider = new DynamicLambda <Shops>();
Expression <Func <Shops, Boolean> > expr = null;
//如果商户号不为空，则优先搜索商户号
if (!string.IsNullOrWhiteSpace(MerchantID))
{
int intMerchantID = 0;
try
{
if (MerchantID.Length >= 6 && MerchantID.StartsWith("61"))
{
MerchantID = MerchantID.Trim().Substring(2, 4);
intMerchantID = Convert.ToInt32(MerchantID.Trim());
}
}
catch
{
}
Expression <Func <Shops, Boolean> > temp = t => t.ID == intMerchantID;
expr = bulider.BuildQueryAnd(expr, temp);
}
else
{
Expression <Func <Shops, Boolean> > tmpStoreID = t => t.ShopName.Contains(strSearchkey) ||
t.Province.Contains(strSearchkey) ||
t.City.Contains(strSearchkey) ||
t.County.Contains(strSearchkey)
//|| t.Users.UserName.Contains(strSearchkey)
//|| t.Users.Phone.Contains(strSearchkey)
//|| t.Users2.RealName.Contains(strSearchkey)
|| t.Remark.Contains(strSearchkey);
expr = bulider.BuildQueryAnd(expr, tmpStoreID);
}
return(expr);
}
/// <summary>
/// 构建查询表达式
/// </summary>
/// <returns></returns>
private Expression <Func <INFOR_CATEGORIES, Boolean> > BuildSearchCriteria(string id)
{
DynamicLambda <INFOR_CATEGORIES> bulider = new DynamicLambda <INFOR_CATEGORIES>();
Expression <Func <INFOR_CATEGORIES, Boolean> > expr = null;
if (!string.IsNullOrEmpty(Request["InforCategoryName"]))
{
var data = Request["InforCategoryName"].Trim();
Expression <Func <INFOR_CATEGORIES, Boolean> > tmp = t => t.InforCategoryName.Contains(data);
expr = bulider.BuildQueryAnd(expr, tmp);
}
if (Request["Enabled"] == "0" || Request["Enabled"] == "1")
{
var data = Request["Enabled"] == "1" ? 1 : 0;
Expression <Func <INFOR_CATEGORIES, Boolean> > tmp = t => t.Status == data;
expr = bulider.BuildQueryAnd(expr, tmp);
}
Expression <Func <INFOR_CATEGORIES, Boolean> > tmpSolid = t => t.ParentID == id;
expr = bulider.BuildQueryAnd(expr, tmpSolid);
return(expr);
}
/// <summary>
/// 创建查询条件表达式和排序表达式
/// </summary>
/// <param name="orderingSelector"></param>
/// <returns></returns>
private Expression<Func<sys_Member, bool>> BuildPredicate(out dynamic orderingSelector)
{
ParameterExpression parameter = Expression.Parameter(typeof(sys_Member));
// 排序表达式
orderingSelector = Expression.Lambda(Expression.Property(parameter, Grid3.SortField), parameter);
DynamicLambda<sys_Member> bulider = new DynamicLambda<sys_Member>();
Expression<Func<sys_Member, Boolean>> expr = null;
Expression<Func<sys_Member, Boolean>> tmp = t => t.IsDelete == false;
expr = bulider.BuildQueryAnd(expr, tmp);
Expression<Func<sys_Member, Boolean>> tmp0 = t => t.IsUsing == true;
expr = bulider.BuildQueryAnd(expr, tmp0);
//查询角色中用户
if (Grid1.SelectedRowIndex >= 0)
{
int rid = Convert.ToInt32(Grid1.DataKeys[Grid1.SelectedRowIndex][0]);
sys_Role role = RoleService.FirstOrDefault(r => r.Id == rid);
List<int> useridlist = new List<int>();
foreach (sys_Member m in role.sys_Member)
{
useridlist.Add(m.id);
}
Expression<Func<sys_Member, Boolean>> tmpSolid = t => useridlist.Contains(t.id);
expr = bulider.BuildQueryAnd(expr, tmpSolid);
}
return expr;
}
/// <summary>
/// 创建查询条件表达式和排序表达式
/// </summary>
/// <param name="orderingSelector"></param>
/// <returns></returns>
private Expression<Func<sys_Member, bool>> BuildPredicate(out dynamic orderingSelector)
{
// 查询条件表达式
DynamicLambda<sys_Member> bulider = new DynamicLambda<sys_Member>();
Expression<Func<sys_Member, Boolean>> expr = null;
if (Role != null)
{
List<sys_Member> userlist = Role.sys_Member.ToList();
List<int> uid = new List<int>();
userlist.ForEach(i => uid.Add(i.id));
Expression<Func<sys_Member, Boolean>> tmp = t => !uid.Contains(t.id);
expr = bulider.BuildQueryAnd(expr, tmp);
}
//未删除用户
Expression<Func<sys_Member, Boolean>> tmp5 = t => t.IsDelete == false;
expr = bulider.BuildQueryAnd(expr, tmp5);
//未禁用用户
Expression<Func<sys_Member, Boolean>> tmp6 = t => t.IsUsing == true;
expr = bulider.BuildQueryAnd(expr, tmp6);
if (!string.IsNullOrWhiteSpace(ttbSearch.Text))
{
Expression<Func<sys_Member, Boolean>> tmp2 = t => t.UserName.Contains(ttbSearch.Text.Trim());
expr = bulider.BuildQueryAnd(expr, tmp2);
Expression<Func<sys_Member, Boolean>> tmp3 = t => t.RealName.Contains(ttbSearch.Text.Trim());
expr = bulider.BuildQueryOr(expr, tmp3);
Expression<Func<sys_Member, Boolean>> tmp4 = t => t.Email.Contains(ttbSearch.Text.Trim());
expr = bulider.BuildQueryOr(expr, tmp4);
}
if (SelectOid != 0)
{
List<int> oidList = GetAllChildOrgnizationId(SelectOid);
Expression<Func<sys_Member, Boolean>> tmp = t => oidList.Contains(t.sys_Orgnization_Id);
expr = bulider.BuildQueryAnd(expr, tmp);
}
ParameterExpression parameter = Expression.Parameter(typeof(sys_Member));
// 排序表达式
orderingSelector = Expression.Lambda(Expression.Property(parameter, Grid1.SortField), parameter);
return expr;
}
/// <summary>
/// 创建查询条件表达式和排序表达式
/// </summary>
/// <param name="orderingSelector"></param>
/// <returns></returns>
private Expression<Func<sys_LoginLog, bool>> BuildPredicate(out dynamic orderingSelector)
{
DynamicLambda<sys_LoginLog> bulider = new DynamicLambda<sys_LoginLog>();
Expression<Func<sys_LoginLog, Boolean>> expr = null;
Expression<Func<sys_LoginLog, Boolean>> tmp = t => BaseOperResUidList.Contains(t.Uid);
expr = bulider.BuildQueryAnd(expr, tmp);
if (BASEttb != null && !string.IsNullOrWhiteSpace(BASEttb.Text))
{
Expression<Func<sys_LoginLog, Boolean>> tmp1 = t => t.RealName.Contains(BASEttb.Text);
expr = bulider.BuildQueryAnd(expr, tmp1);
}
ParameterExpression parameter = Expression.Parameter(typeof(sys_LoginLog));
orderingSelector = Expression.Lambda(Expression.Property(parameter, Grid1.SortField), parameter);
return expr;
}
/// <summary>
/// 构建查询表达式
/// </summary>
/// <returns></returns>
private Expression <Func <Role, Boolean> > BuildSearchCriteria(RoleSearchModel searchModel)
{
DynamicLambda <Role> bulider = new DynamicLambda <Role>();
Expression <Func <Role, Boolean> > expr = null;
if (CurrentInfo.IsShopAdmin)
{
Expression <Func <Role, Boolean> > tmpStoreID = t => t.ShopsID == CurrentInfo.CurrentShop.ID;
expr = bulider.BuildQueryAnd(expr, tmpStoreID);
}
else
{
Expression <Func <Role, Boolean> > tmpStoreID = t => t.StoreID == CurrentInfo.CurrentStore.ID;
expr = bulider.BuildQueryAnd(expr, tmpStoreID);
}
if (!string.IsNullOrWhiteSpace(searchModel.RoleName))
{
Expression <Func <Role, Boolean> > tmp = t => t.Name.Contains(searchModel.RoleName);
expr = bulider.BuildQueryAnd(expr, tmp);
}
if (!string.IsNullOrWhiteSpace(searchModel.Disabled))
{
var flage = searchModel.Disabled == "1" ? true : false;
Expression <Func <Role, Boolean> > tmp = t => t.Disabled == flage;
expr = bulider.BuildQueryAnd(expr, tmp);
}
if (!string.IsNullOrWhiteSpace(searchModel.startDate))
{
try
{
DateTime dt = Convert.ToDateTime(searchModel.startDate);
Expression <Func <Role, Boolean> > tmp = t => t.CreateTime >= dt;
expr = bulider.BuildQueryAnd(expr, tmp);
}
catch
{
}
}
if (!string.IsNullOrWhiteSpace(searchModel.endDate))
{
try
{
DateTime dt = Convert.ToDateTime(searchModel.endDate).AddDays(1);
Expression <Func <Role, Boolean> > tmp = t => t.CreateTime < dt;
expr = bulider.BuildQueryAnd(expr, tmp);
}
catch
{
}
}
//Expression<Func<Role, Boolean>> tmpSolid = t => t.IsDeleted == false;
//expr = bulider.BuildQueryAnd(expr, tmpSolid);
//如果不是管理员账号则 把“店长”这个角色隐藏掉，防止其他客户修改
if (!CurrentInfo.IsAdministrator)
{
Expression <Func <Role, Boolean> > tmpAdmin = t => t.ID != 42;
expr = bulider.BuildQueryAnd(expr, tmpAdmin);
}
return(expr);
}
/// <summary>
/// 创建查询条件表达式和排序表达式
/// </summary>
/// <param name="orderingSelector"></param>
/// <returns></returns>
private Expression<Func<sys_ForbidIp, bool>> BuildPredicate(out dynamic orderingSelector)
{
DynamicLambda<sys_ForbidIp> bulider = new DynamicLambda<sys_ForbidIp>();
Expression<Func<sys_ForbidIp, Boolean>> expr = null;
Expression<Func<sys_ForbidIp, Boolean>> tmp1 = t => t.IsDelete == false;
expr = bulider.BuildQueryAnd(expr, tmp1);
if (ttb != null && !string.IsNullOrWhiteSpace(ttb.Text))
{
Expression<Func<sys_ForbidIp, Boolean>> tmp2 = t => t.IP.Contains(ttb.Text.Trim());
expr = bulider.BuildQueryAnd(expr, tmp2);
}
// 排序表达式
ParameterExpression parameter = Expression.Parameter(typeof(sys_ForbidIp));
orderingSelector = Expression.Lambda(Expression.Property(parameter, Grid1.SortField), parameter);
return expr;
}
/// <summary>
/// 创建查询条件表达式和排序表达式
/// </summary>
/// <param name="orderingSelector"></param>
/// <returns></returns>
private Expression<Func<sys_Member, bool>> BuildPredicate(out dynamic orderingSelector)
{
DynamicLambda<sys_Member> bulider = new DynamicLambda<sys_Member>();
Expression<Func<sys_Member, Boolean>> expr = null;
Expression<Func<sys_Member, Boolean>> tmp1 = t => t.IsDelete == false;
expr = bulider.BuildQueryAnd(expr, tmp1);
if (BASEttb != null && !string.IsNullOrWhiteSpace(BASEttb.Text))
{
Expression<Func<sys_Member, Boolean>> tmp2 = t => t.UserName.Contains(BASEttb.Text.Trim());
expr = bulider.BuildQueryAnd(expr, tmp2);
Expression<Func<sys_Member, Boolean>> tmp3 = t => t.RealName.Contains(BASEttb.Text.Trim());
expr = bulider.BuildQueryOr(expr, tmp3);
Expression<Func<sys_Member, Boolean>> tmp4 = t => t.Email.Contains(BASEttb.Text.Trim());
expr = bulider.BuildQueryOr(expr, tmp4);
}
if (SelectOid != 0)
{
List<int> oidList = GetAllChildOrgnizationId(SelectOid);
Expression<Func<sys_Member, Boolean>> tmp = t => oidList.Contains(t.sys_Orgnization_Id);
expr = bulider.BuildQueryAnd(expr, tmp);
}
// 排序表达式
ParameterExpression parameter = Expression.Parameter(typeof(sys_Member));
orderingSelector = Expression.Lambda(Expression.Property(parameter, Grid1.SortField), parameter);
return expr;
}
/// <summary>
/// 获取商家下的门店
/// </summary>
/// <param name="pageSize"></param>
/// <param name="username"></param>
/// <param name="pageNumber"></param>
/// <returns></returns>
public ActionResult GetShopStores(int pageSize, string username, int pageNumber)
{
SearchModel <StoresParams> searchModel = new SearchModel <StoresParams>
{
PageIndex = pageNumber,
PageSize = pageSize,
Model = new StoresParams()
{
StoreName = username
}
};
//IShopsService shopsService = ServiceFactory.Create<IShopsService>();
//var shop = shopsService.GetFirstOrDefault(t => t.AdminUserID == CurrentInfo.CurrentUser.ID);
DynamicLambda <Stores> bulider = new DynamicLambda <Stores>();
Expression <Func <Stores, Boolean> > expr = null;
//如果是店铺管理员
if (CurrentInfo.IsShopAdmin)
{
Expression <Func <Stores, Boolean> > tmp = t => t.ShopId == CurrentInfo.CurrentUser.ShopsID && t.Disabled != true;
expr = bulider.BuildQueryAnd(expr, tmp);
}
else
{
Expression <Func <Stores, Boolean> > tmp = t => t.ID == CurrentInfo.CurrentStore.ID;
expr = bulider.BuildQueryAnd(expr, tmp);
}
////如果是商家本人的账号，则显示商家自己的门店
//if (shop != null)
//{
// Expression<Func<Stores, Boolean>> tmp = t => t.ShopId == shop.ID;
// expr = bulider.BuildQueryAnd(expr, tmp);
//}
if (!string.IsNullOrWhiteSpace(username))
{
username = username.Trim();
Expression <Func <Stores, Boolean> > tmp = t => t.StoreName.Contains(username);
expr = bulider.BuildQueryAnd(expr, tmp);
}
IStoresService storesService = ServiceFactory.Create <IStoresService>();
int total;
var data = storesService.GetEntitiesByPage(searchModel.PageIndex, searchModel.PageSize, out total, expr, false, t => t.ID).Select(t => new
{
ID = t.ID,
ShopsName = t.Shops.ShopName,
StoreName = t.StoreName,
Adress = t.Adress,
Phone = t.Phone,
IsShowWeiXin = t.IsShowWeiXin == true ? "显示" : "不显示",
IsMainStore = t.IsMainStore,
Disabled = t.Disabled,
AdminUserID = t.AdminUserID,
/// AdminName = t.AdminUserID==null?"0":t.AdminUserID.ToString() //t.Users1 != null ? t.Users1.RealName : ""
}).ToList();
return(Json(new { total = total, rows = data }, JsonRequestBehavior.AllowGet));
}
