示例#1
0
        /// <summary>
        /// 删除一条数据

        /// </summary>
        public bool BasModuleDelete(string id)
        {
            string strSql = "delete from Bas_Module where module_id =" + id + " and module_id not in (select module_id from bas_module_role ) ";

            return(DataBase.ExecuteNonQuery(strSql) > 0 ? true : false);
        }
示例#2
0
        /// <summary>
        /// 获得数据总记录数
        /// </summary>
        public int ParamTotalCount(Dictionary <string, string> dict)
        {
            string strSql = "select count(*) from (" + StringSql(dict) + ") a";

            return(int.Parse(DataBase.ExecuteScalarToStr(strSql)));
        }
示例#3
0
        /// <summary>
        /// 是否存在该记录
        /// </summary>
        public bool ParamExists(string strWhere)
        {
            string strSql = " select count(*) from bas_param where 1=1 " + strWhere;

            return(int.Parse(DataBase.ExecuteScalarToStr(strSql)) > 0 ? true : false);
        }