private void BindLabels() { Hidistro.Membership.Context.Distributor distributor = SubsiteStoreHelper.GetDistributor(); this.ltrAdminName.Text = distributor.Username; this.lblTime.Time = distributor.LastLoginDate; AccountSummaryInfo myAccountSummary = SubsiteStoreHelper.GetMyAccountSummary(); this.lblDistrosBalanceTotal.Text = ((myAccountSummary.AccountAmount > 0m) ? Globals.FormatMoney(myAccountSummary.AccountAmount) : string.Empty); }
protected void Page_Load(object sender, System.EventArgs e) { if (!base.IsPostBack) { AccountSummaryInfo myAccountSummary = SubsiteStoreHelper.GetMyAccountSummary(); this.lblAccountAmount.Money = myAccountSummary.AccountAmount; this.lblFreezeBalance.Money = myAccountSummary.FreezeBalance; this.lblUseableBalance.Money = myAccountSummary.UseableBalance; } }
protected void Page_Load(object sender, EventArgs e) { if (!base.IsPostBack) { AccountSummaryInfo myAccountSummary = SubsiteStoreHelper.GetMyAccountSummary(); lblUseableBalance.Money = myAccountSummary.UseableBalance; Distributor distributor = SubsiteStoreHelper.GetDistributor(); litRealName.Text = distributor.RealName; } }
protected void Page_Load(object sender, System.EventArgs e) { if (!base.IsPostBack) { AccountSummaryInfo myAccountSummary = SubsiteStoreHelper.GetMyAccountSummary(); this.lblUseableBalance.Money = myAccountSummary.UseableBalance; Hidistro.Membership.Context.Distributor distributor = SubsiteStoreHelper.GetDistributor(); this.litRealName.Text = distributor.RealName; } }
private void BindLabels() { Distributor distributor = SubsiteStoreHelper.GetDistributor(); ltrAdminName.Text = distributor.Username; lblTime.Time = distributor.LastLoginDate; AccountSummaryInfo myAccountSummary = SubsiteStoreHelper.GetMyAccountSummary(); lblDistrosBalanceTotal.Text = (myAccountSummary.AccountAmount > 0M) ? Globals.FormatMoney(myAccountSummary.AccountAmount) : string.Empty; }
public AccountSummaryInfo GetAccountSummary(int userId) { AccountSummaryInfo info = null; DbCommand storedProcCommand = this.database.GetStoredProcCommand("sp_Pay_AccountSummary_Get"); this.database.AddInParameter(storedProcCommand, "UserId", DbType.Int32, userId); using (IDataReader reader = this.database.ExecuteReader(storedProcCommand)) { while (reader.Read()) { info = this.PopupAccountSummary(reader); } } return(info); }
public AccountSummaryInfo PopupAccountSummary(IDataRecord reader) { if (reader == null) { return(null); } AccountSummaryInfo info = new AccountSummaryInfo(); if (reader["AccountAmount"] != DBNull.Value) { info.AccountAmount = (decimal)reader["AccountAmount"]; } if (reader["FreezeBalance"] != DBNull.Value) { info.FreezeBalance = (decimal)reader["FreezeBalance"]; } info.UseableBalance = info.AccountAmount - info.FreezeBalance; return(info); }
public AccountSummaryInfo GetAccountSummary(int userId) { AccountSummaryInfo info = null; MySqlParameter[] parameters = { new MySqlParameter("?UserId", SqlDbType.Int) }; parameters[0].Value = userId; //TODO: 存储过程 using (IDataReader reader = DbHelperSQL.RunProcedure("sp_Pay_AccountSummary_Get", parameters)) { while (reader.Read()) { info = this.PopupAccountSummary(reader); } } return(info); }
public override AccountSummaryInfo GetMyAccountSummary() { AccountSummaryInfo info = new AccountSummaryInfo(); DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT SUM(Amount) AS FreezeBalance FROM Hishop_DistributorBalanceDrawRequest WHERE UserId=@UserId; SELECT TOP 1 Balance AS AccountAmount FROM Hishop_DistributorBalanceDetails WHERE UserId= @UserId ORDER BY JournalNumber DESC;"); this.database.AddInParameter(sqlStringCommand, "UserId", DbType.Int32, HiContext.Current.User.UserId); using (IDataReader reader = this.database.ExecuteReader(sqlStringCommand)) { if (reader.Read() && (DBNull.Value != reader["FreezeBalance"])) { info.DrawRequestBalance = info.FreezeBalance = (decimal) reader["FreezeBalance"]; } if ((reader.NextResult() && reader.Read()) && (DBNull.Value != reader["AccountAmount"])) { info.AccountAmount = (decimal) reader["AccountAmount"]; } } info.UseableBalance = info.AccountAmount - info.FreezeBalance; return info; }
protected void Page_Load(object sender, EventArgs e) { btnConfirmPay.Click += new EventHandler(btnConfirmPay_Click); btnBack.Click += new EventHandler(btnBack_Click); btnBack1.Click += new EventHandler(btnBack_Click); imgBtnBack.Click += new System.Web.UI.ImageClickEventHandler(btnBack_Click); if (string.IsNullOrEmpty(base.Request.QueryString["PurchaseOrderId"])) { base.GotoResourceNotFound(); } else { purchaseOrderId = base.Request.QueryString["PurchaseOrderId"]; purchaseOrder = SubsiteSalesHelper.GetPurchaseOrder(purchaseOrderId); if (!base.IsPostBack) { if (purchaseOrder == null) { base.GotoResourceNotFound(); } else { if (purchaseOrder.IsManualPurchaseOrder) { litorder.Visible = false; litOrderId.Visible = false; } else { litOrderId.Text = purchaseOrder.OrderId; } litPurchaseOrderId.Text = purchaseOrder.PurchaseOrderId; lblPurchaseDate.Time = purchaseOrder.PurchaseDate; lblTotalPrice.Money = purchaseOrder.GetPurchaseTotal(); AccountSummaryInfo myAccountSummary = SubsiteStoreHelper.GetMyAccountSummary(); lblUseableBalance.Money = myAccountSummary.UseableBalance; } } } }
protected void Page_Load(object sender, EventArgs e) { this.btnConfirmPay.Click += new EventHandler(this.btnConfirmPay_Click); this.btnBack.Click += new EventHandler(this.btnBack_Click); this.btnBack1.Click += new EventHandler(this.btnBack_Click); this.imgBtnBack.Click += new ImageClickEventHandler(this.btnBack_Click); if (string.IsNullOrEmpty(base.Request.QueryString["PurchaseOrderId"])) { base.GotoResourceNotFound(); } else { this.purchaseOrderId = base.Request.QueryString["PurchaseOrderId"]; this.purchaseOrder = SubsiteSalesHelper.GetPurchaseOrder(this.purchaseOrderId); if (!base.IsPostBack) { if (this.purchaseOrder == null) { base.GotoResourceNotFound(); } else { int num; int.TryParse(base.Request["PayMode"], out num); PaymentModeInfo paymentMode = SubsiteStoreHelper.GetPaymentMode(num); if ((num > 0) && (paymentMode.Gateway != "hishop.plugins.payment.advancerequest")) { SubsiteStoreHelper.GetDistributor(); string showUrl = Globals.FullPath(Globals.GetSiteUrls().Home); if (paymentMode.Gateway.ToLower() != "hishop.plugins.payment.podrequest") { showUrl = base.Server.UrlEncode(string.Format("http://{0}/shopadmin/purchaseorder/MyPurchaseOrderDetails.aspx?purchaseOrderId={1}", base.Request.Url.Host, this.purchaseOrder.PurchaseOrderId)); } if (string.Compare(paymentMode.Gateway, "Hishop.Plugins.Payment.BankRequest", true) == 0) { showUrl = Globals.FullPath(Globals.GetSiteUrls().UrlData.FormatUrl("bank_pay", new object[] { this.purchaseOrder.PurchaseOrderId })); } if (string.Compare(paymentMode.Gateway, "Hishop.Plugins.Payment.AdvanceRequest", true) == 0) { showUrl = Globals.FullPath(Globals.GetSiteUrls().UrlData.FormatUrl("advance_pay", new object[] { this.purchaseOrder.PurchaseOrderId })); } string attach = ""; HttpCookie cookie = HiContext.Current.Context.Request.Cookies["Token_" + HiContext.Current.User.UserId.ToString()]; if ((cookie != null) && !string.IsNullOrEmpty(cookie.Value)) { attach = cookie.Value; } PaymentRequest.CreateInstance(paymentMode.Gateway, HiCryptographer.Decrypt(paymentMode.Settings), this.purchaseOrder.PurchaseOrderId, this.purchaseOrder.GetPurchaseTotal(), "采购单支付", "采购单号-" + this.purchaseOrder.PurchaseOrderId, "", this.purchaseOrder.PurchaseDate, showUrl, Globals.FullPath(Globals.GetSiteUrls().UrlData.FormatUrl("DistributorPaymentNotify_url", new object[] { paymentMode.Gateway })), Globals.FullPath(Globals.GetSiteUrls().UrlData.FormatUrl("DistributorPaymentNotify_url", new object[] { paymentMode.Gateway })), attach).SendRequest(); } if (this.purchaseOrder.IsManualPurchaseOrder) { this.litorder.Visible = false; this.litOrderId.Visible = false; } else { this.litOrderId.Text = this.purchaseOrder.OrderId; } this.litPurchaseOrderId.Text = this.purchaseOrder.PurchaseOrderId; this.lblPurchaseDate.Time = this.purchaseOrder.PurchaseDate; this.lblTotalPrice.Money = this.purchaseOrder.GetPurchaseTotal(); AccountSummaryInfo myAccountSummary = SubsiteStoreHelper.GetMyAccountSummary(); this.lblUseableBalance.Money = myAccountSummary.UseableBalance; } } } }