App_Code/DAL/dalBookType.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Data;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;

using ENTITY;

namespace DAL
{
    public class  dalBookType
    {
        public static string sql = "";

        public static bool AddBookType(ENTITY.BooType bookType)
        {
            string sql = "insert into BookType(typeName) values(@typeName)";
            SqlParameter[] parm = new SqlParameter[] { 
             new SqlParameter("@typeName",SqlDbType.VarChar)
            };
            parm[0].Value = bookType.typeName; 

            return (DBHelp.ExecuteNonQuery(sql, parm) > 0) ? true : false;
        }

        public static ENTITY.BooType getSomeBookType(int typeId)
        {
            string sql = "select * from BookType where  typeId=" + typeId;
            SqlDataReader DataRead = DBHelp.ExecuteReader(sql, null);
            ENTITY.BooType bookeType = new ENTITY.BooType();
            while (DataRead.Read())
            {
                bookeType.typeId = Convert.ToInt32(DataRead["typeId"]); 
                bookeType.typeName = DataRead["typeName"].ToString(); 

            }
            return bookeType;

        }

        public static bool EditBookType(ENTITY.BooType bookType)
        {
            string sql = "update BookType set typeName=@typeName  where typeId=@typeId";
            SqlParameter[] parm = new SqlParameter[] {  
             new SqlParameter("@typeName",SqlDbType.VarChar),
             new SqlParameter("@typeId",SqlDbType.Int),
            };
            parm[0].Value = bookType.typeName;
            parm[1].Value = bookType.typeId;

            return (DBHelp.ExecuteNonQuery(sql, parm) > 0) ? true : false;
        }