protected override void AttachChildControls() { PageTitle.AddSiteNameTitle("下级分销商"); this.onedistributor = (Panel) this.FindControl("onedistributor"); this.twodistributor = (Panel) this.FindControl("twodistributor"); this.rpdistributor = (VshopTemplatedRepeater) this.FindControl("rpdistributor"); DistributorsQuery query = new DistributorsQuery { PageIndex = 1, PageSize = 0x2710 }; DistributorsInfo currentDistributors = DistributorsBrower.GetCurrentDistributors(Globals.GetCurrentMemberUserId()); if (currentDistributors.DistributorGradeId == DistributorGrade.OneDistributor) { query.GradeId = 2; this.twodistributor.Visible = false; } else { query.GradeId = 3; this.onedistributor.Visible = false; } int result = 0; if (int.TryParse(this.Page.Request.QueryString["gradeId"], out result)) { query.GradeId = result; } query.ReferralPath = currentDistributors.UserId.ToString(); query.UserId = currentDistributors.UserId; this.rpdistributor.DataSource = DistributorsBrower.GetDistributorsCommission(query); this.rpdistributor.DataBind(); }
private void BindData() { DistributorsQuery entity = new DistributorsQuery { GradeId = 0, StoreName = "", CellPhone = "", RealName = "", MicroSignal = "", ReferralStatus = 0, PageIndex = 1, PageSize = 15, SortOrder = SortAction.Desc, SortBy = "OrdersTotal" }; Globals.EntityCoding(entity, true); DataTable data = (DataTable) VShopHelper.GetDistributors(entity).Data; this.reDistributor.DataSource = data; this.reDistributor.DataBind(); }
private void BindData() { DistributorsQuery entity = new DistributorsQuery { GradeId = int.Parse(this.Grade), StoreName = this.StoreName, CellPhone = this.CellPhone, RealName = this.RealName, MicroSignal = this.MicroSignal, ReferralStatus = int.Parse(this.Status), PageIndex = this.pager.PageIndex, PageSize = this.pager.PageSize, SortOrder = SortAction.Desc, SortBy = "userid" }; Globals.EntityCoding(entity, true); DbQueryResult distributors = VShopHelper.GetDistributors(entity); this.reDistributor.DataSource = distributors.Data; this.reDistributor.DataBind(); this.pager.TotalRecords = distributors.TotalRecords; }
private void Bind() { DistributorsQuery entity = new DistributorsQuery { UserId = int.Parse(this.Page.Request.QueryString["UserId"]), PageIndex = 1, PageSize = 1, SortOrder = SortAction.Desc, SortBy = "userid" }; Globals.EntityCoding(entity, true); DbQueryResult distributors = VShopHelper.GetDistributors(entity); if (distributors.Data != null) { DataTable data = new DataTable(); data = (DataTable) distributors.Data; this.litUserName.Text = data.Rows[0]["RealName"].ToString(); this.lblStoreName.Text = data.Rows[0]["StoreName"].ToString(); this.litRealName.Text = data.Rows[0]["RealName"].ToString(); this.litCellPhone.Text = data.Rows[0]["CellPhone"].ToString(); this.litQQ.Text = data.Rows[0]["QQ"].ToString(); this.litMicroSignal.Text = data.Rows[0]["MicroSignal"].ToString(); this.litGreade.Text = (data.Rows[0]["GradeId"].ToString() == "1") ? "一级" : ((data.Rows[0]["GradeId"].ToString() == "2") ? "二级" : "三级"); this.litOrders.Text = "本站订单数:" + data.Rows[0]["ReferralOrders"].ToString() + ",所有下级分销商订单数:" + VShopHelper.GetDownDistributorNumReferralOrders(data.Rows[0]["UserId"].ToString()).ToString(); this.litCommission.Text = data.Rows[0]["ReferralBlance"].ToString(); DistributorsInfo userIdDistributors = VShopHelper.GetUserIdDistributors(int.Parse(data.Rows[0]["ReferralUserId"].ToString())); if (userIdDistributors != null) { this.litUpGrade.Text = userIdDistributors.StoreName; } else { this.litUpGrade.Text = "一级分销商"; } this.litDownGradeNum.Text = VShopHelper.GetDownDistributorNum(data.Rows[0]["UserId"].ToString()).ToString(); } else { this.ShowMsg("分销商信息不存在!", false); } }
public static DataTable GetDistributorsCommission(DistributorsQuery query) { return new DistributorsDao().GetDistributorsCommission(query); }
public static DbQueryResult GetDistributors(DistributorsQuery query) { return new DistributorsDao().GetDistributors(query); }
public DataTable GetDistributorsCommission(DistributorsQuery query) { StringBuilder builder = new StringBuilder("1=1"); if (query.GradeId > 0) { builder.AppendFormat("AND GradeId = {0}", query.GradeId); } if (!string.IsNullOrEmpty(query.ReferralPath)) { builder.AppendFormat(" AND (ReferralPath LIKE '{0}|%' OR ReferralPath LIKE '%|{0}|%' OR ReferralPath LIKE '%|{0}' OR ReferralPath='{0}')", DataHelper.CleanSearchString(query.ReferralPath)); } string str = string.Concat(new object[] { "select TOP ", query.PageSize, " UserId,StoreName,GradeId,CreateTime,isnull((select SUM(OrderTotal) from Hishop_Commissions where UserId=", query.UserId, " AND ReferralUserId=aspnet_Distributors.UserId),0) as OrderTotal,isnull((select SUM(CommTotal) from Hishop_Commissions where UserId=", query.UserId, " AND ReferralUserId=aspnet_Distributors.UserId),0) as CommTotal from aspnet_Distributors WHERE ", builder.ToString(), " order by CreateTime " }); DbCommand sqlStringCommand = this.database.GetSqlStringCommand(str); return this.database.ExecuteDataSet(sqlStringCommand).Tables[0]; }
public DbQueryResult GetDistributors(DistributorsQuery query) { StringBuilder builder = new StringBuilder(); if (query.GradeId > 0) { if (builder.Length > 0) { builder.Append(" AND "); } builder.AppendFormat("GradeId = {0}", query.GradeId); } if (query.UserId > 0) { if (builder.Length > 0) { builder.Append(" AND "); } builder.AppendFormat("UserId = {0}", query.UserId); } if (query.ReferralStatus > 0) { if (builder.Length > 0) { builder.Append(" AND "); } builder.AppendFormat("ReferralStatus = '{0}'", query.ReferralStatus); } 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.CellPhone)) { if (builder.Length > 0) { builder.Append(" AND "); } builder.AppendFormat("CellPhone='{0}'", DataHelper.CleanSearchString(query.CellPhone)); } if (!string.IsNullOrEmpty(query.MicroSignal)) { if (builder.Length > 0) { builder.Append(" AND "); } builder.AppendFormat("MicroSignal = '{0}'", DataHelper.CleanSearchString(query.MicroSignal)); } if (!string.IsNullOrEmpty(query.RealName)) { if (builder.Length > 0) { builder.Append(" AND "); } builder.AppendFormat("RealName LIKE '%{0}%'", DataHelper.CleanSearchString(query.RealName)); } if (!string.IsNullOrEmpty(query.ReferralPath)) { if (builder.Length > 0) { builder.Append(" AND "); } builder.AppendFormat("(ReferralPath LIKE '{0}|%' OR ReferralPath LIKE '%|{0}|%' OR ReferralPath LIKE '%|{0}' OR ReferralPath='{0}')", DataHelper.CleanSearchString(query.ReferralPath)); } return DataHelper.PagingByRownumber(query.PageIndex, query.PageSize, query.SortBy, query.SortOrder, query.IsCount, "vw_Hishop_DistributorsMembers", "UserId", (builder.Length > 0) ? builder.ToString() : null, "*"); }