Esempio n. 1
0
 public PagingEntity<FullLogonHistory> QueryPaging(FullLogonHistoryQueryForm form)
 {
     PagingEntity<FullLogonHistory> result = new PagingEntity<FullLogonHistory>();
     result.Record = bll.Query(form);
     result.RecordCount = bll.QueryCount(form);
     return result;
 }
Esempio n. 2
0
 public PagingEntity<Customer> QueryAllPaging()
 {
     CustomerQueryForm form = new CustomerQueryForm { Enabled = 1, IsDeleted = 0 };
     PagingEntity<Customer> result = new PagingEntity<Customer>();
     result.Record = bll.Query(form);
     result.RecordCount = bll.QueryCount(form);
     return result;
 }
Esempio n. 3
0
 public PagingEntity<FullUser> QueryPaging(FullUserQueryForm form)
 {
     form.IsDeleted = 0;
     PagingEntity<FullUser> result = new PagingEntity<FullUser>();
     result.Record = bll.Query(form);
     result.RecordCount = bll.QueryCount(form);
     return result;
 }
Esempio n. 4
0
 public PagingEntity<FullHouse> QueryPaging(QueryHouseServiceForm form)
 {
     form.IsDeleted = 0;
     form.Enabled = 1;
     form.IsOurs = 1;
     PagingEntity<FullHouse> result = new PagingEntity<FullHouse>();
     result.Record = bll.Query(form);
     result.RecordCount = bll.QueryCount(form);
     return result;
 }
Esempio n. 5
0
 public PagingEntity<Customer> Query(CustomerQueryForm form)
 {
     List<string> useridList = Common.GetDataAuthorityUserIDList();
     form.Creators = useridList;
     var list = bll.Query(form);
     PagingEntity<Customer> paggingList = new PagingEntity<Customer>();
     paggingList.Record = list;
     paggingList.PageCount = form.PageCount;
     paggingList.RecordCount = form.RecordCount;
     return paggingList;
 }
Esempio n. 6
0
        /// <summary>
        /// 查询
        /// </summary>
        /// <param name="QuickConditions"></param>
        /// <param name="pageindex"></param>
        /// <param name="pagesize"></param>
        /// <returns></returns>
        public PagingEntity GetDataSource(Hashtable query, int pageindex, int pagesize)
        {
            string where = "";
            PagingEntity pe = db.Find(@"select uFunction_ID _ukid, iFunction_Number, cFunction_Name, cFunction_ByName, dFunction_CreateTime from [dbo].[T_Function]
                                                where 1=1 " + where + " order by  iFunction_Number ", pageindex, pagesize);

            return(new ToJson().GetPagingEntity(pe, new List <BaseEntity>()
            {
                new T_Function()
            }));
        }
Esempio n. 7
0
        public PagingEntity <FullUser> QueryUser(FullUserQueryForm form)
        {
            var list = bll.Query(form);
            PagingEntity <FullUser> users = new PagingEntity <FullUser>
            {
                Record      = list,
                PageCount   = form.PageCount,
                RecordCount = form.RecordCount,
            };

            return(users);
        }
Esempio n. 8
0
        /// <summary>
        /// 通过分页存储过程获取实体集
        /// </summary>
        /// <param name="page"></param>
        /// <returns></returns>
        public static List <T> GetEntityListByPagination(PagingEntity page)
        {
            DataSet ds = GetDataSetByPagination(page);

            if (ds.Tables.Count > 1 && ds.Tables[1].Rows.Count > 0)
            {
                int iDataCount = 0;
                int.TryParse(ds.Tables[1].Rows[0][0] + "", out iDataCount);
                page.DataCount = iDataCount;
            }
            return(DataSetToEntityList(ds));
        }
Esempio n. 9
0
        public PagingEntity <Customer> Query(CustomerQueryForm form)
        {
            List <string> useridList = Common.GetDataAuthorityUserIDList();

            form.Creators = useridList;
            var list = bll.Query(form);
            PagingEntity <Customer> paggingList = new PagingEntity <Customer>();

            paggingList.Record      = list;
            paggingList.PageCount   = form.PageCount;
            paggingList.RecordCount = form.RecordCount;
            return(paggingList);
        }
Esempio n. 10
0
        public static DataSet GetDataSetByPagination <T>(this T t, PagingEntity page, ref string HtmlPage) where T : class
        {
            DataSet ds = EntityOperate <T> .GetDataSetByPagination(page);

            if (ds.Tables.Count > 1 && ds.Tables[1].Rows.Count > 0)
            {
                int iDataCount = 0;
                int.TryParse(ds.Tables[1].Rows[0][0] + "", out iDataCount);
                page.DataCount = iDataCount;
                HtmlPage       = page.CreateHtmlPage("");
            }
            return(ds);
        }
Esempio n. 11
0
 public PagingEntity<Asset> Query(AssetQueryForm form)
 {
     List<string> useridList = Common.GetDataAuthorityUserIDList();
     form.Creators = useridList;
     var list = bll.Query(form);
     PagingEntity<Asset> assets = new PagingEntity<Asset>
     {
         Record = list,
         PageCount = form.PageCount,
         RecordCount = form.RecordCount,
     };
     return assets;
 }
Esempio n. 12
0
        public PagingEntity PagingList(string SQL, int PageIndex, int PageSize)
        {
            var pe = new PagingEntity();
            int PageCount = 0, Counts = 0;
            var dt = new DataTable();

            dt           = SqlHelper.SysPageList(SQL, PageIndex, PageSize, out PageCount, out Counts);
            pe.dt        = dt;
            pe.Counts    = Counts;
            pe.PageCount = PageCount;
            pe.List      = ConvertDataTableToList <Dictionary <string, object> >(dt);
            return(pe);
        }
Esempio n. 13
0
        public virtual ActionResult ExportExcel(FormCollection fc, int page = 1, int rows = 100000)
        {
            foreach (var item in Request.QueryString.Keys)
            {
                if (!fc.AllKeys.Contains(item.ToString()))
                {
                    fc.Add(item.ToString(), Tools.getString(Request.QueryString[item.ToString()]));
                }
            }
            PagingEntity pe = GetPagingEntity(fc, page, rows);

            return(File(DBToExcel(pe), Tools.GetFileContentType[".xls"], Guid.NewGuid().ToString() + ".xls"));
        }
        public HttpResponseMessage Search(string searchText, int pageIndex, int pageSize)
        {
            Expression <Func <bec_AssInformation, bool> > queryexpress = CreateLinkQuery(searchText);
            Expression <Func <bec_AssInformation, int> >  orderexpress = p => p.Id;
            int total = 0;

            return(ExceptionHelp.Execute <PagingEntity <bec_AssInformation> >(() =>
            {
                PagingEntity <bec_AssInformation> result = new PagingEntity <bec_AssInformation>();
                result.items = dbBase.LoadPagerEntities(pageSize, pageIndex, out total, queryexpress, true, orderexpress);
                result.total = total;
                return result;
            }, Request));
        }
Esempio n. 15
0
        public PagingEntity <InitApprovalResultForm> QueryMyApply(QueryMyApplyServiceForm form)
        {
            UserBLL userbll = new UserBLL();
            string  userid  = userbll.GetCurrentUser().User.ID;

            form.UserID   = userid;
            form.Creators = Common.GetDataAuthorityUserIDList();
            PagingEntity <InitApprovalResultForm> result = new PagingEntity <InitApprovalResultForm>();

            result.Record      = bll.QueryMyApply(form);
            result.PageCount   = form.PageCount;
            result.RecordCount = form.RecordCount;
            return(result);
        }
        public HttpResponseMessage ListPage([FromBody] bec_AssInformation filter, int pageIndex, int pageSize)
        {
            Expression <Func <bec_AssInformation, bool> > queryexpress = CreateQueryFilter(filter);
            Expression <Func <bec_AssInformation, int> >  orderexpress = p => p.Id;
            int total = 0;

            return(ExceptionHelp.Execute <PagingEntity <bec_AssInformation> >(() =>
            {
                PagingEntity <bec_AssInformation> result = new PagingEntity <bec_AssInformation>();
                result.items = dbBase.LoadPagerEntities(pageSize, pageIndex, out total, queryexpress, true, orderexpress);
                result.total = total;
                return result;
            }, Request));
        }
Esempio n. 17
0
        public PagingEntity <Asset> Query(AssetQueryForm form)
        {
            List <string> useridList = Common.GetDataAuthorityUserIDList();

            form.Creators = useridList;
            var list = bll.Query(form);
            PagingEntity <Asset> assets = new PagingEntity <Asset>
            {
                Record      = list,
                PageCount   = form.PageCount,
                RecordCount = form.RecordCount,
            };

            return(assets);
        }
Esempio n. 18
0
        public virtual ActionResult GetDataSource(FormCollection fc, int page = 1, int rows = 20)
        {
            var hs = Tools.GetUrlQueryString(Request.UrlReferrer.Query);

            foreach (var item in hs.Keys)
            {
                if (!fc.AllKeys.Contains(item.ToString()))
                {
                    fc.Add(item.ToString(), Tools.getString(hs[item.ToString()]));
                }
            }
            PagingEntity pe = GetPagingEntity(fc, page, rows);

            return(Json(new { status = 1, columnModel = pe.ColModel, rows = pe.List, page = page, records = pe.Counts, total = pe.PageCount }, JsonRequestBehavior.DenyGet));
        }
Esempio n. 19
0
        private void button16_Click(object sender, EventArgs e)
        {
            Workflow          workflow    = new Workflow();
            RoleBLL           rolebll     = new RoleBLL();
            CustomerBLL       customerbll = new CustomerBLL();
            List <string>     ids         = rolebll.GetUserSubUserIDs("13");
            CustomerQueryForm form        = new CustomerQueryForm();

            form.Creators = ids;
            var list = customerbll.Query(form);
            PagingEntity <Customer> paggingList = new PagingEntity <Customer>();

            paggingList.Record      = list;
            paggingList.PageCount   = form.PageCount;
            paggingList.RecordCount = form.RecordCount;
        }
Esempio n. 20
0
        /// <summary>
        /// 通过分页存储过程获取数据
        /// </summary>
        /// <param name="page"></param>
        /// <returns></returns>
        public static DataSet GetDataSetByPagination(PagingEntity page)
        {
            DbParameter[] parameters = new DbParameter[8];
            parameters[0] = dataProvider.CreateParameter("@Tables", typeof(T).Name, DbType.String, 1000);
            parameters[0] = dataProvider.CreateParameter("@PK", page.PrimaryKey, DbType.String, 100);
            parameters[0] = dataProvider.CreateParameter("@Sort", page.Sort, DbType.String, 200);
            parameters[0] = dataProvider.CreateParameter("@PageNumber", page.CurPage, DbType.Int16);
            parameters[0] = dataProvider.CreateParameter("@PageSize", page.PageSize, DbType.Int16);
            parameters[0] = dataProvider.CreateParameter("@Fields", page.Fields, DbType.String, 1000);
            parameters[0] = dataProvider.CreateParameter("@Filter", page.QueryString, DbType.String, 1000);
            parameters[0] = dataProvider.CreateParameter("@Group", DBNull.Value, DbType.String, 1000);

            DataSet ds = new DataSet();//dataProvider.GetDataSetByProcedure("Page2005", parameters);

            return(ds);
        }
Esempio n. 21
0
        public virtual byte[] DBToExcel(PagingEntity pe)
        {
            DataTable    dt       = pe.Table;
            var          list     = pe.ColModel;
            HSSFWorkbook workbook = new HSSFWorkbook();
            ISheet       sheet    = workbook.CreateSheet();

            //填充表头
            IRow dataRow = sheet.CreateRow(0);

            foreach (DataColumn column in dt.Columns)
            {
                if (column.ColumnName.Equals("_ukid"))
                {
                    continue;
                }
                foreach (var item in list)
                {
                    if (column.ColumnName.Equals(item["field"].ToStr()))
                    {
                        dataRow.CreateCell(column.Ordinal).SetCellValue(item["title"].ToStr());
                    }
                }
            }

            //填充内容
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                dataRow = sheet.CreateRow(i + 1);
                for (int j = 0; j < dt.Columns.Count; j++)
                {
                    if (dt.Columns[j].ColumnName.Equals("_ukid"))
                    {
                        continue;
                    }
                    dataRow.CreateCell(j).SetCellValue(dt.Rows[i][j].ToString());
                }
            }

            //保存
            using (MemoryStream ms = new MemoryStream())
            {
                workbook.Write(ms);
                return(ms.ToArray());
            }
        }
Esempio n. 22
0
        public PagingEntity <FullTask> QueryMyProcessingWithPaging(QueryMyProcessingServiceForm form)
        {
            UserBLL userbll = new UserBLL();
            TaskBLL taskbll = new TaskBLL();
            PagingEntity <FullTask> result = new PagingEntity <FullTask>
            {
                PageCount   = form.PageCount,
                RecordCount = form.RecordCount,
            };
            var user   = userbll.GetCurrentUser();
            var record = taskbll.Query(new QueryMyTaskServiceForm {
                UserID = user.User.ID, Status = (int)TaskProcessStatus.Started
            });

            result.Record = record;
            return(result);
        }
Esempio n. 23
0
        /// <summary>
        /// 查询
        /// </summary>
        /// <param name="QuickConditions"></param>
        /// <param name="pageindex"></param>
        /// <param name="pagesize"></param>
        /// <returns></returns>
        public PagingEntity GetDataSource(Hashtable query, int pageindex, int pagesize)
        {
            string where = "";
            where       += string.IsNullOrEmpty(Tools.getString(query[Tools.getAttrName(() => tusers.cUsers_Name)])) ? "" : " and " + Tools.getAttrName(() => tusers.cUsers_Name) + " like '%" + Tools.getString(query[Tools.getAttrName(() => tusers.cUsers_Name)]) + "%' ";
            where       += string.IsNullOrEmpty(Tools.getString(query[Tools.getAttrName(() => tusers.cUsers_LoginName)])) ? "" : " and " + Tools.getAttrName(() => tusers.cUsers_LoginName) + " like '%" + Tools.getString(query[Tools.getAttrName(() => tusers.cUsers_LoginName)]) + "%' ";

            PagingEntity pe = db.Find(@"select cUsers_Name, cUsers_LoginName,cRoles_Name ,dUsers_CreateTime,uUsers_ID _ukid
				            from T_Users a
				            left join dbo.T_UsersRoles b on a.uUsers_ID=b.uUsersRoles_UsersID
				            left join dbo.T_Roles c on b.uUsersRoles_RoleID=c.uRoles_ID
                                                where 1=1 " + where + " ", pageindex, pagesize);

            return(new ToJson().GetPagingEntity(pe, new List <BaseEntity>()
            {
                new T_Users(),
                new T_Roles()
            }));
        }
Esempio n. 24
0
        /// <summary>
        /// 生产表头 Json 对象
        /// </summary>
        /// <param name="_PagingEntity"></param>
        /// <param name="ArryEntity"></param>
        private void SetHeaderJson(PagingEntity _PagingEntity, params BaseClass[] ArryEntity)
        {
            var dic      = new Dictionary <string, object>();
            var list     = new List <PropertyInfo>();
            var colNames = new List <Dictionary <string, string> >();

            ArryEntity.ToList().ForEach(item =>
            {
                //将所有实体里面的属性放入list中
                item.GetType().GetProperties().ToList().ForEach(p =>
                {
                    list.Add(p);
                });
            });
            foreach (DataColumn dc in _PagingEntity.Table.Columns)
            {
                dic = new Dictionary <string, object>();
                var col = new Dictionary <string, string>();
                var pro = list.Find(item => item.Name.Equals(dc.ColumnName));

                dic["field"]    = dc.ColumnName;
                dic["align"]    = "left";
                dic["sortable"] = true;
                if (pro == null)
                {
                    dic["title"]   = dc.ColumnName;
                    dic["visible"] = !dc.ColumnName.Equals("_ukid");
                    col.Add(dc.ColumnName, dc.ColumnName);
                }
                else
                {
                    //获取有特性标记的属性【获取字段别名(中文名称)】
                    var FiledConfig = pro.GetCustomAttribute(typeof(FieldAttribute)) as FieldAttribute;
                    if (FiledConfig != null)
                    {
                        dic["title"]   = (FiledConfig.Alias == "" ? dc.ColumnName : FiledConfig.Alias);
                        dic["visible"] = true;
                        col.Add(dc.ColumnName, dic["title"].ToStr());
                    }
                }
                _PagingEntity.ColNames.Add(col);
                _PagingEntity.ColModel.Add(dic);
            }
        }
Esempio n. 25
0
        public UserInitResultForm Init(FullUserQueryForm form)
        {
            var list = bll.Query(form);
            PagingEntity <FullUser> users = new PagingEntity <FullUser>
            {
                Record      = list,
                PageCount   = form.PageCount,
                RecordCount = form.RecordCount,
            };
            RoleBLL rolebll = new RoleBLL();
            var     role    = rolebll.Query(new RoleQueryForm {
            });
            UserInitResultForm resultform = new UserInitResultForm
            {
                User = users,
                Role = role,
            };

            return(resultform);
        }
Esempio n. 26
0
 /// <summary>
 /// 设置前台页面表头
 /// </summary>
 /// <param name="pe">Find查询完成后的PagingEntity对象</param>
 /// <param name="ArryEntity">查询涉及的表</param>
 /// <param name="isExecute">是否执行</param>
 public PagingEntity GetPagingEntity(PagingEntity pe, List <BaseModel> ArryEntity, bool isExecute = true)
 {
     if (isExecute)
     {
         var list = new List <PropertyInfo>();
         ArryEntity.ForEach(item =>
         {
             //将所有实体里面的属性放入list中
             item.EH.GetAllPropertyInfo(item).ForEach(p =>
             {
                 list.Add(p);
             });
         });
         foreach (DataColumn dc in pe.dt.Columns)
         {
             mjgcm = new M_JqGridColModel();
             var pro = list.Find(item => item.Name.Equals(dc.ColumnName));
             if (pro == null)
             {
                 mjgcm.label  = dc.ColumnName;
                 mjgcm.name   = dc.ColumnName;
                 mjgcm.hidden = dc.ColumnName.Equals("_ukid") ? true : false;
                 mjgcm.align  = "left";
             }
             else
             {
                 //获取有特性标记的属性【获取字段别名(中文名称)】
                 var FiledConfig = pro.GetCustomAttribute(typeof(FiledAttribute)) as FiledAttribute;
                 mjgcm        = new M_JqGridColModel();
                 mjgcm.label  = (FiledConfig.DisplayName == "" ? dc.ColumnName : FiledConfig.DisplayName);
                 mjgcm.name   = dc.ColumnName;
                 mjgcm.hidden = !FiledConfig.IsShowColumn;
                 mjgcm.align  = "left";
             }
             pe.JqGridColModel.Add(mjgcm);
         }
     }
     return(pe);
 }
Esempio n. 27
0
        public PagingEntity <InitApprovalResultForm> Query(QueryProjectServiceForm form)
        {
            var list = bll.QueryProjectByRelationship(form);

            if (list.Count == 0)
            {
                return(new PagingEntity <InitApprovalResultForm> {
                });
            }
            var     projectids = (from p in list select p.ID).Distinct().ToList();
            UserBLL userbll    = new UserBLL();
            string  userid     = userbll.GetCurrentUser().User.ID;
            var     record     = bll.Query(projectids, null, userid);
            PagingEntity <InitApprovalResultForm> result = new PagingEntity <InitApprovalResultForm>
            {
                Record      = record,
                PageCount   = form.PageCount,
                RecordCount = form.RecordCount,
            };

            return(result);
        }
Esempio n. 28
0
 /// <summary>
 /// 设置前台页面表头
 /// </summary>
 /// <param name="pe">Find查询完成后的PagingEntity对象</param>
 /// <param name="ArryEntity">查询涉及的表</param>
 /// <param name="isExecute">是否执行</param>
 public PagingEntity GetPagingEntity(PagingEntity pe, List <BaseEntity> ArryEntity, bool isExecute = true)
 {
     if (isExecute)
     {
         var list = new List <PropertyInfo>();
         ArryEntity.ForEach(item =>
         {
             //将所有实体里面的属性放入list中
             item.EH.GetAllPropertyInfo(item).ForEach(p =>
             {
                 list.Add(p);
             });
         });
         foreach (DataColumn dc in pe.dt.Columns)
         {
             mjgcm = new BootStrapTableColModel();
             var pro = list.Find(item => item.Name.Equals(dc.ColumnName));
             if (pro == null)
             {
                 mjgcm.title   = dc.ColumnName;
                 mjgcm.field   = dc.ColumnName;
                 mjgcm.visible = dc.ColumnName.Equals("_ukid") ? false : true;
                 mjgcm.align   = "left";
             }
             else
             {
                 //获取有特性标记的属性【获取字段别名(中文名称)】
                 var FiledConfig = pro.GetCustomAttribute(typeof(ObjectRemarks.FieldAttribute)) as ObjectRemarks.FieldAttribute;
                 mjgcm         = new BootStrapTableColModel();
                 mjgcm.title   = (FiledConfig.Alias == "" ? dc.ColumnName : FiledConfig.Alias);
                 mjgcm.field   = dc.ColumnName;
                 mjgcm.visible = true;
                 mjgcm.align   = "left";
             }
             pe.ColModel.Add(mjgcm);
         }
     }
     return(pe);
 }
Esempio n. 29
0
        /// <summary>
        /// 分页查询 通过 存储过程 PROC_SPLITPAGE
        /// </summary>
        /// <param name="SqlStr"></param>
        /// <param name="Page"></param>
        /// <param name="Rows"></param>
        /// <param name="Param"></param>
        /// <param name="ArryEntity"></param>
        /// <returns></returns>
        private PagingEntity GetPagingEntity(string SqlStr, int Page, int Rows, DbParameter[] Param, params BaseClass[] ArryEntity)
        {
            var _PagingEntity = new PagingEntity();

            //解析参数
            foreach (var item in Param)
            {
                SqlStr = SqlStr.Replace("@" + item.ParameterName, item.Value == null ? null : "'" + item.Value + "' ");
            }

            var _DynamicParameters = new DynamicParameters();

            _DynamicParameters.Add("@SQL", SqlStr, DbType.String, ParameterDirection.Input);
            _DynamicParameters.Add("@PAGE", Page, DbType.Int32, ParameterDirection.Input);
            _DynamicParameters.Add("@PAGESIZE", Rows, DbType.Int32, ParameterDirection.Input);
            _DynamicParameters.Add("@PAGECOUNT", 0, DbType.Int32, ParameterDirection.Output);
            _DynamicParameters.Add("@RECORDCOUNT", 0, DbType.Int32, ParameterDirection.Output);

            var _IDataReader = db.ExecuteReader("PROC_SPLITPAGE", _DynamicParameters, null, 30, CommandType.StoredProcedure);
            //将 IDataReader 对象转换为 DataSet
            DataSet _DataSet = new AdoExtend.WYDataSet();

            _DataSet.Load(_IDataReader, LoadOption.OverwriteChanges, null, new DataTable[] { });

            if (_DataSet.Tables.Count == 2)
            {
                var _Table = _DataSet.Tables[1];
                var _Total = _DynamicParameters.Get <int>("@RECORDCOUNT");
                _PagingEntity.Table     = _Table;
                _PagingEntity.Counts    = _Total;
                _PagingEntity.PageCount = (_Total / Rows);
                _PagingEntity.List      = _Table.ToList();

                this.SetHeaderJson(_PagingEntity, ArryEntity);
            }

            return(_PagingEntity);
        }
Esempio n. 30
0
 public PagingEntity<FollowupModel> QueryFullFollowup(FullFollowupQueryForm form)
 {
     HouseBLL housebll = new HouseBLL();
     BuildingBLL buildingbll = new BuildingBLL();
     UserBLL userbll = new UserBLL();
     CustomerBLL customerbll = new CustomerBLL();
     House_CustomerBLL hcbll = new House_CustomerBLL();
     PagingEntity<FollowupModel> result = new PagingEntity<FollowupModel>();
     result.Record = new List<FollowupModel>();
     var list = bll.QueryFullFollowup(form);
     var houseids = (from f in list select f.HouseID).Distinct().ToList();
     var houses = housebll.Query(new HouseQueryForm { IDs = houseids });
     var buildingids = (from h in houses select h.BuildingID).Distinct().ToList();
     var ownerids = (from h in houses where !string.IsNullOrEmpty(h.OwnerID) select h.OwnerID).Distinct().ToList();
     var userids = (from f in list select f.Creator).Distinct().ToList();
     var buildings = buildingbll.Query(new BuildingQueryForm { IDs = buildingids });
     var hcs = hcbll.Query(new House_CustomerQueryForm { HouseOrRoomIDs = houseids });
     var customerids = (from hc in hcs select hc.CustomerID).Distinct().ToList();
     var customers = customerbll.Query(new CustomerQueryForm { IDs = customerids });
     var users = userbll.SimpleQuery(new FullUserQueryForm { IDs = userids });
     list.ForEach(t =>
     {
         FollowupModel followup = new FollowupModel
         {
             House = houses.Find(p => p.ID.Equals(t.HouseID)),
             Followup = t,
             User = users.Find(p=>p.ID.Equals(t.Creator)),
         };
         followup.Building = buildings.Find(p => p.ID.Equals(followup.House?.BuildingID));
         followup.Owner = (from hc in hcs
                           join c in customers on hc.CustomerID equals c.ID
                           where hc.HouseOrRoomID.Equals(followup.House?.ID) && c.Type == (int)CustomerType.业主
                           select c).FirstOrDefault();
         result.Record.Add(followup);
     });
     result.RecordCount = bll.QueryFullFollowupCount(form);
     return result;
 }
Esempio n. 31
0
        public PagingEntity PagingList(string SQL, int PageIndex, int PageSize)
        {
            var pe = new PagingEntity();
            int PageCount = 0, Counts = 0;
            var dt = new DataTable();

            switch (_DBType)
            {
            case DBType.MySql:
                dt = MySqlHelper.PagingList(_ConnectionString, SQL, PageIndex, PageSize, out PageCount, out Counts);
                break;

            case DBType.SqlServer:
            default:
                dt = SqlHelper.SysPageList(SQL, PageIndex, PageSize, out PageCount, out Counts);
                break;
            }
            pe.dt        = dt;
            pe.Counts    = Counts;
            pe.PageCount = PageCount;
            pe.List      = Tool.ConvertDataTableToList <Dictionary <string, object> >(dt);
            return(pe);
        }
Esempio n. 32
0
        /// <summary>
        /// 分页查询
        /// </summary>
        /// <param name="Iquery"></param>
        /// <param name="Page"></param>
        /// <param name="Rows"></param>
        /// <param name="ArryEntity"></param>
        /// <returns></returns>
        public PagingEntity GetPagingEntity(IQuery Iquery, int Page, int Rows, params BaseClass[] ArryEntity)
        {
            var _Count = Iquery.Count();

            var _TakePage = Iquery.TakePage(Page, Rows);

            var _PagingEntity = new PagingEntity();

            var _Table = _TakePage.ToTable();

            if (_Table.Columns.Contains("ROWID"))
            {
                _Table.Columns.RemoveAt(0);
            }

            _PagingEntity.Table     = _Table;
            _PagingEntity.Counts    = _Count;
            _PagingEntity.PageCount = (_Count / Rows);
            _PagingEntity.List      = _Table.ToList();

            this.SetHeaderJson(_PagingEntity, ArryEntity);

            return(_PagingEntity);
        }
Esempio n. 33
0
 private void button16_Click(object sender, EventArgs e)
 {
     Workflow workflow = new Workflow();
     RoleBLL rolebll = new RoleBLL();
     CustomerBLL customerbll = new CustomerBLL();
     List<string> ids = rolebll.GetUserSubUserIDs("13");
     CustomerQueryForm form = new CustomerQueryForm();
     form.Creators = ids;
     var list = customerbll.Query(form);
     PagingEntity<Customer> paggingList = new PagingEntity<Customer>();
     paggingList.Record = list;
     paggingList.PageCount = form.PageCount;
     paggingList.RecordCount = form.RecordCount;
 }
Esempio n. 34
0
 public PagingEntity<InitApprovalResultForm> Query(QueryProjectServiceForm form)
 {
     var list = bll.QueryProjectByRelationship(form);
     if (list.Count == 0)
     {
         return new PagingEntity<InitApprovalResultForm> { };
     }
     var projectids = (from p in list select p.ID).Distinct().ToList();
     UserBLL userbll = new UserBLL();
     string userid = userbll.GetCurrentUser().User.ID;
     var record = bll.Query(projectids, null, userid);
     PagingEntity<InitApprovalResultForm> result = new PagingEntity<InitApprovalResultForm>
     {
         Record = record,
         PageCount = form.PageCount,
         RecordCount = form.RecordCount,
     };
     return result;
 }
Esempio n. 35
0
 public PagingEntity<InitApprovalResultForm> QueryMyApply(QueryMyApplyServiceForm form)
 {
     UserBLL userbll = new UserBLL();
     string userid = userbll.GetCurrentUser().User.ID;
     form.UserID = userid;
     form.Creators = Common.GetDataAuthorityUserIDList();
     PagingEntity<InitApprovalResultForm> result = new PagingEntity<InitApprovalResultForm>();
     result.Record = bll.QueryMyApply(form);
     result.PageCount = form.PageCount;
     result.RecordCount = form.RecordCount;
     return result;
 }
Esempio n. 36
0
 public PagingEntity<Customer> QueryRenterPaging(CustomerQueryForm form)
 {
     if (form == null) form = new CustomerQueryForm();
     form.Type = (int)CustomerType.租客;
     form.IsDeleted = 0;
     List<string> userids = Common.GetDataAuthorityUserIDList();
     form.Creators = userids;
     PagingEntity<Customer> result = new PagingEntity<Customer>();
     result.Record = bll.Query(form);
     result.RecordCount = bll.QueryCount(form);
     return result;
 }
Esempio n. 37
0
 public PagingEntity<Customer> QueryOurHouseOwnerPaging(FullCustomerQueryForm form)
 {
     PagingEntity<Customer> result = new PagingEntity<Customer>();
     if (form == null) form = new FullCustomerQueryForm();
     form.Type = (int)CustomerType.业主;
     form.IsDeleted = 0;
     form.IsOurs = 1;
     List<string> userids = Common.GetDataAuthorityUserIDList();
     form.Creators = userids;
     result.Record = bll.QueryFullCustomer(form);
     result.RecordCount = bll.QueryFullCustomerCount(form);
     return result;
 }
Esempio n. 38
0
 public UserInitResultForm Init(FullUserQueryForm form)
 {
     var list = bll.Query(form);
     PagingEntity<FullUser> users = new PagingEntity<FullUser>
     {
         Record = list,
         PageCount = form.PageCount,
         RecordCount = form.RecordCount,
     };
     RoleBLL rolebll = new RoleBLL();
     var role = rolebll.Query(new RoleQueryForm { });
     UserInitResultForm resultform = new UserInitResultForm
     {
         User = users,
         Role = role,
     };
     return resultform;
 }
Esempio n. 39
0
 public PagingEntity<FullHouse> QueryHousePaging(QueryHouseServiceForm form)
 {
     form.IsDeleted = 0;
     PagingEntity<FullHouse> result = new PagingEntity<FullHouse>();
     result.Record = housebll.QueryFullHouse(form);
     result.RecordCount = housebll.QueryFullHouseCount(form);
     return result;
 }
Esempio n. 40
0
 public PagingEntity<FullUser> QueryUser(FullUserQueryForm form)
 {
     var list = bll.Query(form);
     PagingEntity<FullUser> users = new PagingEntity<FullUser>
     {
         Record = list,
         PageCount = form.PageCount,
         RecordCount = form.RecordCount,
     };
     return users;
 }