protected void rptypelist_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (string.IsNullOrEmpty(this.StoreName) && ((e.Item.ItemType == ListItemType.Item) || (e.Item.ItemType == ListItemType.AlternatingItem)))
{
Repeater repeater = e.Item.FindControl("reCommissionsChild") as Repeater;
DataRowView dataItem = (DataRowView)e.Item.DataItem;
int num = Convert.ToInt32(dataItem.Row["ReferralUserId"]);
string str = dataItem.Row["OrderId"].ToString();
if ((num > 0) && (str != ""))
{
CommissionsQuery entity = new CommissionsQuery {
ReferralUserId = num,
StoreName = "",
OrderNum = str,
EndTime = "",
StartTime = "",
PageIndex = 1,
PageSize = 0x3e8,
SortOrder = SortAction.Desc,
SortBy = "CommId"
};
Globals.EntityCoding(entity, true);
DbQueryResult commissionsWithStoreName = VShopHelper.GetCommissionsWithStoreName(entity, "3");
repeater.DataSource = commissionsWithStoreName.Data;
repeater.DataBind();
}
}
}
private void BindData()
{
DateTime time;
CommissionsQuery entity = new CommissionsQuery {
StoreName = this.StoreName,
OrderNum = this.OrderId,
EndTime = this.EndTime,
StartTime = this.StartTime,
PageIndex = this.pager.PageIndex,
PageSize = this.pager.PageSize,
SortOrder = SortAction.Desc,
SortBy = "CommId"
};
Globals.EntityCoding(entity, true);
DbQueryResult commissionsWithStoreName = VShopHelper.GetCommissionsWithStoreName(entity, "0");
this.reCommissions.DataSource = commissionsWithStoreName.Data;
this.reCommissions.DataBind();
this.pager.TotalRecords = commissionsWithStoreName.TotalRecords;
if (!DateTime.TryParse(this.StartTime, out time))
{
time = DateTime.Parse("2015-01-01");
}
this.CurrentTotal = DistributorsBrower.GetUserCommissions(0, time, this.EndTime, this.StoreName, entity.OrderNum, "");
}
private void BindData()
{
CommissionsQuery commissionsQuery = new CommissionsQuery();
commissionsQuery.StoreName = this.StoreName;
commissionsQuery.OrderNum = this.OrderId;
commissionsQuery.EndTime = this.EndTime;
commissionsQuery.StartTime = this.StartTime;
commissionsQuery.PageIndex = this.pager.PageIndex;
commissionsQuery.PageSize = this.pager.PageSize;
commissionsQuery.SortOrder = SortAction.Desc;
commissionsQuery.SortBy = "CommId";
Globals.EntityCoding(commissionsQuery, true);
DbQueryResult commissionsWithStoreName = VShopHelper.GetCommissionsWithStoreName(commissionsQuery, "0");
this.reCommissions.DataSource = commissionsWithStoreName.Data;
this.reCommissions.DataBind();
this.pager.TotalRecords = commissionsWithStoreName.TotalRecords;
System.DateTime fromdatetime;
if (!System.DateTime.TryParse(this.StartTime, out fromdatetime))
{
fromdatetime = System.DateTime.Parse("2015-01-01");
}
this.CurrentTotal = DistributorsBrower.GetUserCommissions(0, fromdatetime, this.EndTime, this.StoreName, commissionsQuery.OrderNum, "");
}
protected void rptypelist_ItemDataBound(object sender, System.Web.UI.WebControls.RepeaterItemEventArgs e)
{
if (string.IsNullOrEmpty(this.StoreName) && (e.Item.ItemType == System.Web.UI.WebControls.ListItemType.Item || e.Item.ItemType == System.Web.UI.WebControls.ListItemType.AlternatingItem))
{
System.Web.UI.WebControls.Repeater repeater = e.Item.FindControl("reCommissionsChild") as System.Web.UI.WebControls.Repeater;
System.Data.DataRowView dataRowView = (System.Data.DataRowView)e.Item.DataItem;
int num = System.Convert.ToInt32(dataRowView.Row["ReferralUserId"]);
string text = dataRowView.Row["OrderId"].ToString();
if (num > 0 && text != "")
{
CommissionsQuery commissionsQuery = new CommissionsQuery();
commissionsQuery.ReferralUserId = num;
commissionsQuery.StoreName = "";
commissionsQuery.OrderNum = text;
commissionsQuery.EndTime = "";
commissionsQuery.StartTime = "";
commissionsQuery.PageIndex = 1;
commissionsQuery.PageSize = 1000;
commissionsQuery.SortOrder = SortAction.Desc;
commissionsQuery.SortBy = "CommId";
Globals.EntityCoding(commissionsQuery, true);
DbQueryResult commissionsWithStoreName = VShopHelper.GetCommissionsWithStoreName(commissionsQuery, "3");
repeater.DataSource = commissionsWithStoreName.Data;
repeater.DataBind();
}
}
}
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()
{
DateTime time;
CommissionsQuery entity = new CommissionsQuery {
UserId = int.Parse(this.Page.Request.QueryString["UserId"]),
EndTime = this.EndTime,
StartTime = this.StartTime,
PageIndex = this.pager.PageIndex,
PageSize = this.pager.PageSize,
SortOrder = SortAction.Desc,
SortBy = "CommId"
};
Globals.EntityCoding(entity, true);
DbQueryResult commissionsWithStoreName = VShopHelper.GetCommissionsWithStoreName(entity);
this.reCommissions.DataSource = commissionsWithStoreName.Data;
this.reCommissions.DataBind();
this.pager.TotalRecords = commissionsWithStoreName.TotalRecords;
if (!DateTime.TryParse(this.StartTime, out time))
{
time = DateTime.Parse("2015-01-01");
}
this.CurrentTotal = DistributorsBrower.GetUserCommissions(entity.UserId, time, this.EndTime, null, null);
DistributorsInfo userIdDistributors = DistributorsBrower.GetUserIdDistributors(entity.UserId);
this.CurrentStoreName = userIdDistributors.StoreName;
}
protected override void AttachChildControls()
{
if (DistributorsBrower.GetCurrentDistributors(Globals.GetCurrentMemberUserId(), true).ReferralStatus != 0)
{
HttpContext.Current.Response.Redirect("MemberCenter.aspx");
}
else
{
CommissionsQuery query;
this.vshopcommssion = (VshopTemplatedRepeater)this.FindControl("vshopcommssion");
query = new CommissionsQuery
{
StartTime = "",
EndTime = "",
PageIndex = 1,
PageSize = 0x186a0,
UserId = Globals.GetCurrentMemberUserId()
};
DbQueryResult commissions = DistributorsBrower.GetCommissions(query);
if (commissions.TotalRecords > 0)
{
this.vshopcommssion.DataSource = commissions.Data;
this.vshopcommssion.DataBind();
}
}
}
private void BindData()
{
DbQueryResult commissionsWithStoreName;
DateTime time;
CommissionsQuery entity = new CommissionsQuery
{
UserId = int.Parse(this.Page.Request.QueryString["UserId"]),
EndTime = this.EndTime,
StartTime = this.StartTime,
PageIndex = this.pager.PageIndex,
PageSize = this.pager.PageSize,
SortOrder = SortAction.Desc,
SortBy = "CommId"
};
Globals.EntityCoding(entity, true);
if (this.subLevel == "0")
{
commissionsWithStoreName = VShopHelper.GetCommissionsWithStoreName(entity, "5");
this.reCommissions.DataSource = commissionsWithStoreName.Data;
this.reCommissions.DataBind();
}
else if (this.subLevel == "45")
{
commissionsWithStoreName = VShopHelper.GetCommissionsWithStoreName(entity, "4");
this.otherCommissions.DataSource = commissionsWithStoreName.Data;
this.otherCommissions.DataBind();
}
else
{
commissionsWithStoreName = VShopHelper.GetSubDistributorsContribute(this.StartTime, this.EndTime, this.pager.PageSize, this.pager.PageIndex, this.userid, int.Parse(this.subLevel));
this.SubCommissions.DataSource = commissionsWithStoreName.Data;
this.SubCommissions.DataBind();
}
this.pager.TotalRecords = commissionsWithStoreName.TotalRecords;
if (!DateTime.TryParse(this.StartTime, out time))
{
time = DateTime.Parse("2015-01-01");
}
this.CurrentTotal = DistributorsBrower.GetUserCommissions(entity.UserId, time, this.EndTime, null, null, "");
decimal num = DistributorsBrower.GetUserCommissions(entity.UserId, time, this.EndTime, null, null, "0");
decimal num2 = DistributorsBrower.GetUserCommissions(entity.UserId, time, this.EndTime, null, null, "1");
decimal num3 = DistributorsBrower.GetUserCommissions(entity.UserId, time, this.EndTime, null, null, "2");
decimal num4 = ((this.CurrentTotal - num) - num2) - num3;
this.storeSum.Text = num.ToString("f2");
this.fristSum.Text = num2.ToString("f2");
this.secondSum.Text = num3.ToString("f2");
this.OtherSum.Text = num4.ToString("f2");
DistributorsInfo userIdDistributors = DistributorsBrower.GetUserIdDistributors(entity.UserId);
this.CurrentStoreName = userIdDistributors.StoreName;
}
private void BindData()
{
CommissionsQuery commissionsQuery = new CommissionsQuery();
commissionsQuery.UserId = int.Parse(this.Page.Request.QueryString["UserId"]);
commissionsQuery.EndTime = this.EndTime;
commissionsQuery.StartTime = this.StartTime;
commissionsQuery.PageIndex = this.pager.PageIndex;
commissionsQuery.PageSize = this.pager.PageSize;
commissionsQuery.SortOrder = SortAction.Desc;
commissionsQuery.SortBy = "CommId";
Globals.EntityCoding(commissionsQuery, true);
DbQueryResult dbQueryResult;
if (this.subLevel == "0")
{
dbQueryResult = VShopHelper.GetCommissionsWithStoreName(commissionsQuery, "5");
this.reCommissions.DataSource = dbQueryResult.Data;
this.reCommissions.DataBind();
}
else if (this.subLevel == "45")
{
dbQueryResult = VShopHelper.GetCommissionsWithStoreName(commissionsQuery, "4");
this.otherCommissions.DataSource = dbQueryResult.Data;
this.otherCommissions.DataBind();
}
else
{
dbQueryResult = VShopHelper.GetSubDistributorsContribute(this.StartTime, this.EndTime, this.pager.PageSize, this.pager.PageIndex, this.userid, int.Parse(this.subLevel));
this.SubCommissions.DataSource = dbQueryResult.Data;
this.SubCommissions.DataBind();
}
this.pager.TotalRecords = dbQueryResult.TotalRecords;
System.DateTime fromdatetime;
if (!System.DateTime.TryParse(this.StartTime, out fromdatetime))
{
fromdatetime = System.DateTime.Parse("2015-01-01");
}
this.CurrentTotal = DistributorsBrower.GetUserCommissions(commissionsQuery.UserId, fromdatetime, this.EndTime, null, null, "");
decimal userCommissions = DistributorsBrower.GetUserCommissions(commissionsQuery.UserId, fromdatetime, this.EndTime, null, null, "0");
decimal userCommissions2 = DistributorsBrower.GetUserCommissions(commissionsQuery.UserId, fromdatetime, this.EndTime, null, null, "1");
decimal userCommissions3 = DistributorsBrower.GetUserCommissions(commissionsQuery.UserId, fromdatetime, this.EndTime, null, null, "2");
decimal num = this.CurrentTotal - userCommissions - userCommissions2 - userCommissions3;
this.storeSum.Text = userCommissions.ToString("f2");
this.fristSum.Text = userCommissions2.ToString("f2");
this.secondSum.Text = userCommissions3.ToString("f2");
this.OtherSum.Text = num.ToString("f2");
DistributorsInfo userIdDistributors = DistributorsBrower.GetUserIdDistributors(commissionsQuery.UserId);
this.CurrentStoreName = userIdDistributors.StoreName;
}
public DbQueryResult GetCommissions(CommissionsQuery query)
{
StringBuilder builder = new StringBuilder();
builder.Append(" State=1 ");
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, "*"));
}
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 commissionsQuery = new CommissionsQuery();
commissionsQuery.UserId = this.userid;
commissionsQuery.EndTime = this.EndTime;
commissionsQuery.StartTime = this.StartTime;
commissionsQuery.PageIndex = this.pager.PageIndex;
commissionsQuery.ReferralUserId = this.ReferralUserId;
commissionsQuery.PageSize = this.pager.PageSize;
commissionsQuery.SortOrder = SortAction.Desc;
commissionsQuery.SortBy = "CommId";
Globals.EntityCoding(commissionsQuery, true);
DbQueryResult commissionsWithStoreName = VShopHelper.GetCommissionsWithStoreName(commissionsQuery, "");
this.reCommissions.DataSource = commissionsWithStoreName.Data;
this.reCommissions.DataBind();
this.pager.TotalRecords = commissionsWithStoreName.TotalRecords;
}
private void BindData()
{
CommissionsQuery entity = new CommissionsQuery {
UserId = this.userid,
EndTime = this.EndTime,
StartTime = this.StartTime,
PageIndex = this.pager.PageIndex,
ReferralUserId = this.ReferralUserId,
PageSize = this.pager.PageSize,
SortOrder = SortAction.Desc,
SortBy = "CommId"
};
Globals.EntityCoding(entity, true);
DbQueryResult commissionsWithStoreName = VShopHelper.GetCommissionsWithStoreName(entity, "");
this.reCommissions.DataSource = commissionsWithStoreName.Data;
this.reCommissions.DataBind();
this.pager.TotalRecords = commissionsWithStoreName.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;
}
protected override void AttachChildControls()
{
DistributorsInfo currentDistributors = DistributorsBrower.GetCurrentDistributors(Globals.GetCurrentMemberUserId(), true);
if (currentDistributors.ReferralStatus != 0)
{
System.Web.HttpContext.Current.Response.Redirect("MemberCenter.aspx");
}
else
{
this.vshopcommssion = (VshopTemplatedRepeater)this.FindControl("vshopcommssion");
CommissionsQuery commissionsQuery = new CommissionsQuery();
commissionsQuery.StartTime = (commissionsQuery.EndTime = "");
commissionsQuery.PageIndex = 1;
commissionsQuery.PageSize = 100000;
commissionsQuery.UserId = Globals.GetCurrentMemberUserId();
DbQueryResult commissions = DistributorsBrower.GetCommissions(commissionsQuery);
if (commissions.TotalRecords > 0)
{
this.vshopcommssion.DataSource = commissions.Data;
this.vshopcommssion.DataBind();
}
}
}
public static DbQueryResult GetCommissionsWithStoreName(CommissionsQuery query, [Optional, DefaultParameterValue("")] string subLevel)
{
return(new DistributorsDao().GetCommissionsWithStoreName(query, subLevel));
}
public static DbQueryResult GetCommissions(CommissionsQuery query)
{
return(new DistributorsDao().GetCommissions(query));
}
protected override void AttachChildControls()
{
this.vshopcommssion = (VshopTemplatedRepeater)this.FindControl("vshopcommssion");
this.lbltotalcommission = (FormatedMoneyLabel)this.FindControl("lbltotalcommission");
this.lblsurpluscommission = (FormatedMoneyLabel)this.FindControl("lblsurpluscommission");
this.lblAlreadycommission = (FormatedMoneyLabel)this.FindControl("lblAlreadycommission");
this.lblcommission = (FormatedMoneyLabel)this.FindControl("lblcommission");
this.lbltwocommission = (FormatedMoneyLabel)this.FindControl("lbltwocommission");
this.lblthreecommission = (FormatedMoneyLabel)this.FindControl("lblthreecommission");
this.lblsaleprice = (FormatedMoneyLabel)this.FindControl("lblsaleprice");
this.lbltwosaleprice = (FormatedMoneyLabel)this.FindControl("lbltwosaleprice");
this.lblthreesaleprice = (FormatedMoneyLabel)this.FindControl("lblthreesaleprice");
this.paneltwo = (Panel)this.FindControl("paneltwo");
this.panelthree = (Panel)this.FindControl("panelthree");
this.litMsg = (Literal)this.FindControl("litMsg");
this.hyrequest = (HyperLink)this.FindControl("hyrequest");
PageTitle.AddSiteNameTitle("我的佣金");
DistributorsInfo userIdDistributors = DistributorsBrower.GetUserIdDistributors(Globals.GetCurrentMemberUserId());
DataTable currentDistributorsCommosion = DistributorsBrower.GetCurrentDistributorsCommosion(userIdDistributors.UserId);
if ((userIdDistributors != null) && (userIdDistributors.UserId > 0))
{
this.lblsurpluscommission.Money = userIdDistributors.ReferralBlance;
this.lblAlreadycommission.Money = userIdDistributors.ReferralRequestBalance;
if (userIdDistributors.DistributorGradeId == DistributorGrade.TowDistributor)
{
this.paneltwo.Visible = false;
}
else if (userIdDistributors.DistributorGradeId == DistributorGrade.ThreeDistributor)
{
this.paneltwo.Visible = false;
this.panelthree.Visible = false;
}
if ((currentDistributorsCommosion != null) && (currentDistributorsCommosion.Rows.Count > 0))
{
this.lblcommission.Money = currentDistributorsCommosion.Rows[0]["CommTotal"];
this.lblsaleprice.Money = currentDistributorsCommosion.Rows[0]["OrderTotal"];
}
if (userIdDistributors.DistributorGradeId == DistributorGrade.OneDistributor)
{
currentDistributorsCommosion = DistributorsBrower.GetDistributorsCommosion(userIdDistributors.UserId, DistributorGrade.TowDistributor);
if ((currentDistributorsCommosion != null) && (currentDistributorsCommosion.Rows.Count > 0))
{
this.lbltwocommission.Money = currentDistributorsCommosion.Rows[0]["CommTotal"];
this.lbltwosaleprice.Money = currentDistributorsCommosion.Rows[0]["OrderTotal"];
}
currentDistributorsCommosion = DistributorsBrower.GetDistributorsCommosion(userIdDistributors.UserId, DistributorGrade.ThreeDistributor);
if ((currentDistributorsCommosion != null) && (currentDistributorsCommosion.Rows.Count > 0))
{
this.lblthreecommission.Money = currentDistributorsCommosion.Rows[0]["CommTotal"];
this.lblthreesaleprice.Money = currentDistributorsCommosion.Rows[0]["OrderTotal"];
}
}
if (userIdDistributors.DistributorGradeId == DistributorGrade.TowDistributor)
{
currentDistributorsCommosion = DistributorsBrower.GetDistributorsCommosion(userIdDistributors.UserId, DistributorGrade.ThreeDistributor);
if ((currentDistributorsCommosion != null) && (currentDistributorsCommosion.Rows.Count > 0))
{
this.lblthreecommission.Money = currentDistributorsCommosion.Rows[0]["CommTotal"];
this.lblthreesaleprice.Money = currentDistributorsCommosion.Rows[0]["OrderTotal"];
}
}
this.lbltotalcommission.Money = userIdDistributors.ReferralBlance + userIdDistributors.ReferralRequestBalance;
if (DistributorsBrower.IsExitsCommionsRequest())
{
this.hyrequest.Text = "申请审核当中……";
this.hyrequest.Enabled = false;
}
MemberInfo currentMember = MemberProcessor.GetCurrentMember();
if (string.IsNullOrEmpty(currentMember.RealName) || string.IsNullOrEmpty(currentMember.CellPhone))
{
this.hyrequest.NavigateUrl = "UserInfo.aspx?edit=true&&returnUrl=" + Globals.UrlEncode(Globals.HostPath(HttpContext.Current.Request.Url) + "/Vshop/RequestCommissions.aspx");
}
//明细列表
CommissionsQuery query;
this.vshopcommssion = (VshopTemplatedRepeater)this.FindControl("vshopcommssion");
query = new CommissionsQuery();
query.StartTime = query.EndTime = "";
query.PageIndex = 1;
query.PageSize = 0x186a0;
query.UserId = MemberProcessor.GetCurrentMember().UserId;
Hidistro.Core.Entities.DbQueryResult commissions = DistributorsBrower.GetCommissions(query);
if (commissions.TotalRecords > 0)
{
this.vshopcommssion.DataSource = commissions.Data;
this.vshopcommssion.DataBind();
}
}
}
public static DbQueryResult GetCommissionsWithStoreName(CommissionsQuery query, string subLevel = "")
{
return((new DistributorsDao()).GetCommissionsWithStoreName(query, subLevel));
}
