private void FillTemplateList(string entityID)
{
#if alexj
var query = string.Format(@"SELECT p.[objID], p.[name] FROM [Permission].[IUTemplatePermission]({0}) p, model.BTables t
where t.[name] = p.[baseTable] and t.[object_ID] = {1} and p.[typeCode] like 'crossReport' and p.[read] = 'True'
order by p.[name]", Session["SystemUser.objID"].ToString(), entityID);
#else
var query = string.Format(@"SELECT [RT].[objID], [RT].[name] FROM [model].[R$Template] [RT]
right JOIN [model].[R$TemplateType] [RTT] ON [RTT].[objID] = [RT].[typeID]
WHERE [RTT].[code] like 'crossReport' AND [RT].[entityID] = '{0}'", entityID);
#endif
var dt = Storage.GetDataTable(query);
TemplateList.Items.Clear();
TemplateList.Items.Add(new ListItem {
Text = "Создать новый", Value = "-1"
});
foreach (DataRow item in dt.Rows)
{
TemplateList.Items.Add(new ListItem {
Value = item[0].ToString(), Text = item[1].ToString()
});
}
TemplateList.DataBind();
}
protected override void OnPreRender(EventArgs e)
{
var userID = Convert.ToInt32(Session["SystemUser.objID"]);
#region заполнение templatelist dropdownlist'а разрешенными на просмотр template'ами
// var TemplateListDataQuery = string.Format(@"SELECT p.[objID], p.[name] FROM [Permission].[IUTemplatePermission]({0}) p, model.BTables t
// where t.[name] = p.[baseTable] and t.[object_ID] = {1} and p.[typeCode] like 'TableBased' and p.[read] = 'True'
// order by p.[name]", userID, (long)EventListGridView.SelectedDataKey["tableID"]);
var TemplateListDataQuery = string.Format(@"SELECT p.[objID], p.[name] FROM [Permission].[IUTemplatePermission]({0}) p, model.BTables t
where t.[name] = p.[baseTable] and t.[object_ID] = {1} and p.[typeCode] like 'TableBased' and p.[read] = 'True'
order by p.[name]", userID, SelectedEntity);
TemplateList.DataSource = Storage.GetDataTable(TemplateListDataQuery);
TemplateList.DataBind();
if (!string.IsNullOrEmpty(selectedTemplateID) && TemplateList.Items.FindByValue(selectedTemplateID) != null)
{
TemplateList.SelectedValue = selectedTemplateID;
}
#endregion
base.OnPreRender(e);
}
//排序获取datatable
protected void GetTemplateListByOrderBy(string orderby)
{
int i, j;
string TemplateName = (ViewState["txtTemplateName"] == null ? txtTemplateName.Text.Trim() : ViewState["txtTemplateName"].ToString());
//string StartDate = (ViewState["TemplateName"] == null ? txtTemplateName.Text.Trim() : ViewState["TemplateName"].ToString()); txtStartDate.Text.Trim();
//string EndDate = (ViewState["TemplateName"] == null ? txtTemplateName.Text.Trim() : ViewState["TemplateName"].ToString()); txtEndDate.Text.Trim();
string Author = (ViewState["txtAuthor"] == null ? txtAuthor.Text.Trim() : ViewState["txtAuthor"].ToString());
string TemplateStatus = (ViewState["ddlStatus"] == null ? ddlStatus.SelectedValue : ViewState["ddlStatus"].ToString());
int startIndex = (AspNetPager1.CurrentPageIndex - 1) * AspNetPager1.PageSize + 1;
int PageSize = AspNetPager1.PageSize;
string bigcate = (ViewState["ddlCATEGORY"] == null ? ddlCATEGORY.SelectedValue : ViewState["ddlCATEGORY"].ToString());
string smallcate = (ViewState["ddlsmallcategory"] == null ? ddlsmallcategory.SelectedValue : ViewState["ddlsmallcategory"].ToString());
DataTable dt = tmbll.GetTemplateList(TemplateName, bigcate, smallcate, Author, TemplateStatus, orderby, AspNetPager1.CurrentPageIndex, PageSize, out i, out j);
if (dt != null && dt.Rows.Count > 0)
{
dt.Columns.Add("bs_row_num", Type.GetType("System.String"));
int pindex = (AspNetPager1.CurrentPageIndex - 1) * PageSize;
foreach (DataRow dr in dt.Rows)
{
pindex++;
dr["bs_row_num"] = pindex.ToString();
}
}
AspNetPager1.RecordCount = i;
TemplateList.DataSource = dt;
TemplateList.DataBind();
ReCodePager();
}
private void PopulateTemplates()
{
TemplateList.Items.Clear();
TemplateList.Items.Add(new ListItem("- Not Selected -", string.Empty));
TemplateList.AppendDataBoundItems = true;
TemplateList.DataSource = DnnPathHelper.GetViewNames("Category");
TemplateList.DataBind();
}
protected void EntityList_OnSelectedIndex(object sender, EventArgs e)
{
if (EntityList.SelectedIndex == 0)
{
TemplateList.Items.Add(new ListItem {
Text = "Не выбрано", Value = "-1"
});
TemplateList.DataBind();
}
else
{
FillTemplateList(EntityList.SelectedValue);
}
multiView.ActiveViewIndex = 0;
}
protected void EventListGridView_DataBound(object sender, EventArgs e)
{
if (!IsPostBack)
{
EventListGridView.SelectedIndex = 0;
if (EventListGridView.SelectedDataKey != null)
{
SelectedEntity = (long)EventListGridView.SelectedDataKey["tableID"];
}
TemplateList.DataBind();
}
selectedTemplateID = TemplateList.SelectedValue;
}
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();
}
private void FillDropDownList()
{
TemplateList.Items.Clear();
TemplateList.Items.Add(new ListItem("Титульный шаблон", string.Format("titleAttributesTemplate_{0}", CardListRelationEntityID)));
TemplateList.Items.Add(new ListItem("Создание и редактирование объектов", string.Format("requireAttributesTemplate_{0}", CardListRelationEntityID)));
TemplateList.DataBind();
var templateSessionKey = string.Format("TemplateList_{0}", CardListRelationEntityID);
var templateID = Session[templateSessionKey];
if (templateID != null)
{
TemplateList.SelectedValue = templateID.ToString();
}
else
{
TemplateList.SelectedValue = string.Format("requireAttributesTemplate_{0}", CardListRelationEntityID);
}
}
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();
}
