public JsonResult GetStudentByCondition(int page, int pageSize, string sortName, List <PropModel> searchs)
        {
            AjaxMessage ajax = new AjaxMessage();

            ajax.IsSuccess = false;
            ajax.Message   = "查询失败,系统异常";
            try
            {
                int count = 0;
                //lamada表达式 条件数组
                List <Expression <Func <StudentDTO, bool> > > parmList = new List <Expression <Func <StudentDTO, bool> > >();


                if (searchs.Count() > 0)
                {
                    foreach (PropModel item in searchs)
                    {
                        if (!string.IsNullOrEmpty(item.value) && item.value != ",")
                        {
                            ExpressionTools.GetEqualPars(item.property, parmList, item.value, item.method);
                        }
                    }
                }

                var list     = stuService.GetConditionStu(page, pageSize, sortName, parmList, ref count);
                var DataList = new PagedList <StudentDTO>(list, page, pageSize, count);

                ajax.data      = DataList;
                ajax.total     = count;     //数据总条数
                ajax.PageIndex = page;      //当前页
                ajax.PageSize  = pageSize;  //每页显示条数

                ajax.IsSuccess = true;
                ajax.Message   = "查询成功";
            }
            catch (Exception e)
            {
                ajax.Message = e.Message;
            }

            //return ajax;
            return(Json(new
            {
                data = ajax.data,
                total = ajax.total,    //数据总条数
                PageIndex = page,      //当前页
                PageSize = pageSize,   //每页显示条数
                TotalPage = ajax.TotalPage
            }));
        }
Example #2
0
        public AjaxMessage GetOrderCustomer(int page, int pagesize, string sortName, PropModel[] searchs, string orderEmployee)
        {
            AjaxMessage ajax = new AjaxMessage();

            ajax.IsSuccess = false;
            try
            {
                List <Expression <Func <OrderDto, bool> > > parmList = new List <Expression <Func <OrderDto, bool> > >();

                if (!string.IsNullOrEmpty(orderEmployee))
                {
                    parmList.Add(c => c.EmployeeId.ToString() == orderEmployee);

                    string employeeId = orderEmployee.ToInt32() > 0 ? orderEmployee : LoginInfo.UserInfo.EmployeeId.ToString();
                    //选择只显示选择人个人的邀约信息
                    bool isLookLowLevel = orderEmployee.ToInt32() > 0 ? false : true;
                    ExpressionTools.GetParsByCondition <OrderDto>("EmployeeId", parmList, employeeId, "Contains", true, isLookLowLevel);
                }
                else
                {
                    //默认获取本人及下级邀约信息
                    MyEmployee sel_emp = new MyEmployee();
                    sel_emp.GetMyEmployee <OrderDto>("EmployeeId", parmList, true);
                }

                if (searchs.Count() > 0)
                {
                    foreach (PropModel item in searchs)
                    {
                        if (item.value != "-1")          //有明确的某个状态
                        {
                            if (!string.IsNullOrEmpty(item.value))
                            {
                                if (!(item.value.Contains(',')))
                                {
                                    ExpressionTools.GetEqualPars(item.property, parmList, item.value, item.method);
                                }
                                else if (item.value.Contains(','))      //时间 婚期
                                {
                                    TimeHelper.GetPartyDateTime(item.value.ToString(), out start, out end);
                                    parmList.Add(c => c.PartyDate >= start && c.PartyDate <= end);
                                }
                            }
                        }
                        else            //二选一/多选一/确认到店
                        {
                            parmList.Add(c => ("5,6,7,8").Contains(c.OrderState.ToString()));
                        }
                    }
                }
                int count = 0;

                var dataList = _orderService.GetAllByPages(page, pagesize, parmList, sortName, out count);
                if (dataList.Count > 0)
                {
                    ajax.IsSuccess = true;

                    ajax.data      = dataList;
                    ajax.total     = count;                                    //数据总条数
                    ajax.PageIndex = page;                                     //当前页
                    ajax.PageSize  = pagesize;                                 //每页显示条数
                    ajax.EmpId     = LoginInfo.UserInfo.EmployeeId.ToString(); //登录员工
                }
            }
            catch (Exception e)
            {
                ajax.Message = e.Message;
            }

            return(ajax);
        }
Example #3
0
        public AjaxMessage GetInviteCustomer(int page, int pageSize, string sortName, PropModel[] searchs, string inviteEmployee)
        {
            AjaxMessage ajax = new AjaxMessage();

            ajax.IsSuccess = false;
            ajax.Message   = "查询失败,系统异常";
            try
            {
                int count = 0;
                List <Expression <Func <InviteDto, bool> > > parmList = new List <Expression <Func <InviteDto, bool> > >();

                #region 条件
                //默认显示当前登录人以及下级的邀约的信息
                if (!string.IsNullOrEmpty(inviteEmployee))
                {
                    string employeeId = inviteEmployee.ToInt32() > 0 ? inviteEmployee : LoginInfo.UserInfo.EmployeeId.ToString();
                    //选择只显示选择人个人的邀约信息
                    bool isLookLowLevel = inviteEmployee.ToInt32() > 0 ? false : true;
                    ExpressionTools.GetParsByCondition <InviteDto>("InviteEmployee", parmList, employeeId, "Contains", true, isLookLowLevel);
                }
                else
                {
                    //默认获取本人及下级邀约信息
                    MyEmployee sel_emp = new MyEmployee();
                    sel_emp.GetMyEmployee <InviteDto>("InviteEmployee", parmList, true);
                }

                if (searchs.Count() > 0)
                {
                    foreach (PropModel item in searchs)
                    {
                        if (item.value != "-1")          //有明确的某个状态
                        {
                            if (!string.IsNullOrEmpty(item.value))
                            {
                                if (!(item.value.Contains(',')))
                                {
                                    ExpressionTools.GetEqualPars(item.property, parmList, item.value, item.method);
                                }
                                else if (item.value.Contains(','))      //时间 婚期
                                {
                                    TimeHelper.GetPartyDateTime(item.value.ToString(), out start, out end);
                                    parmList.Add(c => c.PartyDate >= start && c.PartyDate <= end);
                                }
                            }
                        }
                        else            //邀约/未邀约/邀约成功/确认到店
                        {
                            parmList.Add(c => ("1,2,3,5").Contains(c.State.ToString()));
                        }
                    }
                }


                #endregion

                var DataList = _inviteService.GetAllByPage(page, pageSize, parmList, sortName, out count);
                ajax.data      = DataList;
                ajax.total     = count;                                    //数据总条数
                ajax.PageIndex = page;                                     //当前页
                ajax.PageSize  = pageSize;                                 //每页显示条数
                ajax.EmpId     = LoginInfo.UserInfo.EmployeeId.ToString(); //登录员工

                ajax.IsSuccess = true;
            }
            catch (Exception e)
            {
                ajax.Message = e.Message;
            }

            return(ajax);
        }