public void GetBalance()
{
DistributorQuery query = new DistributorQuery();
query.Username = searchKey;
query.RealName = realName;
query.PageIndex = pager.PageIndex;
query.PageSize = pager.PageSize;
DbQueryResult distributorBalance = DistributorHelper.GetDistributorBalance(query);
grdDistributorAccountList.DataSource = distributorBalance.Data;
grdDistributorAccountList.DataBind();
pager.TotalRecords = distributorBalance.TotalRecords;
pager1.TotalRecords = distributorBalance.TotalRecords;
}
public static DbQueryResult GetDistributors(DistributorQuery query)
{
return DistributorProvider.Instance().GetDistributors(query);
}
public abstract DbQueryResult GetDistributors(DistributorQuery query);
public abstract DbQueryResult GetDistributorBalance(DistributorQuery query);
private void BindDistributorRequest()
{
DistributorQuery query = new DistributorQuery();
query.IsApproved = false;
query.PageIndex = pager.PageIndex;
query.PageSize = pager.PageSize;
query.Username = Keywords;
query.RealName = RealName;
query.SortBy = "CreateDate";
query.SortOrder = SortAction.Desc;
DbQueryResult distributors = DistributorHelper.GetDistributors(query);
grdDistributorRequests.DataSource = distributors.Data;
grdDistributorRequests.DataBind();
pager.TotalRecords = distributors.TotalRecords;
pager1.TotalRecords = distributors.TotalRecords;
}
public override DbQueryResult GetDistributors(DistributorQuery query)
{
StringBuilder builder = new StringBuilder();
builder.AppendFormat("IsApproved = {0}", query.IsApproved ? 1 : 0);
if (!string.IsNullOrEmpty(query.Username))
{
builder.AppendFormat(" AND UserName LIKE '%{0}%'", DataHelper.CleanSearchString(query.Username));
}
if (!string.IsNullOrEmpty(query.RealName))
{
builder.AppendFormat(" AND RealName LIKE '%{0}%'", DataHelper.CleanSearchString(query.RealName));
}
if (query.GradeId.HasValue)
{
builder.AppendFormat(" AND GradeId = {0}", query.GradeId);
}
if (query.LineId.HasValue)
{
builder.AppendFormat(" AND UserId IN (SELECT UserId FROM Hishop_DistributorProductLines WHERE LineId={0})", query.LineId.Value);
}
return DataHelper.PagingByRownumber(query.PageIndex, query.PageSize, query.SortBy, query.SortOrder, query.IsCount, "vw_aspnet_Distributors", "UserId", builder.ToString(), "*");
}
public override DbQueryResult GetDistributorBalance(DistributorQuery query)
{
if (null == query)
{
return new DbQueryResult();
}
DbQueryResult result = new DbQueryResult();
StringBuilder builder = new StringBuilder();
string str = string.Empty;
if (!string.IsNullOrEmpty(query.Username))
{
str = string.Format("AND UserName LIKE '%{0}%'", DataHelper.CleanSearchString(query.Username));
}
if (!string.IsNullOrEmpty(query.RealName))
{
str = str + string.Format(" AND RealName LIKE '%{0}%'", DataHelper.CleanSearchString(query.RealName));
}
builder.AppendFormat("SELECT TOP {0} *", query.PageSize);
builder.Append(" FROM vw_aspnet_Distributors WHERE IsApproved = 1");
if (query.PageIndex == 1)
{
builder.AppendFormat(" {0} ORDER BY CreateDate DESC", str);
}
else
{
builder.AppendFormat(" AND CreateDate < (select min(CreateDate) FROM (SELECT TOP {0} CreateDate FROM vw_aspnet_Distributors WHERE IsApproved = 1 {1} ORDER BY CreateDate DESC ) AS tbltemp) {1} ORDER BY CreateDate DESC", (query.PageIndex - 1) * query.PageSize, str);
}
if (query.IsCount)
{
builder.AppendFormat(" ;SELECT COUNT(CreateDate) AS Total FROM vw_aspnet_Distributors WHERE 0=0 {0}", str);
}
DbCommand sqlStringCommand = database.GetSqlStringCommand(builder.ToString());
using (IDataReader reader = database.ExecuteReader(sqlStringCommand))
{
result.Data = DataHelper.ConverDataReaderToDataTable(reader);
if (query.IsCount && reader.NextResult())
{
reader.Read();
result.TotalRecords = reader.GetInt32(0);
}
}
return result;
}
private void BindDistributors()
{
DistributorQuery query = new DistributorQuery();
query.IsApproved = true;
query.PageIndex = pager.PageIndex;
query.PageSize = pager.PageSize;
query.GradeId = gradeId;
query.LineId = lineId;
query.Username = userName;
query.RealName = realName;
query.SortBy = grdDistributorList.SortOrderBy;
if (grdDistributorList.SortOrder.ToLower() == "desc")
{
query.SortOrder = SortAction.Desc;
}
DbQueryResult distributors = DistributorHelper.GetDistributors(query);
grdDistributorList.DataSource = distributors.Data;
grdDistributorList.DataBind();
pager.TotalRecords = distributors.TotalRecords;
pager1.TotalRecords = distributors.TotalRecords;
}