protected override void AttachChildControls()
{
CommissionsQuery query;
this.vshopcommssion = (VshopTemplatedRepeater)this.FindControl("vshopcommssion");
//query = new CommissionsQuery {
// StartTime = query.EndTime = "",
// PageIndex = 1,
// PageSize = 0x186a0,
// UserId = MemberProcessor.GetCurrentMember().UserId
//};
query = new CommissionsQuery();
query.StartTime = query.EndTime = "";
query.PageIndex = 1;
query.PageSize = 0x186a0;
query.UserId = MemberProcessor.GetCurrentMember().UserId;
DbQueryResult commissions = DistributorsBrower.GetCommissions(query);
if (commissions.TotalRecords > 0)
{
this.vshopcommssion.DataSource = commissions.Data;
this.vshopcommssion.DataBind();
}
}
private void BindData()
{
CommissionsQuery entity = new CommissionsQuery {
UserId = int.Parse(this.Page.Request.QueryString["UserId"]),
EndTime = "",
StartTime = "",
PageIndex = this.pager.PageIndex,
PageSize = this.pager.PageSize,
SortOrder = SortAction.Desc,
SortBy = "CommId"
};
Globals.EntityCoding(entity, true);
DbQueryResult commissions = VShopHelper.GetCommissions(entity);
this.reCommissions.DataSource = commissions.Data;
this.reCommissions.DataBind();
this.pager.TotalRecords = commissions.TotalRecords;
}
private void BindData()
{
CommissionsQuery entity = new CommissionsQuery {
EndTime = this.EndTime,
StartTime = this.StartTime,
StoreName = this.StoreName,
OrderNum = this.OrderId,
PageIndex = this.pager.PageIndex,
PageSize = this.pager.PageSize,
SortOrder = SortAction.Desc,
SortBy = "CommId"
};
Globals.EntityCoding(entity, true);
DbQueryResult commissions = VShopHelper.GetCommissions(entity);
this.reCommissions.DataSource = commissions.Data;
this.reCommissions.DataBind();
this.pager.TotalRecords = commissions.TotalRecords;
}
public static DbQueryResult GetCommissions(CommissionsQuery query)
{
return new DistributorsDao().GetCommissions(query);
}
public DbQueryResult GetCommissions(CommissionsQuery query)
{
StringBuilder builder = new StringBuilder();
if (query.UserId > 0)
{
if (builder.Length > 0)
{
builder.Append(" AND ");
}
builder.AppendFormat("UserId = {0}", query.UserId);
}
if (!string.IsNullOrEmpty(query.StoreName))
{
if (builder.Length > 0)
{
builder.Append(" AND ");
}
builder.AppendFormat("StoreName LIKE '%{0}%'", DataHelper.CleanSearchString(query.StoreName));
}
if (!string.IsNullOrEmpty(query.OrderNum))
{
if (builder.Length > 0)
{
builder.Append(" AND ");
}
builder.AppendFormat(" OrderId = {0}", query.OrderNum);
}
if (!string.IsNullOrEmpty(query.StartTime.ToString()))
{
if (builder.Length > 0)
{
builder.Append(" AND ");
}
builder.AppendFormat(" datediff(dd,'{0}',TradeTime)>=0", query.StartTime);
}
if (!string.IsNullOrEmpty(query.EndTime.ToString()))
{
if (builder.Length > 0)
{
builder.Append(" AND ");
}
builder.AppendFormat(" datediff(dd,'{0}',TradeTime)<=0", query.EndTime);
}
return DataHelper.PagingByRownumber(query.PageIndex, query.PageSize, query.SortBy, query.SortOrder, query.IsCount, "vw_Hishop_CommissionDistributors", "CommId", (builder.Length > 0) ? builder.ToString() : null, "*");
}
