/// <summary> /// 绑定信息 /// </summary> private void BindInfo() { //搜索控件 CardNo.Value = Request.QueryString["title"]; Username.Value = Request.QueryString["uid"]; AreaId.Value = Request.QueryString["area"]; WebUtility.BindHtmlSelectByBool(Sold, "--出售状态--", "已出售", "未出售", Request.QueryString["p1"]); WebUtility.BindHtmlSelectByBool(Enabled, "--激活状态--", "已激活", "未激活", Request.QueryString["enab"]); //组合查询条件 List <SqlWhere> sqlWhereList = new List <SqlWhere>(); sqlWhereList.Add(new SqlWhere(MemberCardModel.CARDNO, SqlWhere.Oper.Equal, Request.QueryString["title"])); sqlWhereList.Add(new SqlWhere(MemberCardModel.USERNAME, SqlWhere.Oper.Like, Request.QueryString["uid"])); sqlWhereList.Add(new SqlWhere(MemberCardModel.SOLD, SqlWhere.Oper.Equal, Request.QueryString["p1"])); sqlWhereList.Add(new SqlWhere(MemberCardModel.ENABLED, SqlWhere.Oper.Equal, Request.QueryString["enab"])); sqlWhereList.Add(new SqlWhere(MemberCardModel.CITYID, SqlWhere.Oper.In, bll_area.GetIds(Request.QueryString["area"]))); //读取分页数据 int iRecordsTotal = bll_memberCard.DoCount(sqlWhereList); QianZhu.Utility.Pagination pagination = new QianZhu.Utility.Pagination(Request.QueryString["page"], iRecordsTotal, iPageSize, "?page=$p" + WebUtility.GetUrlParams("&", false), true); pagination.HAlign = QianZhu.Utility.Pagination.Align.Right; Paging.InnerHtml = pagination.Show(); List <MemberCardModel> memberCardList = bll_memberCard.GetList(pagination.PageIndex, iPageSize, sqlWhereList); //绑定 if (memberCardList.Count == 0) { NoDataRow.Visible = true; } Repeater1.DataSource = memberCardList; Repeater1.DataBind(); }
/// <summary> /// 绑定信息 /// </summary> private void BindInfo() { //搜索控件 MyTitle.Value = Request.QueryString["title"]; bll_adGroup.BindDropDownList(GroupId, Request.QueryString["gid"], "--广告组--"); WebUtility.BindHtmlSelectByBool(Enabled, "--状态--", "上线", "下线", Request.QueryString["enab"]); //组合查询条件 List <SqlWhere> sqlWhereList = new List <SqlWhere>(); sqlWhereList.Add(new SqlWhere(AdGroupModel.PKID, SqlWhere.Oper.Join, AdFixedModel.GROUPID)); sqlWhereList.Add(new SqlWhere(AdGroupModel.INBUILT, SqlWhere.Oper.Equal, true)); sqlWhereList.Add(new SqlWhere(AdFixedModel.GROUPID, SqlWhere.Oper.Equal, Request.QueryString["gid"])); sqlWhereList.Add(new SqlWhere(AdFixedModel.TITLE, SqlWhere.Oper.Like, Request.QueryString["title"])); sqlWhereList.Add(new SqlWhere(AdFixedModel.ENABLED, SqlWhere.Oper.Equal, Request.QueryString["enab"])); //读取分页数据 int iRecordsTotal = bll_adFixed.DoCount(sqlWhereList); QianZhu.Utility.Pagination pagination = new QianZhu.Utility.Pagination(Request.QueryString["page"], iRecordsTotal, iPageSize, "?page=$p" + WebUtility.GetUrlParams("&", false), true); pagination.HAlign = QianZhu.Utility.Pagination.Align.Right; Paging.InnerHtml = pagination.Show(); List <AdFixedModel> adFixedList = bll_adFixed.GetList(pagination.PageIndex, iPageSize, sqlWhereList); //绑定 if (adFixedList.Count == 0) { NoDataRow.Visible = true; } Repeater1.DataSource = adFixedList; Repeater1.DataBind(); }
/// <summary> /// 绑定信息 /// </summary> private void BindInfo() { //搜索控件 MyTitle.Value = Request.QueryString["title"]; //CategoryId.Value = Request.QueryString["cid"]; WebUtility.BindHtmlSelectByBool(IsTop, "--置顶--", "已置顶", "未置顶", Request.QueryString["top"]); WebUtility.BindHtmlSelectByBool(Enabled, "--状态--", "上线", "下线", Request.QueryString["enab"]); //组合查询条件 List <SqlWhere> sqlWhereList = new List <SqlWhere>(); sqlWhereList.Add(new SqlWhere(ProductModel.TITLE, SqlWhere.Oper.Like, Request.QueryString["title"])); sqlWhereList.Add(new SqlWhere(ProductModel.ISTOP, SqlWhere.Oper.Equal, Request.QueryString["top"])); sqlWhereList.Add(new SqlWhere(ProductModel.ENABLED, SqlWhere.Oper.Equal, Request.QueryString["enab"])); sqlWhereList.Add(new SqlWhere(ProductModel.CATEGORYID, SqlWhere.Oper.In, bll_category.GetIds(Request.QueryString["cid"]))); //SystemHelper.PrintEnd(bll_category.GetIds(Request.QueryString["cid"])); //读取分页数据 int iRecordsTotal = bll_product.DoCount(); QianZhu.Utility.Pagination pagination = new QianZhu.Utility.Pagination(Request.QueryString["page"], iRecordsTotal, iPageSize, "?page=$p" + WebUtility.GetUrlParams("&", false), true); pagination.HAlign = QianZhu.Utility.Pagination.Align.Right; Paging.InnerHtml = pagination.Show(); List <ProductModel> productList = bll_product.GetList(pagination.PageIndex, iPageSize, null, sqlWhereList, null); //绑定 if (productList.Count == 0) { NoDataRow.Visible = true; } Repeater1.DataSource = productList; Repeater1.DataBind(); }
/// <summary> /// 绑定信息 /// </summary> private void BindInfo() { //搜索控件 MyContent.Value = Request.QueryString["title"]; WebUtility.BindHtmlSelectByBool(Enabled, "--状态--", "正常", "屏蔽", Request.QueryString["enab"]); //组合查询条件 List <SqlWhere> sqlWhereList = new List <SqlWhere>(); sqlWhereList.Add(new SqlWhere(CommentModel.CONTENT, SqlWhere.Oper.Like, Request.QueryString["title"])); sqlWhereList.Add(new SqlWhere(CommentModel.ENABLED, SqlWhere.Oper.Equal, Request.QueryString["enab"])); //读取分页数据 int iRecordsTotal = bll_comment.DoCount(sqlWhereList); QianZhu.Utility.Pagination pagination = new QianZhu.Utility.Pagination(Request.QueryString["page"], iRecordsTotal, iPageSize, "?page=$p" + WebUtility.GetUrlParams("&", false), true); pagination.HAlign = QianZhu.Utility.Pagination.Align.Right; Paging.InnerHtml = pagination.Show(); List <CommentModel> commentList = bll_comment.GetList(pagination.PageIndex, iPageSize, sqlWhereList); //绑定 if (commentList.Count == 0) { NoDataRow.Visible = true; } Repeater1.DataSource = commentList; Repeater1.DataBind(); }
/// <summary> /// 绑定信息 /// </summary> private void BindInfo() { //搜索控件 Uname.Value = Request.QueryString["uid"]; WebUtility.BindHtmlSelectByBool(Enabled, "--状态--", "启用状态", "禁用状态", Request.QueryString["enab"]); //组合查询条件 List <SqlWhere> sqlWhereList = new List <SqlWhere>(); sqlWhereList.Add(new SqlWhere(AdminModel.USERNAME, SqlWhere.Oper.Equal, Request.QueryString["uid"])); sqlWhereList.Add(new SqlWhere(AdminModel.ENABLED, SqlWhere.Oper.Equal, Request.QueryString["enab"])); //读取分页数据 int iRecordsTotal = bll_admin.DoCount(sqlWhereList); QianZhu.Utility.Pagination pagination = new QianZhu.Utility.Pagination(Request.QueryString["page"], iRecordsTotal, iPageSize, "?page=$p" + WebUtility.GetUrlParams("&", false), true); pagination.HAlign = QianZhu.Utility.Pagination.Align.Right; Paging.InnerHtml = pagination.Show(); List <AdminModel> adminList = bll_admin.GetList(pagination.PageIndex, iPageSize, sqlWhereList); //绑定 if (adminList.Count == 0) { NoDataRow.Visible = true; } Repeater1.DataSource = adminList; Repeater1.DataBind(); }
/// <summary> /// 绑定信息 /// </summary> private void BindInfo() { //搜索控件 MyTitle.Value = Request.QueryString["title"]; XMLHelper.SetCtrlByXmlData(Mode, "--消息类型--", "MsgTempMode", Request.QueryString["gid"]); WebUtility.BindHtmlSelectByBool(Enabled, "--状态--", "上线", "下线", Request.QueryString["enab"]); //组合查询条件 List <SqlWhere> sqlWhereList = new List <SqlWhere>(); sqlWhereList.Add(new SqlWhere(MsgTempModel.TITLE, SqlWhere.Oper.Like, Request.QueryString["title"])); sqlWhereList.Add(new SqlWhere(MsgTempModel.MODE, SqlWhere.Oper.Equal, Request.QueryString["gid"])); sqlWhereList.Add(new SqlWhere(MsgTempModel.ENABLED, SqlWhere.Oper.Equal, Request.QueryString["enab"])); //读取分页数据 int iRecordsTotal = bll_msgTemp.DoCount(sqlWhereList); QianZhu.Utility.Pagination pagination = new QianZhu.Utility.Pagination(Request.QueryString["page"], iRecordsTotal, iPageSize, "?page=$p" + WebUtility.GetUrlParams("&", false), true); pagination.HAlign = QianZhu.Utility.Pagination.Align.Right; Paging.InnerHtml = pagination.Show(); List <MsgTempModel> messageTemplateList = bll_msgTemp.GetList(pagination.PageIndex, iPageSize, sqlWhereList); //绑定 if (messageTemplateList.Count == 0) { NoDataRow.Visible = true; } Repeater1.DataSource = messageTemplateList; Repeater1.DataBind(); }
/// <summary> /// 绑定信息 /// </summary> private void BindInfo() { //搜索控件 MyTitle.Value = Request.QueryString["title"]; WebUtility.BindHtmlSelectByBool(Inbuilt, "--系统内置--", "是", "否", Request.QueryString["stat"]); WebUtility.BindHtmlSelectByBool(Enabled, "--状态--", "上线", "下线", Request.QueryString["enab"]); //组合查询条件 List <SqlWhere> sqlWhereList = new List <SqlWhere>(); sqlWhereList.Add(new SqlWhere(OnePageModel.TITLE, SqlWhere.Oper.Like, Request.QueryString["title"])); sqlWhereList.Add(new SqlWhere(OnePageModel.INBUILT, SqlWhere.Oper.Equal, Request.QueryString["stat"])); sqlWhereList.Add(new SqlWhere(OnePageModel.ENABLED, SqlWhere.Oper.Equal, Request.QueryString["enab"])); //读取分页数据 int iRecordsTotal = bll_onePage.DoCount(sqlWhereList); QianZhu.Utility.Pagination pagination = new QianZhu.Utility.Pagination(Request.QueryString["page"], iRecordsTotal, iPageSize, "?page=$p" + WebUtility.GetUrlParams("&", false), true); pagination.HAlign = QianZhu.Utility.Pagination.Align.Right; Paging.InnerHtml = pagination.Show(); List <OnePageModel> onePageList = bll_onePage.GetList(pagination.PageIndex, iPageSize, sqlWhereList); //绑定 if (onePageList.Count == 0) { NoDataRow.Visible = true; } Repeater1.DataSource = onePageList; Repeater1.DataBind(); }
/// <summary> /// 绑定信息 /// </summary> private void BindInfo() { //搜索控件 MyTitle.Value = Request.QueryString["title"]; CategoryId.Value = Request.QueryString["cid"]; // AreaId.Value = Request.QueryString["area"]; //WebUtility.BindHtmlSelectByBool(IsHead, "--头条--", "是", "否", Request.QueryString["p1"]); WebUtility.BindHtmlSelectByBool(IsTop, "--置顶--", "已置顶", "未置顶", Request.QueryString["top"]); WebUtility.BindHtmlSelectByBool(Enabled, "--状态--", "上线", "下线", Request.QueryString["enab"]); //查询字段 List <string> fieldList = new List <string>(); fieldList.Add(ArticleModel.PKID); fieldList.Add(ArticleModel.TITLE); fieldList.Add(ArticleModel.CATEGORYID); fieldList.Add(ArticleModel.AREAID); fieldList.Add(ArticleModel.PV); fieldList.Add(ArticleModel.ISHEAD); fieldList.Add(ArticleModel.ISTOP); fieldList.Add(ArticleModel.ENABLED); fieldList.Add(ArticleModel.CREATETIME); //组合查询条件 List <SqlWhere> sqlWhereList = new List <SqlWhere>(); sqlWhereList.Add(new SqlWhere(ArticleModel.TITLE, SqlWhere.Oper.Like, Request.QueryString["title"])); //sqlWhereList.Add(new SqlWhere(ArticleModel.ISHEAD, SqlWhere.Oper.Equal, Request.QueryString["p1"])); sqlWhereList.Add(new SqlWhere(ArticleModel.ISTOP, SqlWhere.Oper.Equal, Request.QueryString["top"])); sqlWhereList.Add(new SqlWhere(ArticleModel.ENABLED, SqlWhere.Oper.Equal, Request.QueryString["enab"])); sqlWhereList.Add(new SqlWhere(ArticleModel.CATEGORYID, SqlWhere.Oper.In, bll_category.GetIds(Request.QueryString["cid"]))); //sqlWhereList.Add(new SqlWhere(ArticleModel.AREAID, SqlWhere.Oper.In, bll_area.GetIds(Request.QueryString["area"]))); //读取分页数据 int iRecordsTotal = bll_article.DoCount(sqlWhereList); QianZhu.Utility.Pagination pagination = new QianZhu.Utility.Pagination(Request.QueryString["page"], iRecordsTotal, iPageSize, "?page=$p" + WebUtility.GetUrlParams("&", false), true); pagination.HAlign = QianZhu.Utility.Pagination.Align.Right; Paging.InnerHtml = pagination.Show(); List <ArticleModel> articleList = bll_article.GetList(pagination.PageIndex, iPageSize, fieldList, sqlWhereList, null); //绑定 if (articleList.Count == 0) { NoDataRow.Visible = true; } Repeater1.DataSource = articleList; Repeater1.DataBind(); }
/// <summary> /// 绑定信息 /// </summary> private void BindInfo() { OpBtn.Visible = !group.Inbuilt; PicTd.Visible = group.Display == 0; //搜索控件 MyTitle.Value = Request.QueryString["title"]; if (group.Inbuilt) { Enabled.Visible = false; } else { WebUtility.BindHtmlSelectByBool(Enabled, "--状态--", "上线", "下线", Request.QueryString["enab"]); } //组合查询条件 List <SqlWhere> sqlWhereList = new List <SqlWhere>(); sqlWhereList.Add(new SqlWhere(AdFixedModel.GROUPID, SqlWhere.Oper.Equal, group.Pkid)); sqlWhereList.Add(new SqlWhere(AdFixedModel.TITLE, SqlWhere.Oper.Like, Request.QueryString["title"])); if (group.Inbuilt) { sqlWhereList.Add(new SqlWhere(AdFixedModel.ENABLED, SqlWhere.Oper.Equal, true)); } else { sqlWhereList.Add(new SqlWhere(AdFixedModel.ENABLED, SqlWhere.Oper.Equal, Request.QueryString["enab"])); } //读取分页数据 int iRecordsTotal = bll_adFixed.DoCount(sqlWhereList); QianZhu.Utility.Pagination pagination = new QianZhu.Utility.Pagination(Request.QueryString["page"], iRecordsTotal, iPageSize, "?page=$p" + WebUtility.GetUrlParams("&", false), true); pagination.HAlign = QianZhu.Utility.Pagination.Align.Right; Paging.InnerHtml = pagination.Show(); List <AdFixedModel> adFixedList = bll_adFixed.GetList(pagination.PageIndex, iPageSize, sqlWhereList); //绑定 if (adFixedList.Count == 0) { NoDataRow.Visible = true; } Repeater1.DataSource = adFixedList; Repeater1.DataBind(); }
/// <summary> /// 绑定信息 /// </summary> private void BindInfo() { //搜索控件 MyTitle.Value = Request.QueryString["title"]; XMLHelper.SetCtrlByXmlData(Display, "--展示方式--", "AdDisplay", Request.QueryString["stat"]); WebUtility.BindHtmlSelectByBool(Inbuilt, "--系统内置--", "是", "否", Request.QueryString["enab"]); //组合查询条件 List <SqlWhere> sqlWhereList = new List <SqlWhere>(); sqlWhereList.Add(new SqlWhere(AdGroupModel.TITLE, SqlWhere.Oper.Like, Request.QueryString["title"])); sqlWhereList.Add(new SqlWhere(AdGroupModel.DISPLAY, SqlWhere.Oper.Equal, Request.QueryString["stat"])); sqlWhereList.Add(new SqlWhere(AdGroupModel.INBUILT, SqlWhere.Oper.Equal, Request.QueryString["enab"])); List <AdGroupModel> adGroupList = bll_adGroup.GetList(sqlWhereList); //绑定 if (adGroupList.Count == 0) { NoDataRow.Visible = true; } Repeater1.DataSource = adGroupList; Repeater1.DataBind(); }
/// <summary> /// 绑定信息 /// </summary> private void BindInfo() { //搜索控件 MyTitle.Value = Request.QueryString["title"]; WebUtility.BindHtmlSelectByBool(Enabled, "--状态--", "上线", "下线", Request.QueryString["enab"]); //组合查询条件 List <SqlWhere> sqlWhereList = new List <SqlWhere>(); sqlWhereList.Add(new SqlWhere(CategoryModel.ILEVEL, SqlWhere.Oper.Equal, 1)); sqlWhereList.Add(new SqlWhere(CategoryModel.TITLE, SqlWhere.Oper.Like, Request.QueryString["title"])); sqlWhereList.Add(new SqlWhere(CategoryModel.ENABLED, SqlWhere.Oper.Equal, Request.QueryString["enab"])); List <CategoryModel> categoryList = bll_category.GetList(sqlWhereList); total = categoryList.Count; //绑定 if (categoryList.Count == 0) { NoDataRow.Visible = true; } Repeater1.DataSource = categoryList; Repeater1.DataBind(); }