st_user.cs

it have big power,i hope to do it . happy everyday!

using System;
using System.Data;
using Microsoft.ApplicationBlocks.Data;

namespace STGROUP.ST_BookBiz
{
	/// <summary>
	/// ST_User 的摘要说明。
	/// </summary>
	public class ST_User
	{
		public ST_User()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}

		/// <summary>
		/// 插入用户信息
		/// </summary>
		/// <param name="st_user"></param>
		/// <returns></returns>
		public int InsertUser(ST_BookBiz.ST_UserEntity st_user)
		{
			string sqlString = @"insert into ST_Users(ST_Name,ST_Pass,ST_TrueName,ST_Address,ST_Telephone,ST_Email,ST_Postcode,ST_Gender,ST_Type)
								 values('"+st_user.ST_Name+"','"+st_user.ST_Pass+"','"+st_user.ST_TrueName+"','"+st_user.ST_Address+"','"+st_user.ST_Telephone+"','"+st_user.ST_Email+"','"+st_user.ST_Postcode+"','"+st_user.ST_Gender+"','User'); select scope_identity();";

			object obj = SqlHelper.ExecuteScalar(ST_Utility.ST_ConnString, CommandType.Text, sqlString);
			if(obj!=null)
				return int.Parse(obj.ToString());
			return 0;
		}
		/// <summary>
		/// 更新用户信息
		/// </summary>
		/// <param name="st_user"></param>
		public void UpdateUser(ST_BookBiz.ST_UserEntity st_user)
		{
			string sqlString = "update ST_Users set ST_Name='"+st_user.ST_Name+"',ST_Pass='"+st_user.ST_Pass+"',ST_TrueName='"+st_user.ST_TrueName+"',ST_Address='"+st_user.ST_Address+"',ST_Telephone='"+st_user.ST_Telephone+"',ST_Email='"+st_user.ST_Email+"',ST_Postcode='"+st_user.ST_Postcode+"',ST_Gender='"+st_user.ST_Gender+"' where st_userid="+st_user.ST_UserID;
			SqlHelper.ExecuteNonQuery(ST_Utility.ST_ConnString, CommandType.Text, sqlString);
		}

		/// <summary>
		/// 取得用户的信息
		/// </summary>
		/// <param name="st_userid"></param>
		/// <returns></returns>
		public ST_UserEntity GetUserInfo(int st_userid)
		{
			ST_UserEntity st_entity = new ST_UserEntity();
			string sqlString = "select * from ST_Users where st_userid="+st_userid;
			DataSet ds = SqlHelper.ExecuteDataset(ST_Utility.ST_ConnString, CommandType.Text, sqlString);
			st_entity.ST_UserID = st_userid;
			st_entity.ST_TrueName = ds.Tables[0].Rows[0]["ST_TrueName"].ToString();
			st_entity.ST_Telephone = ds.Tables[0].Rows[0]["ST_Telephone"].ToString();
			st_entity.ST_Postcode = ds.Tables[0].Rows[0]["ST_Postcode"].ToString();
			st_entity.ST_Pass = ds.Tables[0].Rows[0]["ST_Pass"].ToString();
			st_entity.ST_Name = ds.Tables[0].Rows[0]["ST_Name"].ToString();
			st_entity.ST_Gender = ds.Tables[0].Rows[0]["ST_Gender"].ToString();
			st_entity.ST_Email = ds.Tables[0].Rows[0]["ST_Email"].ToString();
			st_entity.ST_Address = ds.Tables[0].Rows[0]["ST_Address"].ToString();
			return st_entity;
		}
        /// <summary>
        /// 判断用户是否重复
        /// </summary>
        /// <param name="st_StuInfo"></param>
        public bool ST_IsUserExist(string ST_Name)
        {
            string sqlString = "select count(ST_Userid) from ST_Users where ST_Name='" + ST_Name + "'";
            object obj = SqlHelper.ExecuteScalar(ST_Utility.ST_ConnString, CommandType.Text, sqlString);
            if (obj != null && obj.ToString() != "0")
            {
                return true;
            }
            else
            {
                return false;
            }
        }
	}
}