static void Main(string[] args)
{
var oLamadaExtention = new LamadaExtention <UserModelDto>();
oLamadaExtention.Equal(x => x.UserName, "张三");
oLamadaExtention.LessThan(x => x.BrithDate, DateTime.Now);
//var lstRes = UserManager.Find(oLamadaExtention.lamada).ToList();
//new LamadaExtention<UserModelDto>()
// .CreateWhereCompareExpressions
// (
// );
//oLamadaExtention.GetExpression("USER_NAME", username, ExpressionType.Contains);
//
// TODO: 在此处添加代码以启动应用程序
//
Console.WriteLine("Hello World");
Console.WriteLine(Environment.Version.ToString());
}
/// <summary>
/// 构建查询条件
/// </summary>
/// <param name="query">查询字段</param>
/// <returns></returns>
public Expression <Func <UserComm, bool> > BuildQuery(UserCommQuery query)
{
var oLamadaExtention = new LamadaExtention <UserComm>();
if (!string.IsNullOrWhiteSpace(query.Id))
{
var Id = ObjectId.Parse(query.Id);
oLamadaExtention.GetExpression(nameof(Id), Id, ExpressionTypeEnum.Equal);
}
if (!string.IsNullOrWhiteSpace(query.NickName))
{
oLamadaExtention.GetExpression(nameof(UserCommQuery.NickName), query.NickName, ExpressionTypeEnum.Equal);
}
if (!string.IsNullOrWhiteSpace(query.CommentTimeBegin))
{
oLamadaExtention.GetExpression(nameof(UserCommQuery.CommentTimeBegin), query.CommentTimeBegin, ExpressionTypeEnum.GreaterThanOrEqual);
}
if (!string.IsNullOrWhiteSpace(query.CommentTimeEnd))
{
oLamadaExtention.GetExpression(nameof(UserCommQuery.CommentTimeEnd), query.CommentTimeEnd, ExpressionTypeEnum.LessThanOrEqual);
}
if (query.CommentScore != null)
{
oLamadaExtention.GetExpression(nameof(UserCommQuery.CommentScore), query.CommentScore, ExpressionTypeEnum.Equal);
}
if (!string.IsNullOrWhiteSpace(query.CommentMediaUrl))
{
oLamadaExtention.GetExpression(nameof(UserCommQuery.CommentMediaUrl), query.CommentMediaUrl, ExpressionTypeEnum.Equal);
}
if (!string.IsNullOrWhiteSpace(query.Content))
{
oLamadaExtention.GetExpression(nameof(UserCommQuery.Content), query.Content, ExpressionTypeEnum.Equal);
}
if (!string.IsNullOrWhiteSpace(query.AdditionalComments))
{
oLamadaExtention.GetExpression(nameof(UserCommQuery.AdditionalComments), query.AdditionalComments, ExpressionTypeEnum.Equal);
}
if (!string.IsNullOrWhiteSpace(query.CustomerServiceReply))
{
oLamadaExtention.GetExpression(nameof(UserCommQuery.CustomerServiceReply), query.CustomerServiceReply, ExpressionTypeEnum.Equal);
}
return(oLamadaExtention.GetLambda());
}
/// <summary>
/// 构建ef查询条件
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
private Expression <Func <TravelInfo, bool> > BuildQuery(TravelInfoQuery query)
{
var oLamadaExtention = new LamadaExtention <TravelInfo>();
if (query.ProId != null)
{
oLamadaExtention.GetExpression(nameof(TravelInfo.ProId), query.ProId, ExpressionTypeEnum.Equal);
}
if (!string.IsNullOrWhiteSpace(query.PlaceOfDeparture))
{
oLamadaExtention.GetExpression(nameof(TravelInfo.PlaceOfDeparture), query.PlaceOfDeparture, ExpressionTypeEnum.Equal);
}
if (!string.IsNullOrWhiteSpace(query.City))
{
oLamadaExtention.GetExpression(nameof(TravelInfo.City), query.City, ExpressionTypeEnum.Equal);
}
if (!string.IsNullOrWhiteSpace(query.Country))
{
oLamadaExtention.GetExpression(nameof(TravelInfo.Country), query.Country, ExpressionTypeEnum.Equal);
}
if (query.EndTime != null)
{
oLamadaExtention.GetExpression(nameof(TravelInfo.EndTime), query.EndTime, ExpressionTypeEnum.LessThanOrEqual);
}
if (query.StartTime != null)
{
oLamadaExtention.GetExpression(nameof(TravelInfo.StartTime), query.StartTime, ExpressionTypeEnum.GreaterThanOrEqual);
}
if (!string.IsNullOrWhiteSpace(query.ProDestination))
{
oLamadaExtention.GetExpression(nameof(TravelInfo.ProDestination), query.ProDestination, ExpressionTypeEnum.Equal);
}
if (!string.IsNullOrWhiteSpace(query.ProTitle))
{
oLamadaExtention.GetExpression(nameof(TravelInfo.ProTitle), query.ProTitle, ExpressionTypeEnum.Equal);
}
return(oLamadaExtention.GetLambda());
}
public JsonResult GetMenus(int limit, int offset, string menuname, string menuurl)
{
var oLamadaExtention = new LamadaExtention <DTO_TB_MENU>();
if (!string.IsNullOrEmpty(menuname))
{
oLamadaExtention.GetExpression("MENU_NAME", menuname, ExpressionType.Contains);
}
if (!string.IsNullOrEmpty(menuurl))
{
oLamadaExtention.GetExpression("MENU_URL", menuurl, ExpressionType.Contains);
}
var lamada = oLamadaExtention.GetLambda();
var lstRes = PowerManager.GetMenus(lamada).ToList();
return(Json(new { rows = lstRes.Skip(offset).Take(limit).ToList(), total = lstRes.Count }, JsonRequestBehavior.AllowGet));
}
public JsonResult GetRole(int limit, int offset, string rolename, string desc)
{
var oLamadaExtention = new LamadaExtention <DTO_TB_ROLE>();
if (!string.IsNullOrEmpty(rolename))
{
oLamadaExtention.GetExpression("ROLE_NAME", rolename, ExpressionType.Contains);
}
if (!string.IsNullOrEmpty(desc))
{
oLamadaExtention.GetExpression("DESCRIPTION", desc, ExpressionType.Contains);
}
var lamada = oLamadaExtention.GetLambda();
var lstRes = PowerManager.GetRoles(lamada).ToList();
return(Json(new { rows = lstRes.Skip(offset).Take(limit).ToList(), total = lstRes.Count }, JsonRequestBehavior.AllowGet));
}
public JsonResult GetDepartments(int limit, int offset, string departmentname, string statu)
{
//得到lamada表达式
var oLamadaExtention = new LamadaExtention <DTO_TB_DEPARTMENT>();
if (!string.IsNullOrEmpty(departmentname))
{
oLamadaExtention.GetExpression("DEPARTMENT_NAME", departmentname, ExpressionType.Contains);
}
if (!string.IsNullOrEmpty(statu))
{
oLamadaExtention.GetExpression("STATUS", statu, ExpressionType.Contains);
}
var lamada = oLamadaExtention.GetLambda();
var lstRes = PowerManager.GetDepartments(lamada);
return(Json(new { rows = lstRes.Skip(offset).Take(limit).ToList(), total = lstRes.Count }, JsonRequestBehavior.AllowGet));
}
public JsonResult GetUsers(int limit, int offset, string username, string fullname)
{
var oLamadaExtention = new LamadaExtention <DTO_TB_USERS>();
if (!string.IsNullOrEmpty(username))
{
oLamadaExtention.GetExpression("USER_NAME", username, ExpressionType.Contains);
}
if (!string.IsNullOrEmpty(fullname))
{
oLamadaExtention.GetExpression("FULLNAME", fullname, ExpressionType.Contains);
}
var lamada = oLamadaExtention.GetLambda();
var lstRes = PowerManager.GetUsers(lamada).ToList();
return(Json(new { rows = lstRes.Skip(offset).Take(limit).ToList(), total = lstRes.Count }, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 构建ef查询条件
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
private Expression <Func <User, bool> > BuildQuery(UserQuery query)
{
var oLamadaExtention = new LamadaExtention <User>();
if (query.CId != null)
{
oLamadaExtention.GetExpression(nameof(User.CId), query.CId, ExpressionTypeEnum.Equal);
}
if (!string.IsNullOrWhiteSpace(query.CName))
{
oLamadaExtention.GetExpression(nameof(User.CName), query.CName, ExpressionTypeEnum.Equal);
}
if (query.CSex != null)
{
oLamadaExtention.GetExpression(nameof(User.CSex), query.CSex, ExpressionTypeEnum.Equal);
}
if (query.CAge != null)
{
oLamadaExtention.GetExpression(nameof(User.CAge), query.CAge, ExpressionTypeEnum.Equal);
}
if (!string.IsNullOrWhiteSpace(query.CAddress))
{
oLamadaExtention.GetExpression(nameof(User.CAddress), query.CAddress, ExpressionTypeEnum.Equal);
}
if (!string.IsNullOrWhiteSpace(query.CPhone))
{
oLamadaExtention.GetExpression(nameof(User.CPhone), query.CPhone, ExpressionTypeEnum.Equal);
}
if (!string.IsNullOrWhiteSpace(query.CIdNum))
{
oLamadaExtention.GetExpression(nameof(User.CIdNum), query.CIdNum, ExpressionTypeEnum.Equal);
}
if (query.CIdentity != null)
{
oLamadaExtention.GetExpression(nameof(User.CIdentity), query.CIdentity, ExpressionTypeEnum.Equal);
}
if (!string.IsNullOrWhiteSpace(query.CNickName))
{
oLamadaExtention.GetExpression(nameof(User.CNickName), query.CNickName, ExpressionTypeEnum.Equal);
}
if (!string.IsNullOrWhiteSpace(query.CEmail))
{
oLamadaExtention.GetExpression(nameof(User.CEmail), query.CEmail, ExpressionTypeEnum.Equal);
}
if (!string.IsNullOrWhiteSpace(query.CPasswd))
{
oLamadaExtention.GetExpression(nameof(User.CPasswd), query.CPasswd, ExpressionTypeEnum.Equal);
}
if (!string.IsNullOrWhiteSpace(query.CPic))
{
oLamadaExtention.GetExpression(nameof(User.CPic), query.CPic, ExpressionTypeEnum.Equal);
}
return(oLamadaExtention.GetLambda());
}
