//添加P2p消息
public bool addP2pMessage(Model.P2pMessage Message)
{
string sql = "insert into [p2p_message](host_id ,guest_id ,contents ,time ,face ,image ) values(@host_id,@guest_id,@contents,@time,@face,@image);";
List <SqlParameter> parameters = new List <SqlParameter>();
SqlParameter host_id = new SqlParameter("@host_id", SqlDbType.Int);
SqlParameter guest_id = new SqlParameter("@guest_id", SqlDbType.Int);
SqlParameter contents = new SqlParameter("@contents", SqlDbType.Text);
SqlParameter time = new SqlParameter("@time", SqlDbType.DateTime);
SqlParameter face = new SqlParameter("@face", SqlDbType.Text);
SqlParameter image = new SqlParameter("@image", SqlDbType.Text);
host_id.Value = Message.HostId;
guest_id.Value = Message.GuestId;
contents.Value = Message.Contents;
time.Value = Message.Time;
face.Value = Message.Face;
image.Value = Message.image;
parameters.Add(host_id);
parameters.Add(guest_id);
parameters.Add(contents);
parameters.Add(time);
parameters.Add(face);
parameters.Add(image);
int result = SqlDbHelper.ExecuteNoQuery(sql, CommandType.Text, parameters);
if (result == 1)
{
return(true);
}
else
{
return(false);
}
}
public bool addP2pMessage(Model.P2pMessage Message); //添加P2p消息
//添加好友分组
public bool addP2pMessage(Model.P2pMessage Message)
{
bool result = MessageDal.addP2pMessage(Message);
return(result);
}