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

namespace Data_Contrl
{
	/* ****************************************************	
				   重慶杰諾軟件開發(fā)工作室

	QQ:83898700
	EMAIL:gimao@163.com
	url:www.gisii.com
	***************************************************** */
	/// <summary>
	/// Sbgl_adminUser 的摘要說明。
	/// </summary>
	public class Sbgl_adminUser
	{
		public Sbgl_adminUser()
		{
			//
			// TODO: 在此處添加構(gòu)造函數(shù)邏輯
			//
		}
		/// <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>
		/// 返回用戶數(shù)據(jù)集
		/// </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();
		}

	}
}