private DataTable Sales()
{
string sql = "select * from lms_sale_order_master master join lms_sale_order_item item on master.master_id=item.master_id join lms_saleitem_detail detail on item.item_id=detail.item_id ";
return database.selectResultToTable(sql);
}
public DataSet SaleOrder()
{
if (ds == null)
{
ds = new DataSet();
ds.Tables.Add(Sales());
}
return ds;
}
请教各位了
{
string sql = "select * from lms_sale_order_master master join lms_sale_order_item item on master.master_id=item.master_id join lms_saleitem_detail detail on item.item_id=detail.item_id ";
return database.selectResultToTable(sql);
}
public DataSet SaleOrder()
{
if (ds == null)
{
ds = new DataSet();
ds.Tables.Add(Sales());
}
return ds;
}
请教各位了
是两个表还是一个表?
select *, row=row_number() over(order by 1)
from 表
)a where row between (页号 -1) * 每页页数 + 1 and 页号 * 每页页数
lms_saleitem_detail 这个是表明 detail 这个是给这个表起的别名
return database.selectResultToTable(sql); 多谢!