后台通用逻辑语句

 #region 通用查询：管理页面
        public DataSet GetInfo(int pageno, int pagesize, string condition, string tablename, string fields,string showFields)
        {
            string strSQL = string.Format("select count(*) from {4} where 1=1 {0};select top {1} *  from (select row_number() over(order by {3}) as rowNumber,{5} from  {4} where 1=1 {0}) as a where a.rowNumber>{1}*({2}-1)", condition, pagesize, pageno, fields, tablename,showFields);
            DataSet ds = db.ExecSQLReDataSet(strSQL);
            if (db.IsError)
            {
                this.strErrMessage = db.ErrorMessage;
                return null;
            }
            else
            {
                return ds;
            }
        }
        #endregion

        #region 通用方法：根据查询条件查询表信息
        public DataTable GetDTInfo( string tablename, string fields,string condition)
        {
            string strSQL = string.Format("select {0} from {1} where 1=1 {2}", fields, tablename, condition);
            DataTable dt = db.ExecSQLReDataTable(strSQL);
            if (db.IsError)
            {
                this.strErrMessage = db.ErrorMessage;
                return null;
            }
            else
            {
                return dt;
            }
        }
        #endregion

        #region 通用方法：得到某表具体字段的值
        public string getStrInfo(string tableName, string field, string condition)
        {
            string info = "";
            string[] fields = field.Split(',');
            string sql = string.Format("select " + field + " from " + tableName + " where 1=1 " + condition);
            DataTable dt = db.ExecSQLReDataTable(sql);
            if (dt != null && dt.Rows.Count > 0)
            {
                for (int i = 0; i < fields.Length; i++)
                {
                    info += dt.Rows[0][i].ToString()+",";
                }
                   
            }
            info = info.TrimEnd(',');
            return info;
        }
        #endregion

        #region 通用方法：插入
        public Boolean InsertInfo(string tableName, string field, string value)
        {
            Boolean flag = false;

            string sql = string.Format("insert into {0} ({1}) values ({2})",tableName,field,value);

            int i = db.ExecSQLReInt(sql);
            if (i > 0)
            {
                flag = true;
            }
            return flag;
        }
        #endregion

        #region 通用方法：删除
        public Boolean DeleteTableInfo(string tableName, string condition)
        {
            Boolean flag = false;

            string sql = string.Format("delete from  {0} where {1}", tableName, condition);

            int i = db.ExecSQLReInt(sql);
            if (i > 0)
            {
                flag = true;
            }
            return flag;
        }
        #endregion