ZhongJianChen/Class_XinShuDingGouGuanLi.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_XinShuDingGouGuanLi : Class_TuShuXinxiXiuGai
    {
        public Class_XinShuDingGouGuanLi()
        { 
        
        }
        //插入图书信息
        public bool update_TuShuXinxi(string ISBN,string BookName,int TypeId,string TypeName,
            string translator,double price)
        {
            string sqlStr = "insert into bookinfo(ISBN,BookName,TypeId,TypeName,translator,price) values('"+
                ISBN+"','"+BookName+"',"+TypeId
                +",'"+TypeName+"','"+translator+"',"+price+")";
            ADO.SqlAdo sql = new ADO.SqlAdo();
            return sql.insert(sqlStr);
        }
        //插入图书订购信息
        public bool update_TuShuDingGouXinxi(string ISBN, string date, int number,
            string operato, string CheckAndAccept, float zk)
        { 
            string sqlStr = "insert into" 
                                + " tb_order(ISBN,date,number,operato,CheckAndAccept,zk)" 
                                +" values "
                                + "('" + ISBN + "',getDate(),"+number+",'"+operato+"','"+CheckAndAccept+"','"+zk+"')";
            ADO.SqlAdo sql = new ADO.SqlAdo();
            return sql.insert(sqlStr);
        }
    }
}