bookconcerninfo.cs

数据库课程设计

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using Common;
namespace DataAccess
{
      public  class BookConcernInfo
    {
          CommonOperator ComOP = new CommonOperator();
          /// <summary>
          /// 查询所有的出版商信息
          /// </summary>
          /// <returns></returns>
          public DataTable SelectBookConcernInfo()
          {
             
              DataTable objBookConcernInfoTable = new DataTable();
              string sql = "select BookConcernID  as '出版商ID',BookConcernName  as '出版商名称',BookConcernAddress  as '出版商地址',"+
                  "BookConcerntell as '联系方式' from BookConcern";
              string sqlTable = "BookConcernInfo";
              try
              {
                  ComOP.ConnectDb();
                  objBookConcernInfoTable = ComOP.Search(sql, sqlTable);
              }
              catch (Exception ex)
              {
                  throw ex;
              }
              finally
              {
                  ComOP.CloseDb();
              }
              return objBookConcernInfoTable;
          }
          /// <summary>
          /// 根据出版商ID进行模糊查找
          /// </summary>
          /// <param name="BookConcernID"></param>
          /// <returns></returns>
          public DataTable SelectLikeBookConcernID(string BookConcernID)
          {

              DataTable objBookConcernInfoTable = new DataTable();
              string sql = "select BookConcernID  as '出版商ID',BookConcernName  as '出版商名称',BookConcernAddress  as '出版商地址'," +
                  "BookConcerntell as '联系方式' from BookConcern where BookConcernID like '%" + BookConcernID + "%'";
              string sqlTable = "BookConcernID";
              try
              {
                  ComOP.ConnectDb();
                  objBookConcernInfoTable = ComOP.Search(sql, sqlTable);
              }
              catch (Exception ex)
              {
                  throw ex;
              }
              finally
              {
                  ComOP.CloseDb();
              }
              return objBookConcernInfoTable;
          }
          /// <summary>
          /// 根据出版商名称进行模糊查找
          /// </summary>
          /// <param name="BookConcernName"></param>
          /// <returns></returns>
          public DataTable SelectLikeBookConcernName(string BookConcernName)
          {

              DataTable objBookConcernInfoTable = new DataTable();
              string sql = "select BookConcernID  as '出版商ID',BookConcernName  as '出版商名称',BookConcernAddress  as '出版商地址'," +
                  "BookConcerntell as '联系方式' from BookConcern where BookConcernName like '%" + BookConcernName + "%'";
              string sqlTable = "BookConcernName";
              try
              {
                  ComOP.ConnectDb();
                  objBookConcernInfoTable = ComOP.Search(sql, sqlTable);
              }
              catch (Exception ex)
              {
                  throw ex;
              }
              finally
              {
                  ComOP.CloseDb();
              }
              return objBookConcernInfoTable;
          }
          /// <summary>
          /// 插入一个新的出版社
          /// </summary>
          /// <param name="BookConcernID"></param>
          /// <param name="BookConcernName"></param>
          /// <param name="BookConcernAddress"></param>
          /// <param name="BookConcerntell"></param>
          public void InsertBookConcern(string BookConcernID, string BookConcernName, string BookConcernAddress, string BookConcerntell)
          {
              try
              {
                  string sql = "insert into BookConcern values('" + BookConcernID + "','" + BookConcernName + "','" + BookConcernAddress + "','" + BookConcerntell + "')";
                  ComOP.Execute(sql);
              }
              catch (Exception ex)
              {
                  throw ex;
              }
              finally
              {
                  ComOP.CloseDb();
              }
          }
          /// <summary>
          /// 修改出版商信息
          /// </summary>
          /// <param name="BookConcernID"></param>
          /// <param name="BookConcernName"></param>
          /// <param name="BookConcernAddress"></param>
          /// <param name="BookConcerntell"></param>
          public void UpdateBookConcern(string BookConcernID, string BookConcernName, string BookConcernAddress, string BookConcerntell)
          {
              try
              {
                  string sql = "update BookConcern "+
                      "set BookConcernName='" + BookConcernName + "',BookConcernAddress='" + BookConcernAddress + "',BookConcerntell='" + BookConcerntell + "'"
                      + "where BookConcernID='" + BookConcernID + "'";
                  ComOP.Execute(sql);
              }
              catch (Exception ex)
              {
                  throw ex;
              }
              finally
              {
                  ComOP.CloseDb();
              }
          }
          /// <summary>
          /// 根据出版商ID删除出版商
          /// </summary>
          /// <param name="BookConcernID"></param>
          public void DELETEBookConcern(string BookConcernID)
          {
              try
              {
                  string sql = "DELETE FROM BookConcern " +
                               "where BookConcernID ='" + BookConcernID + "'";
                  ComOP.Execute(sql);
              }
              catch (Exception ex)
              {
                  throw ex;
              }
              finally
              {
                  ComOP.CloseDb();
              }
          }
    }
}