Data_Control/Sbgl_Tmp.cs

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

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

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

namespace Data_Control
{
    public  class Sbgl_Tmp:EquipmentDBConnection 
    {
        /// <summary>
        /// 获得指定部门及其子部门所有设备维修记录
        /// </summary>
        /// <param name="bmbm">部门编号</param>
        /// <returns>包含设备维修记录的IDataReader</returns>
        public DataSet   Get_WxList(string bmbm)
        {
            using (SqlConnection conn = this.GetEquipmentConnStr())
            {
                string sql = "select a.ServiceID as id,a.EquipmentID as sbbh,b.EquiModel as xh,c.EquiStyleName as bmnr,a.ServicePerson as wxr," +
                    "a.BeginDate as kssj,a.FinishDate as jssj " +
                    "from ServiceInfo a,Equipment b,EquiStyle c where a.EquipmentID=b.EquipmentID and b.EquiStyleID=c.EquiStyleID ";

                if (bmbm != "")
                {
                    Tree_Control zgjg = new Tree_Control();
                    sql += " and b.DepartmentID in(" + zgjg.Treeinit (Convert.ToInt32(bmbm)) + "0)";
                }

                sql += " order by a.ServiceID desc";

                SqlDataAdapter da = new SqlDataAdapter(sql, conn);
                DataSet ds = new DataSet();
                da.Fill(ds, "WxList");
                return ds;
            }
        }
        /// <summary>
        /// 取得给定设备种类的设备信息
        /// </summary>
        /// <param name="lbid"></param>
        /// <returns></returns>
        public SqlDataReader  Get_Sb_bh(int zlid)
        {
            using (SqlConnection conn = this.GetEquipmentConnStr())
            {
                string  sqlstr="select * from Equipment where EquiStyleID=" + zlid;
                SqlCommand cmd=new SqlCommand (sqlstr,conn);
                SqlDataReader dr=cmd.ExecuteReader ();             
                return dr;
            }
        }

        /// <summary>
        /// 获取指定部门及其子部门所有设备的运行信息
        /// </summary>
        /// <param name="bmbm">部门编号</param>
        /// <returns>包含设备运行信息的SqlDataReader</returns>
        public DataSet  Get_DbList(string bmbm)