Data_Control/Sbgl_Up.cs

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

微信扫码关注公众号，代码整理好后第一时间通知你。

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

namespace Data_Control
{
    public class Sbgl_Up:EquipmentDBConnection 
    {
        /// <summary>
        /// 获取指定ID的设备信息
        /// </summary>
        /// <param name="id">设备的编号</param>
        /// <returns>含指定编号的设备信息的IDataReader</returns>
        public DataSet Get_sb_info(int id)
        {
            using (SqlConnection conn = this.GetEquipmentConnStr())
            {
                string sqlstr = "select * from Equipment where EquipmentID=" + id;
                SqlDataAdapter da = new SqlDataAdapter(sqlstr, conn);
                DataSet ds = new DataSet();
                conn.Open();
                da.Fill(ds);
                return ds;
            }
        }
        /// <summary>
        /// 获取指定设备的所有详细信息
        /// </summary>
        /// <param name="id">设备编号</param>
        /// <returns>包含指定设备详细信息的IDataReader</returns>
        public DataSet  Get_Sb_detail(int id)
        {
            using (SqlConnection conn=this.GetEquipmentConnStr ())
            {
            string  sqlstr = "select a.DepartmentID, a.DepartmentName ,b.EquiStyleName ," +
            "c.EquiSortName ,a.EquiModel ,a.Status ,a.UsePerson ,a.Factory ," +
            "a.LeaveFactoryDate ,a.StockDate ,a.UseDate ,a.Remark  from Equipment a,EquiStyle b,EquiSort c " +
            "where a.EquiStyleID=b.EquiStyleID and a.EquiSortID=c.EquiSortID and a.EquipmentID=" + id;
            SqlDataAdapter da = new SqlDataAdapter(sqlstr, conn);
            DataSet ds = new DataSet();
            conn.Open();
            da.Fill(ds);
            return ds;
            }
        }
        /// <summary>
        /// 获取指定维修记录的详细信息
        /// </summary>
        /// <param name="id">维修记录编号</param>
        /// <returns>维修记录详细信息的IDataReader</returns>
        public DataSet   Get_Wx_info(int id)
        {           
            using (SqlConnection conn = this.GetEquipmentConnStr())
            {
              string  sqlstr="select * from ServiceInfo where EquipmentID=" + id;
              SqlDataAdapter da = new SqlDataAdapter(sqlstr, conn);