public static List <TopicReplyInfo> GetValidTopicReplyByTopicId(int topicSysNo) { TopicReplySearchCondition sc = new TopicReplySearchCondition(); sc.Status = 0; return(GetTopicReplyByTopicId(topicSysNo, sc)); }
private static List <TopicReplyInfo> GetTopicReplyByTopicId(int topicSysNo, TopicReplySearchCondition rsc) { string sqlStr = SQL_GET_TOPICREPLY_BY_TOPICID; DataTable dt = new DataTable(); if (topicSysNo != 0) { sqlStr = sqlStr.Replace("@select", "select "); sqlStr = sqlStr.Replace("@sqlPar", " Topic_Reply.TopicSysNo = @TopicSysNo @STATUS ORDER BY Topic_Reply.CreateDate desc"); if (rsc != null && rsc.Status != null) { sqlStr = sqlStr.Replace("@STATUS", "AND Topic_Reply.Status = " + rsc.Status); } else { sqlStr = sqlStr.Replace("@STATUS", ""); } SqlParameter[] parms = new SqlParameter[] { new SqlParameter("@TopicSysNo", SqlDbType.Int) }; parms[0].Value = topicSysNo; dt = SqlHelper.ExecuteDataSet(sqlStr, parms).Tables[0]; } else { StringBuilder sb = new StringBuilder(" CreateUserType = 0 "); if (rsc.DateFrom != null) { sb.Append(" and Topic_Reply.CreateDate >= '" + rsc.DateFrom + "' "); } if (rsc.DateTo != null) { sb.Append(" and Topic_Reply.CreateDate <= '" + rsc.DateTo.Value.AddDays(1).AddSeconds(-1) + "' "); } if (rsc.Status != null) { sb.Append(" and Topic_Reply.Status = " + rsc.Status + ""); } if (rsc.CustomerId != string.Empty) { sb.Append(" and CreateUserSysNo IN (SELECT SysNo FROM Customer (NOLOCK) WHERE CustomerId LIKE '%" + rsc.CustomerId + "%') "); } sb.Append(" ORDER BY Topic_Reply.CreateDate DESC"); if (rsc.InEmpty == true) { sqlStr = sqlStr.Replace("@select", "select top 50 "); } else { sqlStr = sqlStr.Replace("@select", "select "); } sqlStr = sqlStr.Replace("@sqlPar", sb.ToString()); dt = SqlHelper.ExecuteDataSet(sqlStr).Tables[0]; } if (dt == null || dt.Rows.Count == 0) { return(null); } List <TopicReplyInfo> list = new List <TopicReplyInfo>(); foreach (DataRow row in dt.Rows) { list.Add(Map(row)); } return(list); }
public static List <TopicReplyInfo> GetAllTopicReplyBySearch(TopicReplySearchCondition rsc) { return(GetTopicReplyByTopicId(0, rsc)); }