ÎÂܰÌáʾ£º´úÂëÔÚÏßä¯ÀÀ¹¦ÄÜÖ»ÄÜ×öΪԴÂëä¯ÀÀ²Î¿¼£¬Èç¹ûÏë¸ü½øÒ»²½Á˽â¸Ã´úÂëÇëÏÂÔØ£ºMyShopÍøÂçÉ̳Ç080617Ô´Âë
µ±Ç°Îļþ£º
MyShop080617/AccessDAL/DeliverType.cs£¬´ò¿ª´úÂë½á¹¹Í¼
MyShop080617/AccessDAL/DeliverType.cs£¬´ò¿ª´úÂë½á¹¹Í¼1using System; 2
using System.Collections.Generic; 3
4
using System.Data; 5
using System.Data.OleDb; 6
using MyShop.IDAL; 7
using MyShop.Model; 8
9
namespace MyShop.AccessDAL 10
...{ 11
public class DeliverType : IDeliverType 12
...{ 13
14
private ConfigInfo configInfo = new ConfigInfo(); 15
private string tableName = "Ljh_DeliverType"; 16
public DeliverType() 17
...{ 18
if (!string.IsNullOrEmpty(configInfo.TablePrefix.Trim())) 19
tableName = configInfo.TablePrefix + "DeliverType"; 20
} 21
22
IDeliverType member#region IDeliverType member 23
24
/**//// <summary> 25
/// Ìí¼Ó 26
/// </summary> 27
/// <param name="model"></param> 28
/// <returns>·µ»ØID, Èç¹û·¢Éú´íÎóÔò·µ»Ø-1</returns> 29
public int Add(DeliverTypeInfo model) 30
...{ 31
if (model == null) 32
...{ 33
return 0; 34
} 35
string commandText = "insert into " + this.tableName + "(typeName,intro,isDefault,isDisabled,orderId,charge) values(@typeName,@intro,@isDefault,@isDisabled,@orderId,@charge) "; 36
OleDbParameter[] commandParameters = ...{ 37
Database.MakeInParam("@TypeName",OleDbType.VarWChar,50,model.TypeName), 38
Database.MakeInParam("@Intro",OleDbType.VarWChar,255,model.Intro), 39
Database.MakeInParam("@IsDefault",OleDbType.UnsignedTinyInt,1,model.IsDefault), 40
Database.MakeInParam("@IsDisabled",OleDbType.UnsignedTinyInt,1,model.IsDisabled), 41
Database.MakeInParam("@OrderId",OleDbType.Integer,4,model.OrderId), 42
Database.MakeInParam("@Charge",OleDbType.Currency,8,model.Charge), 43
}; 44
int intIdentity = -1; 45
try 46
...{ 47
Database.ExecuteNonQuery(CommandType.Text, out intIdentity, commandText, commandParameters); 48
} 49
catch (Exception exception) 50
...{ 51
throw exception; 52
} 53
return intIdentity; 54
} 55
56
57
58
59
/**//// <summary> 60
/// ɾ³ý 61
/// </summary> 62
/// <param name="filter">whereºóÃæµÄÌõ¼þÓï¾ä£¬²»¼Ówhere</param> 63
/// <returns>·µ»ØÓ°ÏìÐÐÊý</returns> 64
public int Delete(string filter) 65
...{ 66
int count = -1; 67
string sql = @"delete from " + tableName; 68
if (!string.IsNullOrEmpty(filter.Trim())) 69
...{ 70
sql = sql + " where " + filter; 71
} 72
try 73
...{ 74
75
count = Database.ExecuteNonQuery(sql); 76
} 77
catch (Exception ex) 78
...{ 79
throw ex; 80
} 81
return count; 82
} 83
84
/**//// <summary> 85
/// ÅжÏÊÇ·ñ´æÔÚ 86
/// </summary> 87
/// <param name="filter">UserName=condition|UserName and password</param> 88
/// <returns></returns> 89
public bool Exist(string filter) 90
...{ 91
bool result = false; 92
string sql = @"select * from " + tableName; 93
if (!string.IsNullOrEmpty(filter.Trim())) 94
...{ 95
sql = sql + " where " + filter; 96
} 97
try 98
...{ 99
100
101
DataSet dataset = new DataSet(); 102
dataset = Database.ExecuteDataSet(sql); 103
if (dataset.Tables[0].Rows.Count > 0) 104
...{ 105
result = true; 106
} 107
} 108
catch (Exception ex) 109
...{ 110
throw ex; 111
} 112
return result; 113
} 114
115
/**//// <summary> 116
/// ·µ»ØËùÓÐ 117
/// </summary> 118
/// <returns>·µ»ØËùÓÐ</returns> 119
public DataSet GetDataSet() 120
...{ 121
string sql = "select * from " + tableName; 122
DataSet dataset = new DataSet(); 123
try 124
...{ 125
126
dataset = Database.ExecuteDataSet(sql); 127
128
} 129
catch (Exception ex) 130
...{ 131
throw ex; 132
} 133
return dataset; 134
} 135
136
/**//// <summary> 137
/// 138
/// </summary> 139
/// <param name="filter"></param> 140
/// <returns></returns> 141
public DataSet GetDataSet(string filter) 142
...{ 143
if (string.IsNullOrEmpty(filter)) 144
return null; 145
146
string sql = "select * from " + tableName + " where " + filter; 147
DataSet dataset = new DataSet(); 148
try 149
...{ 150
151
dataset = Database.ExecuteDataSet(sql); 152
} 153
catch (Exception ex) 154
...{ 155
throw ex; 156
} 157
return dataset; 158
} 159
160
/**//// <summary> 161
/// / 162
/// </summary> 163
/// <param name="dr"></param> 164
/// <returns></returns> 165
public DeliverTypeInfo GetModel(DataRow dr) 166
...{ 167
if (dr == null) 168
return null; 169
DeliverTypeInfo model = new DeliverTypeInfo(); 170
171
if (dr["TypeId"].ToString() != "") 172
model.TypeId = Convert.ToInt32(dr["TypeId"]); 173
if (dr["typeName"].ToString() != "") 174
model.TypeName = dr["typeName"].ToString(); 175
if (dr["intro"].ToString() != "") 176
model.Intro = dr["intro"].ToString(); 177
if (dr["IsDefault"].ToString() != "") 178
model.IsDefault = Convert.ToInt32( dr["IsDefault"]); 179
if (dr["IsDisabled"].ToString() != "") 180
model.IsDisabled = Convert.ToInt32( dr["IsDisabled"]); 181
if (dr["OrderId"].ToString() != "") 182
model.OrderId = Convert.ToInt32(dr["OrderId"]); 183
if (dr["Charge"].ToString() != "") 184
model.Charge = Convert.ToDecimal(dr["Charge"]); 185
186
return model; 187
} 188
189
/**//// <summary> 190
/// 191
/// </summary> 192
/// <param name="sql"></param> 193
/// <returns></returns> 194
public DataSet Query(string sql) 195
...{ 196
if (string.IsNullOrEmpty(sql)) 197
return null; 198
199
DataSet dataset = new DataSet(); 200
try 201
...{ 202
203
dataset = Database.ExecuteDataSet(sql); 204
} 205
catch (Exception ex) 206
...{ 207
throw ex; 208
} 209
return dataset; 210
} 211
212
/**//// <summary> 213
/// 214
/// </summary> 215
/// <param name="model"></param> 216
/// <param name="filter"></param> 217
/// <returns></returns> 218
public int Update(DeliverTypeInfo model, string filter) 219
...{ 220
int result; 221
if (string.IsNullOrEmpty(filter)) 222
...{ 223
throw new Exception("The 'filter' can not be null!"); 224
} 225
string sql = @"update " + tableName + " set typeName=@typeName,intro=@intro,isDefault=@isDefault,isDisabled=@isDisabled,orderId=@orderId,charge=@charge " + " where " + filter; 226
OleDbParameter[] prams = ...{ 227
Database.MakeInParam("@TypeName",OleDbType.VarWChar,50,model.TypeName), 228
Database.MakeInParam("@Intro",OleDbType.VarWChar,255,model.Intro), 229
Database.MakeInParam("@IsDefault",OleDbType.UnsignedTinyInt,1,model.IsDefault), 230
Database.MakeInParam("@IsDisabled",OleDbType.UnsignedTinyInt,1,model.IsDisabled), 231
Database.MakeInParam("@OrderId",OleDbType.Integer,4,model.OrderId), 232
Database.MakeInParam("@Charge",OleDbType.Currency,8,model.Charge), 233
}; 234
235
try 236
...{ 237
238
result = Database.ExecuteNonQuery(sql, prams); 239
} 240
catch (Exception ex) 241
...{ 242
throw ex; 243
} 244
return result; 245
} 246
247
#endregion 248
249
250
} 251
} 252





}
}