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
}
}