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); }