1using System;
  2using System.Collections.Generic;
  3using System.Data;
  4using System.Data.OleDb;
  5using MyShop.IDAL;
  6using MyShop.Model;
  7
  8
  9namespace MyShop.AccessDAL
 10...{
 11    public  class DeliverItem:IDeliverItem
 12    ...{
 13        private ConfigInfo configInfo = new ConfigInfo();
 14        private string tableName = "Ljh_DeliverItem";
 15
 16        public DeliverItem()
 17        ...{
 18            if (!string.IsNullOrEmpty(configInfo.TablePrefix.Trim()))
 19                tableName = configInfo.TablePrefix + "DeliverItem";
 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(DeliverItemInfo model)
 30        ...{
 31            if (model == null)
 32            ...{
 33                return -1;
 34            }
 35            string commandText = "insert into " + this.tableName + "(orderID,deliverDate,deliverDirection,handlerName,expressCompany,expressNumber,inputer,remark,received)  values(@orderID,@deliverDate,@deliverDirection,@handlerName,@expressCompany,@expressNumber,@inputer,@remark,@received)  ";
 36            OleDbParameter[] commandParameters = ...{
 37                Database.MakeInParam("@OrderID",OleDbType.Integer,4,model.OrderID),
 38                Database.MakeInParam("@DeliverDate",OleDbType.Date,8,model.DeliverDate),
 39                Database.MakeInParam("@DeliverDirection",OleDbType.Integer,4,model.DeliverDirection),
 40                Database.MakeInParam("@HandlerName",OleDbType.VarWChar,20,model.HandlerName),
 41                Database.MakeInParam("@ExpressCompany",OleDbType.VarWChar,50,model.ExpressCompany),
 42                Database.MakeInParam("@ExpressNumber",OleDbType.VarWChar,50,model.ExpressNumber),
 43                Database.MakeInParam("@Inputer",OleDbType.VarWChar,20,model.Inputer),
 44                Database.MakeInParam("@Remark",OleDbType.VarWChar,255,model.Remark),
 45                Database.MakeInParam("@Received",OleDbType.UnsignedTinyInt,1,model.Received),
 46         };
 47            int intIdentity = -1;
 48            try
 49            ...{
 50                Database.ExecuteNonQuery(CommandType.Text, out intIdentity, commandText, commandParameters);
 51            }
 52            catch (Exception exception)
 53            ...{
 54                throw exception;
 55            }
 56            return intIdentity;
 57        }
 58
 59
 60
 61
 62        /**//// <summary>
 63        /// 删除 
 64        /// </summary>
 65        /// <param name="filter">where后面的条件语句，不加where</param>
 66        /// <returns>返回影响行数</returns>
 67        public int Delete(string filter)
 68        ...{
 69            int count = -1;
 70            string sql = @"delete from " + tableName;
 71            if (!string.IsNullOrEmpty(filter.Trim()))
 72            ...{
 73                sql = sql + "  where  " + filter;
 74            }
 75            try
 76            ...{
 77
 78                count = Database.ExecuteNonQuery(sql);
 79            }
 80            catch (Exception ex)
 81            ...{
 82                throw ex;
 83            }
 84            return count;
 85        }
 86
 87        /**//// <summary>
 88        /// 
 89        /// </summary>
 90        /// <param name="filter"></param>
 91        /// <returns></returns>
 92        public bool Exist(string filter)
 93        ...{
 94            bool result = false;
 95            string sql = @"select * from " + tableName;
 96            if (!string.IsNullOrEmpty(filter))
 97            ...{
 98                sql = sql + "  where  " + filter;
 99            }
100            try
101            ...{
102
103
104                DataSet dataset = new DataSet();
105                dataset = Database.ExecuteDataSet(sql);
106                if (dataset.Tables[0].Rows.Count > 0)
107                ...{
108                    result = true;
109                }
110            }
111            catch (Exception ex)
112            ...{
113                throw ex;
114            }
115            return result;
116        }
117
118        /**//// <summary>
119        /// 返回所有
120        /// </summary>
121        /// <returns>返回所有</returns>
122        public DataSet GetDataSet()
123        ...{
124            string sql = "select * from " + tableName;
125            DataSet dataset = new DataSet();
126            try
127            ...{
128
129                dataset = Database.ExecuteDataSet(sql);
130
131            }
132            catch (Exception ex)
133            ...{
134                throw ex;
135            }
136            return dataset;
137        }
138
139        public DataSet GetDataSet(string filter)
140        ...{
141            if (string.IsNullOrEmpty(filter))
142                return null;
143
144            string sql = "select * from " + tableName + " where " + filter;
145            DataSet dataset = new DataSet();
146            try
147            ...{
148
149                dataset = Database.ExecuteDataSet(sql);
150            }
151            catch (Exception ex)
152            ...{
153                throw ex;
154            }
155            return dataset;
156        }
157
158        /**//// <summary>
159        ///
160        /// </summary>
161        /// <param name="dr"></param>
162        /// <returns></returns>
163        public DeliverItemInfo GetModel(DataRow dr)
164        ...{
165            if (dr == null)
166                return null;
167            DeliverItemInfo model = new DeliverItemInfo();
168
169            if (dr["DeliverID"].ToString() != "") model.DeliverID = int.Parse( dr["DeliverID"].ToString());
170            if (dr["OrderID"].ToString() != "") model.OrderID =  int.Parse(  dr["OrderID"].ToString());
171            if (dr["DeliverDate"].ToString() != "") model.DeliverDate = dr["DeliverDate"].ToString();
172            if (dr["DeliverDirection"].ToString() != "") model.DeliverDirection = int.Parse(  dr["DeliverDirection"].ToString());
173            if (dr["HandlerName"].ToString() != "") model.HandlerName = dr["HandlerName"].ToString();
174            if (dr["ExpressCompany"].ToString() != "") model.ExpressCompany = dr["ExpressCompany"].ToString();
175            if (dr["ExpressNumber"].ToString() != "") model.ExpressNumber = dr["ExpressNumber"].ToString();
176            if (dr["Inputer"].ToString() != "") model.Inputer = dr["Inputer"].ToString();
177            if (dr["Remark"].ToString() != "") model.Remark = dr["Remark"].ToString();
178            if (dr["Received"].ToString() != "") model.Received    = Convert.ToInt16(dr["Received"]);
179
180            return model;
181        }
182
183        /**//// <summary>
184        /// 
185        /// </summary>
186        /// <param name="sql"></param>
187        /// <returns></returns>
188        public DataSet Query(string sql)
189        ...{
190            if (string.IsNullOrEmpty(sql))
191                return null;
192
193            DataSet dataset = new DataSet();
194            try
195            ...{
196
197                dataset = Database.ExecuteDataSet(sql);
198            }
199            catch (Exception ex)
200            ...{
201                throw ex;
202            }
203            return dataset;
204        }
205
206
207        /**//// <summary>
208        /// update  
209        /// </summary>
210        /// <param name="model"></param>
211        /// <param name="filter"></param>
212        /// <returns></returns>
213        public int Update(DeliverItemInfo model, string filter)
214        ...{
215            int result;
216            if (string.IsNullOrEmpty(filter))
217            ...{
218                throw new Exception("The 'filter' can not be null!");
219            }
220            string sql = @"update " + tableName + " set orderID=@orderID,deliverDate=@deliverDate,deliverDirection=@deliverDirection,handlerName=@handlerName,expressCompany=@expressCompany,expressNumber=@expressNumber,inputer=@inputer,Remark=@Remark,received=@received " + " where " + filter;
221
222
223            OleDbParameter[] prams = ...{
224                Database.MakeInParam("@OrderID",OleDbType.Integer,4,model.OrderID),
225                Database.MakeInParam("@DeliverDate",OleDbType.Date,8,model.DeliverDate),
226                Database.MakeInParam("@DeliverDirection",OleDbType.Integer,4,model.DeliverDirection),
227                Database.MakeInParam("@HandlerName",OleDbType.VarWChar,20,model.HandlerName),
228                Database.MakeInParam("@ExpressCompany",OleDbType.VarWChar,50,model.ExpressCompany),
229                Database.MakeInParam("@ExpressNumber",OleDbType.VarWChar,50,model.ExpressNumber),
230                Database.MakeInParam("@Inputer",OleDbType.VarWChar,20,model.Inputer),
231                Database.MakeInParam("@Remark",OleDbType.VarWChar,255,model.Remark),
232                Database.MakeInParam("@Received",OleDbType.UnsignedTinyInt,1,model.Received),
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
248        后台管理#region 后台管理
249
250        /**//// <summary>
251        /// 快速搜索
252        /// </summary>
253        /// <param name="searchType"></param>
254        /// <returns></returns>
255        public DataSet QuickSearch(int searchType)
256        ...{
257            string str = "Select * From " + this.tableName + " ";
258            string str2 = "";
259            switch (searchType)
260            ...{
261                case 1:
262                    str2 = " Where   DateDiff('d',DeliverDate,now()) < 10";
263                    break;
264
265                case 2:
266                    str2 = " Where DateDiff('m',DeliverDate,now()) < 1";
267                    break;
268
269                case 3:
270                    str2 = " Where  DeliverDirection= 1";
271                    break;
272
273                case 4:
274                    str2 = " Where  DeliverDirection= 2";
275                    break;
276