-
Notifications
You must be signed in to change notification settings - Fork 1
/
BusinessExpInfo.cs
116 lines (96 loc) · 3.52 KB
/
BusinessExpInfo.cs
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
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
using System;
using System.Collections.Generic;
using System.Text;
using CanYou.OA.DAL;
using System.Data;
using SubSonic;
namespace CanYou.OA.BLL
{
public partial class BusinessExpInfo
{
public static DataTable getRelateBExp(int businessid)
{
return SPs.BExpRelate_Sp(businessid).GetDataSet().Tables[0];
}
public static DataTable getEmployeeBExp(int businessid)
{
return SPs.BExpEmployee_Sp(businessid).GetDataSet().Tables[0];
}
public static void DelRBExp(int businessid)
{
Query q = RelateBExp.Query();
q.AddWhere(RelateBExp.Columns.BusinessExpId, businessid);
q.QueryType = QueryType.Delete;
q.Execute();
}
public static void DelBExp(int businessid)
{
BusinessExp.Delete(businessid);
}
public static void DelEBExp(int businessid)
{
Query q = EmployeeBExp.Query();
q.AddWhere(EmployeeBExp.Columns.BusinessExpId, businessid);
q.QueryType = QueryType.Delete;
q.Execute();
}
public static void DelRB(int RBid)
{
RelateBExp.Delete(RBid);
}
public static void DelEB(int EBid)
{
EmployeeBExp.Delete(EBid);
}
//市场部员工绑定 主gv
public static DataTable getBusinessExpListOfPreEmployee(int emid)
{
return SPs.BsListOfPreEmployee_Sp(emid).GetDataSet().Tables[0];
}
//市场部员工绑定 子GridView2
public static DataTable getBusinessExpListOfPreEmployee2(int emid, int MainBusinessExpId)
{
return SPs.BsListOfPreEmployee2_Sp(emid, MainBusinessExpId).GetDataSet().Tables[0];
}
//市场部经理绑定 主gv
public static DataTable getBusinessExpListOfEmployee(int emid)
{
return SPs.BsListOfEmployee_Sp(emid).GetDataSet().Tables[0];
}
//市场部经理绑定 子gv
public static DataTable getBusinessExpListOfEmployee2(int emid, int mainid)
{
return SPs.BsListOfEmployee2_Sp(emid, mainid).GetDataSet().Tables[0];
}
//审批 市场部经理绑定 主gv
public static DataTable getBusinessExpListOfApprove(int RecvEmployeeId)
{
return SPs.BsListOfApprove_Sp(RecvEmployeeId).GetDataSet().Tables[0];
}
//审批 市场部经理绑定 子gv
public static DataTable getBusinessExpListOfApproves(int RecvEmployeeId, int mainid)
{
return SPs.BsListOfApproves_Sp(RecvEmployeeId, mainid).GetDataSet().Tables[0];
}
//总经理绑定 主gv
public static DataTable getBusinessExpListOfApprove1(int Recv1EmployeeId)
{
return SPs.BsListOfApprove1_Sp(Recv1EmployeeId).GetDataSet().Tables[0];
}
//总经理绑定 子gv
public static DataTable getBusinessExpListOfApproves1(int Recv1EmployeeId, int mainid)
{
return SPs.BsListOfApproves1_Sp(Recv1EmployeeId, mainid).GetDataSet().Tables[0];
}
//财务部经理绑定 主gv
public static DataTable getBusinessExpListOfApprove2(int Recv2EmployeeId)
{
return SPs.BsListOfApprove2_Sp(Recv2EmployeeId).GetDataSet().Tables[0];
}
//财务部经理绑定 子gv
public static DataTable getBusinessExpListOfApproves2(int Recv2EmployeeId, int mainid)
{
return SPs.BsListOfApproves2_Sp(Recv2EmployeeId, mainid).GetDataSet().Tables[0];
}
}
}