user_contrl.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>
	/// User_Contrl 的摘要说明。
	/// </summary>
	public class User_Contrl
	{
		public User_Contrl()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}
		/// <summary>
		/// 用户登陆
		/// </summary>
		/// <param name="Userinfo"></param>
		/// <returns></returns>
		public IDataReader  User_Login(ArrayList Userinfo)
		{
			CreateDb mydb = new CreateDb();
			IDataReader Rs=null;
			DBManager my = mydb.Createdb();
			try
			{
				my.OpenConn();
				Rs=my.ExecuteCreateReader(my.ExeCommand("select * from H_admin where Admin_User='"+Userinfo[0].ToString()+"' and Admin_Pwd='"+Userinfo[1].ToString()+"'"));
				return Rs;
			}
			catch(Exception e)
			{
				throw (e);
			}
		}
		/// <summary>
		/// 修改密码
		/// </summary>
		/// <param name="UserPwd"></param>
		public void UP_Pwd(ArrayList UserPwd)
		{
			CreateDb mydb = new CreateDb();
			DBManager my = mydb.Createdb();
			my.OpenConn();
			my.ExecutenonQuery(my.ExeCommand("update h_admin set admin_pwd='"+UserPwd[1]+"' where admin_User='"+UserPwd[0]+"'"));
			my.CloseConn();
		}
	}
}