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