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

		            
  1using System;
  2using System.Collections.Generic;
  3using System.Data;
  4
  5
  6using MyShop.DALFactory;
  7using MyShop.IDAL;
  8using MyShop.Model;
  9
 10namespace MyShop.BLL
 11...{
 12    public class City
 13    ...{
 14        private ICity dal = DataAccess.CreateCity();
 15        public City() ...{ }
 16        ICategory member#region ICategory member
 17
 18        protected int Add(CityInfo model)
 19        ...{
 20            if (model == null)
 21                return 0;
 22            return dal.Add(model);
 23        }
 24        public int Delete(string filter)
 25        ...{
 26            if (string.IsNullOrEmpty(filter))
 27                return 0;
 28            return dal.Delete(filter);
 29        }
 30
 31        public bool Exist(string filter)
 32        ...{
 33            filter = filter.Trim();
 34            if (string.IsNullOrEmpty(filter))
 35                return false;
 36            return dal.Exist(filter);
 37        }
 38
 39        public DataSet GetDataSet()
 40        ...{
 41            return dal.GetDataSet();
 42        }
 43        public DataSet GetDataSet(string filter)
 44        ...{
 45            filter = filter.Trim();
 46            if (string.IsNullOrEmpty(filter))
 47                return null;
 48            return dal.GetDataSet(filter);
 49        }
 50        public DataSet GetDataSet(int AreaId)
 51        ...{
 52            if (AreaId <= 0)
 53                return null;
 54            string filter = " AreaId=" + AreaId;
 55            return GetDataSet(filter);
 56        }
 57        public CityInfo GetModel(DataRow dr)
 58        ...{
 59            if (dr == null)
 60                return null;
 61            return dal.GetModel(dr);
 62        }
 63
 64        private DataSet Query(string sql)
 65        ...{
 66            sql = sql.Trim();
 67            if (string.IsNullOrEmpty(sql))
 68                return null;
 69            return dal.Query(sql);
 70        }
 71
 72        protected int Update(CityInfo model, string filter)
 73        ...{
 74            if (model == null)
 75                return 0;
 76            filter = filter.Trim();
 77            if (string.IsNullOrEmpty(filter))
 78                return 0;
 79            return dal.Update(model, filter);
 80        }
 81        //-------------------------
 82        #endregion
 83
 84        common#region common
 85
 86        public int Add(CityInfo model, out string msg)
 87        ...{
 88            msg = "";
 89            if (model == null)
 90            ...{
 91                msg = msg + "<li>数据不能为空</li>";
 92                return 0;
 93            }
 94
 95            bool isErr = false;
 96
 97            if (isErr)
 98                return 0;
 99
100            int count = 0;
101            count = Add(model);
102            if (count == 0)
103                msg = "<li>系统发生错误,请重新添加!</li>";
104            if (count == 1)
105                msg = "<li>添加成功!</li>";
106            return count;
107        }
108
109        public int Delete(int AreaId)
110        ...{
111            if (string.IsNullOrEmpty(AreaId.ToString()))
112                return 0;
113            string filer;
114            filer = " AreaId =" + AreaId;
115            return Delete(filer);
116        }
117        public int Update(CityInfo model)
118        ...{
119
120            if (model == null)
121            ...{
122                return 0;
123            }
124            string filter;
125            filter = " AreaId=" + model.AreaId;
126            return Update(model, filter);
127        }
128
129        public CityInfo GetModel(int AreaId)
130        ...{
131            DataSet dataset = new DataSet();
132            dataset = GetDataSet(" AreaId=" + AreaId);
133            if (dataset != null && dataset.Tables[0].Rows.Count > 0)
134                return GetModel(dataset.Tables[0].Rows[0]);
135            return null;
136
137        }     
138
139        #endregion
140
141        public DataSet GetProvinceList()
142        ...{
143
144            return dal.GetProvinceList();
145        }
146    }
147}
148