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


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

	QQ:83898700
	EMAIL:gimao@163.com
	url:www.gisii.com
	***************************************************** */
	/// <summary>
	/// Sbgl_Up 的摘要說明。
	/// </summary>
	public class Sbgl_Up
	{
		public Sbgl_Up()
		{
			//
			// TODO: 在此處添加構造函數邏輯
			//
		}
		/// <summary>
		/// 取得設備維護列表
		/// </summary>
		/// <param name="id"></param>
		/// <returns></returns>
		public IDataReader Get_Sbwf_L(int id)
		{
			string sql="select a.id as id,(select bmnr from h_sbzl where id=a.sbzlid) as sbzl,(select bmnr from H_sblb where id=a.sblbid) as sblb,a.class_name as class_name,a.syr as syr,a.sn as sn,a.sbzt as sbzt,a.sysj as sysj from h_sb_info a where 1=1";
			 Tree_Contrl zgjg= new Tree_Contrl();
			sql+=" and a.Classid in ("+zgjg.Treeinit(Convert.ToInt32(id.ToString()))+"0) and a.sbzt<>'報廢'";
			sql+="  Group by a.id,a.class_name,a.syr,a.sn,a.sbzlid,a.sblbid,a.sbzt,a.sysj";
			sql+="  order by id desc";
			CreateDb mydb = new CreateDb();
			IDataReader Rs=null;
			DBManager my = mydb.Createdb();
			my.OpenConn();
			Rs=my.ExecuteCreateReader(my.ExeCommand(sql));
			return Rs;
		}
		/// <summary>
		/// 取得設備維修信息
		/// </summary>
		/// <param name="id"></param>
		/// <returns></returns>
		public IDataReader Get_Wx_info(int id)
		{
			CreateDb mydb = new CreateDb();
			IDataReader Rs=null;
			DBManager my = mydb.Createdb();
			my.OpenConn();
			Rs=my.ExecuteCreateReader(my.ExeCommand("select * from h_Wxjl where id="+id));
			return Rs;
		}
		/// <summary>
		/// 取得設備調撥信息
		/// </summary>
		/// <param name="id"></param>
		/// <returns></returns>
		public IDataReader Get_Db_info(int id)
		{
			CreateDb mydb = new CreateDb();
			IDataReader Rs=null;
			DBManager my = mydb.Createdb();
			my.OpenConn();
			Rs=my.ExecuteCreateReader(my.ExeCommand("select * from h_sb_Db where id="+id));
			return Rs;
		}
		/// <summary>
		/// 取得設備報廢信息
		/// </summary>
		/// <param name="id"></param>
		/// <returns></returns>
		public IDataReader Get_Bf_info(int id)
		{
			CreateDb mydb = new CreateDb();
			IDataReader Rs=null;
			DBManager my = mydb.Createdb();
			my.OpenConn();
			Rs=my.ExecuteCreateReader(my.ExeCommand("select * from h_sbbf where id="+id));
			return Rs;
		}
		/// <summary>
		/// 取得給定ID的設備信息
		/// </summary>
		/// <param name="id"></param>
		/// <returns></returns>
		public IDataReader Get_Sb_info(int id)
		{
			CreateDb mydb = new CreateDb();
			IDataReader Rs=null;
			DBManager my = mydb.Createdb();
			my.OpenConn();
			Rs=my.ExecuteCreateReader(my.ExeCommand("select * from h_sb_info where id="+id));
			return Rs;		
		}
		/// <summary>
		/// 取得給定ID的設備信息
		/// </summary>
		/// <param name="id"></param>
		/// <returns></returns>
		public IDataReader Get_Sb_detail(int id)
		{
			CreateDb mydb = new CreateDb();
			IDataReader Rs=null;
			DBManager my = mydb.Createdb();
			my.OpenConn();
			Rs=my.ExecuteCreateReader(my.ExeCommand("select a.id as id,a.Class_Name as classname,classid as classid,b.bmnr as sblb,c.bmnr as sbzl,a.sbzt as sbzt,a.syr as syr,a.sn as sn,a.sccj as sccj,a.ccrq as ccrq,a.sysj as sysj,a.cgsj as cgsj,a.bz as bz from h_sb_info a,h_sbzl b,h_sblb c where a.sbzlid=b.id and a.sblbid=c.id and a.id="+id));
			return Rs;	
		}
		/// <summary>
		/// 修改設備報廢信息
		/// </summary>
		/// <param name="A"></param>
		public void UP_Bf_info(ArrayList A)
		{

			   String SQL="update H_Sbbf set sfcf="+A[1]+",bfsj='"+A[2]+"',zj="+A[3]+",bz='"+A[4]+"' where id="+A[5];
				CreateDb mydb = new CreateDb();
				DBManager my = mydb.Createdb();
				my.OpenConn();
				my.ExecutenonQuery(my.ExeCommand(SQL));
				my.CloseConn();
		}
		/// <summary>
		/// 修改設備調撥信息
		/// </summary>
		/// <param name="A"></param>
		public void UP_Db_info(ArrayList A)
		{

			String SQL="update H_Sb_db set xbm="+A[0]+",xbm_name='"+A[1]+"',syr='"+A[2]+"',bz='"+A[3]+"',dbrq='"+A[5]+"' where id="+A[4];
			CreateDb mydb = new CreateDb();
			DBManager my = mydb.Createdb();
			my.OpenConn();
			my.ExecutenonQuery(my.ExeCommand(SQL));
			my.CloseConn();
		}
		/// <summary>
		/// 修改設備維修信息
		/// </summary>
		/// <param name="A"></param>
		public void up_wx_info(ArrayList A)
		{
			String SQL="update H_Wxjl set wxr='"+A[0]+"',wxgs='"+A[1]+"',wxfy="+A[2]+",gzyy='"+A[3]+"',kssj='"+A[4]+"',jssj='"+A[5]+"',bz='"+A[6]+"' where id="+A[7];
			CreateDb mydb = new CreateDb();
			DBManager my = mydb.Createdb();
			my.OpenConn();
			my.ExecutenonQuery(my.ExeCommand(SQL));
			my.CloseConn();
		}
		/// <summary>
		/// 修改設備信息
		/// </summary>
		/// <param name="A"></param>
		public void up_Sb_info(ArrayList A)
		{
			String SQL="update H_Sb_info set sbzt='"+A[0]+"',sn='"+A[1]+"',sccj='"+A[2]+"',ccrq='"+Convert.ToDateTime(A[3])+"',sysj='"+Convert.ToDateTime(A[4])+"',cgsj='"+Convert.ToDateTime(A[5])+"',bz='"+A[6]+"',jz='"+A[8]+"',zcbh='"+A[9]+"' where id="+Convert.ToInt32(A[7]);
			CreateDb mydb = new CreateDb();
			DBManager my = mydb.Createdb();
			my.OpenConn();
			my.ExecutenonQuery(my.ExeCommand(SQL));
			my.CloseConn();
		}
	}
}