sbgl_adminuser.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_adminUser 的摘要说明。
	/// </summary>
	public class Sbgl_adminUser
	{
		public Sbgl_adminUser()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}
		/// <summary>
		/// 加入用户
		/// </summary>
		/// <param name="UserName"></param>
		/// <param name="Pwd"></param>
		/// <param name="qx"></param>
		/// <param name="bmbm"></param>
		/// <param name="bmnr"></param>
		/// <param name="iscg"></param>
		public void  add_admin(string UserName,string Pwd,string qx,int bmbm,string bmnr,int iscg)
		{
			string SQL="insert into H_Admin (Admin_User,Admin_Pwd,qx,bmbm,bmnr,iscg) values ('"+UserName+"','"+Pwd+"','"+qx+"',"+bmbm+",'"+bmnr+"',"+iscg+")";
			CreateDb mydb = new CreateDb();
			DBManager my = mydb.Createdb();
			my.OpenConn();
			my.ExecutenonQuery(my.ExeCommand(SQL));
			my.CloseConn();

		}
		/// <summary>
		/// 用户列表
		/// </summary>
		/// <returns></returns>
		public IDataReader adminList()
		{
			CreateDb mydb = new CreateDb();
			IDataReader Rs=null;
			DBManager my = mydb.Createdb();
			my.OpenConn();
			Rs=my.ExecuteCreateReader(my.ExeCommand("select * from H_Admin"));
			return Rs;
		}
		/// <summary>
		/// 返回用户数据集
		/// </summary>
		/// <param name="id"></param>
		/// <returns></returns>
		public IDataReader admininfo(int id)
		{
			CreateDb mydb = new CreateDb();
			IDataReader Rs=null;
			DBManager my = mydb.Createdb();
			my.OpenConn();
			Rs=my.ExecuteCreateReader(my.ExeCommand("select * from H_Admin where id="+id));
			return Rs;
		}
		/// <summary>
		/// 修改用户
		/// </summary>
		/// <param name="UserName"></param>
		/// <param name="pwd"></param>
		/// <param name="qx"></param>
		/// <param name="id"></param>
		/// <param name="bmbm"></param>
		/// <param name="bmnr"></param>
		/// <param name="iscg"></param>
		public void up_Admin(string UserName,string pwd,string qx,int id,int bmbm,string bmnr,int iscg)
		{
			string SQL="update H_Admin set Admin_User='"+UserName+"',Admin_Pwd='"+pwd+"',qx='"+qx+"',bmbm="+bmbm+",bmnr='"+bmnr+"',iscg="+iscg+" where id="+id;
			CreateDb mydb = new CreateDb();
			DBManager my = mydb.Createdb();
			my.OpenConn();
			my.ExecutenonQuery(my.ExeCommand(SQL));
			my.CloseConn();
		}
		/// <summary>
		/// 修改密码
		/// </summary>
		/// <param name="UserName"></param>
		/// <param name="Pwd"></param>
		public void up_pwd(string UserName,string Pwd)
		{
			string SQL="update H_Admin set Admin_Pwd='"+Pwd+"' where Admin_User='"+UserName+"'";
			CreateDb mydb = new CreateDb();
			DBManager my = mydb.Createdb();
			my.OpenConn();
			my.ExecutenonQuery(my.ExeCommand(SQL));
			my.CloseConn();
		}

	}
}