ZhongJianChen/Class_TuShuLeiBieXiuGai.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_TuShuLeiBieXiuGai
    {
        //返回一个数据集合.返回的集合赋给选项卡
        public DataSet getCombox()
        {
            string sqlStr = "select * from tb_bookType order by typeid asc";
            ADO.AdoTable table = new ADO.AdoTable();
            return table.getTable(sqlStr);
        }
        //返回图书可借天数,和罚款的字符串
        public string[] getString(string TypeName)
        {
            string [] str = new string[2];
            ADO.SqlAdo sql = new ADO.SqlAdo();
            string sqlStr = "select Days,Fk from tb_bookType where TypeName = '"+ TypeName +"'";
            SqlDataReader read = sql.select(sqlStr);
            if(read.Read())
            {
                str[0] = read[0].ToString();
                str[1] = read[1].ToString();
            }
            return str;
        }
        //插入数据
        public bool info_Update(string TypeName,int Days, double Fk,string TypeName2)
        {
            string sqlStr = "Update  tb_bookType set TypeName = '"+TypeName+"',"
             + "Days = "+Days+",Fk = "+Fk+" where TypeName = '"+TypeName2+"'" ;
            ADO.SqlAdo sql = new ADO.SqlAdo();
            bool boolean = sql.update(sqlStr);
            return boolean;
        }
    }
}