App_Code/Components/Users.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Data;
using System.Data.SqlClient;
using HouseSystem.SQLDAL;
using HouseSystem.Modal;

namespace HouseSystem.Components
{
	/// <summary>
	/// Users 的摘要说明。
	/// </summary>
	public class Users
	{
		public static int Add(UserInfo entity)
		{
			string text1 = "SELECT UserName FROM Users WHERE UserName='" + entity.UserName + "'";
			DataRow row1 = SQLHelper.ExecuteDataRow(text1);
			if (row1 != null)
			{
				return -1;
			}
			object[] objArray1 = new object[0x13] { 
													  "INSERT INTO Users(UserName ,UserPass ,Question ,Answer ,Name ,Sex ,Tel1 ,Tel2 ,Email) VALUES ('", entity.UserName, "' ,'", entity.UserPass, "' ,'", entity.Question, "' ,'", entity.Answer, "' ,'", entity.Name, "' ,", entity.Sex, " ,'", entity.Tel1, "' ,'", entity.Tel2, 
													  "' ,'", entity.Email, "')"
												  } ;
			text1 = string.Concat(objArray1);
			return SQLHelper.ExecuteNonQuery(text1);
		}
 
		public static int Delete(int userId)
		{
			string text1 = "DELETE FROM Users WHERE User_ID = " + userId + "";
			return SQLHelper.ExecuteNonQuery(text1);
		}
 
		public static DataTable GetAllUserList()
		{
			string text1 = "SELECT * FROM Users ORDER BY Addtime DESC";
			return SQLHelper.ExecuteDataTable(text1);
		}
 
		public static DataRow GetAnswerByUserName(string strUserName)
		{
			string text1 = "SELECT UserPass,Answer,Question FROM Users WHERE UserName = '" + strUserName + "'";
			return SQLHelper.ExecuteDataRow(text1);
		}
 
		public static DataRow GetUserInfoByEmail(string strEmail)
		{
			string text1 = "SELECT UserName,UserPass FROM Users WHERE Email='" + strEmail + "'";
			return SQLHelper.ExecuteDataRow(text1);
		}
 
		public static DataRow GetUserInfoByID(string UserId)
		{
			string text1 = "SELECT UserName,Question ,Answer ,Name ,Sex ,Tel1 ,Tel2 ,Email FROM Users WHERE User_ID=" + UserId + "";
			return SQLHelper.ExecuteDataRow(text1);
		}
 
		public static bool IsUserExist(string strUserName)