/// <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;
}
