Exemplo n.º 1
0
        private void PageInit()
        {
            EyouSoft.BLL.ComStructure.BComArea BLL = new EyouSoft.BLL.ComStructure.BComArea();
            pageIndex = Utils.GetInt(Utils.GetQueryStringValue("Page"), 1);
            MComAreaSearch model = new MComAreaSearch();

            model.AreaName = Utils.GetQueryStringValue("txtlineName");
            model.Type     = Utils.GetQueryStringValue("areaType") == "" ? (AreaType?)null : (AreaType)Utils.GetInt(Utils.GetQueryStringValue("areaType"));
            IList <EyouSoft.Model.ComStructure.MComArea> lst = BLL.GetList(pageIndex, pageSize, ref recordCount, this.SiteUserInfo.CompanyId, model);

            if (lst != null && lst.Count > 0)
            {
                this.rpt_list.DataSource = lst;
                this.rpt_list.DataBind();
                if (pageSize >= recordCount)
                {
                    this.ExporPageInfoSelect1.Visible = false;
                }
                else
                {
                    BindPage();
                }
            }
            else
            {
                this.rpt_list.Controls.Add(new Label()
                {
                    Text = "<tr><td colspan='3' height='23' align='center'>对不起,没有相关数据!</td></tr>"
                });
                this.ExporPageInfoSelect1.Visible = false;
            }
        }
Exemplo n.º 2
0
        /// <summary>
        /// 分页获取线路区域信息
        /// </summary>
        /// <param name="pageCurrent">当前页</param>
        /// <param name="pageSize">每页显示记录数</param>
        /// <param name="pageCount">总记录数</param>
        /// <param name="companyId">公司编号</param>
        /// <param name="model">搜索实体</param>
        /// <returns>线路区域集合</returns>
        public IList <MComArea> GetList(int pageCurrent, int pageSize, ref int pageCount, string companyId, MComAreaSearch model)
        {
            string tableName  = "tbl_ComArea";
            string primaryKey = "AreaId";
            string fields     = " AreaId,CompanyId,AreaName,[Type],OperatorId,(select OperatorId as PlanerId,(select ContactName from tbl_ComUser where UserId=tbl_ComAreaPlaner.OperatorId) as Planer from tbl_ComAreaPlaner where AreaId=tbl_ComArea.AreaId  for xml raw,root) PlanList ";

            string query   = string.Format(" CompanyId = '{0}' and IsDelete='0'", companyId);
            string orderBy = " AreaId DESC";

            if (model != null)
            {
                if (!string.IsNullOrEmpty(model.AreaName))
                {
                    query += string.Format(" and AreaName like '%{0}%'", Utils.ToSqlLike(model.AreaName));
                }
                if (model.Type.HasValue)
                {
                    query += string.Format(" and [Type]={0}", (int)model.Type);
                }
            }
            IList <MComArea> list = new List <MComArea>();
            MComArea         item = null;

            string xmlString = string.Empty;

            using (IDataReader reader = DbHelper.ExecuteReader(this._db, pageSize, pageCurrent, ref pageCount,
                                                               tableName, primaryKey, fields, query, orderBy))
            {
                while (reader.Read())
                {
                    item = new MComArea()
                    {
                        AreaId     = (int)reader["AreaId"],
                        CompanyId  = reader["CompanyId"].ToString(),
                        AreaName   = reader["AreaName"].ToString(),
                        Type       = (AreaType)Enum.Parse(typeof(AreaType), reader["Type"].ToString()),
                        OperatorId = reader["OperatorId"].ToString(),
                        Plan       = GetPlanByXml(reader["PlanList"].ToString())
                    };
                    //计调员

                    list.Add(item);
                }
            }

            return(list);
        }
Exemplo n.º 3
0
 /// <summary>
 /// 分页获取线路区域信息
 /// </summary>
 /// <param name="pageCurrent">当前页</param>
 /// <param name="pageSize">每页显示记录数</param>
 /// <param name="pageCount">总记录数</param>
 /// <param name="companyId">公司编号</param>
 /// <param name="model">搜索实体</param>
 /// <returns>线路区域集合</returns>
 public IList <MComArea> GetList(int pageCurrent, int pageSize, ref int pageCount, string companyId, MComAreaSearch model)
 {
     if (!string.IsNullOrEmpty(companyId))
     {
         return(dal.GetList(pageCurrent, pageSize, ref pageCount, companyId, model));
     }
     return(null);
 }