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 InvoiceItem:IInvoiceItem
 11    ...{
 12        private ConfigInfo configInfo = new ConfigInfo();
 13        private string tableName = "Ljh_InvoiceItem";
 14
 15        public InvoiceItem()
 16        ...{
 17            if (!string.IsNullOrEmpty(configInfo.TablePrefix.Trim()))
 18                tableName = configInfo.TablePrefix + "InvoiceItem";
 19        }
 20        IOrder member#region IOrder member
 21
 22
 23        /**//// <summary>
 24        /// add  
 25        /// </summary>
 26        /// <param name="model"></param>
 27        /// <returns>返回ID, 如果发生错误则返回-1</returns>
 28        public int Add(InvoiceItemInfo model)
 29        ...{
 30            if (model == null)
 31            ...{
 32                return -1;
 33            }
 34            string commandText = "insert into " + this.tableName + "(clientID,userName,orderID,invoiceType,invoiceNum,invoiceTitle,invoiceContent,invoiceDate,totalMoney,drawer,inputer,inputTime)  values(@clientID,@userName,@orderID,@invoiceType,@invoiceNum,@invoiceTitle,@invoiceContent,@invoiceDate,@totalMoney,@drawer,@inputer,@inputTime)  ";
 35            OleDbParameter[] commandParameters = ...{
 36                Database.MakeInParam("@ClientID",OleDbType.Integer,4,model.ClientID),
 37                Database.MakeInParam("@UserName",OleDbType.VarWChar,50,model.UserName),
 38                Database.MakeInParam("@OrderID",OleDbType.Integer,4,model.OrderID),
 39                Database.MakeInParam("@InvoiceType",OleDbType.Integer,4,model.InvoiceType),
 40                Database.MakeInParam("@InvoiceNum",OleDbType.VarWChar,50,model.InvoiceNum),
 41                Database.MakeInParam("@InvoiceTitle",OleDbType.VarWChar,50,model.InvoiceTitle),
 42                Database.MakeInParam("@InvoiceContent",OleDbType.VarWChar,0,model.InvoiceContent),
 43                Database.MakeInParam("@InvoiceDate",OleDbType.Date,8,model.InvoiceDate),
 44                Database.MakeInParam("@TotalMoney",OleDbType.Currency,8,model.TotalMoney),
 45                Database.MakeInParam("@Drawer",OleDbType.VarWChar,50,model.Drawer),
 46                Database.MakeInParam("@Inputer",OleDbType.VarWChar,50,model.Inputer),
 47                Database.MakeInParam("@InputTime",OleDbType.Date,8,model.InputTime)
 48
 49         };
 50            int intIdentity = -1;
 51            try
 52            ...{
 53                Database.ExecuteNonQuery(CommandType.Text, out intIdentity, commandText, commandParameters);
 54            }
 55            catch (Exception exception)
 56            ...{
 57                throw exception;
 58            }
 59            return intIdentity;
 60        }
 61
 62
 63
 64
 65        /**//// <summary>
 66        /// 删除 
 67        /// </summary>
 68        /// <param name="filter">where后面的条件语句，不加where</param>
 69        /// <returns>返回影响行数</returns>
 70        public int Delete(string filter)
 71        ...{
 72            int count = -1;
 73            string sql = @"delete from " + tableName;
 74            if (!string.IsNullOrEmpty(filter.Trim()))
 75            ...{
 76                sql = sql + "  where  " + filter;
 77            }
 78            try
 79            ...{
 80
 81                count = Database.ExecuteNonQuery(sql);
 82            }
 83            catch (Exception ex)
 84            ...{
 85                throw ex;
 86            }
 87            return count;
 88        }
 89
 90        /**//// <summary>
 91        /// 
 92        /// </summary>
 93        /// <param name="filter"></param>
 94        /// <returns></returns>
 95        public bool Exist(string filter)
 96        ...{
 97            bool result = false;
 98            string sql = @"select * from " + tableName;
 99            if (!string.IsNullOrEmpty(filter))
100            ...{
101                sql = sql + "  where  " + filter;
102            }
103            try
104            ...{
105
106
107                DataSet dataset = new DataSet();
108                dataset = Database.ExecuteDataSet(sql);
109                if (dataset.Tables[0].Rows.Count > 0)
110                ...{
111                    result = true;
112                }
113            }
114            catch (Exception ex)
115            ...{
116                throw ex;
117            }
118            return result;
119        }
120
121        /**//// <summary>
122        /// 返回所有
123        /// </summary>
124        /// <returns>返回所有</returns>
125        public DataSet GetDataSet()
126        ...{
127            string sql = "select * from " + tableName;
128            DataSet dataset = new DataSet();
129            try
130            ...{
131
132                dataset = Database.ExecuteDataSet(sql);
133
134            }
135            catch (Exception ex)
136            ...{
137                throw ex;
138            }
139            return dataset;
140        }
141
142        public DataSet GetDataSet(string filter)
143        ...{
144            if (string.IsNullOrEmpty(filter))
145                return null;
146
147            string sql = "select * from " + tableName + " where " + filter;
148            DataSet dataset = new DataSet();
149            try
150            ...{
151
152                dataset = Database.ExecuteDataSet(sql);
153            }
154            catch (Exception ex)
155            ...{
156                throw ex;
157            }
158            return dataset;
159        }
160
161        /**//// <summary>
162        ///
163        /// </summary>
164        /// <param name="dr"></param>
165        /// <returns></returns>
166        public InvoiceItemInfo GetModel(DataRow dr)
167        ...{
168            if (dr == null)
169                return null;
170            InvoiceItemInfo model = new InvoiceItemInfo();
171
172            if (dr["InvoiceID"].ToString() != "") model.InvoiceID = int.Parse( dr["InvoiceID"].ToString());
173            if (dr["clientID"].ToString() != "") model.ClientID = int.Parse(  dr["clientID"].ToString());
174            if (dr["UserName"].ToString() != "") model.UserName = dr["UserName"].ToString();
175            if (dr["orderID"].ToString() != "") model.OrderID = int.Parse(  dr["orderID"].ToString());
176            if (dr["InvoiceType"].ToString() != "") model.InvoiceType = int.Parse(  dr["InvoiceType"].ToString());
177            if (dr["InvoiceNum"].ToString() != "") model.InvoiceNum = dr["InvoiceNum"].ToString();
178            if (dr["InvoiceTitle"].ToString() != "") model.InvoiceTitle = dr["InvoiceTitle"].ToString();
179            if (dr["InvoiceContent"].ToString() != "") model.InvoiceContent = dr["InvoiceContent"].ToString();
180            if (dr["InvoiceDate"].ToString() != "") model.InvoiceDate = dr["InvoiceDate"].ToString();
181            if (dr["totalMoney"].ToString() != "") model.TotalMoney = decimal.Parse( dr["totalMoney"].ToString());
182            if (dr["drawer"].ToString() != "") model.Drawer = dr["drawer"].ToString();
183            if (dr["inputer"].ToString() != "") model.Inputer = dr["inputer"].ToString();
184            if (dr["InputTime"].ToString() != "") model.InputTime =  dr["InputTime"].ToString();
185
186
187
188            return model;
189        }
190
191        /**//// <summary>
192        /// 
193        /// </summary>
194        /// <param name="sql"></param>
195        /// <returns></returns>
196        public DataSet Query(string sql)
197        ...{
198            if (string.IsNullOrEmpty(sql))
199                return null;
200
201            DataSet dataset = new DataSet();
202            try
203            ...{
204
205                dataset = Database.ExecuteDataSet(sql);
206            }
207            catch (Exception ex)
208            ...{
209                throw ex;
210            }
211            return dataset;
212        }
213
214
215        /**//// <summary>
216        /// update  
217        /// </summary>
218        /// <param name="model"></param>
219        /// <param name="filter"></param>
220        /// <returns></returns>
221        public int Update(InvoiceItemInfo model, string filter)
222        ...{
223            int result;
224            if (string.IsNullOrEmpty(filter))
225            ...{
226                throw new Exception("The 'filter' can not be null!");
227            }
228            string sql = @"update " + tableName + " set clientID=@clientID,UserName=@UserName,orderID=@orderID,InvoiceType=@InvoiceType,InvoiceNum=@InvoiceNum,InvoiceTitle=@InvoiceTitle,InvoiceContent=@InvoiceContent,InvoiceDate=@InvoiceDate,totalMoney=@totalMoney,drawer=@drawer,inputer=@inputer,InputTime=@InputTime " + " where " + filter;
229
230
231            OleDbParameter[] prams = ...{
232                Database.MakeInParam("@ClientID",OleDbType.Integer,4,model.ClientID),
233                Database.MakeInParam("@UserName",OleDbType.VarWChar,50,model.UserName),
234                Database.MakeInParam("@OrderID",OleDbType.Integer,4,model.OrderID),
235                Database.MakeInParam("@InvoiceType",OleDbType.Integer,4,model.InvoiceType),
236                Database.MakeInParam("@InvoiceNum",OleDbType.VarWChar,50,model.InvoiceNum),
237                Database.MakeInParam("@InvoiceTitle",OleDbType.VarWChar,50,model.InvoiceTitle),
238                Database.MakeInParam("@InvoiceContent",OleDbType.VarWChar,0,model.InvoiceContent),
239                Database.MakeInParam("@InvoiceDate",OleDbType.Date,8,model.InvoiceDate),
240                Database.MakeInParam("@TotalMoney",OleDbType.Currency,8,model.TotalMoney),
241                Database.MakeInParam("@Drawer",OleDbType.VarWChar,50,model.Drawer),
242                Database.MakeInParam("@Inputer",OleDbType.VarWChar,50,model.Inputer),
243                Database.MakeInParam("@InputTime",OleDbType.Date,8,model.InputTime)
244         };
245
246            try
247            ...{
248
249                result = Database.ExecuteNonQuery(sql, prams);
250            }
251            catch (Exception ex)
252            ...{
253                throw ex;
254            }
255            return result;
256        }
257
258
259
260        RunPoc#region RunPoc
261
262        /**//// <summary>
263        /// 快速搜索
264        /// </summary>
265        /// <param name="searchType"></param>
266        /// <returns></returns>
267        public DataSet QuickSearch(int searchType)
268        ...{
269            string str = "Select * From " + this.tableName + " ";
270            string