userloadaccess.cs

实施医院管理系统

using System;
using comman;
using System.Data;
using System.Data.SqlClient;
using DataAccess;

namespace DataAccess
{
	/// <summary>
	/// UserLoadAccess 的摘要说明。
	/// </summary>
	public class UserLoadAccess
	{
		DBconnection cn = new DBconnection();

		public UserLoadAccess()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}
		public DataTable CheckUser(string UserName,string Password)
		{
			string commandText = string.Format(@"SELECT UserName,Password,GradeID FROM UserLoad WHERE UserName = '{0}'AND Password = '{1}'",UserName,Password);
			return DBAccess.ExcuteDataTable(cn.Connection,commandText);
		}

		public int AddUser(UserLoad userLoad)
		{
			string commandText = string.Format("INSERT INTO userLoad (UserName,Password,GradeID) VALUES ('{0}','{1}','{2}')",userLoad.UserName,userLoad.Password,userLoad.GradeID);
			return DBAccess.ExcuteCommand(cn.Connection,commandText);
		}
		public DataTable SelectLoad()
		{
			string commandText = string.Format("SELECT UserName FROM UserLoad");
			return DBAccess.ExcuteDataTable(cn.Connection,commandText);
		}
	}
}