public bool CommissionToAmount(MemberAmountDetailedInfo amountinfo, int userid, decimal amount)
{
bool flag = this.CreatAmount(amountinfo);
if (flag)
{
flag = this.UpdateMember(amountinfo);
if (flag)
{
flag = new DistributorsDao().UpdateBalanceDistributors(userid, amount);
if (flag)
{
BalanceDrawRequestInfo balanceDrawRequestInfo = new BalanceDrawRequestInfo();
MemberInfo member = new MemberDao().GetMember(userid);
balanceDrawRequestInfo.UserId = member.UserId;
balanceDrawRequestInfo.RequestType = 4;
balanceDrawRequestInfo.UserName = member.UserName;
balanceDrawRequestInfo.RequestTime = DateTime.Now;
balanceDrawRequestInfo.Amount = amount;
balanceDrawRequestInfo.AccountName = (string.IsNullOrEmpty(member.RealName) ? member.UserName : member.RealName);
balanceDrawRequestInfo.BankName = "";
balanceDrawRequestInfo.MerchantCode = "佣金转余额";
balanceDrawRequestInfo.Remark = "";
balanceDrawRequestInfo.CheckTime = DateTime.Now;
balanceDrawRequestInfo.CellPhone = (string.IsNullOrEmpty(member.CellPhone) ? "" : member.CellPhone);
balanceDrawRequestInfo.IsCheck = "2";
flag = this.AddBalanceDrawRequest(balanceDrawRequestInfo);
}
}
}
return(flag);
}
private void BankPaySave_Click(object sender, System.EventArgs e)
{
int num = Globals.ToNum(this.HiddenSid.Value);
int userId = Globals.ToNum(this.hduserid.Value);
string remark = "转账流水号：" + this.bankPayNum.Text;
decimal num2 = decimal.Parse(this.hdreferralblance.Value);
int num3 = Globals.ToNum("0" + this.hdredpackrecordnum.Value);
if (!VShopHelper.UpdateBalanceDrawRequest(num, remark))
{
this.ShowMsg("结算失败", false);
return;
}
decimal num4 = num2;
if (num3 > 0)
{
num4 -= decimal.Parse(DistributorsBrower.GetRedPackTotalAmount(num, 0).ToString()) / 100m;
}
if (VShopHelper.UpdateBalanceDistributors(userId, num4))
{
if (num4 > 0m)
{
BalanceDrawRequestInfo balanceDrawRequestById = DistributorsBrower.GetBalanceDrawRequestById(num.ToString());
if (balanceDrawRequestById != null)
{
Messenger.SendWeiXinMsg_DrawCashRelease(balanceDrawRequestById);
}
}
this.ShowMsg("结算成功", true);
this.BindData();
return;
}
this.ShowMsg("结算失败", false);
}
public static bool AddBalanceDrawRequest(BalanceDrawRequestInfo balancerequestinfo, MemberInfo memberinfo)
{
DistributorsInfo currentDistributors = DistributorsBrower.GetCurrentDistributors(false);
bool result;
if (memberinfo != null && !string.IsNullOrEmpty(memberinfo.RealName) && currentDistributors != null && currentDistributors.UserId > 0 && !string.IsNullOrEmpty(memberinfo.CellPhone))
{
if (!string.IsNullOrEmpty(balancerequestinfo.MerchantCode) && currentDistributors.RequestAccount != balancerequestinfo.MerchantCode)
{
new DistributorsDao().UpdateDistributorById(balancerequestinfo.MerchantCode, memberinfo.UserId);
}
balancerequestinfo.UserId = memberinfo.UserId;
balancerequestinfo.UserName = memberinfo.UserName;
if (balancerequestinfo.RequesType == 0 || balancerequestinfo.RequesType == 3)
{
balancerequestinfo.MerchantCode = memberinfo.OpenId;
}
else if (balancerequestinfo.MerchantCode.Length < 1)
{
balancerequestinfo.MerchantCode = currentDistributors.RequestAccount;
}
balancerequestinfo.CellPhone = memberinfo.CellPhone;
result = new DistributorsDao().AddBalanceDrawRequest(balancerequestinfo);
}
else
{
result = false;
}
return(result);
}
public static bool AddBalanceDrawRequest(BalanceDrawRequestInfo balancerequestinfo, MemberInfo memberinfo)
{
DistributorsInfo currentDistributors = GetCurrentDistributors();
if ((((memberinfo == null) || string.IsNullOrEmpty(memberinfo.RealName)) || ((currentDistributors == null) || (currentDistributors.UserId <= 0))) || string.IsNullOrEmpty(memberinfo.CellPhone))
{
return(false);
}
if (!string.IsNullOrEmpty(balancerequestinfo.MerchantCode) && (currentDistributors.RequestAccount != balancerequestinfo.MerchantCode))
{
new DistributorsDao().UpdateDistributorById(balancerequestinfo.MerchantCode, memberinfo.UserId);
}
balancerequestinfo.UserId = memberinfo.UserId;
balancerequestinfo.UserName = memberinfo.UserName;
if ((balancerequestinfo.RequesType == 0) || (balancerequestinfo.RequesType == 3))
{
balancerequestinfo.MerchantCode = memberinfo.OpenId;
}
else if (balancerequestinfo.MerchantCode.Length < 1)
{
balancerequestinfo.MerchantCode = currentDistributors.RequestAccount;
}
balancerequestinfo.CellPhone = memberinfo.CellPhone;
return(new DistributorsDao().AddBalanceDrawRequest(balancerequestinfo));
}
private void btnDrawNext_Click(object sender, System.EventArgs e)
{
Member member = HiContext.Current.User as Member;
if (member.RequestBalance > 0m)
{
this.ShowMessage("上笔提现管理员还没有处理，只有处理完后才能再次申请提现", false);
}
else
{
decimal num = 0m;
if (!decimal.TryParse(this.txtAmount.Text.Trim(), out num))
{
this.ShowMessage("提现金额输入错误,请重新输入提现金额", false);
}
else
{
if (num > (decimal)this.lblBanlance.Money)
{
this.ShowMessage("预付款余额不足,请重新输入提现金额", false);
}
else
{
if (string.IsNullOrEmpty(this.txtTradePassword.Text))
{
this.ShowMessage("请输入交易密码", false);
}
else
{
member.TradePassword = this.txtTradePassword.Text;
if (!Users.ValidTradePassword(member))
{
this.ShowMessage("交易密码不正确,请重新输入", false);
}
else
{
BalanceDrawRequestInfo balanceDrawRequestInfo = new BalanceDrawRequestInfo();
balanceDrawRequestInfo.BankName = this.txtBankName.Text.Trim();
balanceDrawRequestInfo.AccountName = this.txtAccountName.Text.Trim();
balanceDrawRequestInfo.MerchantCode = this.txtMerchantCode.Text.Trim();
balanceDrawRequestInfo.Amount = num;
balanceDrawRequestInfo.Remark = this.txtRemark.Text.Trim();
if (this.ValidateBalanceDrawRequest(balanceDrawRequestInfo))
{
this.Page.Response.Redirect(Globals.GetSiteUrls().UrlData.FormatUrl("user_RequestBalanceDrawConfirm", new object[]
{
Globals.UrlEncode(Globals.HtmlEncode(balanceDrawRequestInfo.BankName)),
Globals.UrlEncode(Globals.HtmlEncode(balanceDrawRequestInfo.AccountName)),
Globals.UrlEncode(Globals.HtmlEncode(balanceDrawRequestInfo.MerchantCode)),
balanceDrawRequestInfo.Amount,
Globals.UrlEncode(Globals.HtmlEncode(balanceDrawRequestInfo.Remark))
}));
}
}
}
}
}
}
}
private void WeiRedPack_Click(object sender, System.EventArgs e)
{
int num = Globals.ToNum(this.HiddenSid.Value);
decimal d = decimal.Parse(this.hdreferralblance.Value);
if (d > 200m)
{
this.ShowMsg("红包金额大于200，无法发放！", false);
return;
}
string text = DistributorsBrower.SendRedPackToBalanceDrawRequest(num);
if (text != "1" && text != "-1")
{
this.ShowMsg("生成红包失败，原因是：" + text, false);
return;
}
if (!(text == "1") && !(text == "-1"))
{
this.ShowMsg("发送失败0！", false);
return;
}
SendRedpackRecordInfo sendRedpackRecordByID = DistributorsBrower.GetSendRedpackRecordByID(null, num.ToString());
if (sendRedpackRecordByID == null)
{
this.ShowMsg("发送失败" + num + "！", false);
return;
}
if (sendRedpackRecordByID.IsSend)
{
this.ShowMsg("当前红包已是发送状态：请检查原因！", false);
return;
}
text = this.SendRedPack(sendRedpackRecordByID.OpenID, "", sendRedpackRecordByID.Wishing, sendRedpackRecordByID.ActName, "分销商发红包提现", sendRedpackRecordByID.Amount, sendRedpackRecordByID.ID);
if (text == "1")
{
DistributorsBrower.SetRedpackRecordIsUsed(sendRedpackRecordByID.ID, true);
decimal num2 = decimal.Parse(sendRedpackRecordByID.Amount.ToString()) / 100m;
VShopHelper.UpdateBalanceDistributors(sendRedpackRecordByID.UserID, num2);
if (num2 > 0m)
{
BalanceDrawRequestInfo balanceDrawRequestById = DistributorsBrower.GetBalanceDrawRequestById(num.ToString());
if (balanceDrawRequestById != null)
{
Messenger.SendWeiXinMsg_DrawCashRelease(balanceDrawRequestById);
}
}
this.ShowMsg("红包发送成功！", true);
this.LoadParameters();
this.BindData();
return;
}
this.ShowMsg("发送失败，原因是：" + text, false);
}
private void WeiRedPack_Click(object sender, EventArgs e)
{
int id = Globals.ToNum(this.HiddenSid.Value);
if (decimal.Parse(this.hdreferralblance.Value) > 200M)
{
this.ShowMsg("红包金额大于200，无法发放！", false);
}
else
{
BalanceDrawRequestInfo balanceDrawRequestById = DistributorsBrower.GetBalanceDrawRequestById(id.ToString());
if (balanceDrawRequestById == null)
{
this.ShowMsg("参数错误，请求不存在", false);
}
else if (balanceDrawRequestById.IsCheck == "2")
{
this.ShowMsg("该申请已经支付，请检查", false);
}
else if (!string.IsNullOrEmpty(balanceDrawRequestById.RedpackId))
{
string str = this.SendRedPack(balanceDrawRequestById.MerchantCode, "", "恭喜您提现成功!", "您的提现申请已成功", "分销商发红包提现", ((int)balanceDrawRequestById.Amount) * 100, balanceDrawRequestById.RedpackId);
if (str == "success")
{
VShopHelper.UpdateBalanceDrawRequest(id, "微信红包付款");
VShopHelper.UpdateBalanceDistributors(balanceDrawRequestById.UserId, balanceDrawRequestById.Amount);
if (balanceDrawRequestById.Amount > 0M)
{
BalanceDrawRequestInfo balance = DistributorsBrower.GetBalanceDrawRequestById(id.ToString());
if (balance != null)
{
try
{
Messenger.SendWeiXinMsg_DrawCashRelease(balance);
}
catch
{
}
}
}
this.ShowMsg("红包发送成功！", true);
this.LoadParameters();
this.BindData();
}
else
{
this.ShowMsg("发送失败，原因是：" + str, false);
}
}
else
{
this.ShowMsg("发送失败0！", false);
}
}
}
private void weipaySend_Click(object sender, System.EventArgs e)
{
int num = Globals.ToNum(this.HiddenSid.Value);
decimal num2 = decimal.Parse(this.hdreferralblance.Value);
BalanceDrawRequestInfo balanceDrawRequestById = DistributorsBrower.GetBalanceDrawRequestById(num.ToString());
if (balanceDrawRequestById == null)
{
this.ShowMsg("参数错误！", false);
return;
}
if (balanceDrawRequestById.IsCheck == "2")
{
this.ShowMsg("该申请已经支付，请检查", false);
return;
}
WeiPayResult weiPayResult = OutPayHelp.SingleWeiPay((int)(num2 * 100m), "分销商佣金发放！", balanceDrawRequestById.MerchantCode, balanceDrawRequestById.AccountName, balanceDrawRequestById.SerialId.ToString(), balanceDrawRequestById.UserId);
if (weiPayResult.result_code == "SUCCESS")
{
VShopHelper.UpdateBalanceDrawRequest(num, "微信企业付款");
int arg_B6_0 = balanceDrawRequestById.UserId;
VShopHelper.UpdateBalanceDistributors(balanceDrawRequestById.UserId, num2);
if (num2 > 0m)
{
BalanceDrawRequestInfo balanceDrawRequestById2 = DistributorsBrower.GetBalanceDrawRequestById(num.ToString());
if (balanceDrawRequestById2 != null)
{
Messenger.SendWeiXinMsg_DrawCashRelease(balanceDrawRequestById2);
}
}
this.LoadParameters();
this.BindData();
this.ShowMsg("支付成功！", true);
return;
}
if (weiPayResult.err_code == "OPENID_ERROR" || weiPayResult.err_code == "NAME_MISMATCH" || weiPayResult.return_msg.Contains("openid字段") || weiPayResult.err_code == "FATAL_ERROR")
{
DistributorsBrower.SetBalanceDrawRequestIsCheckStatus(new int[]
{
num
}, 3, System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss ") + weiPayResult.return_msg, num2.ToString());
this.LoadParameters();
this.BindData();
}
else
{
DistributorsBrower.SetBalanceDrawRequestIsCheckStatus(new int[]
{
num
}, 1, System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss ") + weiPayResult.return_msg, num2.ToString());
}
this.ShowMsg("微信企业付款失败，" + weiPayResult.return_msg, false);
}
public BalanceDrawRequestInfo GetBalanceDrawRequestInfo(int requestId)
{
BalanceDrawRequestInfo result = null;
DbCommand sqlStringCommand = base.database.GetSqlStringCommand("SELECT * FROM Hishop_BalanceDrawRequest WHERE ID = @RequestId ");
base.database.AddInParameter(sqlStringCommand, "RequestId", DbType.Int32, requestId);
using (IDataReader objReader = base.database.ExecuteReader(sqlStringCommand))
{
result = DataHelper.ReaderToModel<BalanceDrawRequestInfo>(objReader);
}
return result;
}
public static bool BalanceDrawRequest(BalanceDrawRequestInfo balanceDrawRequest)
{
Globals.EntityCoding(balanceDrawRequest, true);
bool flag = PersonalProvider.Instance().BalanceDrawRequest(balanceDrawRequest);
if (flag)
{
Users.ClearUserCache(HiContext.Current.User);
}
return(flag);
}
public static bool BalanceDrawRequest(BalanceDrawRequestInfo balanceDrawRequest)
{
Globals.EntityCoding(balanceDrawRequest, true);
bool flag = new BalanceDetailDao().BalanceDrawRequest(balanceDrawRequest);
if (flag)
{
Users.ClearUserCache(HiContext.Current.User);
}
return(flag);
}
public override bool BalanceDrawRequest(BalanceDrawRequestInfo balanceDrawRequest)
{
System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand("INSERT INTO Hishop_DistributorBalanceDrawRequest VALUES(@UserId,@UserName,@RequestTime,@Amount,@AccountName,@BankName,@MerchantCode)");
this.database.AddInParameter(sqlStringCommand, "UserId", System.Data.DbType.Int32, balanceDrawRequest.UserId);
this.database.AddInParameter(sqlStringCommand, "UserName", System.Data.DbType.String, balanceDrawRequest.UserName);
this.database.AddInParameter(sqlStringCommand, "RequestTime", System.Data.DbType.DateTime, balanceDrawRequest.RequestTime);
this.database.AddInParameter(sqlStringCommand, "Amount", System.Data.DbType.Currency, balanceDrawRequest.Amount);
this.database.AddInParameter(sqlStringCommand, "MerchantCode", System.Data.DbType.String, balanceDrawRequest.MerchantCode);
this.database.AddInParameter(sqlStringCommand, "BankName", System.Data.DbType.String, balanceDrawRequest.BankName);
this.database.AddInParameter(sqlStringCommand, "AccountName", System.Data.DbType.String, balanceDrawRequest.AccountName);
return(this.database.ExecuteNonQuery(sqlStringCommand) > 0);
}
private void weipaySend_Click(object sender, EventArgs e)
{
int id = Globals.ToNum(this.HiddenSid.Value);
decimal referralRequestBalance = decimal.Parse(this.hdreferralblance.Value);
BalanceDrawRequestInfo balanceDrawRequestById = DistributorsBrower.GetBalanceDrawRequestById(id.ToString());
if (balanceDrawRequestById != null)
{
if (balanceDrawRequestById.IsCheck == "2")
{
this.ShowMsg("该申请已经支付，请检查", false);
}
else
{
WeiPayResult result = OutPayHelp.SingleWeiPay((int)(referralRequestBalance * 100M), "分销商佣金发放！", balanceDrawRequestById.MerchantCode, balanceDrawRequestById.AccountName, balanceDrawRequestById.SerialId.ToString(), balanceDrawRequestById.UserId);
if (result.result_code == "SUCCESS")
{
VShopHelper.UpdateBalanceDrawRequest(id, "微信企业付款");
int userId = balanceDrawRequestById.UserId;
VShopHelper.UpdateBalanceDistributors(balanceDrawRequestById.UserId, referralRequestBalance);
if (referralRequestBalance > 0M)
{
BalanceDrawRequestInfo balance = DistributorsBrower.GetBalanceDrawRequestById(id.ToString());
if (balance != null)
{
Messenger.SendWeiXinMsg_DrawCashRelease(balance);
}
}
this.LoadParameters();
this.BindData();
this.ShowMsg("支付成功！", true);
}
else
{
if (((result.err_code == "OPENID_ERROR") || (result.err_code == "NAME_MISMATCH")) || (result.return_msg.Contains("openid字段") || (result.err_code == "FATAL_ERROR")))
{
DistributorsBrower.SetBalanceDrawRequestIsCheckStatus(new int[] { id }, 3, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss ") + result.return_msg, referralRequestBalance.ToString());
this.LoadParameters();
this.BindData();
}
else
{
DistributorsBrower.SetBalanceDrawRequestIsCheckStatus(new int[] { id }, 1, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss ") + result.return_msg, referralRequestBalance.ToString());
}
this.ShowMsg("微信企业付款失败，" + result.return_msg, false);
}
}
}
else
{
this.ShowMsg("参数错误！", false);
}
}
private BalanceDrawRequestInfo GetBalanceDrawRequest()
{
BalanceDrawRequestInfo balanceDrawRequestInfo = new BalanceDrawRequestInfo();
balanceDrawRequestInfo.UserId = HiContext.Current.User.UserId;
balanceDrawRequestInfo.UserName = HiContext.Current.User.Username;
balanceDrawRequestInfo.RequestTime = System.DateTime.Now;
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["bankName"]))
{
balanceDrawRequestInfo.BankName = Globals.UrlDecode(this.Page.Request.QueryString["bankName"]);
}
else
{
balanceDrawRequestInfo.BankName = string.Empty;
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["accountName"]))
{
balanceDrawRequestInfo.AccountName = Globals.UrlDecode(this.Page.Request.QueryString["accountName"]);
}
else
{
balanceDrawRequestInfo.AccountName = string.Empty;
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["merchantCode"]))
{
balanceDrawRequestInfo.MerchantCode = Globals.UrlDecode(this.Page.Request.QueryString["merchantCode"]);
}
else
{
balanceDrawRequestInfo.MerchantCode = string.Empty;
}
decimal amount;
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["amount"]) && decimal.TryParse(this.Page.Request.QueryString["amount"], out amount))
{
balanceDrawRequestInfo.Amount = amount;
}
else
{
balanceDrawRequestInfo.Amount = 0m;
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["remark"]))
{
balanceDrawRequestInfo.Remark = Globals.UrlDecode(this.Page.Request.QueryString["remark"]);
}
else
{
balanceDrawRequestInfo.Remark = string.Empty;
}
return(balanceDrawRequestInfo);
}
public override bool BalanceDrawRequest(BalanceDrawRequestInfo balanceDrawRequest)
{
System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand("INSERT INTO distro_BalanceDrawRequest (UserId,UserName,DistributorUserId,RequestTime, Amount, AccountName, BankName, MerchantCode, Remark) VALUES (@UserId,@UserName, @DistributorUserId,@RequestTime, @Amount, @AccountName, @BankName, @MerchantCode, @Remark)");
this.database.AddInParameter(sqlStringCommand, "UserId", System.Data.DbType.Int32, balanceDrawRequest.UserId);
this.database.AddInParameter(sqlStringCommand, "UserName", System.Data.DbType.String, balanceDrawRequest.UserName);
this.database.AddInParameter(sqlStringCommand, "DistributorUserId", System.Data.DbType.Int32, HiContext.Current.SiteSettings.UserId);
this.database.AddInParameter(sqlStringCommand, "RequestTime", System.Data.DbType.DateTime, balanceDrawRequest.RequestTime);
this.database.AddInParameter(sqlStringCommand, "Amount", System.Data.DbType.Currency, balanceDrawRequest.Amount);
this.database.AddInParameter(sqlStringCommand, "AccountName", System.Data.DbType.String, balanceDrawRequest.AccountName);
this.database.AddInParameter(sqlStringCommand, "BankName", System.Data.DbType.String, balanceDrawRequest.BankName);
this.database.AddInParameter(sqlStringCommand, "MerchantCode", System.Data.DbType.String, balanceDrawRequest.MerchantCode);
this.database.AddInParameter(sqlStringCommand, "Remark", System.Data.DbType.String, balanceDrawRequest.Remark);
return(this.database.ExecuteNonQuery(sqlStringCommand) >= 1);
}
public bool AddBalanceDrawRequest(BalanceDrawRequestInfo bdrinfo)
{
string query = "INSERT INTO Hishop_BalanceDrawRequest(UserId,RequestType,UserName,Amount,AccountName,CellPhone,MerchantCode,Remark,RequestTime,IsCheck) VALUES(@UserId,@RequestType,@UserName,@Amount,@AccountName,@CellPhone,@MerchantCode,@Remark,getdate(),0)";
DbCommand sqlStringCommand = this.database.GetSqlStringCommand(query);
this.database.AddInParameter(sqlStringCommand, "UserId", DbType.Int32, bdrinfo.UserId);
this.database.AddInParameter(sqlStringCommand, "RequestType", DbType.Int32, bdrinfo.RequesType);
this.database.AddInParameter(sqlStringCommand, "UserName", DbType.String, bdrinfo.UserName);
this.database.AddInParameter(sqlStringCommand, "Amount", DbType.Decimal, bdrinfo.Amount);
this.database.AddInParameter(sqlStringCommand, "AccountName", DbType.String, bdrinfo.AccountName);
this.database.AddInParameter(sqlStringCommand, "CellPhone", DbType.String, bdrinfo.CellPhone);
this.database.AddInParameter(sqlStringCommand, "MerchantCode", DbType.String, bdrinfo.MerchanCade);
this.database.AddInParameter(sqlStringCommand, "Remark", DbType.String, bdrinfo.Remark);
return (this.database.ExecuteNonQuery(sqlStringCommand) > 0);
}
public override bool BalanceDrawRequest(BalanceDrawRequestInfo balanceDrawRequest)
{
DbCommand sqlStringCommand = database.GetSqlStringCommand("INSERT INTO Hishop_BalanceDrawRequest (UserId,UserName,RequestTime, Amount, AccountName, BankName, MerchantCode, Remark) VALUES (@UserId,@UserName,@RequestTime, @Amount, @AccountName, @BankName, @MerchantCode, @Remark)");
database.AddInParameter(sqlStringCommand, "UserId", DbType.Int32, balanceDrawRequest.UserId);
database.AddInParameter(sqlStringCommand, "UserName", DbType.String, balanceDrawRequest.UserName);
database.AddInParameter(sqlStringCommand, "RequestTime", DbType.DateTime, balanceDrawRequest.RequestTime);
database.AddInParameter(sqlStringCommand, "Amount", DbType.Currency, balanceDrawRequest.Amount);
database.AddInParameter(sqlStringCommand, "AccountName", DbType.String, balanceDrawRequest.AccountName);
database.AddInParameter(sqlStringCommand, "BankName", DbType.String, balanceDrawRequest.BankName);
database.AddInParameter(sqlStringCommand, "MerchantCode", DbType.String, balanceDrawRequest.MerchantCode);
database.AddInParameter(sqlStringCommand, "Remark", DbType.String, balanceDrawRequest.Remark);
return(database.ExecuteNonQuery(sqlStringCommand) >= 1);
}
private bool ValidateBalanceDrawRequest(BalanceDrawRequestInfo balanceDrawRequest)
{
ValidationResults validationResults = Validation.Validate(balanceDrawRequest, "ValBalanceDrawRequestInfo");
string text = string.Empty;
if (!validationResults.IsValid)
{
foreach (ValidationResult item in (IEnumerable <ValidationResult>)validationResults)
{
text += Formatter.FormatErrorMessage(item.Message);
}
this.ShowMessage(text, false, "", 1);
}
return(validationResults.IsValid);
}
public bool AddBalanceDrawRequest(BalanceDrawRequestInfo bdrinfo)
{
string query = "INSERT INTO Hishop_BalanceDrawRequest(UserId,RequestType,UserName,Amount,AccountName,CellPhone,MerchantCode,Remark,RequestTime,IsCheck) VALUES(@UserId,@RequestType,@UserName,@Amount,@AccountName,@CellPhone,@MerchantCode,@Remark,getdate(),0)";
DbCommand sqlStringCommand = this.database.GetSqlStringCommand(query);
this.database.AddInParameter(sqlStringCommand, "UserId", DbType.Int32, bdrinfo.UserId);
this.database.AddInParameter(sqlStringCommand, "RequestType", DbType.Int32, bdrinfo.RequesType);
this.database.AddInParameter(sqlStringCommand, "UserName", DbType.String, bdrinfo.UserName);
this.database.AddInParameter(sqlStringCommand, "Amount", DbType.Decimal, bdrinfo.Amount);
this.database.AddInParameter(sqlStringCommand, "AccountName", DbType.String, bdrinfo.AccountName);
this.database.AddInParameter(sqlStringCommand, "CellPhone", DbType.String, bdrinfo.CellPhone);
this.database.AddInParameter(sqlStringCommand, "MerchantCode", DbType.String, bdrinfo.MerchanCade);
this.database.AddInParameter(sqlStringCommand, "Remark", DbType.String, bdrinfo.Remark);
return(this.database.ExecuteNonQuery(sqlStringCommand) > 0);
}
private bool ValidateBalanceDrawRequest(BalanceDrawRequestInfo balanceDrawRequest)
{
ValidationResults results = Hishop.Components.Validation.Validation.Validate <BalanceDrawRequestInfo>(balanceDrawRequest, new string[] { "ValBalanceDrawRequestInfo" });
string msg = string.Empty;
if (!results.IsValid)
{
foreach (ValidationResult result in (IEnumerable <ValidationResult>)results)
{
msg = msg + Formatter.FormatErrorMessage(result.Message);
}
this.ShowMessage(msg, false);
}
return(results.IsValid);
}
private BalanceDrawRequestInfo GetBalanceDrawRequest()
{
decimal num;
BalanceDrawRequestInfo info = new BalanceDrawRequestInfo();
info.UserId = HiContext.Current.User.UserId;
info.UserName = HiContext.Current.User.Username;
info.RequestTime = DateTime.Now;
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["bankName"]))
{
info.BankName = Globals.UrlDecode(this.Page.Request.QueryString["bankName"]);
}
else
{
info.BankName = string.Empty;
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["accountName"]))
{
info.AccountName = Globals.UrlDecode(this.Page.Request.QueryString["accountName"]);
}
else
{
info.AccountName = string.Empty;
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["merchantCode"]))
{
info.MerchantCode = Globals.UrlDecode(this.Page.Request.QueryString["merchantCode"]);
}
else
{
info.MerchantCode = string.Empty;
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["amount"]) && decimal.TryParse(this.Page.Request.QueryString["amount"], out num))
{
info.Amount = num;
}
else
{
info.Amount = 0M;
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["remark"]))
{
info.Remark = Globals.UrlDecode(this.Page.Request.QueryString["remark"]);
return(info);
}
info.Remark = string.Empty;
return(info);
}
private void BankPaySave_Click(object sender, EventArgs e)
{
int id = Globals.ToNum(this.HiddenSid.Value);
int userId = Globals.ToNum(this.hduserid.Value);
string remark = "转账流水号：" + this.bankPayNum.Text;
decimal num3 = decimal.Parse(this.hdreferralblance.Value);
int num4 = Globals.ToNum("0" + this.hdredpackrecordnum.Value);
if (VShopHelper.UpdateBalanceDrawRequest(id, remark))
{
decimal referralRequestBalance = num3;
if (num4 > 0)
{
int redPackTotalAmount = DistributorsBrower.GetRedPackTotalAmount(id, 0);
referralRequestBalance -= decimal.Parse(redPackTotalAmount.ToString()) / 100M;
}
if (VShopHelper.UpdateBalanceDistributors(userId, referralRequestBalance))
{
if (referralRequestBalance > 0M)
{
BalanceDrawRequestInfo balanceDrawRequestById = DistributorsBrower.GetBalanceDrawRequestById(id.ToString());
if (balanceDrawRequestById != null)
{
try
{
Messenger.SendWeiXinMsg_DrawCashRelease(balanceDrawRequestById);
}
catch
{
}
}
}
this.ShowMsg("结算成功", true);
this.BindData();
}
else
{
this.ShowMsg("结算失败", false);
}
}
else
{
this.ShowMsg("结算失败", false);
}
}
private void btnOK_Click(object sender, System.EventArgs e)
{
if (SubsiteStoreHelper.DistroHasDrawRequest())
{
this.ShowMsg("对不起，您的上一笔提现申请尚未进行处理", false);
return;
}
if (this.Session["BalanceDrawRequest"] != null)
{
BalanceDrawRequestInfo balanceDrawRequest = (BalanceDrawRequestInfo)this.Session["BalanceDrawRequest"];
if (SubsiteStoreHelper.BalanceDrawRequest(balanceDrawRequest))
{
this.message.Visible = true;
return;
}
this.ShowMsg("写入提现信息失败", false);
}
}
private bool ValidateBalanceDrawRequest(BalanceDrawRequestInfo balanceDrawRequest)
{
ValidationResults validationResults = Validation.Validate <BalanceDrawRequestInfo>(balanceDrawRequest, new string[]
{
"ValBalanceDrawRequestInfo"
});
string text = string.Empty;
if (!validationResults.IsValid)
{
foreach (ValidationResult current in (System.Collections.Generic.IEnumerable <ValidationResult>)validationResults)
{
text += Formatter.FormatErrorMessage(current.Message);
}
this.ShowMessage(text, false);
}
return(validationResults.IsValid);
}
public static bool AddBalanceDrawRequest(BalanceDrawRequestInfo balancerequestinfo)
{
MemberInfo currentMember = MemberProcessor.GetCurrentMember();
DistributorsInfo currentDistributors = GetCurrentDistributors();
if ((((currentMember != null) && !string.IsNullOrEmpty(currentMember.RealName)) && ((currentDistributors != null) && (currentDistributors.UserId > 0))) && !string.IsNullOrEmpty(currentMember.CellPhone))
{
if (!(string.IsNullOrEmpty(balancerequestinfo.MerchanCade) || !(currentDistributors.RequestAccount != balancerequestinfo.MerchanCade)))
{
new DistributorsDao().UpdateDistributorById(balancerequestinfo.MerchanCade, currentMember.UserId);
}
balancerequestinfo.AccountName = currentMember.RealName;
balancerequestinfo.UserId = currentMember.UserId;
balancerequestinfo.UserName = currentMember.UserName;
balancerequestinfo.CellPhone = currentMember.CellPhone;
return(new DistributorsDao().AddBalanceDrawRequest(balancerequestinfo));
}
return(false);
}
private void btnOK_Click(object sender, EventArgs e)
{
if (SubsiteStoreHelper.DistroHasDrawRequest())
{
ShowMsg("对不起，您的上一笔提现申请尚未进行处理", false);
}
else if (Session["BalanceDrawRequest"] != null)
{
BalanceDrawRequestInfo balanceDrawRequest = (BalanceDrawRequestInfo)Session["BalanceDrawRequest"];
if (SubsiteStoreHelper.BalanceDrawRequest(balanceDrawRequest))
{
message.Visible = true;
}
else
{
ShowMsg("写入提现信息失败", false);
}
}
}
private void ExportExcel(HttpContext context)
{
BalanceDetailQuery dataQuery = this.GetDataQuery(context);
DbQueryResult balanceDetailsNoPage = MemberHelper.GetBalanceDetailsNoPage(dataQuery);
string empty = string.Empty;
empty += "用户名";
empty += ",交易时间";
empty += ",提现帐户";
empty += ",业务摘要";
empty += ",转出金额";
empty += ",当前余额";
empty += ",操作人\r\n";
foreach (DataRow row in balanceDetailsNoPage.Data.Rows)
{
int requestId = row["InpourId"].ToInt(0);
BalanceDrawRequestInfo balanceDrawRequestInfo = MemberHelper.GetBalanceDrawRequestInfo(requestId);
empty += row["UserName"];
empty = empty + "," + row["TradeDate"];
if (balanceDrawRequestInfo != null)
{
string text = "";
text = ((!balanceDrawRequestInfo.IsWeixin.HasValue || !balanceDrawRequestInfo.IsWeixin.Value) ? ((!balanceDrawRequestInfo.IsAlipay.HasValue || !balanceDrawRequestInfo.IsAlipay.Value) ? $"提现到银行卡(开户银行:{balanceDrawRequestInfo.BankName}，银行开户名:{balanceDrawRequestInfo.AccountName}，银行卡帐号:{balanceDrawRequestInfo.MerchantCode})" : ("提现到支付宝(支付宝帐号:" + balanceDrawRequestInfo.AlipayCode + "，支付宝姓名:" + balanceDrawRequestInfo.AlipayRealName + ")")) : "提现到微信");
empty = empty + "," + text;
}
else
{
empty += ",";
}
empty += ",提现";
empty = empty + "," + row["Expenses"];
empty = empty + "," + row["Balance"];
empty = empty + "," + row["ManagerUserName"] + "\r\n";
}
context.Response.Clear();
context.Response.Buffer = false;
context.Response.Charset = "GB2312";
context.Response.AppendHeader("Content-Disposition", "attachment;filename=BalanceDetailsStatistics.csv");
context.Response.ContentEncoding = Encoding.GetEncoding("GB2312");
context.Response.ContentType = "application/octet-stream";
context.Response.Write(empty);
context.Response.End();
}
protected void Page_Load(object sender, System.EventArgs e)
{
this.btnOK.Click += new System.EventHandler(this.btnOK_Click);
if (!base.IsPostBack)
{
BalanceDrawRequestInfo balanceDrawRequestInfo = new BalanceDrawRequestInfo();
if (this.Session["BalanceDrawRequest"] != null)
{
balanceDrawRequestInfo = (BalanceDrawRequestInfo)this.Session["BalanceDrawRequest"];
Hidistro.Membership.Context.Distributor distributor = Hidistro.Membership.Context.Users.GetUser(balanceDrawRequestInfo.UserId) as Hidistro.Membership.Context.Distributor;
this.litRealName.Text = distributor.RealName;
this.litName.Text = balanceDrawRequestInfo.AccountName;
this.litBankName.Text = balanceDrawRequestInfo.BankName;
this.litBankCode.Text = balanceDrawRequestInfo.MerchantCode;
this.lblAmount.Money = balanceDrawRequestInfo.Amount;
return;
}
base.GotoResourceNotFound();
}
}
public static bool AddBalanceDrawRequest(BalanceDrawRequestInfo balancerequestinfo)
{
MemberInfo currentMember = MemberProcessor.GetCurrentMember();
DistributorsInfo currentDistributors = GetCurrentDistributors();
if (((((currentMember != null) && !string.IsNullOrEmpty(currentMember.RealName)) && ((currentDistributors != null) && (currentDistributors.UserId > 0))) && !string.IsNullOrEmpty(currentDistributors.RequestAccount)) && !string.IsNullOrEmpty(currentMember.CellPhone))
{
if (currentDistributors.RequestAccount != balancerequestinfo.MerchanCade)
{
new DistributorsDao().UpdateDistributorById(balancerequestinfo.MerchanCade, currentMember.UserId);
}
balancerequestinfo.AccountName = currentMember.RealName;
balancerequestinfo.UserId = currentMember.UserId;
balancerequestinfo.UserName = currentMember.UserName;
balancerequestinfo.MerchanCade = currentDistributors.RequestAccount;
balancerequestinfo.RequesType = 1;
balancerequestinfo.CellPhone = currentMember.CellPhone;
return new DistributorsDao().AddBalanceDrawRequest(balancerequestinfo);
}
return false;
}
protected override void AttachChildControls()
{
this.litAmount = (FormatedMoneyLabel)this.FindControl("litAmount");
this.litRequestDate = (Literal)this.FindControl("litRequestDate");
this.litAccount = (Literal)this.FindControl("litAccount");
this.litAccountDate = (Literal)this.FindControl("litAccountDate");
this.litStatus = (Literal)this.FindControl("litStatus");
this.litMark = (Literal)this.FindControl("litMark");
this.litManagerRemark = (Literal)this.FindControl("litManagerRemark");
PageTitle.AddSiteNameTitle("提现详情");
int num = 0;
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["id"]))
{
int.TryParse(this.Page.Request.QueryString["id"], out num);
}
BalanceDetailDao balanceDetailDao = new BalanceDetailDao();
BalanceDrawRequestInfo balanceDrawRequestInfo = balanceDetailDao.Get <BalanceDrawRequestInfo>(num);
if (balanceDrawRequestInfo == null)
{
this.ShowMessage("错误的提现记录ID", false, "", 1);
}
this.litAmount.Money = balanceDrawRequestInfo.Amount;
Literal literal = this.litRequestDate;
DateTime dateTime = balanceDrawRequestInfo.RequestTime;
literal.Text = dateTime.ToString("yyyy-MM-dd HH:mm:ss");
this.litMark.Text = balanceDrawRequestInfo.Remark;
this.litManagerRemark.Text = balanceDrawRequestInfo.ManagerRemark;
this.litAccount.Text = (balanceDrawRequestInfo.IsWeixin.ToBool() ? "提现至微信账号" : (balanceDrawRequestInfo.IsAlipay.ToBool() ? (balanceDrawRequestInfo.AlipayRealName + "(" + balanceDrawRequestInfo.AlipayCode + ")") : (balanceDrawRequestInfo.BankName + balanceDrawRequestInfo.MerchantCode)));
if (balanceDrawRequestInfo.IsPass.HasValue)
{
Literal literal2 = this.litAccountDate;
dateTime = balanceDrawRequestInfo.AccountDate.Value;
literal2.Text = dateTime.ToString("yyyy-MM-dd HH:mm:ss");
}
this.litStatus.Text = ((!balanceDrawRequestInfo.IsPass.HasValue) ? "未审核" : (balanceDrawRequestInfo.IsPass.Value ? "同意" : "拒绝"));
}
protected void Page_Load(object sender, EventArgs e)
{
this.btnOK.Click += new EventHandler(this.btnOK_Click);
if (!base.IsPostBack)
{
BalanceDrawRequestInfo info = new BalanceDrawRequestInfo();
if (this.Session["BalanceDrawRequest"] != null)
{
info = (BalanceDrawRequestInfo)this.Session["BalanceDrawRequest"];
Distributor user = Users.GetUser(info.UserId) as Distributor;
this.litRealName.Text = user.RealName;
this.litName.Text = info.AccountName;
this.litBankName.Text = info.BankName;
this.litBankCode.Text = info.MerchantCode;
this.lblAmount.Money = info.Amount;
}
else
{
base.GotoResourceNotFound();
}
}
}
protected override void AttachChildControls()
{
this.litUserName = (System.Web.UI.WebControls.Literal) this.FindControl("litUserName");
this.lblDrawBanlance = (FormatedMoneyLabel)this.FindControl("lblDrawBanlance");
this.litBankName = (System.Web.UI.WebControls.Literal) this.FindControl("litBankName");
this.litAccountName = (System.Web.UI.WebControls.Literal) this.FindControl("litAccountName");
this.litMerchantCode = (System.Web.UI.WebControls.Literal) this.FindControl("litMerchantCode");
this.litRemark = (System.Web.UI.WebControls.Literal) this.FindControl("litRemark");
this.btnDrawConfirm = ButtonManager.Create(this.FindControl("btnDrawConfirm"));
PageTitle.AddSiteNameTitle("确认申请提现", HiContext.Current.Context);
this.btnDrawConfirm.Click += new System.EventHandler(this.btnDrawConfirm_Click);
if (!this.Page.IsPostBack)
{
BalanceDrawRequestInfo balanceDrawRequest = this.GetBalanceDrawRequest();
this.litUserName.Text = HiContext.Current.User.Username;
this.lblDrawBanlance.Money = balanceDrawRequest.Amount;
this.litBankName.Text = balanceDrawRequest.BankName;
this.litAccountName.Text = balanceDrawRequest.AccountName;
this.litMerchantCode.Text = balanceDrawRequest.MerchantCode;
this.litRemark.Text = balanceDrawRequest.Remark;
}
}
private void AddCommissions(HttpContext context)
{
context.Response.ContentType = "text/json";
string msg = "";
if (this.CheckAddCommissions(context, ref msg))
{
string str2 = context.Request["account"].Trim();
decimal num = decimal.Parse(context.Request["commissionmoney"].Trim());
BalanceDrawRequestInfo balancerequestinfo = new BalanceDrawRequestInfo {
MerchanCade = str2,
Amount = num
};
if (DistributorsBrower.AddBalanceDrawRequest(balancerequestinfo))
{
msg = "{\"success\":true,\"msg\":\"申请成功！\"}";
}
else
{
msg = "{\"success\":false,\"msg\":\"真实姓名或手机号未填写！\"}";
}
}
context.Response.Write(msg);
context.Response.End();
}
