当前文件路径：ClothesShop/OleDbDAL/order.cs 
1
using System;
2using System.Collections.Generic;
3using System.Text;
4using System.Data.OleDb;
5using ClothesShop.DBUtility;
6using System.Data;
7namespace ClothesShop.OleDbDAL
8
...{
9
public class order : ClothesShop.IDAL.Iorder
10
...{
11 /**//// <summary>
12 /// 添加一条订单纪录
13 /// </summary>
14 /// <param name="orderid">订单号</param>
15 /// <param name="productid">商品号</param>
16 /// <param name="userid">用户编号</param>
17 /// <param name="acceptname">收货人</param>
18 /// <param name="address">收货地址</param>
19 /// <param name="postalcode">邮政编码</param>
20 /// <param name="phone">联系电话</param>
21 /// <param name="delivery">送货方式</param>
22 /// <param name="payment">付款方式</param>
23 /// <param name="state">订单状态</param>
24 /// <param name="ordertime">下单时间</param>
25 /// <param name="orderprice">订单总额</param>
26
/// <returns></returns>
27 public int createorder(string orderid, string productid, int userid, string acceptname,
28 string address, string postalcode, string phone, string delivery, string payment, int state, DateTime ordertime, double orderprice)
29 ...{
30 StringBuilder sb = new StringBuilder();
31 sb.Append("insert into orders (orderid,productid,[userid],acceptname,address,postalcode,phone,delivery,payment,state,ordertime,orderprice) values ");
32 sb.Append("(@orderid,@productid,@userid,@acceptname,@address,@postalcode,@phone,@delivery,@payment,@state,@ordertime,@orderprice)");
33 OleDbParameter[] param =
34 ...{
35 OleDbHelper.GetParameter("@orderid",OleDbType.Char,50,"orderid",orderid),
36 OleDbHelper.GetParameter("@productid",OleDbType.Char,50,"productid",productid),
37 OleDbHelper.GetParameter("@userid",OleDbType.Integer,4,"[userid]",userid),
38 OleDbHelper.GetParameter("@acceptname",OleDbType.Char,50,"acceptname",acceptname),
39 OleDbHelper.GetParameter("@address",OleDbType.Char,200,"address",address),
40 OleDbHelper.GetParameter("@postalcode",OleDbType.Char,50,"postalcode",postalcode),
41 OleDbHelper.GetParameter("@phone",OleDbType.Char,50,"phone",phone),
42 OleDbHelper.GetParameter("@delivery",OleDbType.Char,50,"delivery",delivery),
43 OleDbHelper.GetParameter("@payment",OleDbType.Char,50,"payment",payment),
44 OleDbHelper.GetParameter("@state",OleDbType.Integer,4,"state",state),
45 OleDbHelper.GetParameter("@ordertime",OleDbType.Date,8,"ordertime",ordertime),
46 OleDbHelper.GetParameter("@orderprice",OleDbType.Double,8,"orderprice",orderprice)
47 };
48 return OleDbHelper.ExecuteSql(sb.ToString(), param);
49 }
50
51 /**//// <summary>
52 /// 更新订单状态
53 /// </summary>
54 /// <param name="orderid">订单号</param>
55 /// <param name="state">订单状态</param>
56 /// <returns></returns>
57 public int updatestate(string orderid, int state)
58 ...{
59 StringBuilder sb = new StringBuilder();
60 sb.Append("update orders set state=@state where orderid=@orderid");
61 OleDbParameter[] param =
62 ...{ OleDbHelper.GetParameter("@state", OleDbType.Integer, 4, "state", state),
63 OleDbHelper.GetParameter("@orderid", OleDbType.Char, 50, "orderid", orderid)
64 };
65 return OleDbHelper.ExecuteSql(sb.ToString(), param);
66 }
67
68 /**//// <summary>
69 /// 根据条件查询订单纪录
70 /// </summary>
71 /// <param name="username">用户名</param>
72 /// <param name="ordertime">下单时间</param>
73 /// <param name="state">订单状态</param>
74 /// <returns></returns>
75 public DataTable selectorderlist(string username, string ordertime, int state)
76 ...{
77 StringBuilder sb = new StringBuilder();
78 sb.Append("SELECT userinfo.userid, userinfo.username,orders.orderid, orders.acceptname, orders.address,");
79 sb.Append("orders.postalcode, orders.phone, orders.delivery, orders.payment, orders.state,");
80 sb.Append("orders.ordertime, orders.orderprice ");
81 sb.Append("FROM orders INNER JOIN userinfo ON orders.userid = userinfo.userid");
82 sb.Append(" where 1=@index");
83 List<OleDbParameter> list = new List<OleDbParameter>();
84 list.Add(OleDbHelper.GetParameter("@index",OleDbType.Integer,1));
85 if (username != "")
86 ...{
87 sb.Append(" and userinfo.username like '%' + @username + '%'");
88 list.Add(OleDbHelper.GetParameter("@username", OleDbType.Char, 50, "userinfo.username",username));
89 }
90 //if (ordertime != "")
91 //{
92 // sb.Append(" and orders.ordertime = # + @ordertime #");
93 // list.Add(OleDbHelper.GetParameter("@ordertime", OleDbType.Char, 50, "orders.ordertime", ordertime));
94 //}
95 if (state == 0 || state == 1 || state == 2 || state == 3 ||state == 4 || state == 5 )
96 ...{
97 sb.Append(" and orders.state=@state");
98 list.Add(OleDbHelper.GetParameter("@state", OleDbType.Integer, 4, "state", state));
99 }
100 return OleDbHelper.ExecuteDt(sb.ToString(), list.ToArray());
101 }
102
103 /**//// <summary>
104 /// 根据用户ID获得订单列表
105 /// </summary>
106 /// <param name="userid"></param>
107 /// <returns></returns>
108 public DataTable getordersbyuserid(int userid)
109 ...{
110 StringBuilder sb = new StringBuilder();
111 sb.Append("SELECT orderid,productid,[userid],");
112 sb.Append("acceptname,address,postalcode,phone,");
113 sb.Append("delivery,payment,state,ordertime,orderprice ");
114 sb.Append("from orders where [userid]=@userid");
115 OleDbParameter[] param =
116 ...{
117 OleDbHelper.GetParameter("@userid",OleDbType.Integer,4,"userid",userid)
118 };
119 return OleDbHelper.ExecuteDt(sb.ToString(), param);
120 }
121
122 /**//// <summary>
123 /// 根据条件查询订单纪录
124 /// </summary>
125 /// <param name="state">订单状态</param>
126 /// <returns></returns>
127 public DataTable selectorderlist(int state)
128 ...{
129 StringBuilder sb = new StringBuilder();
130 sb.Append("SELECT userinfo.userid, userinfo.username,orders.orderid, orders.acceptname, orders.address,");
131 sb.Append("orders.postalcode, orders.phone, orders.delivery, orders.payment, orders.state,");
132 sb.Append("orders.ordertime, orders.orderprice ");
133 sb.Append("FROM orders INNER JOIN userinfo ON orders.userid = userinfo.userid");
134 sb.Append(" where 1=@index");
135 List<OleDbParameter> list = new List<OleDbParameter>();
136 list.Add(OleDbHelper.GetParameter("@index",OleDbType.Integer,1));
137 if (state == 0 || state == 1 || state == 2 || state == 3 || state == 4)
138 ...{
139 sb.Append(" and state=@state");
140 list.Add(OleDbHelper.GetParameter("@state", OleDbType.Integer, 4, "state", state));
141 }
142 return OleDbHelper.ExecuteDt(sb.ToString(), list.ToArray());
143 }
144
145 public DataTable selectorderlist(string username, int state)
146 ...{
147 StringBuilder sb = new StringBuilder();
148 sb.Append("SELECT userinfo.userid, userinfo.username,orders.orderid, orders.acceptname, orders.address,");
149 sb.Append("orders.postalcode, orders.phone, orders.delivery, orders.payment, orders.state,");
150 sb.Append("orders.ordertime, orders.orderprice ");
151 sb.Append("FROM orders INNER JOIN userinfo ON orders.userid = userinfo.userid");
152 sb.Append(" where 1=@index");
153 List<OleDbParameter> list = new List<OleDbParameter>();
154 list.Add(OleDbHelper.GetParameter("@index", OleDbType.Integer, 1));
155 if (username != "")
156 ...{
157 sb.Append(" and userinfo.username like '%' + @username + '%'");
158 list.Add(OleDbHelper.GetParameter("@username", OleDbType.Char, 50, "userinfo.username", username));
159 }
160 if (state == 0 || state == 1 || state == 2 || state == 3 || state == 4)
161 ...{
162 sb.Append(" and orders.state=@state");
163 list.Add(OleDbHelper.GetParameter("@state", OleDbType.Integer, 4, "orders.state", state));
164 }
165 return OleDbHelper.ExecuteDt(sb.ToString(), list.ToArray());
166 }
167
168 /**//// <summary>
169 /// 获得一条订单信息
170 /// </summary>
171 /// <param name="orderid"></param>
172 /// <returns></returns>
173 public DataRow getoneorder(string orderid)
174 ...{
175 StringBuilder sb = new StringBuilder();
176 sb.Append("SELECT orderid,productid,[userid],");
177 sb.Append("acceptname,address,postalcode,phone,");
178 sb.Append("delivery,payment,state,ordertime,orderprice ");
179 sb.Append("from orders where orderid=@orderid");
180 OleDbParameter[] param =
181 ...{
182 OleDbHelper.GetParameter("@orderid",OleDbType.Char,50,"orderid",orderid)
183 };
184 return OleDbHelper.ExecuteDt(sb.ToString(), param).Rows[0];
185 }
186 }
187
}
188
打包下载该项目完整源码：衣购网站项目(三层开发)源码
