private static void AbandTopicReply(int topicReplySysNo, int userSysNo, AppEnum.TopicReplyStatus status, string sysNos)
{
string sqlStr;
if (sysNos == string.Empty)
{
sqlStr = SQL_UPDATE_TOPICREPLY_STATUS.Replace("SysNo=@SysNo", "SysNo=" + topicReplySysNo);
}
else
{
sqlStr = SQL_UPDATE_TOPICREPLY_STATUS.Replace("SysNo=@SysNo", "SysNo in (" + sysNos + ")");
}
SqlParameter[] parms = new SqlParameter[]
{
new SqlParameter("@Status", SqlDbType.Int),
new SqlParameter("@LastEditUserSysNo", SqlDbType.Int),
};
parms[0].Value = (int)status;
parms[1].Value = userSysNo;
SqlCommand cmd = new SqlCommand(sqlStr);
cmd.Parameters.AddRange(parms);
cmd.CommandTimeout = 180;
SqlHelper.ExecuteNonQuery(cmd);
}
public static void AbandTopicReplys(string sysNos, int userSysNo, AppEnum.TopicReplyStatus status)
{
AbandTopicReply(0, userSysNo, status, sysNos);
}
public static void AbandTopicReply(int topicReplySysNo, int userSysNo, AppEnum.TopicReplyStatus status)
{
AbandTopicReply(topicReplySysNo, userSysNo, status, string.Empty);
}
