当前文件路径：MyShop/BLL/Log.cs

		            
  1using System;
  2using System.Collections.Generic;
  3
  4using System.Data;
  5
  6
  7using MyShop.DALFactory;
  8using MyShop.IDAL;
  9using MyShop.Model;
 10
 11namespace MyShop.BLL
 12...{
 13    public class Log
 14    ...{
 15
 16        private ILog dal = DataAccess.CreateLog();
 17
 18        ILog#region  ILog
 19
 20        public int Add(LogInfo model)
 21        ...{
 22            if (model == null)
 23            ...{
 24                return 0;
 25            }
 26            return dal.Add(model);
 27        }
 28
 29        public int Delete(string filter)
 30        ...{
 31            if (string.IsNullOrEmpty(filter))
 32                return 0;
 33            return dal.Delete(filter);
 34        }
 35
 36        public bool Exist(string filter)
 37        ...{
 38            filter = filter.Trim();
 39            if (string.IsNullOrEmpty(filter))
 40                return false;
 41            return dal.Exist(filter);
 42        }
 43        public DataSet GetDataSet()
 44        ...{
 45            return dal.GetDataSet();
 46        }
 47
 48        public DataSet GetDataSet(string filter)
 49        ...{
 50            filter = filter.Trim();
 51            if (string.IsNullOrEmpty(filter))
 52                return null;
 53            return dal.GetDataSet(filter);
 54        }
 55
 56        public LogInfo GetModel(DataRow dr)
 57        ...{
 58            if (dr == null)
 59                return null;
 60            return dal.GetModel(dr);
 61        }
 62
 63        private DataSet Query(string sql)
 64        ...{
 65            sql = sql.Trim();
 66            if (string.IsNullOrEmpty(sql))
 67                return null;
 68            return dal.Query(sql);
 69        }
 70
 71        public int Update(LogInfo model, string filter)
 72        ...{
 73            if (model == null)
 74                return 0;
 75            filter = filter.Trim();
 76            if (string.IsNullOrEmpty(filter))
 77                return 0;
 78            return dal.Update(model, filter);
 79        }
 80
 81        #endregion
 82
 83        common#region common
 84
 85        public int Add(LogInfo model, out string msg)
 86        ...{
 87            msg = "";
 88            if (model == null)
 89            ...{
 90                msg = msg + "<li>数据不能为空</li>";
 91                return 0;
 92            }
 93            bool isErr = false;
 94
 95            if (isErr)
 96                return 0;
 97
 98            int count = 0;
 99            count = Add(model);
100            if (count == 0)
101                msg = "<li>系统发生错误,请重新添加!</li>";
102            if (count == 1)
103                msg = "<li>添加成功!</li>";
104            return count;
105        }
106
107        public int Delete(int logId)
108        ...{
109            if (string.IsNullOrEmpty(logId.ToString()))
110                return 0;
111            string filer;
112            filer = " logId =" + logId;
113            return Delete(filer);
114        }
115        public int Update(LogInfo model)
116        ...{
117
118            if (model == null)
119            ...{
120                return 0;
121            }
122            string filter;
123            filter = " logId=" + model.LogID;
124            return Update(model, filter);
125        }
126
127        public LogInfo GetModel(int logId)
128        ...{
129            DataSet dataset = new DataSet();
130            dataset = GetDataSet(" logId=" + logId);
131            if (dataset != null && dataset.Tables[0].Rows.Count > 0)
132                return GetModel(dataset.Tables[0].Rows[0]);
133            return null;
134        }
135
136        #endregion
137
138
139        后台管理#region 后台管理
140
141        /**//// <summary>
142        /// 快速搜索
143        /// </summary>
144        /// <param name="trademarkType"></param>
145        /// <returns></returns>
146        public DataSet QuickSearchByLogType(int logType)
147        ...{
148            DataSet ds = new DataSet();
149            string filter = " logType=" + logType + "  order by LogId desc  ";
150            return GetDataSet(filter);
151        }
152
153        /**//// <summary>
154        /// 高级查询
155        /// </summary>
156        /// <param name="field"></param>
157        /// <param name="keywords"></param>
158        /// <returns></returns>
159        public DataSet KeywordsSearch(string field, string keywords)
160        ...{
161            field = field.Trim();
162            keywords = keywords.Trim();
163            if( string.IsNullOrEmpty(field) || string.IsNullOrEmpty(keywords) )
164                return null;
165            DataSet ds = new DataSet();
166
167            return GetDataSet(" " + Utils.ReplaceBadSQL(field) + " like '%" + Utils.ReplaceBadSQL(keywords) + "%'  order by LogId desc  ");
168        }
169
170        /**//// <summary>
171        /// 删除两天以前的日志
172        /// </summary>
173        /// <returns></returns>
174        public int DeleteLogBeforeTwoDays()
175        ...{
176            return dal.DeleteLogBeforeTwoDays();
177        }
178
179        public DataSet GetDataSetOrderByLogId()
180        ...{
181            return GetDataSet(" LogId > 0 order by LogId desc  ");
182        }
183        #endregion
184    }
185}
186