ZhongJianChen/Class_GuiHaiGuanLi.cs

（开头部分） 9KB

这里只显示每个文件的开头 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_GuiHaiGuanLi
    {
        private string ISBN, DuzheId;
        public Class_GuiHaiGuanLi()
        { 
        
        }
        public Class_GuiHaiGuanLi(string ISBN, string DuzheId)
        {
            this.ISBN = ISBN;
            this.DuzheId = DuzheId;
        }
   
        //返回数据集合
        private DataSet getTable(string sql)
        {
            ADO.AdoTable table = new ADO.AdoTable();
            return table.getTable(sql);
        }
  
        //返回所有的借书信息
        public DataSet getJieShu()
        {
            string sqlStr = "select "+
                                       "ISBN as '图书编号',DuzheId as '读者编号', DuzheName as '读者姓名', "+ 
	                                   "Kejie_number as '可借数量',Moeny as '金额', "+
	                                   "date as '借出时间',operato as '操作员' "+
                                  " from "+
                                       "zonghe ";
            return this.getTable(sqlStr);
        }

        //返回所有归还信息
        public DataSet guiGuihaiXinxi()
        {
            string sqlStr = "select "+
                                     "ISBN as '书籍编号',DuzheId as '读者编号',Date as '借书日期',GuiDing_day as '规定天数', "+
                                     "shiji_Day as '实际天数',chaochu_Day as '超出天数',Fk as '罚款', "+
	                                 "dangqian_time as '归还时间',operato as '操作员' "+ 
                                 "from Guihai";
            return this.getTable(sqlStr);
        }

        //输入读者编号时显示该读者的借书信息
        public DataSet getDuzhe(string duZheId)
        {
            string sqlStr = "select "+ 
                                	   "DuzheId as '读者编号',DuzheName as '读者姓名', "+
                                	   "Kejie_number as '可借数量',Moeny as '金额', "+
                                	   "ISBN as '图书编号',date as '借出时间',operato as '操作员' "+
                                  "from "+
后面还有 173 行代码，解锁后查看完整代码

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

AI 解读 AI

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

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