sbgl_contrl.cs

来自「工资管理系统」· CS 代码 · 共 175 行

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_Contrl 的摘要说明。
	/// </summary>
	public class Sbgl_Contrl
	{
		public Sbgl_Contrl()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}
		/// <summary>
		/// 设备种类列表数据集
		/// </summary>
		/// <returns></returns>
		public IDataReader ZlList()
		{
			CreateDb mydb = new CreateDb();
			IDataReader Rs=null;
			DBManager my = mydb.Createdb();
			my.OpenConn();
			Rs=my.ExecuteCreateReader(my.ExeCommand("select * from h_sbzl"));
			return Rs;
		}
		/// <summary>
		/// 类别数据集
		/// </summary>
		/// <returns></returns>
		public IDataReader LbList()
		{
			CreateDb mydb = new CreateDb();
			IDataReader Rs=null;
			DBManager my = mydb.Createdb();
			my.OpenConn();
			Rs=my.ExecuteCreateReader(my.ExeCommand("select b.id as id,b.bmnr as bmnr,a.bmnr as dwmc,b.zlid as zlid  from h_sbzl a,h_sblb b where a.id=b.zlid"));
			return Rs;
		}
		/// <summary>
		/// 删除记录
		/// </summary>
		/// <param name="table"></param>
		/// <param name="id"></param>
		public void Delid(string table,int id)
		{
			String SQL="delete  from "+table+" where id="+id;
			CreateDb mydb = new CreateDb();
			DBManager my = mydb.Createdb();
			my.OpenConn();
			my.ExecutenonQuery(my.ExeCommand(SQL));
			my.CloseConn();
		}
		/// <summary>
		/// 删除ID
		/// </summary>
		/// <param name="table"></param>
		/// <param name="tj"></param>
		/// <param name="id"></param>
		public void Delid(string table,string tj,int id)
		{
			String SQL="delete  from "+table+" where "+tj+"="+id;
			CreateDb mydb = new CreateDb();
			DBManager my = mydb.Createdb();
			my.OpenConn();
			my.ExecutenonQuery(my.ExeCommand(SQL));
			my.CloseConn();
		}		
		/// <summary>
		/// 加入设备种类
		/// </summary>
		/// <param name="bmnr"></param>
		public void Add_sbzl(string bmnr)
		{
			string SQL="insert into h_sbzl (bmnr) values ('"+bmnr+"')";
			CreateDb mydb = new CreateDb();
			DBManager my = mydb.Createdb();
			my.OpenConn();
			my.ExecutenonQuery(my.ExeCommand(SQL));
			my.CloseConn();
		}
		/// <summary>
		/// 修改设备种类
		/// </summary>
		/// <param name="id"></param>
		/// <param name="bmnr"></param>
		public void update_sbzl(int id,string bmnr)
		{
			string SQL="update h_sbzl set bmnr='"+bmnr+"' where id="+id;
			CreateDb mydb = new CreateDb();
			DBManager my = mydb.Createdb();
			my.OpenConn();
			my.ExecutenonQuery(my.ExeCommand(SQL));
			my.CloseConn();
		}
		/// <summary>
		/// 加入设备列表
		/// </summary>
		/// <param name="id"></param>
		/// <param name="bmnr"></param>
		public void Add_sblb(int id,string bmnr)
		{
			string SQL="insert into h_sblb (bmnr,zlid) values ('"+bmnr+"',"+id+")";
			CreateDb mydb = new CreateDb();
			DBManager my = mydb.Createdb();
			my.OpenConn();
			my.ExecutenonQuery(my.ExeCommand(SQL));
			my.CloseConn();
		}
		/// <summary>
		/// 修改设备列表
		/// </summary>
		/// <param name="id"></param>
		/// <param name="zlid"></param>
		/// <param name="bmnr"></param>
		public void update_sblb(int id,int zlid,string bmnr)
		{
			string SQL="update h_sblb set bmnr='"+bmnr+"',zlid="+zlid+" where id="+id;
			CreateDb mydb = new CreateDb();
			DBManager my = mydb.Createdb();
			my.OpenConn();
			my.ExecutenonQuery(my.ExeCommand(SQL));
			my.CloseConn();
		}
		/// <summary>
		/// 设备编号
		/// </summary>
		/// <param name="id"></param>
		/// <returns></returns>
		public int get_sbbh(int id)
		{
			CreateDb mydb = new CreateDb();
			IDataReader Rs=null;
			DBManager my = mydb.Createdb();
			my.OpenConn();
			Rs=my.ExecuteCreateReader(my.ExeCommand("select sbbh from H_Sbbf where id="+id));
			string sbbh=string.Empty;
			while(Rs.Read())
			{
                sbbh=Rs["sbbh"].ToString();
			}
			Rs.Close();
			Rs.Dispose();
			my.CloseConn();
			return Convert.ToInt32(sbbh);
		}
		/// <summary>
		/// 修改设备状态为正常
		/// </summary>
		/// <param name="id"></param>
		public void Re_Bf(int id)
		{
			string SQL="update H_SB_info set sbzt='正常' where id="+get_sbbh(id);
			CreateDb mydb = new CreateDb();
			DBManager my = mydb.Createdb();
			my.OpenConn();
			my.ExecutenonQuery(my.ExeCommand(SQL));
			my.CloseConn();
		}
	}
}