public MenuDataItem(SecPageEntity page, MenuDataItem parentMenu) { ParentMenu = parentMenu; Page = page; SubMenu = new List<MenuDataItem>(); ValidControls = new List<SecPermissionEntity>(); }
public virtual SecPageDomain CreateSecPageDomain() { SecPageEntity entity = new SecPageEntity(); entity.PageId = Guid.NewGuid().ToString(); return new SecPageDomain(entity); }
/// <summary> /// 页面选择绑定 /// </summary> void DDLBind() { SecPageEntity rootPage = new SecPageEntity(); rootPage.PageId = VSASYSConst.C_Root_Parent_ID; PageDomain rootDomain = new PageDomain(rootPage); AddPageToDDL(rootDomain.ChildsDomain, 0); if (0 < ddlParanet.Items.Count) { if (!string.IsNullOrEmpty(ddlParanet.Items[0].Value)) { ddlParanet.Items.Insert(0, new ListItem(GetMessage("SYSTEM_ROLE_MESSAGE_ROLESELECT"), VSASYSConst.C_Root_Parent_ID)); } } }
/// <summary> /// 绑定页面选择 /// </summary> void DDLBind() { SecPageEntity rootPage = new SecPageEntity(); rootPage.PageId = VSASYSConst.C_Root_Parent_ID; PageDomain rootDomain = new PageDomain(rootPage); AddPageToDDL(rootDomain.ChildsDomain, 0); }
//保存报表 public virtual bool SaveReport(DataTable dtReport, string reportName, string remark, string user, string reportID) { //1. 生成菜单项 SecPageEntity objPage; if (reportID != "") { objPage = DataAccess.SelectSingle<SecPageEntity>(reportID); objPage.PageId = reportID; } else { objPage = new SecPageEntity(); objPage.PageId = Guid.NewGuid().ToString(); objPage.MenuOrder = GetLastReportOrder(); } objPage.PageName = reportName; objPage.ParentId = "11"; objPage.PageUrl = "~/Search/DynamicReportDisplay.aspx?ReportID=" + objPage.PageId; objPage.IsMenu = 1; objPage.MenuLevel = 1; objPage.Remark = remark; objPage.LastModifiedBy = user; objPage.LastModifiedTime = DateTime.Now; objPage.IcoCssclass = "Report"; using (DataAccessBroker broker = DataAccessFactory.Instance()) { broker.BeginTransaction(); try { if (reportID != "") { DataAccess.Update(objPage, broker); } else { DataAccess.Insert(objPage, broker); } if (dtReport != null && dtReport.Rows.Count > 0) { string strSql = @"delete " + ReportTable.C_TableName + " where " + ReportTable.C_Report_ID + "='" + objPage.PageId + "'"; broker.ExecuteNonQuery(strSql, null, CommandType.Text); ReportEntity objEntity; foreach (DataRow drReport in dtReport.Rows) { objEntity = new ReportEntity(); objEntity.Id = Guid.NewGuid().ToString(); objEntity.ReportId = objPage.PageId; objEntity.Type = drReport["Type"].ToString(); objEntity.ColumnName = drReport["Column_Name"].ToString(); objEntity.DisplayName = drReport["Display_Name"].ToString(); objEntity.DisplayOrder = drReport["Display_Order"].ToString(); objEntity.IsQuery = drReport["Is_Query"].ToString(); objEntity.IsDeleted = "0"; objEntity.ModifyDate = DateTime.Now; objEntity.ModifyUser = user; objEntity.Datatype = drReport["DataType"].ToString(); DataAccess.Insert(objEntity, broker); } } BPSC.Common.WebUtils.WebCaching.PageCaching = null; broker.Commit(); return true; } catch { broker.RollBack(); return false; } } }
public virtual bool DeleteReport(List<string> reportIDS) { using (DataAccessBroker objBroker = DataAccessFactory.Instance()) { try { objBroker.BeginTransaction(); foreach (string reportID in reportIDS) { string strSql = @"delete " + ReportTable.C_TableName + " where " + ReportTable.C_Report_ID + "='" + reportID + "'"; objBroker.ExecuteNonQuery(strSql, null, CommandType.Text); SecPageEntity report = new SecPageEntity(); report.PageId = reportID; DataAccess.Delete(report, objBroker); } objBroker.Commit(); return true; } catch (Exception e) { objBroker.RollBack(); return false; } } }
/// <summary> /// 构造函数 /// </summary> /// <param name="SecPageEntity"></param> public PageDomain(SecPageEntity SecPageEntity) : base(SecPageEntity) { }
private void LoadData(SecPageEntity entity) { //1. 获取报表基本信息 txtReportName.Text = entity.PageName; txtRemark.Text = entity.Remark; //2. 获取选中的table //dexTableList_RowDataBound //3. 获取选中的列 DataTable dtSelectedTable = SelectedTable; if (dtSelectedTable == null) { dtSelectedTable = new DataTable(); dtSelectedTable.Columns.Add("tableName"); dtSelectedTable.Columns.Add("ColumnName"); dtSelectedTable.Columns.Add("DisplayName"); dtSelectedTable.Columns.Add("Display_Order"); dtSelectedTable.Columns.Add("DataType"); dtSelectedTable.Columns.Add("Checked"); } DataTable dtTableNames; for (int i = 0; i < dexTableList.Rows.Count; i++) { if (((CheckBox)dexTableList.Rows[i].FindControl("cbxSelect")).Checked) { DataRow drColumn; DataTable dtSelectTable = MainService.ReportService.GetAllColumnsByTable(((Label)dexTableList.Rows[i].FindControl("lblTableName")).Text.Trim()); foreach (DataRow drSelect in dtSelectTable.Rows) { drColumn = dtSelectedTable.NewRow(); drColumn["tableName"] = drSelect["tableName"].ToString().Trim(); drColumn["ColumnName"] = drSelect["ColumnName"].ToString().Trim(); drColumn["DisplayName"] = ""; drColumn["Display_Order"] = ""; drColumn["DataType"] = drSelect["DataType"].ToString().Trim(); drColumn["Checked"] = ""; dtTableNames = MainService.ReportService.GetSelectColumns(ReportID); foreach (DataRow drColumnName in dtTableNames.Rows) { if ("[" + drSelect["tableName"].ToString().Trim() + "].[" + drSelect["ColumnName"].ToString().Trim() + "]" == drColumnName["Column_Name"].ToString().Trim()) { drColumn["DisplayName"] = drColumnName["Display_Name"].ToString().Trim(); drColumn["Display_Order"] = drColumnName["Display_Order"].ToString().Trim(); drColumn["Checked"] = "1"; } } dtSelectedTable.Rows.Add(drColumn); } } } SelectedTable = dtSelectedTable; dexSelectedTable.DataSource = dtSelectedTable; dexSelectedTable.DataBind(); //汇总统计列 txtSumColumn.Text = MainService.ReportService.GetSunColumn(ReportID); //多表关联 txtWhere.Text = MainService.ReportService.GetValueByType(ReportID, "where"); //分组查询 txtGroupBy.Text = MainService.ReportService.GetValueByType(ReportID, "Group By"); //排序 txtOrderBy.Text = MainService.ReportService.GetValueByType(ReportID, "Order By"); }
public virtual void UpdateSecPageEntity(SecPageEntity entity, DataAccessBroker broker) { DataAccess.Update(entity, broker); }
public virtual void InsertSecPageEntity(SecPageEntity entity, DataAccessBroker broker) { DataAccess.Insert(entity, broker); }
public virtual List<MenuDataItem> GetMenuDataItemByUserId(string userId) { List<MenuDataItem> menuDataItemList = new List<MenuDataItem>(); SecPageEntity SecPageEntity = new SecPageEntity(); SecPageEntity.PageId = BPSC.Common.Const.VSASYSConst.C_Root_Parent_ID; PageDomain baseDomain = new PageDomain(SecPageEntity); Dictionary<string, decimal> pageDataScopes = GetPageDataScope(userId);//页面数据权限 foreach (PageDomain pageDomain in baseDomain.ChildsDomain) { if (GetPageIds(userId).Contains(pageDomain.SecPageEntity.PageId)) { MenuDataItem rootMenuDataItem = pageDataScopes.ContainsKey(pageDomain.SecPageEntity.PageId) ? new MenuDataItem(pageDomain.SecPageEntity, null,(DataScope)Enum.Parse(typeof(DataScope),pageDataScopes[pageDomain.SecPageEntity.PageId].ToString())):new MenuDataItem(pageDomain.SecPageEntity, null) ; foreach (PermissionDomain permissionDomain in pageDomain.PermissionDomainList) { if (GetPermissionIds(userId).Contains(permissionDomain.SecPermissionEntity.PermissionId)) { rootMenuDataItem.ValidControls.Add(permissionDomain.SecPermissionEntity); } } Bind(rootMenuDataItem, pageDomain, userId); menuDataItemList.Add(rootMenuDataItem); } } return menuDataItemList; }
public SecPageDomain(SecPageEntity entity) : base(entity) { masterEntity = entity; }
/// <summary> /// 绑定页面选择 /// </summary> void DDLBind(string moduleID) { ddlPage.Items.Clear(); SecPageEntity rootPage = new SecPageEntity(); rootPage.PageId = VSASYSConst.C_Root_Parent_ID; PageDomain rootDomain = new PageDomain(rootPage); AddPageToDDL(SystemService.PageService.GetDomainChildsByParentId(VSASYSConst.C_Root_Parent_ID), 0); }