温馨提示:代码在线浏览功能只能做为源码浏览参考,如果想更进一步了解该代码请下载:MyShop网络商城080617源码
当前文件:
MyShop080617/AccessDAL/Order.cs,打开代码结构图
MyShop080617/AccessDAL/Order.cs,打开代码结构图1using System; 2
using System.Collections.Generic; 3
using System.Data; 4
using System.Data.OleDb; 5
using MyShop.IDAL; 6
using MyShop.Model; 7
8
namespace MyShop.AccessDAL 9
...{ 10
public class Order :IOrder 11
...{ 12
private ConfigInfo configInfo = new ConfigInfo(); 13
private string tableName = "Ljh_Order"; 14
15
public Order() 16
...{ 17
if (!string.IsNullOrEmpty(configInfo.TablePrefix.Trim())) 18
tableName = configInfo.TablePrefix + "orders"; 19
} 20
21
IOrder member#region IOrder member 22
23
24
/**//// <summary> 25
/// add 26
/// </summary> 27
/// <param name="model"></param> 28
/// <returns>返回ID, 如果发生错误则返回-1</returns> 29
public int Add(OrderInfo model) 30
...{ 31
if (model == null) 32
...{ 33
return 0; 34
} 35
string commandText = "insert into " + this.tableName + "(orderNum,userName,clientId,moneyTotal,moneyGoods,needInvoice,invoiced,remark,inputTime,contacterName,address,zipCode,mobile,phone,email,paymentType,deliverType,[status],presentExp,chargeDeliver,invoiceContent,DeliverStatus,MoneyReceipt) values(@orderNum,@userName,@clientId,@moneyTotal,@moneyGoods,@needInvoice,@invoiced,@remark,@inputTime,@contacterName,@address,@zipCode,@mobile,@phone,@email,@paymentType,@deliverType,@status,@presentExp,@chargeDeliver,@invoiceContent,@DeliverStatus,@MoneyReceipt)"; 36
OleDbParameter[] commandParameters = ...{ 37
Database.MakeInParam("@OrderNum",OleDbType.VarWChar,20,model.OrderNum), 38
Database.MakeInParam("@UserName",OleDbType.VarWChar,20,model.UserName), 39
Database.MakeInParam("@ClientId",OleDbType.Integer,4,model.ClientId), 40
Database.MakeInParam("@MoneyTotal",OleDbType.Currency,4,model.MoneyTotal), 41
Database.MakeInParam("@MoneyGoods",OleDbType.Currency,4,model.MoneyGoods), 42
Database.MakeInParam("@NeedInvoice",OleDbType.UnsignedTinyInt,1,model.NeedInvoice), 43
Database.MakeInParam("@Invoiced",OleDbType.UnsignedTinyInt,1,model.Invoiced), 44
Database.MakeInParam("@Remark",OleDbType.VarWChar,0,model.Remark), 45
Database.MakeInParam("@InputTime",OleDbType.Date,8,model.InputTime), 46
Database.MakeInParam("@ContacterName",OleDbType.VarWChar,50,model.ContacterName), 47
Database.MakeInParam("@Address",OleDbType.VarWChar,255,model.Address), 48
Database.MakeInParam("@ZipCode",OleDbType.VarWChar,10,model.ZipCode), 49
Database.MakeInParam("@Mobile",OleDbType.VarWChar,50,model.Mobile), 50
Database.MakeInParam("@Phone",OleDbType.VarWChar,50,model.Phone), 51
Database.MakeInParam("@Email",OleDbType.VarWChar,50,model.Email), 52
Database.MakeInParam("@PaymentType",OleDbType.Integer,4,model.PaymentType), 53
Database.MakeInParam("@DeliverType",OleDbType.Integer,4,model.DeliverType), 54
Database.MakeInParam("@Status",OleDbType.Integer,4,model.Status), 55
Database.MakeInParam("@PresentExp",OleDbType.Integer,4,model.PresentExp), 56
Database.MakeInParam("@ChargeDeliver",OleDbType.Currency,2,model.ChargeDeliver), 57
Database.MakeInParam("@InvoiceContent",OleDbType.VarWChar,0,model.InvoiceContent), 58
Database.MakeInParam("@DeliverStatus",OleDbType.Integer,4,model.DeliverStatus), 59
Database.MakeInParam("@MoneyReceipt",OleDbType.Currency,8,model.MoneyReceipt) 60
}; 61
int intIdentity = -1; 62
try 63
...{ 64
Database.ExecuteNonQuery(CommandType.Text, out intIdentity, commandText, commandParameters); 65
} 66
catch (Exception exception) 67
...{ 68
throw exception; 69
} 70
return intIdentity; 71
} 72
73
74
75
76
/**//// <summary> 77
/// 删除 78
/// </summary> 79
/// <param name="filter">where后面的条件语句,不加where</param> 80
/// <returns>返回影响行数</returns> 81
public int Delete(string filter) 82
...{ 83
int count = -1; 84
string sql = @"delete from " + tableName; 85
if (!string.IsNullOrEmpty(filter.Trim())) 86
...{ 87
sql = sql + " where " + filter; 88
} 89
try 90
...{ 91
92
count = Database.ExecuteNonQuery(sql); 93
} 94
catch (Exception ex) 95
...{ 96
throw ex; 97
} 98
return count; 99
} 100
101
/**//// <summary> 102
/// 103
/// </summary> 104
/// <param name="filter"></param> 105
/// <returns></returns> 106
public bool Exist(string filter) 107
...{ 108
bool result = false; 109
string sql = @"select * from " + tableName; 110
if (!string.IsNullOrEmpty(filter)) 111
...{ 112
sql = sql + " where " + filter; 113
} 114
try 115
...{ 116
117
118
DataSet dataset = new DataSet(); 119
dataset = Database.ExecuteDataSet(sql); 120
if (dataset.Tables[0].Rows.Count > 0) 121
...{ 122
result = true; 123
} 124
} 125
catch (Exception ex) 126
...{ 127
throw ex; 128
} 129
return result; 130
} 131
132
/**//// <summary> 133
/// 返回所有 134
/// </summary> 135
/// <returns>返回所有</returns> 136
public DataSet GetDataSet() 137
...{ 138
string sql = "select * from " + tableName; 139
DataSet dataset = new DataSet(); 140
try 141
...{ 142
143
dataset = Database.ExecuteDataSet(sql); 144
145
} 146
catch (Exception ex) 147
...{ 148
throw ex; 149
} 150
return dataset; 151
} 152
153
public DataSet GetDataSet(string filter) 154
...{ 155
if (string.IsNullOrEmpty(filter)) 156
return null; 157
158
string sql = "select * from " + tableName + " where " + filter; 159
DataSet dataset = new DataSet(); 160
try 161
...{ 162
163
dataset = Database.ExecuteDataSet(sql); 164
} 165
catch (Exception ex) 166
...{ 167
throw ex; 168
} 169
return dataset; 170
} 171
172
/**//// <summary> 173
/// 174
/// </summary> 175
/// <param name="dr"></param> 176
/// <returns></returns> 177
public OrderInfo GetModel(DataRow dr) 178
...{ 179
if (dr == null) 180
return null; 181
OrderInfo model = new OrderInfo(); 182
183
if (dr["orderId"].ToString() != "") model.OrderId = Convert.ToInt32( dr["orderId"].ToString() ); 184
if (dr["orderNum"].ToString() != "") model.OrderNum = dr["orderNum"].ToString(); 185
if (dr["UserName"].ToString() != "") model.UserName = dr["UserName"].ToString(); 186
if (dr["clientId"].ToString() != "") model.ClientId = Convert.ToInt32( dr["clientId"].ToString()); 187
if (dr["moneyTotal"].ToString() != "") model.MoneyTotal = Convert.ToDecimal( dr["moneyTotal"].ToString()); 188
if (dr["moneyGoods"].ToString() != "") model.MoneyGoods = Convert.ToDecimal( dr["moneyGoods"].ToString()); 189
if (dr["needInvoice"].ToString() != "") model.NeedInvoice = Convert.ToInt16( dr["needInvoice"]); 190
if (dr["Invoiced"].ToString() != "") model.Invoiced = Convert.ToInt16( dr["Invoiced"]); 191
if (dr["Remark"].ToString() != "") model.Remark = dr["Remark"].ToString(); 192
if (dr["InputTime"].ToString() != "") model.InputTime = dr["InputTime"].ToString(); 193
if (dr["ContacterName"].ToString() != "") model.ContacterName = dr["ContacterName"].ToString(); 194
if (dr["Address"].ToString() != "") model.Address = dr["Address"].ToString(); 195
if (dr["ZipCode"].ToString() != "") model.ZipCode = dr["ZipCode"].ToString(); 196
if (dr["Mobile"].ToString() != "") model.Mobile = dr["Mobile"].ToString(); 197
if (dr["phone"].ToString() != "") model.Phone = dr["phone"].ToString(); 198
if (dr["Email"].ToString() != "") model.Email = dr["Email"].ToString(); 199
if (dr["PaymentType"].ToString() != "") model.PaymentType = Convert.ToInt16( dr["PaymentType"].ToString()); 200
if (dr["DeliverType"].ToString() != "") model.DeliverType = Convert.ToInt16( dr["DeliverType"].ToString()); 201
if (dr["Status"].ToString() != "") model.Status = Convert.ToInt16( dr["Status"].ToString()); 202
if (dr["PresentExp"].ToString() != "") model.PresentExp = Convert.ToInt32( dr["PresentExp"].ToString()); 203
if (dr["ChargeDeliver"].ToString() != "") model.ChargeDeliver = Convert.ToDecimal( dr["ChargeDeliver"].ToString()); 204
if (dr["InvoiceContent"].ToString() != "") model.InvoiceContent = dr["InvoiceContent"].ToString().ToString(); 205
if (dr["DeliverStatus"].ToString() != "") model.DeliverStatus = Convert.ToInt32(dr["DeliverStatus"].ToString()); 206
if (dr["moneyReceipt"].ToString() != "") model.MoneyReceipt = Convert.ToDecimal(dr["moneyReceipt"].ToString()); 207
208
209
210
return model; 211
} 212
213
/**//// <summary> 214
/// 215
/// </summary> 216
/// <param name="sql"></param> 217
/// <returns></returns> 218
public DataSet Query(string sql) 219
...{ 220
if (string.IsNullOrEmpty(sql)) 221
return null; 222
223
DataSet dataset = new DataSet(); 224
try 225
...{ 226
227
dataset = Database.ExecuteDataSet(sql); 228
} 229
catch (Exception ex) 230
...{ 231
throw ex; 232
} 233
return dataset; 234
} 235
236
237
/**//// <summary> 238
/// update 239
/// </summary> 240
/// <param name="model"></param> 241
/// <param name="filter"></param> 242
/// <returns></returns> 243
public int Update(OrderInfo model, string filter) 244
...{ 245
int result; 246
if (string.IsNullOrEmpty(filter)) 247
...{ 248
throw new Exception("The 'filter' can not be null!"); 249
} 250
string sql = @"update " + tableName + " set orderNum=@orderNum,UserName=@UserName,clientId=@clientId,moneyTotal=@moneyTotal,moneyGoods=@moneyGoods,needInvoice=@needInvoice,Invoiced=@Invoiced,Remark=@Remark,InputTime=@InputTime,ContacterName=@ContacterName,Address=@Address,ZipCode=@ZipCode,Mobile=@Mobile,phone=@phone,Email=@Email,PaymentType=@PaymentType,DeliverType=@DeliverType,Status=@Status,PresentExp=@PresentExp,ChargeDeliver=@ChargeDeliver,InvoiceContent=@InvoiceContent,DeliverStatus=@DeliverStatus,MoneyReceipt=@MoneyReceipt " + " where " + filter; 251
252
253
OleDbParameter[] prams = ...{ 254
Database.MakeInParam("@OrderNum",OleDbType.VarWChar,20,model.OrderNum), 255
Database.MakeInParam("@UserName",OleDbType.VarWChar,20,model.UserName), 256
Database.MakeInParam("@ClientId",OleDbType.Integer,4,model.ClientId), 257
Database.MakeInParam("@MoneyTotal&quo





}