accounts_useradd_aspx_cs_checkuser.cs

来自「用vs2005写的一个生产任务管理系统。数据的统计和综合查询是主要功能」· CS 代码 · 共 78 行

using System; 
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using RWSB.DatabaseOper;


namespace RWSB.Manage
 {


	public class checkUser:System.Web .UI .Page 
	{
		public checkUser()
		{
		}
		/// <summary>
		/// 检查当前用户在数据库中是否存在
		/// </summary>
		/// <param name="username">用户名</param>
		/// <returns></returns>
		public bool ExistUser(string username)
		{
			RWSB.DatabaseOper.DatabaseConnect  dc=new DatabaseConnect();
			string sql="select count(*)  from users where username='"+username+"'" ;
			int count=0;
			try
			{
				count =int.Parse (dc.GetValueBySql(sql));
			}
			catch(Exception er)
			{
				Response.Write (er.Message );
				Response.End ();
			}
			if (count>0)
			{
				return true;
			}
			return false;
		}
		/// <summary>
		/// 检查当前用户在数据库中是否存在，此方法用在用户修改模块
		/// </summary>
		/// <param name="username">用户名</param>
		/// <param name="userid">原用户ID</param>
		/// <returns></returns>
		public bool ExistUser(string username,int userid)
		{
			RWSB.DatabaseOper.DatabaseConnect  dc=new DatabaseConnect();
			string sql="select count(*)  from users where username='"+username+"' and id !="+userid.ToString () ;
			int count=0;
			try
			{
				count =int.Parse (dc.GetValueBySql(sql));
			}
			catch(Exception er)
			{
				Response.Write (er.Message );
				Response.End ();
			}
			if (count>0)
			{
				return true;
			}
			return false;
		}
	}

}