void device() { BLL.dt_item bll = new BLL.dt_item(); int pageSize = int.Parse(request["pagesize"]); int pageIdx = int.Parse(request["pageidx"]); int totalCount = 0; var ds = bll.GetList(pageSize, pageIdx, " ", " i.id desc", out totalCount); var data = (from DataRow dr in ds.Tables[0].Rows select new DBRowConvertor(dr).ConvertToEntity <Model.dt_item>()).ToList(); this.res = DTcms.Common.JsonHelper2.GetCommonObj(0, data); }
private void RptBind(string _strWhere, string _orderby) { ddlState.SelectedValue = this.state.ToString(); ddlOnLine.SelectedValue = this.online.ToString(); this.page = DTRequest.GetQueryInt("page", 1); BLL.dt_item bll = new BLL.dt_item(); //this.rptList.DataSource = bll.GetList(this.pageSize, this.page, _strWhere, _orderby, out this.totalCount); //this.rptList.DataBind(); ds = bll.GetList(this.pageSize, this.page, _strWhere, _orderby, out this.totalCount); //绑定页码 txtPageNum.Text = this.pageSize.ToString(); string pageUrl = Utils.CombUrlTxt("warning_list.aspx", "keywords={0}&page={1}&state={2}&online={3}", this.keywords, "__id__", this.state.ToString(), this.online.ToString()); PageContent.InnerHtml = Utils.OutPageList(this.pageSize, this.page, this.totalCount, pageUrl, 8); }
protected void databind() { var model = GetAdminInfo(); this.page = DTRequest.GetQueryInt("page", 1); tbKeys.Text = this.keywords; string strwhere = " 1=1 "; StringBuilder strTemp = new StringBuilder(); this.keywords = this.keywords.Replace("'", ""); if (model.role_type != 1) { strwhere += $" and i.user_id={model.id} "; } if (!string.IsNullOrEmpty(this.areacode)) { strwhere += $" and i.area_code='{this.areacode.Replace("'","")}' "; } if (!string.IsNullOrEmpty(this.keywords)) { strwhere += $" and (i.name like '%{this.keywords}%' or i.onenetnum='{this.keywords}')"; } BLL.dt_item bll = new BLL.dt_item(); string _orderby = " addtime desc "; var q = bll.GetList(this.pageSize, this.page, strwhere, _orderby, out this.totalCount); rptList1.DataSource = q; rptList1.DataBind(); if (this.totalCount > 0) { string position = q.Tables[0].Rows[0]["position"].ToString(); point1 = position.Substring(0, position.IndexOf(",")); point2 = position.Substring(position.IndexOf(",") + 1); } string pageUrl = Utils.CombUrlTxt("map_show.aspx", "areacode={0}&keywords={1}&page={2}", this.areacode, this.keywords, "__id__"); PageContent.InnerHtml = Utils.OutPageList(this.pageSize, this.page, this.totalCount, pageUrl, 3); }