/// <summary>
/// 设置评论是否有用
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public static int SetRemarkUseful(TopicRemarkInfo info)
{
if (TopicRemarkDac.IsExistRemark(info))
{
return(-1); // 已存在当前用户的评价
}
TopicRemarkDac.InsertTopicRemark(info);
#region 自动设为精华功能，（包括给客户添加积分）
//// 达到一定分数之后，自动设置为精华。
//if (Can_AutoSetDigest == true
// && CanAutoSetTopicDigest(info.TopicSysNo) == true)
//{
// TopicSetDigset(info.TopicSysNo, 0);
// // 奖励积分，仅限于顾客
// if (PointBonus_AutoSetDigest > 0 && info.CreateUserType == CreateUserType.Customer)
// {
// string strLog = "评论ID:" + info.TopicSysNo + ", 顾客ID:" + info.CreateUserSysNo + ", 时间:" + System.DateTime.Now.ToString("yyyy-MM-dd HH:mm");
// PointManager.GetInstance().SetScore(
// info.CreateUserSysNo,
// TopicManager.PointBonus_AutoSetDigest,
// (int)AppEnum.PointLogType.SetScoreAuto,
// strLog);
// }
//}
#endregion
return(0); // 更新评价成功
}
/// <summary>
/// 添加Remark记录
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public static int InsertTopicRemark(TopicRemarkInfo info)
{
SqlParameter[] parms = new SqlParameter[]
{
new SqlParameter("@TopicSysNo", SqlDbType.Int),
new SqlParameter("@IsUseful", SqlDbType.Int),
new SqlParameter("@CreateUserType", SqlDbType.Int),
new SqlParameter("@CreateUserSysNo", SqlDbType.Int)
};
parms[0].Value = info.TopicSysNo;
parms[1].Value = info.IsUseful ? 1 : 0;
parms[2].Value = (int)info.CreateUserType;
parms[3].Value = info.CreateUserSysNo;
UpdateTopicRemarkCount(info);
SqlCommand cmd = new SqlCommand(SQL_INSERT_TOPICREMARK);
cmd.Parameters.AddRange(parms);
cmd.CommandTimeout = 180;
object obj = SqlHelper.ExecuteScalar(cmd);
return(Convert.ToInt32(obj));
}
protected static TopicRemarkInfo Map(DataRow row)
{
TopicRemarkInfo info = new TopicRemarkInfo();
info.SysNo = Convert.ToInt32(row["SysNo"]);
info.TopicSysNo = Convert.ToInt32(row["TopicSysNo"]);
info.IsUseful = Convert.ToInt32(row["IsUseful"]) == 1;
info.CreateUserType = (AppEnum.CreateUserType)Convert.ToInt32(row["CreateUserType"]);
info.CreateUserSysNo = Convert.ToInt32(row["CreateUserSysNo"]);
info.CreateDate = Convert.ToDateTime(row["CreateDate"]);
return(info);
}
/// <summary>
/// 更新主表中的 Remark Count, 使得保持一致
/// </summary>
/// <param name="info"></param>
private static void UpdateTopicRemarkCount(TopicRemarkInfo info)
{
string sql = @"UPDATE Topic_Master
SET TotalRemarkCount = TotalRemarkCount+1, TotalUsefulRemarkCount = @NEW_TotalUsefulRemarkCount
WHERE SysNo=" + info.TopicSysNo;
if (info.IsUseful)
{
sql = sql.Replace("@NEW_TotalUsefulRemarkCount", "TotalUsefulRemarkCount + 1");
}
else
{
sql = sql.Replace("@NEW_TotalUsefulRemarkCount", "TotalUsefulRemarkCount");
}
SqlHelper.ExecuteScalar(sql);
}
/// <summary>
/// ����Ƿ��Ѿ����ڵ�ǰ�û��� Remark
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public static bool IsExistRemark(TopicRemarkInfo info)
{
SqlParameter[] parms = new SqlParameter[]
{
new SqlParameter("@TopicSysNo", SqlDbType.Int),
new SqlParameter("@CreateUserType", SqlDbType.Int),
new SqlParameter("@CreateUserSysNo", SqlDbType.Int)
};
parms[0].Value = info.TopicSysNo;
parms[1].Value = (int)info.CreateUserType;
parms[2].Value = info.CreateUserSysNo;
SqlCommand cmd = new SqlCommand(SQL_CHECK_EXITREMARK);
cmd.Parameters.AddRange(parms);
cmd.CommandTimeout = 180;
return Convert.ToInt32(SqlHelper.ExecuteScalar(cmd)) > 0;
}
/// <summary>
/// 检查是否已经存在当前用户的 Remark
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public static bool IsExistRemark(TopicRemarkInfo info)
{
SqlParameter[] parms = new SqlParameter[]
{
new SqlParameter("@TopicSysNo", SqlDbType.Int),
new SqlParameter("@CreateUserType", SqlDbType.Int),
new SqlParameter("@CreateUserSysNo", SqlDbType.Int)
};
parms[0].Value = info.TopicSysNo;
parms[1].Value = (int)info.CreateUserType;
parms[2].Value = info.CreateUserSysNo;
SqlCommand cmd = new SqlCommand(SQL_CHECK_EXITREMARK);
cmd.Parameters.AddRange(parms);
cmd.CommandTimeout = 180;
return(Convert.ToInt32(SqlHelper.ExecuteScalar(cmd)) > 0);
}
/// <summary>
/// ���Remark��¼
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public static int InsertTopicRemark(TopicRemarkInfo info)
{
SqlParameter[] parms = new SqlParameter[]
{
new SqlParameter("@TopicSysNo", SqlDbType.Int),
new SqlParameter("@IsUseful", SqlDbType.Int),
new SqlParameter("@CreateUserType", SqlDbType.Int),
new SqlParameter("@CreateUserSysNo", SqlDbType.Int)
};
parms[0].Value = info.TopicSysNo;
parms[1].Value = info.IsUseful ? 1 : 0;
parms[2].Value = (int)info.CreateUserType;
parms[3].Value = info.CreateUserSysNo;
UpdateTopicRemarkCount(info);
SqlCommand cmd = new SqlCommand(SQL_INSERT_TOPICREMARK);
cmd.Parameters.AddRange(parms);
cmd.CommandTimeout = 180;
object obj = SqlHelper.ExecuteScalar(cmd);
return Convert.ToInt32(obj);
}
/// <summary>
/// ���������Ƿ�����
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public static int SetRemarkUseful(TopicRemarkInfo info)
{
if (TopicRemarkDac.IsExistRemark(info))
return -1; // �Ѵ��ڵ�ǰ�û�������
TopicRemarkDac.InsertTopicRemark(info);
#region �Զ���Ϊ�������ܣ����������ͻ���ӻ��֣�
//// �ﵽһ������֮���Զ�����Ϊ������
//if (Can_AutoSetDigest == true
// && CanAutoSetTopicDigest(info.TopicSysNo) == true)
//{
// TopicSetDigset(info.TopicSysNo, 0);
// // �������֣������ڹ˿�
// if (PointBonus_AutoSetDigest > 0 && info.CreateUserType == CreateUserType.Customer)
// {
// string strLog = "����ID:" + info.TopicSysNo + ", �˿�ID:" + info.CreateUserSysNo + ", ʱ��:" + System.DateTime.Now.ToString("yyyy-MM-dd HH:mm");
// PointManager.GetInstance().SetScore(
// info.CreateUserSysNo,
// TopicManager.PointBonus_AutoSetDigest,
// (int)AppEnum.PointLogType.SetScoreAuto,
// strLog);
// }
//}
#endregion
return 0; // �������۳ɹ�
}
protected static TopicRemarkInfo Map(DataRow row)
{
TopicRemarkInfo info = new TopicRemarkInfo();
info.SysNo = Convert.ToInt32(row["SysNo"]);
info.TopicSysNo = Convert.ToInt32(row["TopicSysNo"]);
info.IsUseful = Convert.ToInt32(row["IsUseful"]) == 1;
info.CreateUserType = (AppEnum.CreateUserType)Convert.ToInt32(row["CreateUserType"]);
info.CreateUserSysNo = Convert.ToInt32(row["CreateUserSysNo"]);
info.CreateDate = Convert.ToDateTime(row["CreateDate"]);
return info;
}
/// <summary>
/// ���������е� Remark Count, ʹ�ñ���һ��
/// </summary>
/// <param name="info"></param>
private static void UpdateTopicRemarkCount(TopicRemarkInfo info)
{
string sql = @"UPDATE Topic_Master
SET TotalRemarkCount = TotalRemarkCount+1, TotalUsefulRemarkCount = @NEW_TotalUsefulRemarkCount
WHERE SysNo=" + info.TopicSysNo;
if (info.IsUseful)
sql = sql.Replace("@NEW_TotalUsefulRemarkCount", "TotalUsefulRemarkCount + 1");
else
sql = sql.Replace("@NEW_TotalUsefulRemarkCount", "TotalUsefulRemarkCount");
SqlHelper.ExecuteScalar(sql);
}
