public virtual async Task <IEnumerable <PRODUCT> > SelectPaging(int start = 0, int end = 10, string query = "", string listcolumn = "") { var sql = "SELECT * FROM(SELECT ROW_NUMBER() OVER (order by id) AS ROWNUM, * FROM PRODUCT WHERE 1=1 " + query + ") as u WHERE RowNum BETWEEN @start AND @end ORDER BY RowNum;"; if (!string.IsNullOrEmpty(listcolumn)) { sql = sql.Replace("*", listcolumn); } var result = await DBManager <PRODUCT> .ExecuteReader(sql, new { start = start, end = end }); return(result); }
public virtual async Task <IEnumerable <BULKCOPY> > SelectByName(string Name, string listcolumn = "") { var sql = "SELECT TOP 1 * FROM BULKCOPY WHERE NAME LIKE @NAME+'%';"; if (!string.IsNullOrEmpty(listcolumn)) { sql = sql.Replace("*", listcolumn); } var result = await DBManager <BULKCOPY> .ExecuteReader(sql, new { NAME = Name }); return(result); }
public virtual async Task <IEnumerable <PRODUCT> > Select(int ID = 0, string listcolumn = "") { var sql = "SELECT * FROM PRODUCT "; if (!string.IsNullOrEmpty(listcolumn)) { sql = sql.Replace("*", listcolumn); } if (ID == 0) { var row = await DBManager <PRODUCT> .ExecuteReader(sql); return(row); } sql += " WHERE ID=@ID"; var result = await DBManager <PRODUCT> .ExecuteReader(sql, new { ID = ID }); return(result); }