Newer
Older
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
using System;
using System.Collections.Generic;
using System.Web;
using System.Web.UI.WebControls;
using System.Data;
using Hiquotion.DataStruct.Tree;
using Hiquotion.DataStruct.Node;
namespace Sqcy.Page
{
/// <summary>
///ObjGroup 的摘要说明
/// </summary>
public class ObjGroup
{
private ObjGroup()
{
}
public static DataTable GetAllSupplierGroups()
{
return DataService.Sdbo.ExecuteDataTableProc("msp_GetAllSupplierGroups");
}
public static DataTable GetUserSupplierGroups()
{
return DataService.Sdbo.ExecuteDataTableProc("SP_GetUserSupplierGroups", MySession.UserID, -1);
}
public static DataTable GetUserSupplierGroups(PermissionHelper.PermissionCode pc)
{
return DataService.Sdbo.ExecuteDataTableProc("SP_GetUserSupplierGroups", MySession.UserID, (int)pc);
}
public static DataTable GetUserSupplierGroups(Guid _userID)
{
return DataService.Sdbo.ExecuteDataTableProc("SP_GetUserSupplierGroups", _userID, -1);
}
public static DataTable GetUserSupplierGroups(Guid _userID, PermissionHelper.PermissionCode pc)
{
return DataService.Sdbo.ExecuteDataTableProc("SP_GetUserSupplierGroups", _userID, (int)pc);
}
public static DataTable GetAllDeliveryGroups()
{
return DataService.Sdbo.ExecuteDataTableProc("msp_AdminGetAllDeliveryGroups");
}
public static Tree<MyDelivery> GetAllDeliveryGroupTree()
{
Tree<MyDelivery> tree = new Tree<MyDelivery>();
TreeNode<MyDelivery> root = new TreeNode<MyDelivery>(new MyDelivery(GlobalDefine.DeliveryGroupID, Guid.Empty, "配送点", "", 0, 0, 0));
tree.TreeRoot = root;
DataTable dt = GetAllDeliveryGroups();
return tree;
}
public static DataTable GetUserDeliveryGroups()
{
return DataService.Sdbo.ExecuteDataTableProc("msp_AdminGetDeliveryGroups", MySession.UserGroupID);
}
public static DataTable GetUserDeliveryGroups(PermissionHelper.PermissionCode pc)
{
return DataService.Sdbo.ExecuteDataTableProc("dbo.SP_GetUserDeliveryGroups", MySession.UserID, (int)pc);
}
public static DataTable GetUserDeliveryGroups(Guid _userID)
{
return DataService.Sdbo.ExecuteDataTableProc("SP_GetUserDeliveryGroups", _userID, -1);
}
public static DataTable GetUserDeliveryGroups(Guid _userID, PermissionHelper.PermissionCode pc)
{
return DataService.Sdbo.ExecuteDataTableProc("SP_GetUserDeliveryGroups", _userID, (int)pc);
}
public static DataTable GetAdministratorList()
{
return DataService.Sdbo.ExecuteDataTable("SELECT A.[ID],A.[LoginName],A.NickName FROM [Permission].[User] A INNER JOIN [Permission].User_Group B ON A.[ID]=B.UserID WHERE A.IsDel=0 AND B.GroupID='{0}' ORDER BY A.NickName", GlobalDefine.AdministratorGroupID);
}
}
}