private static void AbandTopicImage(int topicImageSysNo, AppEnum.TopicImageStatus status, string sysNos)
{
string sqlStr;
if (sysNos == string.Empty)
{
sqlStr = SQL_UPDATE_TOPICIMAGE_STATUS.Replace("SysNo=@SysNo", "SysNo=" + topicImageSysNo);
}
else
{
sqlStr = SQL_UPDATE_TOPICIMAGE_STATUS.Replace("SysNo=@SysNo", "SysNo in (" + sysNos + ")");
}
SqlParameter[] parms = new SqlParameter[]
{
new SqlParameter("@Status", SqlDbType.Int),
};
parms[0].Value = (int)status;
SqlCommand cmd = new SqlCommand(sqlStr);
cmd.Parameters.AddRange(parms);
cmd.CommandTimeout = 180;
SqlHelper.ExecuteNonQuery(cmd);
}
public void Init()
{
_sysno = AppConst.IntNull;
_TopicSysNo = AppConst.IntNull;
_ImageLink = AppConst.StringNull;
_ThumbnailLink = AppConst.StringNull;
_HitCount = AppConst.IntNull;
_Status = AppEnum.TopicImageStatus.Normal;
_CreateUserSysNo = AppConst.IntNull;
_CreateDate = AppConst.DateTimeNull;
}
public void Init()
{
_sysno = AppConst.IntNull;
_TopicSysNo = AppConst.IntNull;
_ImageLink = AppConst.StringNull;
_ThumbnailLink = AppConst.StringNull;
_HitCount = AppConst.IntNull;
_Status = AppEnum.TopicImageStatus.Normal;
_CreateUserSysNo = AppConst.IntNull;
_CreateDate = AppConst.DateTimeNull;
}
public static void AbandTopicImages(string sysNos, AppEnum.TopicImageStatus status)
{
AbandTopicImage(0, status, sysNos);
}
public static void AbandTopicImage(int topicImageSysNo, AppEnum.TopicImageStatus status)
{
AbandTopicImage(topicImageSysNo, status, string.Empty);
}
