sbgl_up.cs

工资管理系统

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


namespace Data_Contrl
{
	/* ****************************************************	
				   重庆杰诺软件开发工作室

	QQ:83898700
	EMAIL:[e-mail]
	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();
		}
	}
}