1
using System;
2using System.Data;
3using System.Configuration;
4using System.Web;
5using System.Web.Security;
6using System.Web.UI;
7using System.Web.UI.WebControls;
8using System.Web.UI.WebControls.WebParts;
9using System.Web.UI.HtmlControls;
10using System.Data.SqlClient;
11
12
/**//// <summary>
13
/// MangerClass 的摘要说明
14
/// </summary>
15public class MangerClass
16...{
17 DBClass dbObj = new DBClass();
18 public MangerClass()
19
...{
20 //
21 // TODO: 在此处添加构造函数逻辑
22 //
23
}
24 //*************************************************************************************************
25 /**//// <summary>
26 /// GridView控件的绑定
27 /// </summary>
28 /// <param name="gvName">控件名字</param>
29 /// <param name="P_Str_srcTable">绑定信息</param>
30 public void gvBind(GridView gvName, SqlCommand myCmd, string P_Str_srcTable)
31 ...{
32 SqlDataAdapter da = new SqlDataAdapter(myCmd);
33 DataSet ds = new DataSet();
34 da.Fill(ds, P_Str_srcTable);
35 gvName.DataSource = ds.Tables[P_Str_srcTable].DefaultView;
36 gvName.DataBind();
37 }
38 /**//// <summary>
39 /// 判断有没有最新的订单或新会员
40 /// </summary>
41 /// <param name="P_Str_ProcName">执行语句的存储过程名</param>
42 /// <returns></returns>
43 public int IsExistsNI(string P_Str_ProcName)
44 ...{
45 SqlConnection myConn = dbObj.GetConnection();
46 SqlCommand myCmd = new SqlCommand(P_Str_ProcName, myConn);
47 myCmd.CommandType = CommandType.StoredProcedure;
48 //添加参数
49 SqlParameter returnValue = myCmd.Parameters.Add("returnValue", SqlDbType.Int, 4);
50 returnValue.Direction = ParameterDirection.ReturnValue;
51 //执行过程
52 myConn.Open();
53 try
54 ...{
55 myCmd.ExecuteNonQuery();
56 }
57 catch (Exception ex)
58 ...{
59 throw (ex);
60 }
61 finally
62 ...{
63 myCmd.Dispose();
64 myConn.Close();
65
66 }
67 int P_Int_returnValue = Convert.ToInt32(returnValue.Value.ToString());
68 return P_Int_returnValue;
69 }
70 /**//// <summary>
71 /// 绑定最新信息(最新订单信息，最新用户信息量)
72 /// </summary>
73 /// <param name="P_Str_ProcName">执行语句的存储过程名</param>
74 /// <returns></returns>
75 public SqlCommand GetNewICmd(string P_Str_ProcName)
76 ...{
77 SqlConnection myConn = dbObj.GetConnection();
78 SqlCommand myCmd = new SqlCommand(P_Str_ProcName, myConn);
79 myCmd.CommandType = CommandType.StoredProcedure;
80 //添加参数
81 SqlParameter returnValue = myCmd.Parameters.Add("returnValue", SqlDbType.Int, 4);
82 returnValue.Direction = ParameterDirection.ReturnValue;
83 //执行过程
84 myConn.Open();
85 try
86 ...{
87 myCmd.ExecuteNonQuery();
88 }
89 catch (Exception ex)
90 ...{
91 throw (ex);
92 }
93 finally
94 ...{
95 myCmd.Dispose();
96 myConn.Close();
97
98 }
99
100 return myCmd ;
101 }
102 //*************************************************************************************************
103 /**//// <summary>
104 /// 获取订单信息
105 /// </summary>
106 /// <param name="P_Int_Flag">是否是功能菜单栏传来的值</param>
107 /// <param name="P_Int_IsMember">是否是以员工来查询</param>
108 /// <param name="P_Int_MemberID">员工编号</param>
109 /// <param name="P_Int_OrderID">订单编号</param>
110 /// <param name="P_Int_Confirm">是否选择了确认下拉菜单</param>
111 /// <param name="P_Int_Payed">是否选择了确认下拉菜单</param>
112 /// <param name="P_Int_Shipped">是否选择了付款下拉菜单</param>
113 /// <param name="P_Int_Finished">是否选择了归档下拉菜单</param>
114 /// <param name="P_Int_IsConfirm">订单是否已确认</param>
115 /// <param name="P_Int_IsPayment">订单是否已付款</param>
116 /// <param name="P_Int_IsConsignment">订单是否已发贷</param>
117 /// <param name="P_Int_IsPigeonhole">订单是否已归档</param>
118 /// <returns>返回Sqlcommand</returns>
119 public SqlCommand GetOrderInfo(int P_Int_Flag,int P_Int_IsMember, int P_Int_MemberID, int P_Int_OrderID, int P_Int_Confirm,int P_Int_Payed,int P_Int_Shipped,int P_Int_Finished,int P_Int_IsConfirm, int P_Int_IsPayment, int P_Int_IsConsignment, int P_Int_IsPigeonhole)
120 ...{
121 SqlConnection myConn = dbObj.GetConnection();
122 SqlCommand myCmd = new SqlCommand("Proc_GetOrderInfo", myConn);
123 myCmd.CommandType = CommandType.StoredProcedure;
124 //添加参数
125 SqlParameter Flag = new SqlParameter("@Flag", SqlDbType.Int, 4);
126 Flag.Value = P_Int_Flag;
127 myCmd.Parameters.Add(Flag);
128 //添加参数
129 SqlParameter IsMember = new SqlParameter("@IsMember", SqlDbType.Int, 4);
130 IsMember.Value = P_Int_IsMember;
131 myCmd.Parameters.Add(IsMember);
132 //添加参数
133 SqlParameter MemberID = new SqlParameter("@MemberID", SqlDbType.Int, 4);
134 MemberID.Value = P_Int_MemberID;
135 myCmd.Parameters.Add(MemberID);
136 //添加参数
137 SqlParameter OrderID = new SqlParameter("@OrderID", SqlDbType.Int, 4);
138 OrderID.Value = P_Int_OrderID;
139 myCmd.Parameters.Add(OrderID);
140 //添加参数
141 SqlParameter Confirm = new SqlParameter("@Confirm", SqlDbType.Int, 4);
142 Confirm.Value = P_Int_Confirm;
143 myCmd.Parameters.Add(Confirm);
144 //添加参数
145 SqlParameter Payed = new SqlParameter("@Payed", SqlDbType.Int, 4);
146 Payed.Value = P_Int_Payed;
147 myCmd.Parameters.Add(Payed);
148 //添加参数
149 SqlParameter Shipped = new SqlParameter("@Shipped", SqlDbType.Int, 4);
150 Shipped.Value = P_Int_Shipped;
151 myCmd.Parameters.Add(Shipped);
152 SqlParameter Finished = new SqlParameter("@Finished", SqlDbType.Int, 4);
153 Finished.Value = P_Int_Finished;
154 myCmd.Parameters.Add(Finished);
155 //添加参数
156 SqlParameter IsConfirm = new SqlParameter("@IsConfirm", SqlDbType.Int, 4);
157 IsConfirm.Value = P_Int_IsConfirm;
158 myCmd.Parameters.Add(IsConfirm);
159 //添加参数
160 SqlParameter IsPayment = new SqlParameter("@IsPayment", SqlDbType.Int, 4);
161 IsPayment.Value = P_Int_IsPayment;
162 myCmd.Parameters.Add(IsPayment);
163 //添加参数
164 SqlParameter IsConsignment = new SqlParameter("@IsConsignment", SqlDbType.Int, 4);
165 IsConsignment.Value = P_Int_IsConsignment;
166 myCmd.Parameters.Add(IsConsignment);
167 //添加参数
168 SqlParameter IsPigeonhole = new SqlParameter("@IsPigeonhole", SqlDbType.Int, 4);
169 IsPigeonhole.Value = P_Int_IsPigeonhole;
170 myCmd.Parameters.Add(IsPigeonhole);
171 //执行过程
172 myConn.Open();
173 try
174 ...{
175 myCmd.ExecuteNonQuery();
176 }
177 catch (Exception ex)
178 ...{
179 throw (ex);
180 }
181 finally
182 ...{
183 myCmd.Dispose();
184 myConn.Close();
185
186 }
187 return myCmd;
188 }
189 /**//// <summary>
190 /// 删除指定订单的信息
191 /// </summary>
192 /// <param name="P_Int_OrderID">订单编号</param>
193 public void DeleteOrderInfo(int P_Int_OrderID)
194 ...{
195 SqlConnection myConn = dbObj.GetConnection();
196 SqlCommand myCmd = new SqlCommand("Proc_DeleteOrderInfo", myConn);
197 myCmd.CommandType = CommandType.StoredProcedure;
198 //添加参数
199 SqlParameter OrderID = new SqlParameter("@OrderID", SqlDbType.BigInt, 8);
200 OrderID.Value = P_Int_OrderID;
201 myCmd.Parameters.Add(OrderID);
202 //执行过程
203 myConn.Open();
204 try
205 ...{
206 myCmd.ExecuteNonQuery();
207 }
208 catch (Exception ex)
209 ...{
210 throw (ex);
211 }
212 finally
213 ...{
214 myCmd.Dispose();
215 myConn.Close();
216
217 }
218 }
219 /**//// <summary>
220 /// 获取运输方式名
221 /// </summary>
222 /// <param name="P_Int_ShipType">运输编号</param>
223 /// <returns></returns>
224 public string GetShipWay(int P_Int_ShipType)
225 ...{
226 SqlConnection myConn = dbObj.GetConnection();
227 SqlCommand myCmd = new SqlCommand("Proc_GetShipWay", myConn);
228 myCmd.CommandType = CommandType.StoredProcedure;
229 //添加参数
230 SqlParameter ShipType = new SqlParameter("@ShipType", SqlDbType.Int,4);
231 ShipType.Value = P_Int_ShipType;
232 myCmd.Parameters.Add(ShipType);
233 //执行过程
234 myConn.Open();
235 string P_Str_ShipWay =Convert.ToString(myCmd.ExecuteScalar());
236 myCmd.Dispose();
237 myConn.Close();
238 return P_Str_ShipWay;
239 }
240 /**//// <summary>
241 /// 获取支付方式名
242 /// </summary>
243 /// <param name="P_Int_PayType">获取支付编号</param>
244 /// <returns></returns>
245 public string GetPayWay(int P_Int_PayType)
246 ...{
247 SqlConnection myConn = dbObj.GetConnection();
248 SqlCommand myCmd = new SqlCommand("Proc_GetPayWay", myConn);
249 myCmd.CommandType = CommandType.StoredProcedure;
250 //添加参数
251 SqlParameter PayType = new SqlParameter("@PayType", SqlDbType.Int, 4);
252 PayType.Value = P_Int_PayType;
253 myCmd.Parameters.Add(PayType);
254 //执行过程
255 myConn.Open();
256 string P_Str_PayWay = Convert.ToString (myCmd.ExecuteScalar());
257 myCmd.Dispose();
258 myConn.Close();
259 return P_Str_PayWay;
260 }
261 /**//// <summary>
262 /// 获取订单状态的Dataset数据集
263 /// </summary>
264 /// <param name="P_Int_OrderID">订单编号</param>
265 /// <param name="P_Str_srcTable">订单信息</param>
266 /// <returns>返回Dataset</returns>
267 public DataSet GetStatusDS(int P_Int_OrderID,string P_Str_srcTable)
268 ...{
269 SqlConnection myConn = dbObj.GetConnection();
270 SqlCommand myCmd = new SqlCommand("Proc_GetStatus", myConn);
271 myCmd.CommandType = CommandType.StoredProcedure;
272 //添加参数
273 SqlParameter OrderID = new SqlParameter("@OrderID", SqlDbType.BigInt, 8);
274 OrderID.Value = P_Int_OrderID;
275 myCmd.Parameters.Add(OrderID);
276 //执行过程
277 myConn.Open();
278 myCmd.ExecuteNonQuery();
279 SqlDataAdapter da = new SqlDataAdapter(myCmd);
280 DataSet ds=new DataSet ();
281 da.Fill(ds, P_Str_srcTable);
282 myCmd.Dispose();
283 myConn.Dispose();
284 return ds;
285 }
286 /**//// <summary>
287 /// 获取订单状态的Dataset数据集
288 /// </summary>
289 /// <param name="P_Int_OrderID">订单编号</param>
290 /// <param name="P_Str_srcTable">订单信息</param>
291 /// <returns>返回Dataset</returns>
292 public DataSet GetOdIfDS(int P_Int_OrderID, string P_Str_srcTable)
293 ...{
294 SqlConnection myConn = dbObj.GetConnection();
295 SqlCommand myCmd = new SqlCommand("Proc_GetOdIf", myConn);
296 myCmd.CommandType = CommandType.StoredProcedure;
297 //添加参数
298 SqlParameter OrderID = new SqlParameter("@OrderID", SqlDbType.BigInt, 8);
299 OrderID.Value = P_Int_OrderID;
300 myCmd.Parameters.Add(OrderID);
301 //执行过程
302 myConn.Open();
303 myCmd.ExecuteNonQuery();
304 SqlDataAdapter da = new SqlDataAdapter(myCmd);
305 DataSet ds = new DataSet();
306 da.Fill(ds, P_Str_srcTable);
307 myCmd.Dispose();
308 myConn.Dispose();
309 return ds;
310 }
311 /**//// <summary>
312 /// 通过订单ID代号，获取商品信息
313 /// </summary>
314 /// <param name="P_Int_OrderID">订单ID代号</param>
315 /// <param name="P_Str_srcTable">信息</param>
316 /// <returns>返回信息的数据集Ds</returns>
317 public DataSet GetGIByOID(int P_Int_OrderID, string P_Str_srcTable)
MingriNetShop/App_Code/MangerClass.cs，打开代码结构图