ZhongJianChen/Class_TuShuXinxiXiuGai.cs

（开头部分） 2KB

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

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

namespace MF借书系统.ZhongJianChen
{
    class Class_TuShuXinxiXiuGai
    {
        //构造方法 
        public Class_TuShuXinxiXiuGai()
        { 
        
        }
        //返回数据集合,给DataGiadView绑定数据源
        public DataSet getTable()
        {
            string sqlStr = "select ISBN as 图书编号,TypeID as 类别编号,typeName as 类别名称,bookName as 书名,writer as 作者,Translator as 出版社,"
                                  +"Publisher as 译者,Date as 日期,Price as 价格 from bookinfo ";
            ADO.AdoTable table = new ADO.AdoTable();
            return table.getTable(sqlStr);
        }
        //返回数据集合.给选项卡绑定数据源
        public DataSet getCombo()
        {
            string sqlStr = "select * from tb_bookType order by typeid asc";
            ADO.AdoTable table = new ADO.AdoTable();
            return table.getTable(sqlStr);
        }
        //获取数据,返回字符串数组
        public string[] getString(string ISBN)
        {
            string [] temp = new string[9];
            string sqlStr = "select * from bookinfo where ISBN = '"+ ISBN +"'";
            ADO.SqlAdo sql = new ADO.SqlAdo();
            SqlDataReader read = sql.select(sqlStr);
            if(read.Read())
            for(int i = 0; i < 9; i ++)
                temp[i] = read[i].ToString();
            return temp;
        }
        //提交修改.
        public bool update( string ISBN ,int TypeID ,string typeName ,
            string bookName ,string writer ,string Translator ,
            string Publisher ,string Date ,float Price,string ISBN2)
        { 
           string str =  " update bookinfo "
                             + " set ISBN = '"+ISBN+"',typeID = "+TypeID+",typeName = '"+typeName+"',"
                             + " bookName = '"+bookName+"',writer = '"+writer+"',"
	                         + " Translator = '"+Translator+"',Publisher = '"+Publisher+"',"
                             + " Date = '"+Date+"',Price = "+Price+""
                             + " where ISBN = '"+ISBN2+"'";
           ADO.SqlAdo ado = new ADO.SqlAdo();
           bool boolean = ado.update(str);
           return boolean;
        }
        //返回类别编号
        public string getTypeId(string TypeName)
后面还有 10 行代码，解锁后查看完整代码

24 小时内免费解锁 3 个项目，之后 1 算力/个。 规则说明

AI 解读 AI

登录后可用，每次 10 算力，解读结果公开显示在下面。

还没有人解读过这个文件。