protected void BindTemplateList() { int i, j; string TemplateName = txtTemplateName.Text.Trim(); string StartDate = txtStartDate.Text.Trim(); string EndDate = txtEndDate.Text.Trim(); string Author = txtAuthor.Text.Trim(); string TemplateStatus = ""; int startIndex = (AspNetPager1.CurrentPageIndex - 1) * AspNetPager1.PageSize + 1; int PageSize = AspNetPager1.PageSize; TemplateManageComponent tmbll = new TemplateManageComponent(); DataTable dt = tmbll.GetTemplateList(TemplateName, StartDate, EndDate, Author, TemplateStatus, AspNetPager1.CurrentPageIndex, PageSize, out i, out j); AspNetPager1.RecordCount = i; TemplateList.DataSource = dt; TemplateList.DataBind(); }
public string GetPageInfoByTemplateID(string TemplateID) { string pinfo = string.Empty; if (!string.IsNullOrEmpty(TemplateID)) { TemplateManageComponent pbll = new TemplateManageComponent(); DataTable dt = pbll.GetListByTemplateID(TemplateID); if (dt != null && dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { pinfo += "<a href='" + dr["Url"].ToString() + "' target='_blank' class='operateLink'>" + dr["PageName"].ToString() + "</a><br/>"; } } } return(pinfo.TrimEnd(',')); }
//启用 protected void btnuse_Click(object sender, EventArgs e) { try { string TemplateID = hidtemplateid.Value.Trim(); if (!string.IsNullOrEmpty(TemplateID)) { QueryConfigComponent qcc = new QueryConfigComponent(); DataTable qdt = qcc.GetUserQueryColListByTemplateID(Guid.Parse(TemplateID)); if (qdt != null && qdt.Rows.Count > 0) { string tstatus = "FREE"; TemplateManageComponent tcc = new TemplateManageComponent(); DataTable dt = tcc.GetListByTemplateID(TemplateID); if (dt != null && dt.Rows.Count > 0)//判断有无页面 { tstatus = "ENABLE"; } if (tmbll.EnableTemplateInfo(TemplateID, tstatus)) { //刷新模板缓存 BusinessSearchComponent bsbll = new BusinessSearchComponent(); bsbll.RefreshTemplateByGuid(TemplateID); hidtemplateid.Value = ""; ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "suseenable", "layer.alert('模板启用成功!',9);", true); BindTemplateList(); } else { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "suseenable", "layer.alert('模板启用失败!',8);", true); } } else { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "suseenablerror", "layer.alert('模板未配置完成,无法启用!',8);", true); } } } catch (Exception ee) { BaseComponent.Error(ee.Message); ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "suseenablcatch", "layer.alert('模板启用出错!',8);", true); } }
protected void BindTemplateList() { ViewState["id"] = null; int i, j; string TemplateName = txtTemplateName.Text.Trim(); ViewState["txtTemplateName"] = TemplateName; string StartDate = txtStartDate.Text.Trim(); string EndDate = txtEndDate.Text.Trim(); string Author = txtAuthor.Text.Trim(); ViewState["txtAuthor"] = Author; string TemplateStatus = ""; if (!string.IsNullOrWhiteSpace(hidisdefault.Value)) { TemplateStatus = (ddlStatus.SelectedValue == "all" ? "" : ddlStatus.SelectedValue); } ViewState["ddlStatus"] = TemplateStatus; int startIndex = (AspNetPager1.CurrentPageIndex - 1) * AspNetPager1.PageSize + 1; int PageSize = AspNetPager1.PageSize; string bigcate = (ddlCATEGORY.SelectedValue == "all" ? "" : ddlCATEGORY.SelectedValue); ViewState["ddlCATEGORY"] = bigcate; string smallcate = (ddlsmallcategory.SelectedValue == "all" ? "" : ddlsmallcategory.SelectedValue); ViewState["ddlsmallcategory"] = smallcate; DataTable dt = tmbll.GetTemplateList(TemplateName, bigcate, smallcate, Author, TemplateStatus, "", AspNetPager1.CurrentPageIndex, PageSize, out i, out j); if (dt != null && dt.Rows.Count > 0) { dt.Columns.Add("bs_row_num", Type.GetType("System.String")); dt.Columns.Add("bigcate", Type.GetType("System.String")); dt.Columns.Add("smallcate", Type.GetType("System.String")); dt.Columns.Add("statusname", Type.GetType("System.String")); dt.Columns.Add("pagelist", Type.GetType("System.String")); int pindex = (AspNetPager1.CurrentPageIndex - 1) * PageSize; DataTable bigdata = null; DataTable statusdata = null; DataTable pagelist = null; DataTable smalldata = null; if (ViewState["bigcate"] != null) { bigdata = ViewState["bigcate"] as DataTable; smalldata = ViewState["smalldata"] as DataTable; statusdata = ViewState["statusdata"] as DataTable; pagelist = ViewState["pagelist"] as DataTable; } else { bigdata = BaseComponent.GetBigCateData("/Lists/USER_LOOKUP_TYPES"); smalldata = BaseComponent.GetBigCateData("/Lists/USER_LOOKUP_VALUES"); statusdata = BaseComponent.GetBigCateData("/Lists/SYS_LOOKUP_VALUES"); TemplateManageComponent pbll = new TemplateManageComponent(); pagelist = pbll.GetPageList(); ViewState["bigcate"] = bigdata; ViewState["smalldata"] = smalldata; ViewState["statusdata"] = statusdata; ViewState["pagelist"] = pagelist; } foreach (DataRow dr in dt.Rows) { pindex++; dr["bs_row_num"] = pindex.ToString(); dr["bigcate"] = BaseComponent.GetBigCateName(bigdata, dr["BigCategory"].ToString()); dr["smallcate"] = BaseComponent.GetSmallCateName(smalldata, "模板-" + dr["BigCategory"].ToString(), dr["SmallCategory"].ToString()); dr["statusname"] = BaseComponent.GetStatusName(statusdata, "BS_TEMPLATE_STATUS", Convert.ToString(dr["TemplateStatus"])); DataRow[] drs = pagelist.Select("Templateid='" + dr["Templateid"].ToString() + "'"); string pinfo = string.Empty; if (drs != null) { foreach (DataRow dd in drs) { pinfo += "<a href='" + dd["Url"].ToString() + "' target='_blank' class='operateLink'>" + dd["PageName"].ToString() + "</a><br/>"; } } dr["pagelist"] = pinfo; } } AspNetPager1.RecordCount = i; TemplateList.DataSource = dt; TemplateList.DataBind(); if (dt == null || dt.Rows.Count == 0) { lblnodata.Visible = true; } else { lblnodata.Visible = false; } //ViewState["TemplateList"] = dt; ReCodePager(); }