usermanage.cs

一个 用Ajax实现聊天室的简单例子 不全的地方指点

using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;
using ChatModel;
using System.Data;


namespace ChatDAL
{
    public class UserManage
    {
        DBHelper db = new DBHelper();

        /// <summary>
        /// 登录验证
        /// </summary>
        /// <param name="un"></param>
        /// <param name="pwd"></param>
        /// <returns></returns>
        public User isLogin(string un,string pwd)
        {
            User us=null;
            string sql = "select ID,name from users where userName='" + un + "' and password='" + pwd + "'";
            SqlDataReader rs = db.getRead(sql);
            if (rs.Read())
            {
                us = new User();
                us.ID = Convert.ToInt32(rs[0]);
                us.name = rs[1].ToString();
            }
            rs.Close();
            db.closeCon();
            return us;
        }

        /// <summary>
        /// 是否重复
        /// </summary>
        /// <param name="un"></param>
        /// <returns></returns>
        public bool isRepeat(string un)
        {
            bool flag = false;
            string sql = "select * from users where userName='" + un + "'";
            flag = db.getRead(sql).HasRows;
            db.closeCon();
            return flag;
        }

        /// <summary>
        /// 添加用户
        /// </summary>
        /// <param name="us"></param>
        public void addUser(User us)
        {
            string sql = "insert into users values('" + us.userName + "','"
                + us.password + "','" + us.name + "','" + us.sex + "','" + us.face 
                + "','" + us.address + "','" + us.phone + "','" + us.mail + "')";
            db.getRow(sql);
        }

        /// <summary>
        /// 修改用户资料
        /// </summary>
        /// <param name="us"></param>
        public void updUser(User us)
        {
            string sql = "update users set userName='" + us.userName + "',password='"
                + us.password + "',name='" + us.name + "',sex='" + us.sex + "',face=" + us.face 
                + ",address='" + us.address + "',phone='" + us.phone + "',mail='" + us.mail 
                + "' where ID="+us.ID+"";
            db.getRow(sql);
        }

        /// <summary>
        /// 根据标识找出用户资料
        /// </summary>
        /// <param name="ID"></param>
        /// <returns></returns>
        public User getUserByID(int ID)
        {
            User us = new User();
            string sql = "select * from users where ID="+ID+"";
            SqlDataReader rs = db.getRead(sql);
            while (rs.Read())
            {
                us.ID = Convert.ToInt32(rs[0]);
                us.userName = rs[1].ToString();
                us.name = rs[3].ToString();
                us.sex = rs[4].ToString();
                us.face = Convert.ToInt32(rs[5]);
                us.address = rs[6].ToString();
                us.phone = rs[7].ToString();
                us.mail = rs[8].ToString();
            }
            rs.Close();
            db.closeCon();
            return us;
        }

        /// <summary>
        /// 根据姓名模糊查找
        /// </summary>
        /// <param name="name"></param>
        /// <returns></returns>
        public string[] fuzzySearch(string name)
        {
            List<string> list = new List<string>();
            string sql = "select name from users where name like '" + name + "%'";
            SqlDataReader rs = db.getRead(sql);
            while (rs.Read())
                list.Add(rs[0].ToString());
            rs.Close();
            db.closeCon();
            return list.ToArray();
        }

        /// <summary>
        /// 根据标识找出昵称和头像
        /// </summary>
        /// <param name="ID"></param>
        /// <returns></returns>
        public User getFace(int ID)
        {
            User us=null;
            string sql = "select ID,name,face from users where ID=" + ID + "";
            SqlDataReader rs = db.getRead(sql);
            while (rs.Read())
            {
                us = new User();
                us.ID = Convert.ToInt32(rs[0]);
                us.name = rs[1].ToString();
                us.face = Convert.ToInt32(rs[2]);
            }
            rs.Close();
            db.closeCon();
            return us;
        }

        /// <summary>
        /// 找出所有头像
        /// </summary>
        /// <returns></returns>
        public DataTable getAllFace()
        {
            DataTable dt = new DataTable();
            DataColumn col1 = dt.Columns.Add("face", typeof(int));
            for (int i = 1; i <= 100; i++)
            {
                DataRow dr = dt.NewRow();
                dr["face"] = i;
                dt.Rows.Add(dr);
            }
            return dt;
        }

        /// <summary>
        /// 根据编号找出昵称
        /// </summary>
        /// <param name="ID"></param>
        /// <returns></returns>
        public User getNameByID(int ID)
        {
            User us = null;
            string sql = "select name from users where ID=" + ID + "";
            SqlDataReader rs = db.getRead(sql);
            while (rs.Read())
            {
                us = new User();
                us.name = rs[0].ToString();
            }
            rs.Close();
            db.closeCon();
            return us;
        }
    }
}