/// <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();
}