public void Init(CommentParameter commentParameter)
{
Message = commentParameter.Message;
Likes = commentParameter.Likes;
SocialMedia = commentParameter.SocialMedia;
CreatedTime = commentParameter.CreatedTime;
ExtractedAt = commentParameter.ExtractedAt;
ExtractedAtSince = commentParameter.ExtractedAtSince;
AuthorName = commentParameter.AuthorName;
AuthorPhoto = commentParameter.AuthorPhoto;
Sentiment = commentParameter.Sentiment;
Violence = commentParameter.Violence;
Drugs = commentParameter.Drugs;
Bullying = commentParameter.Bullying;
Adult = commentParameter.Adult;
}
/// <summary>
/// Gets all CommentReplies.
/// </summary>
/// <param name="BenefitsParameter">The Comment Reply parameters.</param>
/// <returns></returns>
public async Task <PagedList <Entity> > GetAllComments(CommentParameter commentParameter)
{
{
{
var getCommentReplyParams = new object[] {
new MySqlParameter("@p_ReviewType", commentParameter.ReviewType),
new MySqlParameter("@p_ReferenceId", commentParameter.ReferenceId),
new MySqlParameter("@p_ApprovalStatus", commentParameter.ApprovalStatus)
};
var CommentReply = await FindAll("CALL SpSelectActiveComments(@p_ReviewType, @p_ReferenceId,@p_ApprovalStatus)", getCommentReplyParams).ToListAsync();
var mappedCommentReply = CommentReply.AsQueryable().ProjectTo <CommentReplyResponse>(mapper.ConfigurationProvider);
var sortedCommentReply = sortHelper.ApplySort(mappedCommentReply, commentParameter.OrderBy);
var shapedCommentReply = dataShaper.ShapeData(sortedCommentReply, commentParameter.Fields);
return(await PagedList <Entity> .ToPagedList(shapedCommentReply, commentParameter.PageNumber, commentParameter.PageSize));
}
}
}
public void Check_LeaveType(string typeCode, decimal hours, int?billID)
{
DepotManagementDataContext ctx = CommentParameter.DepotDataContext;
IDBOperate m_dbOperate = CommentParameter.GetDBOperatorOfDepotManagement();
HR_LeaveType leaveType = GetLeaveType(ctx, typeCode);
Hashtable paramTable = new Hashtable();
paramTable.Add("@TypeCode", leaveType.TypeCode);
paramTable.Add("@Hours", hours);
paramTable.Add("@WorkID", BasicInfo.LoginID);
paramTable.Add("@BillID", billID == null ? 0 : billID);
Dictionary <OperateCMD, object> dicOperateCMD = m_dbOperate.RunProc_CMD("HR_LeaveBill_Type_Check", paramTable);
if (!Convert.ToBoolean(dicOperateCMD[OperateCMD.Return_OperateResult]))
{
throw new Exception(Convert.ToString(dicOperateCMD[OperateCMD.Return_Errmsg]));
}
}
/// <summary>
/// 台帐
/// </summary>
/// <param name="productName">查询方式</param>
/// <param name="startDate">开始时间</param>
/// <param name="endDate">结束时间</param>
/// <param name="storageID">库房ID</param>
/// <param name="showTable">返回table数据集</param>
/// <param name="error">出错时返回错误信息，无错时返回null</param>
/// <returns>操作成功返回True，操作失败返回False</returns>
public bool GetAllGather(string productName, DateTime startDate, DateTime endDate, string storageID,
out DataTable showTable, out string error)
{
IDBOperate dbOperate = CommentParameter.GetDBOperatorOfDepotManagement();
error = null;
showTable = null;
try
{
Hashtable paramTable = new Hashtable();
if (productName == "pro_B_GoodsListGather")
{
paramTable.Add("@StartDate", startDate);
paramTable.Add("@EndDate", endDate);
}
DataSet ds = new DataSet();
Dictionary <OperateCMD, object> dicOperateCMD = dbOperate.RunProc_CMD(productName, ds, paramTable);
if (!Convert.ToBoolean(dicOperateCMD[OperateCMD.Return_OperateResult]))
{
error = Convert.ToString(dicOperateCMD[OperateCMD.Return_Errmsg]);
return(false);
}
showTable = ds.Tables[0];
return(true);
}
catch (Exception ex)
{
error = ex.Message;
return(false);
}
}
/// <summary>
/// Initializes a new instance of the <see cref="GetAllCommentRepliesQuery"/> class.
/// </summary>
/// <param name="commentReplyParameter">The Comment Reply parameters.</param>
public GetAllCommentsQuery(CommentParameter commentParameter)
{
CommentParameter = commentParameter;
}
