userinfo.cs

企业短信收发系统

using System;
using System.Data;
using System.Data.SqlClient;

namespace MessageLibrary
{
	/// <summary>
	/// UserInfo 的摘要说明。
	/// </summary>
	public class UserInfo
	{
		DataAccess da=new DataAccess();
		public UserInfo()
		{
			
		}
		public DataSet UserLogin(string LoginName,string Pwd)
		{
			SqlParameter[] objSqlParameter=new SqlParameter[2];
			objSqlParameter.SetValue(new SqlParameter("@LoginName",LoginName),0);
			objSqlParameter.SetValue(new SqlParameter("@Password",Pwd),1);
			DataSet ds=da.ExcuteProcedure("UserLogin",objSqlParameter);
			return ds;
		}
		public bool InsertUser(string LoginName,string Pwd,string UserName,string Gender,string Moblie,string Remark)
		{
			SqlParameter[] objSqlParameter=new SqlParameter[6];
			objSqlParameter.SetValue(new SqlParameter("@LoginName",LoginName),0);
			objSqlParameter.SetValue(new SqlParameter("@Password",Pwd),1);
			objSqlParameter.SetValue(new SqlParameter("@UserName",UserName),2);
			objSqlParameter.SetValue(new SqlParameter("@Gender",Gender),3);
			objSqlParameter.SetValue(new SqlParameter("@Moblie",Moblie),4);
			objSqlParameter.SetValue(new SqlParameter("@Remark",Remark),5);
			if(da.ExcuteUpdateProcedure("InsertUser",objSqlParameter)==true)
			{
				return true;
			}
			else
			{
				return false;
			}
		}
		public DataSet AllUserInfo()
		{
			DataSet ds=da.ExcuteProcedure("AllUserInfo",null);
			return ds;
		}

	}
}