sbgl_tmp.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_Tmp 的摘要说明。
	/// </summary>
	public class Sbgl_Tmp
	{
		public Sbgl_Tmp()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}
		/// <summary>
		/// 设备编码
		/// </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>
		/// 取得给定设备类别的设备信息
		/// </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>
		/// 取得维修数据集
		/// </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>
		/// 调拨数据集
		/// </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>
		/// 取得报废数据集
		/// </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>
		/// 取得所有设备信息
		/// </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;
		}
	}
}