Example #1
0
        /// <summary>
        /// ���ݱ�Ų����û���Ϣ
        /// </summary>
        /// <param name="userid">�û����</param>
        /// <returns>�û�ʵ�����</returns>
        public UserItem LoadUser(int userid)
        {
            //�������ݿ����ͨ����
             DbOperate dbo = new DbOperate();
             dbo.TableName = UsersOperator.TABLENAME;

             //�������ݲ�������
             SqlCommand com = new SqlCommand();

             //�����ѯ��䣬��ȷ���������������ֵ
             com.CommandText = "select * from users where id=@uid ";
             SqlParameter uid = new SqlParameter("@uid", SqlDbType.Int);
             uid.Value = userid;

             com.Parameters.Add(uid);

             DataTable table = dbo.Select(com).Tables[0];

             //���ݱ�Ž��в���
             if (table.Rows.Count == 1)
             {
                 this.view = table.DefaultView;
                 this.item = new UserItem();

                 //����ҵ���Ӧ��¼�������װ���û�ʵ�������
                 DataRow row = table.Rows[0];
                 this.item.Id = Convert.ToInt32(row["Id"]);
                 this.item.LoginPwd = row["LoginPwd"].ToString();
                 this.item.NickName = row["NickName"].ToString();
                 this.item.FaceId = Convert.ToInt32(row["FaceId"].ToString().Length<=0 ? 0 : row["FaceId"]);
                 this.item.Sex = row["Sex"].ToString();
                 this.item.Age = Convert.ToInt32(row["Age"]);
                 this.item.Name = row["Name"].ToString();
                 this.item.StarId =Convert.ToInt32( row["StarId"]);
                 this.item.BloodTypeId = Convert.ToInt32(row["BloodTypeId"]);

                 //���ظ��û�ʵ�����
                 return this.item;
             }
             else
             {
                 //���û�ҵ���Ӧ�û������ؿն���
                 return null;
             }
        }
Example #2
0
        /// <summary>
        /// ���ݲ����е��û�ID���¸��û�ʵ�������ݿ��е���Ϣ
        /// </summary>
        /// <param name="item">�û�ʵ�����</param>
        /// <returns>������Ӱ�������</returns>
        public int Update(UserItem item)
        {
            DbOperate dbo = new DbOperate();
             dbo.TableName = UsersOperator.TABLENAME;
             //����һ�����ݲ�������׼��ִ�и������
             SqlCommand com = new SqlCommand();
             com.CommandText = "update Users set Loginpwd=@LoginPwd,nickName=@nickName,faceId=@faceId,sex=@sex,age=@age,name=@name,starId=@starId,bloodTypeId=@bloodTypeId where Id=@id ";
             //��SQL��������еIJ���ȷ�����ͣ������θ�ֵ
             com.Parameters.Add(new SqlParameter("@LoginPwd", SqlDbType.VarChar, 50)).Value = item.LoginPwd;
             com.Parameters.Add(new SqlParameter("@nickName", SqlDbType.VarChar, 50)).Value = item.NickName;
             com.Parameters.Add(new SqlParameter("@faceId", SqlDbType.Int)).Value = item.FaceId;
             com.Parameters.Add(new SqlParameter("@sex", SqlDbType.VarChar, 50)).Value = item.Sex;
             com.Parameters.Add(new SqlParameter("@age", SqlDbType.Int)).Value = item.Age;
             com.Parameters.Add(new SqlParameter("@name", SqlDbType.VarChar, 50)).Value = item.Name;
             com.Parameters.Add(new SqlParameter("@starId", SqlDbType.Int)).Value = item.StarId;
             com.Parameters.Add(new SqlParameter("@bloodTypeId", SqlDbType.Int)).Value = item.BloodTypeId;
             com.Parameters.Add(new SqlParameter("@id", SqlDbType.Int)).Value = item.Id;

             //ִ�����ݸ��²��������ر�Ӱ��ļ�¼����
             return dbo.UpDate(com);
        }
Example #3
0
        /// <summary>
        /// ���������û���Ϣ�б�
        /// </summary>
        /// <returns>�����û���Ϣ�б�</returns>
        public UserList LoadFrendList()
        {
            //�������ݿ����ͨ�����һ������
             DbOperate dbo = new DbOperate();
             dbo.TableName = UsersOperator.TABLENAME;

             //�������ݲ������󣬲���ʼ���佫ִ�е�SQL���
             SqlCommand com = new SqlCommand();
             com.CommandText = "select * from Users";

             //ִ��SQL��䣬��ȡ�����ݼ��е����ݱ�
             DataTable table = dbo.Select(com).Tables[0];
             this.view = table.DefaultView;
             //�����������ݱ��е��û���Ϣ��ӵ��û��б�����ϣ���
             foreach (DataRow row in table.Rows)
             {
                 UserItem item = new UserItem();
                 item.Id=Convert.ToInt32(row["Id"]);
                 item.LoginPwd = (string)row["LoginPwd"];
                 item.NickName = (string)row["NickName"];
                 item.FaceId = Convert.ToInt32(row["FaceId"]);
                 item.Sex =Convert.ToString( row["Sex"]);
                 item.Age = Convert.ToInt32(row["Age"]);
                 item.Name = Convert.ToString(row["Name"]);
                 item.StarId = Convert.ToInt32(row["StarId"]);
                 item.BloodTypeId = Convert.ToInt32(row["BloodTypeId"]);
                 this.list.Add(item);
             }

             return this.list.Length >= 1 ? this.list : null;
        }
Example #4
0
        /// <summary>
        /// ע��һ���û�
        /// </summary>
        /// <param name="item">�û�ʵ�����</param>
        /// <returns>�����ݿ��и��µļ�¼����</returns>
        public int InsertUser(UserItem item)
        {
            //����һ�����ݿ����ͨ�ö���
             DbOperate dbo = new DbOperate();
             dbo.TableName = UsersOperator.TABLENAME;
             //����һ�����ݲ����SQL���
             SqlCommand com = new SqlCommand();
             com.CommandText = "insert into Users values(@LoginPwd,@nickName,@faceId,@sex,@age,@name,@starId,@bloodTypeId)";
             //����SQL�������󣬽��û�ʵ������ֵ�������
             com.Parameters.Add(new SqlParameter("@LoginPwd", SqlDbType.VarChar,50)).Value = item.LoginPwd;
             com.Parameters.Add(new SqlParameter("@nickName", SqlDbType.VarChar, 50)).Value = item.NickName;
             com.Parameters.Add(new SqlParameter("@faceId", SqlDbType.Int)).Value = item.FaceId;
             com.Parameters.Add(new SqlParameter("@sex", SqlDbType.VarChar,50)).Value = item.Sex;
             com.Parameters.Add(new SqlParameter("@age", SqlDbType.Int)).Value = item.Age;
             com.Parameters.Add(new SqlParameter("@name", SqlDbType.VarChar,50)).Value=item.Name;
             com.Parameters.Add(new SqlParameter("@starId", SqlDbType.Int)).Value = item.StarId;
             com.Parameters.Add(new SqlParameter("@bloodTypeId", SqlDbType.Int)).Value = item.BloodTypeId;
             //ִ�����ݿ���������������Ӱ��ļ�¼����
             //SqlDataReader objReader = dbo.ModifyAndFind(com);
             //if (objReader.Read())
             //{
             //    return (int)objReader[0];
             //}
             //return -1;
             int result = dbo.Insert(com);
             this._lastUserId = this.getUserId();

             return result;
        }
Example #5
0
 /// <summary>
 ///���췽��
 /// </summary>
 public UsersOperator()
 {
     this.item = new UserItem();
 }
Example #6
0
 /// <summary>
 /// ���û��б����Ƴ�һ���û�ʵ�����
 /// </summary>
 /// <param name="item">�û�ʵ�����</param>
 public void Remove(UserItem item)
 {
     this.list.Remove(item);
 }
Example #7
0
 /// <summary>
 /// ���û��б�������һ���û�����
 /// </summary>
 /// <param name="item">�û�ʵ�����</param>
 /// <returns>�û�ʵ��������û��б��е��±�</returns>
 public int Add(UserItem item)
 {
     return this.list.Add(item);
 }