ZhongJianChen/Class_TuShuYanShow.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_TuShuYanShow : Class_TuShuXinxiXiuGai
    {
        public Class_TuShuYanShow()
        { 
        
        }
        //返回字符串数组
        public string[] getString2(string ISBN)
        { 
           string [] str = new string[8];
           string sqlStr = "select a.ISBN,b.date,number,operato,typename,checkAndAccept,zk,price "+ 
                                "from bookinfo as a " + 
                                "inner join tb_order as b " + 
                                "on a.ISBN = b.ISBN " + 
                                "where a.ISBN = '"+ISBN+"'";
           ADO.SqlAdo sql = new ADO.SqlAdo();
           SqlDataReader read = sql.select(sqlStr);
           if (read.Read())
               for (int i = 0; i < 8; i++)
                   str[i] = read[i].ToString();
           return str;
        }
        //返回数据集合,显示在datagiadview
        public DataSet getDataGiadView()
        {
            string sqlStr = "select a.ISBN as '书籍编号',b.date as '订购时间',number as '订购数量',"+
                                  "operato as '操作员',typename as '类别名称',checkAndAccept as '是否验收',zk as '折扣',price as '价格' "+
                                  "from bookinfo as a " + 
                                  "inner join tb_order as b " +
                                  "on a.ISBN = b.ISBN ";
            ADO.AdoTable table = new ADO.AdoTable();
           return table.getTable(sqlStr); 
        }
        //更改图书信息
        public bool update_bookInfo(string ISBN,string TypeName,double price,string ISBN2) 
        {
            string sqlStr = "update bookinfo set "+
                                 " ISBN = '"+ISBN+"',TypeName = '"+TypeName+"', price = "+price+" " +
                                 " where " +
	                             " ISBN = '"+ISBN2+"'";
            ADO.SqlAdo sql = new ADO.SqlAdo();
            return sql.update(sqlStr);
        }
        //更改图书订购信息
        public bool update_tb_order(string ISBN ,string date ,int number,
        string operato ,string checkandaccept ,double zk,string ISBN2)
        { 
            string sqlStr = "update tb_order set "+
                            		"ISBN = '"+ISBN+"',date = '"+date+"',number = "+number+", "+
                                    "operato = '"+operato+"',checkandaccept = '"+checkandaccept+"',zk = "+zk+""+
                                "where "+
后面还有 6 行代码，解锁后查看完整代码

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

AI 解读 AI

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

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