public virtual async Task <int> GetCount(string query = "")
{
var sql = "SELECT COUNT(1) AS CNT FROM PRODUCT WHERE 1=1 " + query;
var result = await DBManager <PRODUCT> .ExecuteScalar(sql);
return(Convert.ToInt32(result));
}
public async Task <int> SpecialCount()
{
var sql = string.Format(@"
SELECT SUM (row_count)
FROM sys.dm_db_partition_stats
WHERE object_id=OBJECT_ID('PRODUCT')
AND (index_id=0 or index_id=1);
");
var result = await DBManager <PRODUCT> .ExecuteScalar(sql);
return(Convert.ToInt32(result));
}
