1using System;
  2using System.Collections.Generic;
  3using System.Data;
  4using System.Data.OleDb;
  5using MyShop.IDAL;
  6using MyShop.Model;
  7
  8namespace 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