using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using Datamodel;

namespace Data_Contrl
{
	/* ****************************************************	
				   重慶杰諾軟件開發(fā)工作室

	QQ:83898700
	EMAIL:gimao@163.com
	url:www.gisii.com
	***************************************************** */
	/// <summary>
	/// Sbgl_Tmp 的摘要說明。
	/// </summary>
	public class Sbgl_Tmp
	{
		public Sbgl_Tmp()
		{
			//
			// TODO: 在此處添加構(gòu)造函數(shù)邏輯
			//
		}
		/// <summary>
		/// 設(shè)備編碼
		/// </summary>
		/// <returns></returns>
		public string Get_SBbm()
		{
			CreateDb mydb = new CreateDb();
			IDataReader Rs=null;
			DBManager my = mydb.Createdb();
			my.OpenConn();
			Rs=my.ExecuteCreateReader(my.ExeCommand("select max(id)+1 as id from H_Sb_info"));
			string id="";
			while(Rs.Read())
			{
				id=Rs["id"].ToString();
			}
			if (id=="")
				id="1";
			return id;
		}
		/// <summary>
		/// 取得給定設(shè)備類別的設(shè)備信息
		/// </summary>
		/// <param name="lbid"></param>
		/// <returns></returns>
		public IDataReader Get_Sb_bh(int lbid)
		{
			CreateDb mydb = new CreateDb();
			IDataReader Rs=null;
			DBManager my = mydb.Createdb();
			my.OpenConn();
			Rs=my.ExecuteCreateReader(my.ExeCommand("select * from h_Sb_info where sblbid="+lbid));
			return Rs;
		}
		/// <summary>
		/// 取得維修數(shù)據(jù)集
		/// </summary>
		/// <param name="bmbm"></param>
		/// <returns></returns>
		public IDataReader Get_WxList(string bmbm)
		{
			string sql="SELECT a.id AS id,a.sbbh as sbbh,b.sn as xh, c.bmnr AS bmnr, a.Wxr AS wxr,a.kssj AS kssj, a.jssj AS jssj FROM H_WxJl a , H_SB_info b, H_Sblb c where a.sbbh = b.id and b.sblbid = c.id";
			if(bmbm!="")
			{
				Tree_Contrl zgjg= new Tree_Contrl();
				sql+=" and b.classid in ("+zgjg.Treeinit(Convert.ToInt32(bmbm))+"0)";
			}
			sql+=" order by a.id desc";
			CreateDb mydb = new CreateDb();
			IDataReader Rs=null;
			DBManager my = mydb.Createdb();
			my.OpenConn();
			Rs=my.ExecuteCreateReader(my.ExeCommand(sql));
			return Rs;
		}
		/// <summary>
		/// 調(diào)撥數(shù)據(jù)集
		/// </summary>
		/// <param name="bmbm"></param>
		/// <returns></returns>
		public IDataReader Get_DbList(string bmbm)
		{
		
			string sql="SELECT a.id as id,a.sbbh as sbbh,b.sn as xh,c.bmnr as bmnr, a.ybm_Name AS ybm, a.y_syr as y_syr, a.xbm_Name as xbm_name, a.syr as syr FROM H_Sb_Db a,H_SB_info b, H_Sblb c  where a.sbbh = b.id and b.sblbid = c.id";
			if(bmbm!="")
			{
				Tree_Contrl zgjg= new Tree_Contrl();
				sql+=" and b.classid in ("+zgjg.Treeinit(Convert.ToInt32(bmbm))+"0)";
			}
			sql+=" order by a.id desc";
			CreateDb mydb = new CreateDb();
			IDataReader Rs=null;
			DBManager my = mydb.Createdb();
			my.OpenConn();
			Rs=my.ExecuteCreateReader(my.ExeCommand(sql));
			return Rs;
		}
		/// <summary>
		/// 取得報廢數(shù)據(jù)集
		/// </summary>
		/// <param name="bmbm"></param>
		/// <returns></returns>
		public IDataReader Get_BfList(string bmbm)
		{
			string sql="SELECT a.id AS id,a.sbbh as sbbh,b.sn as xh,c.bmnr AS bmnr, a.bfsj AS bfsj FROM H_SBbf a,H_SB_info b,H_Sblb c where a.sbbh = b.id and b.sblbid = c.id";
			if(bmbm!="")
			{
				Tree_Contrl zgjg= new Tree_Contrl();
				sql+=" and b.classid in ("+zgjg.Treeinit(Convert.ToInt32(bmbm))+"0)";
			}
			sql+=" order by a.id desc";
			CreateDb mydb = new CreateDb();
			IDataReader Rs=null;
			DBManager my = mydb.Createdb();
			my.OpenConn();
			Rs=my.ExecuteCreateReader(my.ExeCommand(sql));
			return Rs;
		}
		/// <summary>
		/// 取得所有設(shè)備信息
		/// </summary>
		/// <returns></returns>
		public IDataReader Get_SbList()
		{
			CreateDb mydb = new CreateDb();
			IDataReader Rs=null;
			DBManager my = mydb.Createdb();
			my.OpenConn();
			Rs=my.ExecuteCreateReader(my.ExeCommand("SELECT * from H_Sb_info order by id desc"));
			return Rs;
		}
	}
}