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