/// <summary>
/// ����Ƿ��Ѿ����ڵ�ǰ�û���Complain
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public static bool IsExistComplain(TopicComplainInfo 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_EXITCOMPLAIN);
cmd.Parameters.AddRange(parms);
cmd.CommandTimeout = 180;
return Convert.ToInt32(SqlHelper.ExecuteScalar(cmd)) > 0;
}
public static int InsertTopicComplain(TopicComplainInfo info)
{
SqlParameter[] parms = new SqlParameter[]
{
new SqlParameter("@TopicSysNo", SqlDbType.Int),
new SqlParameter("@Memo", SqlDbType.NVarChar),
new SqlParameter("@CreateUserType", SqlDbType.Int),
new SqlParameter("@CreateUserSysNo", SqlDbType.Int)
};
parms[0].Value = info.TopicSysNo;
parms[1].Value = info.Memo;
parms[2].Value = info.CreateUserType;
parms[3].Value = info.CreateUserSysNo;
UpdateTopicRemarkCount(info);
SqlCommand cmd = new SqlCommand(SQL_INSERT_TOPICCOMPLAIN);
cmd.Parameters.AddRange(parms);
cmd.CommandTimeout = 180;
return Convert.ToInt32(SqlHelper.ExecuteScalar(cmd));
}
// Ͷ������
public static int SetComplain(TopicComplainInfo info)
{
if (TopicComplainDac.IsExistComplain(info))
return -1; //�Ѵ��ڵ�ǰ�û���Ͷ��
else
{
TopicComplainDac.InsertTopicComplain(info);
return 0; //Ͷ�߳ɹ�
}
}
public static void ComplainTopic(TopicComplainInfo complain)
{
TopicComplainDac.InsertTopicComplain(complain);
}
protected static TopicComplainInfo Map(DataRow row)
{
TopicComplainInfo info = new TopicComplainInfo();
info.SysNo = Convert.ToInt32(row["SysNo"]);
info.TopicSysNo = Convert.ToInt32(row["TopicSysNo"]);
info.Memo = row["Memo"].ToString();
info.CreateUserType = (AppEnum.CreateUserType)Convert.ToInt32(row["CreateUserType"]);
info.CreateUserSysNo = Convert.ToInt32(row["CreateUserSysNo"]);
info.CreateDate = Convert.ToDateTime(row["CreateDate"]);
return info;
}
/// <summary>
/// ���������е� TotalComplainCount, ʹ�ñ���һ��
/// </summary>
/// <param name="info"></param>
private static void UpdateTopicRemarkCount(TopicComplainInfo info)
{
string sql = @"UPDATE Topic_Master
SET TotalComplainCount = TotalComplainCount+1 WHERE SysNo = " + info.TopicSysNo;
SqlHelper.ExecuteScalar(sql);
}
