private void BindList()
{
LeaveCommentQuery query2 = new LeaveCommentQuery();
query2.PageIndex = this.pager.PageIndex;
LeaveCommentQuery query = query2;
if (!string.IsNullOrEmpty(base.Request.QueryString["MessageStatus"]))
{
query.MessageStatus = (MessageStatus) int.Parse(base.Request.QueryString["MessageStatus"]);
this.statusList.SelectedValue = query.MessageStatus;
}
DbQueryResult leaveComments = SubsiteCommentsHelper.GetLeaveComments(query);
this.leaveList.DataSource = leaveComments.Data;
this.leaveList.DataBind();
this.pager.TotalRecords = leaveComments.TotalRecords;
this.pager1.TotalRecords = leaveComments.TotalRecords;
}
private void BindList()
{
LeaveCommentQuery query = new LeaveCommentQuery();
query.PageIndex = pager.PageIndex;
query.PageSize = pager.PageSize;
if (!string.IsNullOrEmpty(base.Request.QueryString["MessageStatus"]))
{
query.MessageStatus = (MessageStatus)int.Parse(base.Request.QueryString["MessageStatus"]);
statusList.SelectedValue = query.MessageStatus;
}
DbQueryResult leaveComments = NoticeHelper.GetLeaveComments(query);
leaveList.DataSource = leaveComments.Data;
leaveList.DataBind();
pager.TotalRecords = leaveComments.TotalRecords;
pager1.TotalRecords = leaveComments.TotalRecords;
}
public static DbQueryResult GetLeaveComments(LeaveCommentQuery query)
{
return CommentProvider.Instance().GetLeaveComments(query);
}
static string BuildLeaveCommentQuery(LeaveCommentQuery query)
{
StringBuilder builder = new StringBuilder();
builder.Append(" SELECT l.LeaveId FROM Hishop_LeaveComments l where 0=0");
if (query.MessageStatus == MessageStatus.Replied)
{
builder.Append(" and (select Count(ReplyId) from Hishop_LeaveCommentReplys where LeaveId=l.LeaveId) >0 ");
}
if (query.MessageStatus == MessageStatus.NoReply)
{
builder.Append(" and (select Count(ReplyId) from Hishop_LeaveCommentReplys where LeaveId=l.LeaveId) <=0 ");
}
if (!string.IsNullOrEmpty(query.SortBy))
{
builder.AppendFormat(" ORDER BY {0} {1}", DataHelper.CleanSearchString(query.SortBy), query.SortOrder.ToString());
}
else
{
builder.Append(" ORDER BY LastDate desc");
}
return builder.ToString();
}
public override DbQueryResult GetLeaveComments(LeaveCommentQuery query)
{
DbQueryResult result = new DbQueryResult();
DbCommand storedProcCommand = database.GetStoredProcCommand("cp_LeaveComments_Get");
database.AddInParameter(storedProcCommand, "PageIndex", DbType.Int32, query.PageIndex);
database.AddInParameter(storedProcCommand, "PageSize", DbType.Int32, query.PageSize);
database.AddInParameter(storedProcCommand, "IsCount", DbType.Boolean, query.IsCount);
database.AddInParameter(storedProcCommand, "sqlPopulate", DbType.String, BuildLeaveCommentQuery(query));
database.AddOutParameter(storedProcCommand, "Total", DbType.Int32, 4);
DataSet set = database.ExecuteDataSet(storedProcCommand);
set.Relations.Add("LeaveCommentReplays", set.Tables[0].Columns["LeaveId"], set.Tables[1].Columns["LeaveId"], false);
result.Data = set;
result.TotalRecords = (int)database.GetParameterValue(storedProcCommand, "Total");
return result;
}
public override DbQueryResult GetLeaveComments(LeaveCommentQuery query)
{
StringBuilder builder = new StringBuilder();
builder.Append(" SELECT l.LeaveId FROM Hishop_LeaveComments l ");
builder.Append(" WHERE IsReply = 1 ");
builder.Append(" ORDER BY LastDate desc");
DbQueryResult result = new DbQueryResult();
DbCommand storedProcCommand = this.database.GetStoredProcCommand("ss_LeaveComments_Get");
this.database.AddInParameter(storedProcCommand, "PageIndex", DbType.Int32, query.PageIndex);
this.database.AddInParameter(storedProcCommand, "PageSize", DbType.Int32, query.PageSize);
this.database.AddInParameter(storedProcCommand, "IsCount", DbType.Boolean, query.IsCount);
this.database.AddInParameter(storedProcCommand, "sqlPopulate", DbType.String, builder.ToString());
this.database.AddOutParameter(storedProcCommand, "Total", DbType.Int32, 4);
DataSet set = this.database.ExecuteDataSet(storedProcCommand);
set.Relations.Add("LeaveCommentReplays", set.Tables[0].Columns["LeaveId"], set.Tables[1].Columns["LeaveId"], false);
result.Data = set;
result.TotalRecords = (int) this.database.GetParameterValue(storedProcCommand, "Total");
return result;
}
public abstract DbQueryResult GetLeaveComments(LeaveCommentQuery query);
void BindList()
{
LeaveCommentQuery query = new LeaveCommentQuery();
query.PageSize = 3;
query.PageIndex = this.pager.PageIndex;
DbQueryResult leaveComments = CommentBrowser.GetLeaveComments(query);
this.rptLeaveComments.DataSource = leaveComments.Data;
this.rptLeaveComments.DataBind();
this.pager.TotalRecords = (int) (leaveComments.TotalRecords * (Convert.ToDouble(this.pager.PageSize) / 3.0));
}