public List <Model.PlantStockBin> GetTableData(Model.StoreParams store, ref int count)
{
string sqlWhere = AppendWhere(store.obj);
string order = store.sort + " " + store.dir;
order = string.IsNullOrEmpty(order.Trim()) ? " id asc " : order;
count = this.SqlQueryOne <int>("SELECT COUNT(1) FROM plant WHERE " + sqlWhere, null);
string sql = string.Format("SELECT id,plantCode as numberCode FROM plant WHERE {0} ORDER BY {1} LIMIT {2},{3}", sqlWhere, order, store.start, store.limit);
return(this.SqlQuery <PlantStockBin>(sql, null).ToList());
}
public List <Model.Operation> GetTableData(Model.StoreParams store, ref int count)
{
string sqlWhere = AppendWhere(store.obj);
string order = store.sort + " " + store.dir;
order = string.IsNullOrEmpty(order.Trim()) ? " id desc " : order;
count = this.SqlQueryOne <int>("SELECT COUNT(1) FROM operationView WHERE " + sqlWhere, null);
string sql = string.Format("select * from operationView WHERE {0} ORDER BY {1} LIMIT {2},{3}", sqlWhere, order, store.start, store.limit);
return(this.SqlQuery <Operation>(sql, null).ToList());
}
public List <PlantStockBin> GetTableData(Model.StoreParams storeParams, ref int count)
{
return(dal.GetTableData(storeParams, ref count));
}
public List <SAPRecord> GetTableData(Model.StoreParams storeParams, ref int count)
{
return(dal.GetTableData(storeParams, ref count));
}
public List <CargoConfig> GetTableData(Model.StoreParams storeParams, ref int count)
{
return(dal.GetTableData(storeParams, ref count));
}
public List <Rfid_bound> GetTableData(Model.StoreParams storeParams, int thisID, ref int count)
{
return(dal.GetTableData(storeParams, thisID, ref count));
}
public List <Rfid_tag> GetTableData(Model.StoreParams storeParams, ref int count)
{
return(dal.GetTableData(storeParams, ref count));
}
public List <Operation> GetTableData(Model.StoreParams storeParams, ref int count)
{
return(dal.GetTableData(storeParams, ref count));
}