예제 #1
0
 public string GetView(DataByPage datapage)
 {
     DataTable table = new DataTable();
     table.RowHead = this.rowHeah;
     table.RowText = this.rowText;
     table.DataReader = datapage.DataReader;
     string str = table.GetDataTable() + datapage.PageToolBar;
     datapage.Dispose();
     datapage = null;
     table = null;
     return str;
 }
예제 #2
0
 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;
 }
예제 #3
0
 /// <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;
 }
예제 #4
0
 /// <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;
 }
예제 #5
0
 /// <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;
 }
예제 #6
0
 /// <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;
 }
예제 #7
0
 /// <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;
 }
예제 #8
0
 /// <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;
 }
예제 #9
0
 /// <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;
 }
예제 #10
0
 /// <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;
 }