books_commongetlist.cs

简单的图书管理系统

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using KeYou.Books.DB;
namespace KeYou.Books.DL
{
    public class Books_CommonGetList
    {
        public DataSet GetList(string tblName, string fldName, string colOrder, int orderBy, string strWhere)
        {
            SqlParameter[] parameters = {
					new SqlParameter("@tblName", SqlDbType.VarChar, 255),
					new SqlParameter("@fldName", SqlDbType.VarChar, 255),
                    new SqlParameter ("@colOrder",SqlDbType.VarChar,100),
                    new SqlParameter("@orderBy",SqlDbType.Bit),
					new SqlParameter("@strWhere", SqlDbType.VarChar,1000),
					};

            parameters[0].Value = tblName;
            parameters[1].Value = fldName;
            parameters[2].Value = colOrder;
            parameters[3].Value = orderBy;
            parameters[4].Value = strWhere;
            return DbHelperSQL.RunProcedure("UP_GetRecordByStrWhere", parameters, "ds");
        }
    }
}