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