public virtual int GetCount(string sqlWhere)
{
string sqlStr = "Select Count(*) From [dbo].[ThreadDetails]" + ((sqlWhere == "") ? "" : (" Where " + sqlWhere));
IDbCommand cmd = _db.CreateCommand(sqlStr);
return(Convert.ToInt32(cmd.ExecuteScalar()));
}
public DataTable NewsPublished_GetNewsModeByCat(string Cat_ID)
{
IDbCommand cmd = _db.CreateCommand("NewsPublished_GetNewsModeByCat", true);
_db.AddParameter(cmd, "Cat_ID", DbType.String, Cat_ID);
DataTable table = _db.CreateDataTable(cmd);
return(table);
}
public DataTable proc_CategoryLayout_Insert(int Cat_ID, int CellIndex, int ProductID)
{
IDbCommand cmd = _db.CreateCommand("proc_CategoryLayout_Insert", true);
_db.AddParameter(cmd, "Cat_ID", DbType.Int32, Cat_ID);
_db.AddParameter(cmd, "CellIndex", DbType.Int32, CellIndex);
_db.AddParameter(cmd, "ProductID", DbType.Int32, ProductID);
DataTable table = _db.CreateDataTable(cmd);
return(table);
}