/// <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); }
/// <summary> /// 更新消息列表中的消息为已读消息 /// </summary> /// <param name="list"></param> /// <returns></returns> public MessageList UpdateMsg2Readed(MessageList list) { DbOperate dbo = new DbOperate(); dbo.TableName = MessageOperator.TABLENAME; MessageList returnList = new MessageList(); foreach (MessageItem item in list) { SqlCommand com = new SqlCommand(); com.CommandText = "update Messages set MessageState=1 where Id=@MessageId"; SqlParameter Idpar = new SqlParameter("@MessageId", SqlDbType.Int); Idpar.Value = item.Id; com.Parameters.Add(Idpar); dbo.UpDate(com); MessageItem upItem = this.GetMessage(item.Id); returnList.Add(upItem); } return returnList; }