sbgl_add.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_Add 的摘要说明。
	/// </summary>
	public class Sbgl_Add
	{
		public Sbgl_Add()
		{
		}
		/// <summary>
		/// 加入设备信息
		/// </summary>
		/// <param name="A"></param>
		public void Add_Sb_info(ArrayList A)
		{
				String SQL="insert into H_SB_info (Classid,Class_Name,sbzlid,sblbid,sbzt,syr,sn,sccj,ccrq,sysj,cgsj,bz,jz,zcbh,lry) values ("+A[0]+",";
				SQL+="'"+A[1]+"',"+A[2]+","+A[3]+",'"+A[4]+"','"+A[5]+"','"+A[6]+"','"+A[7]+"','"+A[8]+"','"+A[9]+"','"+A[10]+"','"+A[11]+"','"+A[12]+"','"+A[13]+"','"+A[14]+"')";
				CreateDb mydb = new CreateDb();
				DBManager my = mydb.Createdb();
				my.OpenConn();
				my.ExecutenonQuery(my.ExeCommand(SQL));
				my.CloseConn();
		}
		/// <summary>
		/// 统计设备条数
		/// </summary>
		/// <returns></returns>
		public string Get_Article_countid()
		{
			CreateDb mydb = new CreateDb();
			IDataReader Rs=null;
			DBManager my = mydb.Createdb();
			my.OpenConn();
			Rs=my.ExecuteCreateReader(my.ExeCommand("select count(id) as id from H_SB_INFO"));
			string id="";
			while(Rs.Read())
			{
				id=Rs["id"].ToString();
			}
			return id;
		}
		/// <summary>
		/// 获得设备最大的ID
		/// </summary>
		/// <returns></returns>
		public string Get_Article_id()
		{
			CreateDb mydb = new CreateDb();
			IDataReader Rs=null;
			DBManager my = mydb.Createdb();
			my.OpenConn();
			Rs=my.ExecuteCreateReader(my.ExeCommand("select max(id) as id from H_SB_INFO"));
			string id="";
			while(Rs.Read())
			{
				id=Rs["id"].ToString();
			}
			return id;
		}
		/// <summary>
		/// 获得维修的记录的最大ID
		/// </summary>
		/// <returns></returns>
		public string Get_wxid()
		{
			CreateDb mydb = new CreateDb();
			IDataReader Rs=null;
			DBManager my = mydb.Createdb();
			my.OpenConn();
			Rs=my.ExecuteCreateReader(my.ExeCommand("select max(id) as id from H_wxjl"));
			string id="";
			while(Rs.Read())
			{
				id=Rs["id"].ToString();
			}
			return id;
		}
		/// <summary>
		/// 加入设备的报废信息
		/// </summary>
		/// <param name="A"></param>
		public void add_Sbbf(ArrayList A)
		{
			String SQL="insert into H_SBbf (sbbh,sfcf,bfsj,zj,bz,lry) values ("+A[0]+",";
			SQL+=""+A[1]+",'"+A[2]+"',"+A[3]+",'"+A[4]+"','"+A[5]+"')";
			CreateDb mydb = new CreateDb();
			DBManager my = mydb.Createdb();
			my.OpenConn();
			my.ExecutenonQuery(my.ExeCommand(SQL));
			my.CloseConn();
			up_zt("报废",Convert.ToInt32(A[0].ToString()));
		}
		/// <summary>
		/// 修改设备状态
		/// </summary>
		/// <param name="zt"></param>
		/// <param name="id"></param>
		public void up_zt(string zt,int id)
		{
			String SQL="update H_SB_info set sbzt='"+zt+"' where id="+id;
			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 Add_Sbwx_info(ArrayList A)
		{
			String SQL="insert into H_Wxjl (sbbh,Wxr,wxgs,wxfy,gzyy,kssj,jssj,bz) values ("+A[0]+",";
			SQL+="'"+A[1]+"','"+A[2]+"',"+A[3]+",'"+A[4]+"','"+A[5]+"','"+A[6]+"','"+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 Add_Sb_Db(ArrayList A)
		{
			String SQL="insert into H_Sb_Db (sbbh,ybm,ybm_name,y_syr,xbm,xbm_name,syr,bz,dbrq,lry) values ("+A[0]+",";
			SQL+=""+A[1]+",'"+A[2]+"','"+A[3]+"',"+A[4]+",'"+A[5]+"','"+A[6]+"','"+A[7]+"','"+A[8]+"','"+A[9]+"')";
			CreateDb mydb = new CreateDb();
			DBManager my = mydb.Createdb();
			my.OpenConn();
			my.ExecutenonQuery(my.ExeCommand(SQL));
			my.CloseConn();
			up_Db(Convert.ToInt32(A[0].ToString()),Convert.ToInt32(A[4].ToString()),A[5].ToString(),A[6].ToString());
		}
		/// <summary>
		/// 修改调拨信息
		/// </summary>
		/// <param name="id"></param>
		/// <param name="Classid"></param>
		/// <param name="ClassName"></param>
		/// <param name="syr"></param>
		public void up_Db(int id,int Classid,string ClassName,string syr)
		{
			String SQL="update H_Sb_info set Classid="+Classid+",Class_Name='"+ClassName+"',syr='"+syr+"' where id="+id;
			CreateDb mydb = new CreateDb();
			DBManager my = mydb.Createdb();
			my.OpenConn();
			my.ExecutenonQuery(my.ExeCommand(SQL));
			my.CloseConn();
		}
	}
}