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