//them
public DataTable GetAllBox()
{
IDbCommand cmd = _db.CreateCommand("GetAllBox", true);
DataTable table = _db.CreateDataTable(cmd);
return(table);
}
protected virtual IDbCommand CreateGetCommand(string whereSql, string orderBySql)
{
string sql = "SELECT * FROM [dbo].[User_Permission]";
if (null != whereSql && 0 < whereSql.Length)
{
sql += " WHERE " + whereSql;
}
if (null != orderBySql && 0 < orderBySql.Length)
{
sql += " ORDER BY " + orderBySql;
}
return(_db.CreateCommand(sql));
}
public DataTable vc_Execute_Sql(String sSql)
{
IDbCommand cmd = _db.CreateCommand("vc_Execute_Sql", true);
_db.AddParameter(cmd, "sSql", DbType.String, sSql);
DataTable table = _db.CreateDataTable(cmd);
return(table);
}