public ApiResult <bool> AddMessage(TalkNotesReqDto model)
{
var result = new ApiResult <bool>();
bool bo = _service.AddMessage(model);
result.Data = bo;
return(result);
}
/// <summary>
/// 添加聊天记录
/// </summary>
/// <param name="model"></param>
public bool AddMessage(TalkNotesReqDto model)
{
string regsql = @"insert into TalkNotes (Content,UserId,UserName,PhotoImg,SendTime,RoomId,MsgTypeChild,Status,Guid,IsAdmin,MasterLottery)
values (@Content,@UserId,@UserName,@PhotoImg,@SendTime,@RoomId,@MsgTypeChild,@Status,@Guid,@IsAdmin,@MasterLottery);";
SqlParameter[] regsp = new SqlParameter[] {
new SqlParameter("@Content", model.Content),
new SqlParameter("@UserId", model.UserId),
new SqlParameter("@UserName", model.UserName),
new SqlParameter("@PhotoImg", model.PhotoImg ?? ""),
new SqlParameter("@SendTime", DateTime.Now),
new SqlParameter("@RoomId", model.RoomId),
new SqlParameter("@MsgTypeChild", model.MsgTypeChild),
new SqlParameter("@Status", 1),
new SqlParameter("@Guid", model.Guid),
new SqlParameter("@IsAdmin", model.IsAdmin),
new SqlParameter("@MasterLottery", model.MasterLottery ?? "")
};
var i = SqlHelper.ExecuteNonQuery(regsql, regsp);
return(i > 0);
}
