//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));
        }
Пример #3
0
        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);
        }