public string GetView()
{
DataByPage page = new DataByPage();
page.Sql = this.sql;
page.GetRecordSetByPage();
DataTable table = new DataTable();
table.RowHead = this.rowHeah;
table.RowText = this.rowText;
table.DataReader = page.DataReader;
string str = table.GetDataTable() + page.PageToolBar;
page.Dispose();
page = null;
table = null;
return str;
}
/// <summary>
/// 查询购物车
/// </summary>
/// <param name="condition">条件</param>
/// <returns></returns>
public DataByPage GetProfilesList(string condition)
{
string sql = "[select] * [from] yxs_profiles [where] 1=1" + condition + " [order by] uniqueid desc";
ChangeHope.DataBase.DataByPage datapage = new DataByPage();
datapage.Sql = sql;
datapage.GetRecordSetByPage();
return datapage;
}
/// <summary>
/// 查询购物车产品
/// </summary>
/// <returns></returns>
public DataByPage GetCartProduct(string uniqueid)
{
string sql = "[select] yxs_product.pro_ID,yxs_product.pro_Name,yxs_product.pro_ShopPrice,yxs_product.pro_RatingDiscount,yxs_cart.quantity,yxs_cart.addtime [from] yxs_cart inner join yxs_product on yxs_product.pro_ID=yxs_cart.productid [where] yxs_cart.uniqueid=" + uniqueid + " [order by] pro_Id desc";
ChangeHope.DataBase.DataByPage datapage = new DataByPage();
datapage.Sql = sql;
datapage.GetRecordSetByPage();
return datapage;
}
/// <summary>
/// 获得数据列表
/// </summary>
public ChangeHope.DataBase.DataByPage GetListByPage(string sqlWhere)
{
ChangeHope.DataBase.DataByPage datapage = new DataByPage();
datapage.Sql = "[select] *,(select content from yxs_code_order_step where code=" + tableName + ".OrderStatus) as OrderStatusContent [from] " + tableName + " [where] 1=1 " + sqlWhere + " [order by] OrderDate desc";
datapage.GetRecordSetByPage();
return datapage;
}
/// <summary>
/// 前台
/// </summary>
/// <param name="orderfield"></param>
/// <param name="pagesize"></param>
/// <param name="Conditions"></param>
/// <returns></returns>
public ChangeHope.DataBase.DataByPage GetList(string orderfield, int pagesize, string Conditions)
{
ChangeHope.DataBase.DataByPage dataPage = new ChangeHope.DataBase.DataByPage();
dataPage.Sql = "[select] *,(select content from yxs_code_order_step where code=" + tableName + ".OrderStatus) as OrderStatusContent [from] " + tableName + " [where] 1=1 " + Conditions + " " + orderfield;
dataPage.PageSize = pagesize;
dataPage.GetRecordSetByPage();
return dataPage;
}
/// <summary>
/// 获得数据列表
/// </summary>
public DataByPage GetListByPage()
{
DataByPage datapage = new DataByPage();
datapage.Sql = "[select] * [from] " + tableName + " [where] 1=1 [order by] id asc";
datapage.GetRecordSetByPage();
return datapage;
}
/// <summary>
/// 查询所有记录
/// </summary>
/// <remarks></remarks>
public ChangeHope.DataBase.DataByPage GetList(string orderfield, int pagesize, string Conditions)
{
ChangeHope.DataBase.DataByPage dataPage = new ChangeHope.DataBase.DataByPage();
dataPage.Sql = "[select] * [from] " + tableName + " [where] 1=1 " + Conditions + " " + orderfield;
dataPage.PageSize = pagesize;
dataPage.GetRecordSetByPage();
return dataPage;
}
/// <summary>
/// 分页列表
/// </summary>
/// <returns></returns>
public ChangeHope.DataBase.DataByPage GetList()
{
ChangeHope.DataBase.DataByPage dataPage = new DataByPage();
dataPage.Sql = "[select] * [from] yxs_remittanceinfo [where] 1=1 [order by] id asc";
dataPage.GetRecordSetByPage();
return dataPage;
}
/// <summary>
/// 跟据条件查询
/// </summary>
/// <param name="StrWhere">条件</param>
/// <returns></returns>
public ChangeHope.DataBase.DataByPage GetListByPage(string StrWhere)
{
ChangeHope.DataBase.DataByPage datapage = new DataByPage();
datapage.Sql = "[select] * [from] " + tableName + " [where] 1=1 "+StrWhere+" [order by] id asc";
datapage.GetRecordSetByPage();
return datapage;
}