public String CompanyDetail(Guid oid) { CompanyDetailViewData view = new CompanyDetailViewData(); string mode = HttpContext.Current.Request["mode"]; if (oid == Guid.Empty) { view.Url = "/AjaxCompany/Insert.cspx"; view.Entity = new Company(); view.Entity.CreatedOn = DateTime.Now; } else { view.Url = "/AjaxCompany/Update.cspx"; view.Entity = bll.Retrieve(oid); view.FormType = FormType.Modify; if (!string.IsNullOrEmpty(mode) && mode != "2") { view.FormType = FormType.ReadOnly; } } view.PayTypeList = kpBll.RetrieveList("[KeyValuePair].[Group] = 'PayType' ORDER BY [KeyValuePair].[Code]"); view.CompanyCharacterList = kpBll.RetrieveList("[KeyValuePair].[Group] = 'CompanyCharacter' ORDER BY [KeyValuePair].[Code]"); return(PageViewHelper.LoadPage("/System/CompanyDetail.aspx", view)); }
public String BusinessTypeList() { BusinessTypeListViewData view = new BusinessTypeListViewData(); view.pageDataParents = new BaseFrameWork.Model.PaginationData(); view.pageDataParents.PageIndex = 1; view.pageDataParents.PageSize = 10; view.pageDataParents.PagintionJsFunction = "window.System.BusinessTypeList.firstSearch()"; view.pageDataParents.OrderBy = "Code"; string sql = "SELECT * FROM BusinessType WHERE ParentID IS NULL"; view.menuListParents = new Pagintion(sql, null, view.pageDataParents).ToList <BusinessType>(); view.pageDataChildren = new BaseFrameWork.Model.PaginationData(); view.pageDataChildren.PageIndex = 1; view.pageDataChildren.PageSize = 10; view.pageDataChildren.PagintionJsFunction = "window.System.BusinessTypeList.secondSearch()"; view.pageDataChildren.OrderBy = "Code"; Guid ParentGuid = view.menuListParents.Count > 0 ? view.menuListParents[0].TypeID : Guid.Empty; sql = "SELECT A.*, B.[Name] AS ParentName FROM BusinessType AS A INNER JOIN BusinessType AS B ON A.ParentID = B.TypeID WHERE B.TypeID = @TypeID"; view.menuListChildren = new Pagintion(sql, new { TypeID = ParentGuid }, view.pageDataChildren).ToList <BusinessType>(); return(PageViewHelper.LoadPage("/System/BusinessTypeList.aspx", view)); }
public String OrganizationDetail(Guid oid, Guid parentGuid) { OrganizationDetailViewData view = new OrganizationDetailViewData(); view.Entity = new Organization(); if (oid == Guid.Empty) { view.Url = "/AjaxOrganization/Insert.cspx"; if (parentGuid != Guid.Empty) { Organization org = new Organization(); org.UnitGuid = parentGuid; org = (Organization)org.Retrieve(); view.Entity.ParentGuid = org.UnitGuid; view.Entity.ParentCode = org.ParentCode; view.Entity.ParentName = org.Name; } } else { view.Url = "/AjaxOrganization/Update.cspx"; view.Entity.UnitGuid = oid; view.Entity = (Organization)view.Entity.Retrieve(); view.FormType = FormType.Modify; } return(PageViewHelper.LoadPage("/System/OrganizationDetail.aspx", view)); }
public static String LoginBootStrap() { LoginViewData view = new LoginViewData(); view.RedirectUrl = FormsAuthentication.GetRedirectUrl(String.Empty, true); return(PageViewHelper.LoadPage("/LoginBootStrap.aspx", view)); }
public String CustomerMonthList() { BusinessTypeListViewData view = new BusinessTypeListViewData(); view.pageDataParents = new BaseFrameWork.Model.PaginationData(); view.pageDataParents.PageIndex = 1; view.pageDataParents.PageSize = 10; view.pageDataParents.PagintionJsFunction = "window.System.CustomerMonthList.search()"; view.pageDataParents.OrderBy = "Code"; string sql = @"SELECT DISTINCT C.Code, C.Name, SUM(BidCost) OVER(PARTITION BY A.BusinessType, C.Code, C.NAME) AS BidCost, SUM(SaleAmount) OVER(PARTITION BY A.BusinessType, C.Code, C.NAME) AS SaleAmount, SUM(FactCost) OVER(PARTITION BY A.BusinessType, C.Code, C.NAME) AS FactCost, SUM(Profit) OVER(PARTITION BY A.BusinessType, C.Code, C.NAME) AS Profit, SUM(BidCost) OVER() AS TotalBidCost, SUM(SaleAmount) OVER() AS TotalSaleAmount, SUM(FactCost) OVER() AS TotalFactCost, SUM(Profit) OVER() AS TotalProfit FROM dbo.Customer AS A LEFT JOIN dbo.Company AS B ON A.CompanyID = B.CompanyID LEFT JOIN dbo.BusinessType AS C ON A.BusinessType = C.TypeID WHERE A.CreatedOn >= CAST(DATENAME(YEAR, GETDATE()) + '-' + DATENAME(MONTH, GETDATE()) + '-01' AS DATETIME) AND A.CreatedOn < GETDATE()"; view.menuListParents = new Pagintion(sql, null, view.pageDataParents).ToList <BusinessType>(); return(PageViewHelper.LoadPage("/System/CustomerMonthList.aspx", view)); }
public String RoleToBusinessList(Guid oid) { RoleToBusinessListViewData view = new RoleToBusinessListViewData(); view.RoleGuid = oid; view.listOrganization.PageData.PagintionJsFunction = "window.System.RoleList.searchOrganization()"; view.listOrganization.PageData.OrderBy = "Code"; string sql = @"SELECT A.*, B.Name AS ParentName, C.RoleToBusinessGuid AS PermissionGuid FROM dbo.Organization AS A LEFT JOIN dbo.Organization AS B ON A.ParentGuid = B.UnitGuid LEFT JOIN dbo.RoleToBusiness AS C ON A.UnitGuid = C.BusinessGuid AND C.RoleGuid = @RoleGuid "; view.listOrganization.List = new Pagintion(sql, new { RoleGuid = oid }, view.listOrganization.PageData).ToList <Organization>(); view.listUserInfo.PageData.PagintionJsFunction = "window.System.RoleList.searchUser()"; view.listUserInfo.PageData.OrderBy = "UserCode"; sql = @"SELECT A.*, B.Name AS DepartmentName, C.Name AS CompanyName, D.RoleToBusinessGuid AS PermissionGuid FROM dbo.UserInfo AS A LEFT JOIN dbo.Organization AS B ON A.DepartmentGuid = B.UnitGuid LEFT JOIN dbo.Organization AS C ON A.CompanyGuid = C.UnitGuid LEFT JOIN dbo.RoleToBusiness AS D ON A.UserGuid = D.BusinessGuid AND D.RoleGuid = @RoleGuid "; view.listUserInfo.List = new Pagintion(sql, new { RoleGuid = oid }, view.listUserInfo.PageData).ToList <UserInfo>(); return(PageViewHelper.LoadPage("/System/RoleToBusinessList.aspx", view)); }
public String CustomerAlertList() { CustomerListViewData view = new CustomerListViewData(); view.PageData = new BaseFrameWork.Model.PaginationData(); view.PageData.PageIndex = 1; view.PageData.PageSize = 10; view.PageData.PagintionJsFunction = "window.System.CustomerAlertList.search()"; view.PageData.OrderBy = "CreatedOn DESC, Name"; string sql = @"SELECT A.*, B.Name AS CompanyName, C.Name AS BusinessTypeName, SUM(BidCost) OVER() AS TotalBidCost, SUM(SaleAmount) OVER() AS TotalSaleAmount, SUM(FactCost) OVER() AS TotalFactCost, SUM(Profit) OVER() AS TotalProfit, D.StepName, D.EstimateDate FROM dbo.Customer AS A LEFT JOIN dbo.Company AS B ON A.CompanyID = B.CompanyID LEFT JOIN dbo.BusinessType AS C ON A.BusinessType = C.TypeID OUTER APPLY (SELECT TOP 1 IA.ID AS StepID, IA.StepName, IA.EstimateDate FROM dbo.ProcessStep AS IA WHERE A.CustomerID = IA.CustomerID AND IA.EstimateDate > GETDATE() AND IA.EstimateDate < GETDATE() + @AlertDays AND FinishDate IS NULL ORDER BY IA.EstimateDate, IA.CreatedOn) AS D WHERE D.StepID IS NOT NULL"; view.List = new Pagintion(sql, new { AlertDays = Convert.ToInt32(ConfigurationManager.AppSettings["AlertDays"]) }, view.PageData).ToList <Customer>(); return(PageViewHelper.LoadPage("/System/CustomerAlertList.aspx", view)); }
public String RoleList() { RoleListViewData view = new RoleListViewData(); view.PageData.PagintionJsFunction = "window.System.RoleTab.searchRole()"; view.PageData.OrderBy = "Code"; string sql = @"SELECT A.*, CASE WHEN B.OrganizationName IS NOT NULL THEN STUFF(B.OrganizationName, 1, 1, '') ELSE '' END AS OrganizationName, CASE WHEN C.UserName IS NOT NULL THEN STUFF(C.UserName, 1, 1, '') ELSE '' END AS UserName FROM dbo.RoleInfo AS A OUTER APPLY (SELECT ';' + IB.Name FROM dbo.RoleToBusiness AS IA INNER JOIN dbo.Organization AS IB ON IA.BusinessGuid = IB.UnitGuid WHERE IA.RoleGuid = A.RoleGuid AND IB.Name > '' ORDER BY IB.Code FOR XML PATH('')) AS B(OrganizationName) OUTER APPLY (SELECT ';' + IB.UserName FROM dbo.RoleToBusiness AS IA INNER JOIN dbo.UserInfo AS IB ON IA.BusinessGuid = IB.UserGuid WHERE IA.RoleGuid = A.RoleGuid AND IB.UserName > '' ORDER BY IB.UserCode FOR XML PATH('')) AS C(UserName)"; using (DbConnectionScope dcs = new DbConnectionScope()) { view.List = new Pagintion(sql, null, view.PageData).ToList <RoleInfo>(); } return(PageViewHelper.LoadPage("/System/RoleList.aspx", view)); }
public String NavigationList() { NavigationListViewData view = new NavigationListViewData(); view.pageDataParents = new BaseFrameWork.Model.PaginationData(); view.pageDataParents.PageIndex = 1; view.pageDataParents.PageSize = 10; view.pageDataParents.PagintionJsFunction = "window.System.NavigationList.firstSearch()"; view.pageDataParents.OrderBy = "OrderCode"; string sql = "select * from dbo.Menu where ParentGuid IS NULL"; view.menuListParents = new Pagintion(sql, null, view.pageDataParents).ToList <Menu>(); view.pageDataChildren = new BaseFrameWork.Model.PaginationData(); view.pageDataChildren.PageIndex = 1; view.pageDataChildren.PageSize = 10; view.pageDataChildren.PagintionJsFunction = "window.System.NavigationList.secondSearch()"; view.pageDataChildren.OrderBy = "OrderCode"; Guid ParentGuid = view.menuListParents.Count > 0 ? view.menuListParents[0].MenuGuid : Guid.Empty; sql = "select A.*, B.Name AS ParentName from dbo.Menu AS A INNER JOIN dbo.Menu AS B ON A.ParentGuid = B.MenuGuid where A.ParentGuid = @ParentGuid"; view.menuListChildren = new Pagintion(sql, new { ParentGuid = ParentGuid }, view.pageDataChildren).ToList <Menu>(); return(PageViewHelper.LoadPage("/System/NavigationList.aspx", view)); }
public String SelectCompany() { CompanyListViewData view = new CompanyListViewData(); view.PageData = new BaseFrameWork.Model.PaginationData(); view.PageData.PageIndex = 1; view.PageData.PageSize = 10; view.PageData.PagintionJsFunction = "window.System.SelectCompany.search()"; view.PageData.OrderBy = "Name, CreatedOn"; string sql = @"SELECT A.*, B.Name AS CompanyCharacterName, C.Name AS PayTypeName, D.Processing, E.AllCustomer - D.Processing AS Finished FROM dbo.Company AS A LEFT JOIN dbo.KeyValuePair AS B ON A.[Character] = B.Code AND B.[Group] = 'CompanyCharacter' LEFT JOIN dbo.KeyValuePair AS C ON A.PayType = C.Code AND C.[Group] = 'PayType' OUTER APPLY (SELECT COUNT(DISTINCT IA.CustomerID) AS Processing FROM dbo.Customer AS IA INNER JOIN dbo.ProcessStep AS IB ON IA.CustomerID = IB.CustomerID WHERE IB.FinishDate IS NULL AND IA.CompanyID = A.CompanyID) AS D OUTER APPLY(SELECT COUNT(*) AS AllCustomer FROM dbo.Customer AS IA WHERE IA.CompanyID = A.CompanyID) AS E"; view.List = new Pagintion(sql, null, view.PageData).ToList <Company>(); return(PageViewHelper.LoadPage("/System/SelectCompany.aspx", view)); }
public static String OrganizationList() { OrganizationListViewData view = new OrganizationListViewData(); view.List = new List <Organization>(); List <TreeNode> list; view.PageData = new PaginationData(); view.PageData.PageIndex = 1; view.PageData.PageSize = 10; view.PageData.PagintionJsFunction = "window.System.OrganizationList.search()"; view.PageData.OrderBy = "Code"; string sql = @"SELECT Name AS Text, CAST(UnitGuid AS NVARCHAR(36)) AS ID, CAST(ParentGuid AS NVARCHAR(36)) AS ParentID, '<i class=''ace-icon ' + Icon + '''></i>' AS Icon FROM dbo.Organization ORDER BY Code"; using (DbConnectionScope dcs = new DbConnectionScope()) { list = DbHelper.Db(sql).ToList <TreeNode>(); view.treeList = TreeNodeList.ToTreeNodeJson(list); } view.treeTitle = "组织架构"; TreeNode tr = list.FirstOrDefault(); if (tr == null) { tr = new TreeNode(); } sql = @"SELECT A.*, B.Name AS ParentName FROM dbo.Organization AS A LEFT JOIN dbo.Organization AS B ON A.ParentGuid = B.UnitGuid WHERE A.ParentGuid = @ParentGuid"; view.List = new Pagintion(sql, new { ParentGuid = tr.ID }, view.PageData).ToList <Organization>(); return(PageViewHelper.LoadPage("/System/OrganizationList.aspx", view)); }
public String PriceList() { PriceListViewData view = new PriceListViewData(); view.PageData = new BaseFrameWork.Model.PaginationData(); view.PageData.PageIndex = 1; view.PageData.PageSize = 10; view.PageData.PagintionJsFunction = "window.System.PriceList.search()"; view.PageData.OrderBy = "StartPlace, DestinationPlace, InterimPlace, Type, LuggageAmount"; string sql = @"SELECT * FROM dbo.PriceList"; view.List = new Pagintion(sql, null, view.PageData).ToList <PriceList>(); return(PageViewHelper.LoadPage("/System/PriceList.aspx", view)); }
public String SelectBusinessType() { BusinessTypeListViewData view = new BusinessTypeListViewData(); view.pageDataParents = new BaseFrameWork.Model.PaginationData(); view.pageDataParents.PageIndex = 1; view.pageDataParents.PageSize = 10; view.pageDataParents.PagintionJsFunction = "window.System.SelectBusinessType.search()"; view.pageDataParents.OrderBy = "Code"; string sql = "SELECT * FROM BusinessType WHERE ParentID IS NULL"; view.menuListParents = new Pagintion(sql, null, view.pageDataParents).ToList <BusinessType>(); return(PageViewHelper.LoadPage("/System/SelectBusinessType.aspx", view)); }
public String UserDetail(Guid oid) { SystemDetailViewData view = new SystemDetailViewData(); if (oid == Guid.Empty) { view.Url = "/AjaxSystem/Insert.cspx"; view.Entity = new SystemInfo(); } else { view.Url = "/AjaxSystem/Update.cspx"; view.Entity = bll.Retrieve(oid); view.FormType = FormType.Modify; } return(PageViewHelper.LoadPage("/System/SystemDetail.aspx", view)); }
public String PermissionToRoleList(Guid oid) { PermissionRoleListViewData view = new PermissionRoleListViewData(); view.ActionGuid = oid; view.PageData.PagintionJsFunction = "window.System.PermissionToRoleList.search()"; view.PageData.OrderBy = "Code"; string sql = @"SELECT A.*, B.RoleToPermissionGuid AS PermissionGuid FROM dbo.RoleInfo AS A LEFT JOIN dbo.RoleToPermission AS B ON A.RoleGuid = B.RoleGuid AND B.ActionGuid = @ActionGuid "; view.List = new Pagintion(sql, new { ActionGuid = oid }, view.PageData).ToList <RoleInfo>(); return(PageViewHelper.LoadPage("/System/PermissionToRoleList.aspx", view)); }
public string OrganizationToRole(Guid oid) { BusinessToRoleViewData view = new BusinessToRoleViewData(); view.BusinessGuid = oid; view.PageData.PagintionJsFunction = "window.System.OrganizationToRole.search()"; view.PageData.OrderBy = "Code"; string sql = @"SELECT A.*, B.RoleToBusinessGuid AS PermissionGuid FROM dbo.RoleInfo AS A LEFT JOIN dbo.RoleToBusiness AS B ON A.RoleGuid = B.RoleGuid AND B.BusinessGuid = @BusinessGuid "; view.List = new Pagintion(sql, new { BusinessGuid = oid }, view.PageData).ToList <RoleInfo>(); return(PageViewHelper.LoadPage("/System/OrganizationToRole.aspx", view)); }
public String SystemTree() { TreeViewData view = new TreeViewData(); view.Title = "系统"; string sql = @"SELECT Name AS Text, CAST(SystemGuid AS NVARCHAR(36)) AS ID, CAST(NULL AS NVARCHAR(36)) AS ParentID, '<i class=''ace-icon ''></i>' AS Icon FROM dbo.SystemInfo ORDER BY Code"; view.List = "[]"; using (DbConnectionScope dcs = new DbConnectionScope()) { view.List = TreeNodeList.ToTreeNodeJson(DbHelper.Db(sql).ToList <TreeNode>()); } return(PageViewHelper.LoadPage("/System/CommonPage/SingleSelectedTree.aspx", view)); }
public String KeyValuePDetail(Guid oid, String code) { KeyValuePDetailViewData view = new KeyValuePDetailViewData(); if (oid == Guid.Empty) { view.Url = "/AjaxKeyValueP/Insert.cspx"; view.Entity = new KeyValueP(); view.Entity.Group = code; } else { view.Url = "/AjaxKeyValueP/Update.cspx"; view.Entity = bll.Retrieve(oid); view.FormType = FormType.Modify; } return(PageViewHelper.LoadPage("/System/KeyValuePDetail.aspx", view)); }
public String SelectAgentCompany() { AgentCompanyListViewData view = new AgentCompanyListViewData(); view.PageData = new BaseFrameWork.Model.PaginationData(); view.PageData.PageIndex = 1; view.PageData.PageSize = 10; view.PageData.PagintionJsFunction = "window.System.SelectAgentCompany.search()"; view.PageData.OrderBy = "Name, CreatedOn"; string sql = @"SELECT A.*, B.Name AS AgentCompanyCharacterName FROM dbo.AgentCompany AS A LEFT JOIN dbo.KeyValuePair AS B ON A.[Character] = B.Code AND B.[Group] = 'CompanyCharacter'"; view.List = new Pagintion(sql, null, view.PageData).ToList <AgentCompany>(); return(PageViewHelper.LoadPage("/System/SelectAgentCompany.aspx", view)); }
public String PriceDetail(Guid oid) { PriceDetailViewData view = new PriceDetailViewData(); if (oid == Guid.Empty) { view.Url = "/AjaxPrice/Insert.cspx"; view.Entity = new PriceList(); } else { view.Url = "/AjaxPrice/Update.cspx"; view.Entity = bll.Retrieve(oid); view.FormType = FormType.Modify; } view.TypeList = new KeyValueP().RetrieveList("[KeyValuePair].[Group] = 'UnitType'") as List <KeyValueP>; return(PageViewHelper.LoadPage("/System/PriceDetail.aspx", view)); }
public String SelectPrice(double amount, string type) { PriceListViewData view = new PriceListViewData(); view.PageData = new BaseFrameWork.Model.PaginationData(); view.PageData.PageIndex = 1; view.PageData.PageSize = 10; view.PageData.PagintionJsFunction = "window.System.SelectPrice.search()"; view.PageData.OrderBy = "StartPlace, DestinationPlace, InterimPlace, Type, LuggageAmount"; view.Amount = amount; view.Type = type; string sql = @"SELECT * FROM dbo.PriceList WHERE LuggageAmount= @Amount AND [Type] = @Type"; view.List = new Pagintion(sql, new { Amount = amount, Type = type }, view.PageData).ToList <PriceList>(); return(PageViewHelper.LoadPage("/System/SelectPrice.aspx", view)); }
public String DepartmentTree() { TreeViewData view = new TreeViewData(); view.Title = "部门"; string sql = @"SELECT Name AS Text, CAST(UnitGuid AS NVARCHAR(36)) AS ID, CAST(ParentGuid AS NVARCHAR(36)) AS ParentID, '<i class=''ace-icon ' + Icon + '''></i>' AS Icon FROM dbo.Organization --WHERE ParentGuid IS NOT NULL ORDER BY Code"; view.List = "[]"; using (DbConnectionScope dcs = new DbConnectionScope()) { view.List = TreeNodeList.ToTreeNodeJson(DbHelper.Db(sql).ToList <TreeNode>()); } return(PageViewHelper.LoadPage("/System/CommonPage/SingleSelectedTree.aspx", view)); }
public String AgentCompanyDetail(Guid oid) { AgentCompanyDetailViewData view = new AgentCompanyDetailViewData(); if (oid == Guid.Empty) { view.Url = "/AjaxAgentCompany/Insert.cspx"; view.Entity = new AgentCompany(); view.Entity.CreatedOn = DateTime.Now; } else { view.Url = "/AjaxAgentCompany/Update.cspx"; view.Entity = bll.Retrieve(oid); view.FormType = FormType.Modify; } view.CompanyCharacterList = kpBll.RetrieveList("[KeyValuePair].[Group] = 'CompanyCharacter' ORDER BY [KeyValuePair].[Code]");; return(PageViewHelper.LoadPage("/System/AgentCompanyDetail.aspx", view)); }
public String UserList() { UserListViewData view = new UserListViewData(); view.PageData = new BaseFrameWork.Model.PaginationData(); view.PageData.PageIndex = 1; view.PageData.PageSize = 10; view.PageData.PagintionJsFunction = "window.System.UserList.search()"; view.PageData.OrderBy = "UserCode"; string sql = @"SELECT A.*, B.Name AS CompanyName, C.Name AS DepartmentName FROM dbo.UserInfo AS A LEFT JOIN dbo.Organization AS B ON A.CompanyGuid = B.UnitGuid LEFT JOIN dbo.Organization AS C ON A.DepartmentGuid = C.UnitGuid"; view.List = new Pagintion(sql, null, view.PageData).ToList <UserInfo>(); return(PageViewHelper.LoadPage("/System/UserList.aspx", view)); }
public String UserDetail(Guid oid) { UserDetailViewData udvd = new UserDetailViewData(); if (oid == Guid.Empty) { udvd.Url = "/AjaxUser/Insert.cspx"; udvd.user = new UserInfo(); udvd.user.Sex = true; udvd.FormType = FormType.Add; } else { udvd.Url = "/AjaxUser/Update.cspx"; udvd.user = bll.Retrieve(oid); udvd.FormType = FormType.Modify; } return(PageViewHelper.LoadPage("/System/UserDetail.aspx", udvd)); }
public String SystemList() { SystemListViewData view = new SystemListViewData(); view.List = new List <SystemInfo>(); view.PageData = new PaginationData(); view.PageData.PageIndex = 1; view.PageData.PageSize = 10; view.PageData.PagintionJsFunction = "window.System.SystemList.search()"; view.PageData.OrderBy = "Code"; string sql = @"SELECT CreatedBy, CreatedOn, ModifiedBy, ModifiedOn, SystemGuid, Code, Name, Remark FROM dbo.SystemInfo "; view.List = new Pagintion(sql, null, view.PageData).ToList <SystemInfo>(); return(PageViewHelper.LoadPage("/System/SystemList.aspx", view)); }
public String CustomerList() { CustomerListViewData view = new CustomerListViewData(); view.PageData = new BaseFrameWork.Model.PaginationData(); view.PageData.PageIndex = 1; view.PageData.PageSize = 10; view.PageData.PagintionJsFunction = "window.System.CustomerList.search()"; view.PageData.OrderBy = "CreatedOn DESC, Name"; string sql = @"SELECT A.*, B.Name AS CompanyName, C.Name AS BusinessTypeName, SUM(BidCost) OVER() AS TotalBidCost, SUM(SaleAmount) OVER() AS TotalSaleAmount, SUM(FactCost) OVER() AS TotalFactCost, SUM(Profit) OVER() AS TotalProfit FROM dbo.Customer AS A LEFT JOIN dbo.Company AS B ON A.CompanyID = B.CompanyID LEFT JOIN dbo.BusinessType AS C ON A.BusinessType = C.TypeID"; view.List = new Pagintion(sql, null, view.PageData).ToList <Customer>(); return(PageViewHelper.LoadPage("/System/CustomerList.aspx", view)); }
public String FunctionList() { FunctionListViewData view = new FunctionListViewData(); view.List = new List <FunctionInfo>(); view.PageData = new PaginationData(); view.PageData.PageIndex = 1; view.PageData.PageSize = 10; view.PageData.PagintionJsFunction = "window.System.FunctionList.search()"; view.PageData.OrderBy = "Code"; string sql = @"SELECT A.CreatedBy, A.CreatedOn, A.ModifiedBy, A.ModifiedOn, A.FunctionGuid, A.Code, A.Name, A.Remark, B.Name AS SystemName FROM dbo.FunctionInfo AS A LEFT JOIN dbo.SystemInfo AS B ON A.SystemGuid = B.SystemGuid "; view.List = new Pagintion(sql, null, view.PageData).ToList <FunctionInfo>(); return(PageViewHelper.LoadPage("/System/FunctionList.aspx", view)); }
public String ActionDetail(Guid oid) { ActionDetailViewData view = new ActionDetailViewData(); if (oid == Guid.Empty) { view.Url = "/AjaxAction/Insert.cspx"; view.Entity = new ActionInfo(); } else { FunctionInfo fi = new FunctionInfo(); view.Url = "/AjaxAction/Update.cspx"; view.Entity = bll.Retrieve(oid); fi = fBll.Retrieve(view.Entity.FunctionGuid.Value); view.Entity.SystemGuid = fi.SystemGuid; view.Entity.SystemName = fi.SystemName; view.FormType = FormType.Modify; } return(PageViewHelper.LoadPage("/System/ActionDetail.aspx", view)); }
public String RoleToPermissionList(Guid oid) { RolePermissionListViewData view = new RolePermissionListViewData(); view.RoleGuid = oid; view.systemList = bllS.GetList(); view.functionList = bllF.GetList(); view.PageData.PagintionJsFunction = "window.System.RoleToPermissionList.search()"; view.PageData.OrderBy = "Code"; string sql = @"SELECT A.*, B.Name AS FunctionName, C.Name AS SystemName, D.RoleToPermissionGuid AS PermissionGuid FROM dbo.ActionInfo AS A LEFT JOIN dbo.FunctionInfo AS B ON A.FunctionGuid = B.FunctionGuid LEFT JOIN dbo.SystemInfo AS C ON B.SystemGuid = C.SystemGuid LEFT JOIN dbo.RoleToPermission AS D ON A.ActionGuid = D.ActionGuid AND D.RoleGuid = @RoleGuid "; view.List = new Pagintion(sql, new { RoleGuid = oid }, view.PageData).ToList <ActionInfo>(); return(PageViewHelper.LoadPage("/System/RoleToPermissionList.aspx", view)); }