Esempio n. 1
0
        /// <summary>
        /// 是否已存在相同的Case
        /// </summary>
        /// <param name="info">投诉内容实体</param>
        /// <param name="oldComplainID">已存在的相关投诉</param>
        /// <returns>如果存在返回真,否则返回假</returns>
        public bool IsSameCaseExist(SOComplaintCotentInfo info, ref object oldComplainID)
        {
            // 距当前时间一个工作日的时间点
            DateTime          tmpStarttime = CommonUtility.AddWorkMinute(DateTime.Now, -1 * 60 * 9);
            CustomDataCommand cmd          = DataCommandManager.CreateCustomDataCommandFromConfig("IsSameComplainCaseExist");

            cmd.AddInputParameter("@SOSysNo", DbType.Int32, info.SOSysNo);
            cmd.AddInputParameter("@CustomerSysno", DbType.Int32, info.CustomerSysNo);
            cmd.AddInputParameter("@Subject", DbType.String, info.Subject.Trim());
            cmd.AddInputParameter("@StartTime", DbType.DateTime, tmpStarttime);
            cmd.AddInputParameter("@CompanyCode", DbType.AnsiStringFixedLength, info.CompanyCode);
            oldComplainID = cmd.ExecuteScalar();
            return(oldComplainID != null);
        }