/// <summary>
/// 根据ID查询不同价格
/// </summary>
/// <param name="ID"></param>
/// <returns></returns>
public DataTable GetPriceByID(string ID)
{
string sql = "SELECT * FROM dbo.Price WHERE ID='" + ID + "'";
BLL.DbBase db = new BLL.DbBase();
return(db.ExecuteTable(sql));
}
public DataTable GetRegion(int ParentId)
{
string sql = string.Format("select ID,Name from Region where ParentId={0}", ParentId);
BLL.DbBase db = new BLL.DbBase();
db.ChangeDBShop();
return(db.ExecuteTable(sql));
}
public DataTable GetRegionAll()
{
string sql = "SELECT * FROM dbo.Region";
BLL.DbBase db = new BLL.DbBase();
db.ChangeDBShop();
return(db.ExecuteTable(sql));
}