using System; using System.Text; using System.Collections.Generic; using System.Data; using ShopMobile.Model; namespace ShopMobile.Bll { //PT_Base_Site public partial class PT_Base_Site { private readonly ShopMobile.Dal.PT_Base_Site dal = new ShopMobile.Dal.PT_Base_Site(); public PT_Base_Site() { } #region Method /// /// 是否存在该记录 /// public bool Exists(int ID) { return dal.Exists(ID); } /// /// 增加一条数据 /// public int Add(ShopMobile.Model.PT_Base_Site model) { return dal.Add(model); } /// /// 更新一条数据 /// public bool Update(ShopMobile.Model.PT_Base_Site model) { return dal.Update(model); } /// /// 删除一条数据 /// public bool Delete(int ID) { return dal.Delete(ID); } /// /// 批量删除一批数据 /// public bool DeleteList(string IDlist) { return dal.DeleteList(IDlist); } /// /// 得到一个对象实体 /// public ShopMobile.Model.PT_Base_Site GetModel(int ID) { return dal.GetModel(ID); } /// /// 获得数据列表 /// public DataSet GetList(string strWhere) { return dal.GetList(strWhere); } /// /// 获得前几行数据 /// public DataSet GetList(int Top, string strWhere, string filedOrder) { return dal.GetList(Top, strWhere, filedOrder); } /// /// 获得数据列表 /// public List GetModelList(string strWhere) { DataSet ds = dal.GetList(strWhere); return DataTableToList(ds.Tables[0]); } /// /// 获得数据列表 /// public List DataTableToList(DataTable dt) { List modelList = new List(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { ShopMobile.Model.PT_Base_Site model; for (int n = 0; n < rowsCount; n++) { model = new ShopMobile.Model.PT_Base_Site(); if (dt.Rows[n]["ID"].ToString() != "") { model.ID = int.Parse(dt.Rows[n]["ID"].ToString()); } model.WX_AppID = dt.Rows[n]["WX_AppID"].ToString(); model.WX_AppSecret = dt.Rows[n]["WX_AppSecret"].ToString(); model.WX_MCHID = dt.Rows[n]["WX_MCHID"].ToString(); model.WX_KEY = dt.Rows[n]["WX_KEY"].ToString(); model.SiteName = dt.Rows[n]["SiteName"].ToString(); model.Alipay_PublicKey = dt.Rows[n]["Alipay_PublicKey"].ToString(); model.SiteLogo = dt.Rows[n]["SiteLogo"].ToString(); model.SiteTel = dt.Rows[n]["SiteTel"].ToString(); model.SiteQQ = dt.Rows[n]["SiteQQ"].ToString(); model.SearchKey = dt.Rows[n]["SearchKey"].ToString(); model.Alipay_No = dt.Rows[n]["Alipay_No"].ToString(); model.Alipay_PID = dt.Rows[n]["Alipay_PID"].ToString(); model.Alipay_PrivateKey = dt.Rows[n]["Alipay_PrivateKey"].ToString(); modelList.Add(model); } } return modelList; } /// /// 获得数据列表 /// public DataSet GetAllList() { return GetList(""); } #endregion } }