ZhongJianChen/Class_TushuXinxiTianjia.cs

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

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Text;

namespace MF借书系统.ZhongJianChen
{
    class Class_TushuXinxiTianjia
    {
        public Class_TushuXinxiTianjia()
        { 
        
        }
        public bool insert(string ISBY, int typeId, string typeName, string bookname, string writer,
            string translator,string publisher,string date,double price)
        {
            string sqlStr = "insert into bookinfo values('"+ISBY+"',"+typeId+",'"+typeName+"','"+bookname
                +"','"+writer+"'," + " '"+translator+"','"+publisher+"','"+date+"',"+price+") ";
            ADO.SqlAdo sql = new ADO.SqlAdo();
            bool boolean = sql.insert(sqlStr);
            return boolean;
        }
        public DataSet getComboBox()
        {
            string sqlStr = "select * from tb_bookType order by typeid asc ";
            ADO.AdoTable table = new ADO.AdoTable();
            return table.getTable(sqlStr);
        }
        public string getTypeId(string str)
        {
            string typeId = null;
            string sqlStr = "select typeid from tb_bookType where TypeName = '"+str+"' order by typeid asc ";
            ADO.SqlAdo sql = new ADO.SqlAdo();
            SqlDataReader read = sql.select(sqlStr);
            if (read.Read())
                typeId = read[0].ToString();
            return typeId;
        }
    }
}