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