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