/// <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)); }