public SplittinDetailInfo GetSplittinDetail(long journalNumber) { SplittinDetailInfo result = null; DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT * FROM Ecshop_SplittinDetails WHERE JournalNumber = @JournalNumber;"); this.database.AddInParameter(sqlStringCommand, "JournalNumber", DbType.Int64, journalNumber); using (IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand)) { result = ReaderConvert.ReaderToModel <SplittinDetailInfo>(dataReader); } return(result); }
private bool AddSplittinDetail(SplittinDetailInfo splittinDetail) { System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand("INSERT INTO Ecshop_SplittinDetails (OrderId, UserId, UserName, IsUse, TradeDate, TradeType, SubUserId, Income, Expenses, Balance, Remark) VALUES (@OrderId, @UserId, @UserName, @IsUse, @TradeDate, @TradeType, @SubUserId, @Income, @Expenses, @Balance, @Remark)"); this.database.AddInParameter(sqlStringCommand, "OrderId", System.Data.DbType.String, splittinDetail.OrderId); this.database.AddInParameter(sqlStringCommand, "UserId", System.Data.DbType.Int32, splittinDetail.UserId); this.database.AddInParameter(sqlStringCommand, "UserName", System.Data.DbType.String, splittinDetail.UserName); this.database.AddInParameter(sqlStringCommand, "IsUse", System.Data.DbType.Boolean, splittinDetail.IsUse); this.database.AddInParameter(sqlStringCommand, "TradeDate", System.Data.DbType.DateTime, splittinDetail.TradeDate); this.database.AddInParameter(sqlStringCommand, "TradeType", System.Data.DbType.Int32, splittinDetail.TradeType); this.database.AddInParameter(sqlStringCommand, "SubUserId", System.Data.DbType.Int32, splittinDetail.SubUserId); this.database.AddInParameter(sqlStringCommand, "Income", System.Data.DbType.Currency, splittinDetail.Income); this.database.AddInParameter(sqlStringCommand, "Expenses", System.Data.DbType.Currency, splittinDetail.Expenses); this.database.AddInParameter(sqlStringCommand, "Balance", System.Data.DbType.Currency, splittinDetail.Balance); this.database.AddInParameter(sqlStringCommand, "Remark", System.Data.DbType.String, splittinDetail.Remark); return(this.database.ExecuteNonQuery(sqlStringCommand) > 0); }
private DataGridViewModel <Dictionary <string, object> > GetReferralRequest(BalanceDetailQuery query) { DataGridViewModel <Dictionary <string, object> > dataGridViewModel = new DataGridViewModel <Dictionary <string, object> >(); string empty = string.Empty; if (query != null) { DbQueryResult splittinDetails = MemberHelper.GetSplittinDetails(query); List <Dictionary <string, object> > list = DataHelper.DataTableToDictionary(splittinDetails.Data); foreach (Dictionary <string, object> item in list) { SplittinDetailInfo splittinDetailInfo = item.ToObject <SplittinDetailInfo>(); if (splittinDetailInfo.TradeType == SplittingTypes.RegReferralDeduct) { item.Add("TradeDateStr", ""); item.Add("FinishDateStr", splittinDetailInfo.TradeDate); } else { item.Add("TradeDateStr", splittinDetailInfo.TradeDate); item.Add("FinishDateStr", item["FinishDate"]); } if (splittinDetailInfo.TradeType == SplittingTypes.DrawRequest) { item.Add("Money", "-" + splittinDetailInfo.Expenses); } else { item.Add("Money", splittinDetailInfo.Income); } if (string.IsNullOrEmpty(item["FromUserName"].ToNullString())) { item.Add("UserNameStr", splittinDetailInfo.UserName); } else { item.Add("UserNameStr", item["FromUserName"].ToNullString()); } item.Add("TradeTypeStr", MemberHelper.GetSplittingType((int)splittinDetailInfo.TradeType)); } dataGridViewModel.rows = list; dataGridViewModel.total = splittinDetails.TotalRecords; } return(dataGridViewModel); }
protected override void AttachChildControls() { this.litOrderAmount = (FormatedMoneyLabel)this.FindControl("litOrderAmount"); this.litSplittinAmount = (FormatedMoneyLabel)this.FindControl("litSplittinAmount"); this.litOrderNo = (System.Web.UI.WebControls.Literal) this.FindControl("litOrderNo"); this.litSplittinType = (SplittingTypeNameLabel)this.FindControl("litSplittinType"); this.litSplittinDate = (System.Web.UI.WebControls.Literal) this.FindControl("litSplittinDate"); this.litStatus = (System.Web.UI.WebControls.Literal) this.FindControl("litStatus"); this.litMark = (System.Web.UI.WebControls.Literal) this.FindControl("litMark"); PageTitle.AddSiteNameTitle("佣金明细"); long journalNumber = 0L; if (!string.IsNullOrEmpty(this.Page.Request.QueryString["id"])) { long.TryParse(this.Page.Request.QueryString["id"], out journalNumber); } SplittinDetailInfo splittinDetail = MemberProcessor.GetSplittinDetail(journalNumber); if (splittinDetail == null) { this.ShowMessage("错误的明细ID", false); } OrderInfo orderInfo = ShoppingProcessor.GetOrderInfo(splittinDetail.OrderId); if (!string.IsNullOrEmpty(splittinDetail.OrderId) && orderInfo != null) { this.litOrderAmount.Money = orderInfo.GetAmount(); } else { this.litOrderAmount.Money = 0; } this.litSplittinAmount.Money = splittinDetail.Income; this.litOrderNo.Text = splittinDetail.OrderId; this.litMark.Text = splittinDetail.Remark; this.litSplittinType.SplittingType = ((int)splittinDetail.TradeType).ToString(); this.litSplittinDate.Text = splittinDetail.TradeDate.ToString("yyyy-MM-dd hh:mm:ss"); if (splittinDetail.TradeType == SplittingTypes.DrawRequest) { this.litSplittinAmount.Money = splittinDetail.Expenses; } this.litStatus.Text = (splittinDetail.IsUse ? "可用" : "不可用"); }
private void btnDraw_Click(object sender, EventArgs e) { BalanceDrawRequestQuery balanceDrawRequestQuery = new BalanceDrawRequestQuery(); balanceDrawRequestQuery.PageIndex = 1; balanceDrawRequestQuery.PageSize = this.pager.PageSize; balanceDrawRequestQuery.UserId = HiContext.Current.UserId; decimal num = default(decimal); num = MemberProcessor.GetUserUseSplittin(HiContext.Current.UserId); DbQueryResult mySplittinDraws = MemberProcessor.GetMySplittinDraws(balanceDrawRequestQuery, 1); SiteSettings masterSettings = SettingsManager.GetMasterSettings(); if (mySplittinDraws.TotalRecords > 0) { this.ShowMessage("上笔提现管理员还没有处理,只有处理完后才能再次申请提现", false, "", 1); } else if (!this.IsDefault.Visible && !this.IsWithdrawToAccount.Visible && !this.IsWeixin.Visible && !this.IsAlipay.Visible) { this.ShowMessage("没有合适的提现方式,请与管理员联系", false, "", 1); } else if (!this.IsDefault.Checked && !this.IsWithdrawToAccount.Checked && !this.IsWeixin.Checked && !this.IsAlipay.Checked) { this.ShowMessage("请选择提现方式", false, "", 1); } else { decimal num2 = default(decimal); if (!decimal.TryParse(this.txtAmount.Text.Trim(), out num2)) { this.ShowMessage("提现金额输入错误,请重新输入提现金额", false, "", 1); } else if (num2 < masterSettings.MinimumSingleShot) { this.ShowMessage("每次提现金额必须多于" + this.lblminDraws.Text + "元", false, "", 1); } else if (num2 > num) { this.ShowMessage("可提现奖励不足,请重新输入提现金额", false, "", 1); } else if (string.IsNullOrEmpty(this.txtTradePassword.Text)) { this.ShowMessage("请输入交易密码", false, "", 1); } else if (!MemberProcessor.ValidTradePassword(this.txtTradePassword.Text)) { this.ShowMessage("交易密码不正确,请重新输入", false, "", 1); } else { MemberInfo user = HiContext.Current.User; if (!user.IsOpenBalance) { this.ShowMessage("请先开通预付款账户", false, "", 1); } else { SplittinDrawInfo splittinDrawInfo = new SplittinDrawInfo(); splittinDrawInfo.UserId = user.UserId; splittinDrawInfo.UserName = user.UserName; splittinDrawInfo.Amount = num2; splittinDrawInfo.RequestDate = DateTime.Now; splittinDrawInfo.BankName = this.txtBankName.Text.Trim(); splittinDrawInfo.AccountName = this.txtAccountName.Text.Trim(); splittinDrawInfo.MerchantCode = this.txtMerchantCode.Text.Trim(); splittinDrawInfo.AlipayCode = this.txtAlipayCode.Text.Trim(); splittinDrawInfo.AlipayRealName = this.txtAlipayRealName.Text; splittinDrawInfo.Remark = this.txtRemark.Text.Trim(); splittinDrawInfo.ManagerRemark = ""; splittinDrawInfo.IsWithdrawToAccount = this.IsWithdrawToAccount.Checked; splittinDrawInfo.IsAlipay = this.IsAlipay.Checked; splittinDrawInfo.IsWeixin = this.IsWeixin.Checked; if (splittinDrawInfo.IsWithdrawToAccount) { splittinDrawInfo.AuditStatus = 2; splittinDrawInfo.AccountDate = DateTime.Now; splittinDrawInfo.ManagerRemark = "提现至预付款账户" + (string.IsNullOrEmpty(splittinDrawInfo.Remark.ToNullString()) ? "" : ("(买家备注:" + splittinDrawInfo.Remark.ToNullString() + ")")); } else { splittinDrawInfo.AuditStatus = 1; } OnLinePayment onLinePayment; if (this.IsAlipay.Checked) { splittinDrawInfo.BankName = "0"; splittinDrawInfo.AccountName = "0"; splittinDrawInfo.MerchantCode = "0"; SplittinDrawInfo splittinDrawInfo2 = splittinDrawInfo; onLinePayment = OnLinePayment.NoPay; splittinDrawInfo2.RequestState = onLinePayment.GetHashCode().ToNullString(); } else if (this.IsWeixin.Checked || splittinDrawInfo.IsWithdrawToAccount) { splittinDrawInfo.BankName = "0"; splittinDrawInfo.AccountName = "0"; splittinDrawInfo.MerchantCode = "0"; splittinDrawInfo.AlipayCode = "0"; splittinDrawInfo.AlipayRealName = "0"; if (this.IsWeixin.Checked) { SplittinDrawInfo splittinDrawInfo3 = splittinDrawInfo; onLinePayment = OnLinePayment.NoPay; splittinDrawInfo3.RequestState = onLinePayment.GetHashCode().ToNullString(); } } else { splittinDrawInfo.AlipayCode = "0"; splittinDrawInfo.AlipayRealName = "0"; } if (this.ValidateBalanceDrawRequest(splittinDrawInfo)) { if (MemberProcessor.SplittinDrawRequest(splittinDrawInfo)) { if (splittinDrawInfo.IsWithdrawToAccount) { ReferralDao referralDao = new ReferralDao(); SplittinDetailInfo splittinDetailInfo = new SplittinDetailInfo(); splittinDetailInfo.OrderId = string.Empty; splittinDetailInfo.UserId = splittinDrawInfo.UserId; splittinDetailInfo.UserName = splittinDrawInfo.UserName; splittinDetailInfo.IsUse = true; splittinDetailInfo.TradeDate = DateTime.Now; splittinDetailInfo.TradeType = SplittingTypes.DrawRequest; splittinDetailInfo.Expenses = splittinDrawInfo.Amount; splittinDetailInfo.Balance = referralDao.GetUserUseSplittin(splittinDrawInfo.UserId) - splittinDrawInfo.Amount; splittinDetailInfo.Remark = ""; referralDao.Add(splittinDetailInfo, null); this.SaveBalance(splittinDrawInfo.UserId, splittinDrawInfo.Amount); this.ShowMessage("提现成功,申请金额已转至您的预付款账户", true, "", 1); Users.ClearUserCache(splittinDrawInfo.UserId, user.SessionId); this.BindSplittinDraw(); } else { this.btnDraw.Visible = false; this.ShowMessage("提现申请成功,等待管理员的审核", true, "", 1); this.BindSplittinDraw(); } this.Clear(); } else { this.ShowMessage("提现申请失败,请重试", false, "", 1); } } } } } }