protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
try
{
String custid = Request["hiddenCustID"];
String spid = Request["hiddenSPID"];
String InvoiceType = Request["InvoiceType"];
String InvoiceTitle = Request["InvoiceTitle"];
String InvoiceContent = Request["InvoiceContent"];
String ContactPerson = Request["ContactPerson"];
String ContactPhone = Request["ContactPhone"];
String Address = Request["Address"];
String Zip = Request["Zip"];
String Mem = Request["Mem"];
String NeedInvoice = Request["NeedInvoice"];
long balance = Convert.ToInt64(Convert.ToDouble(Request["TranAmount"]) * 100);
DateTime reqTime = DateTime.Now;
//查询账户信息
BesttoneAccountDAO _besttoneAccount_dao = new BesttoneAccountDAO();
BesttoneAccount account_entity = _besttoneAccount_dao.QueryByCustID(custid);
if (account_entity == null)
{
CommonBizRules.ErrorHappenedRedircet(result, ErrMsg, "账户信息异常", this.Context);
return;
}
#region 账户充值金额上限校验
long OnceRechargeLimit = BesttoneAccountConstDefinition.DefaultInstance.AccountRechargeLimitedOne; //单笔充值金额上限
long RechargeAmountLimit = BesttoneAccountConstDefinition.DefaultInstance.AccountRechargeLimitedDay; //账户单日充值额度上限
long CurrentAmountLimit = BesttoneAccountConstDefinition.DefaultInstance.AccountBalanceLimited; //账户余额上限
if (OnceRechargeLimit > 0)
{
//检测用户单笔充值金额是否超限(10000元)
if (balance > OnceRechargeLimit)
{
result = 100003;
ErrMsg = String.Format("单笔充值金额最多不能超过{0}元", BesttoneAccountHelper.ConvertAmountToYuan(OnceRechargeLimit));
CommonBizRules.ErrorHappenedRedircet(result, ErrMsg, "充值金额超过上限", this.Context);
return;
}
}
if (RechargeAmountLimit > 0)
{
//检测用户当日充值是否超限(当日充值金额不能超过50000元)
long hadRechargeAmount = _rechargeOrder_dao.QueryCurrentRechargeAmount(account_entity.BestPayAccount);
if ((hadRechargeAmount + balance) > RechargeAmountLimit)
{
result = 100001;
ErrMsg = String.Format("您今日累计充值金额:{0}元，本次充值将超过您的当日累计充值限额:{1}元，请改日再进行充值操作!",
BesttoneAccountHelper.ConvertAmountToYuan(hadRechargeAmount), BesttoneAccountHelper.ConvertAmountToYuan(RechargeAmountLimit));
CommonBizRules.ErrorHappenedRedircet(result, ErrMsg, "充值金额超过上限", this.Context);
return;
}
}
if (CurrentAmountLimit > 0)
{
long accountBalance = 0;
//检测用户帐户余额(个人账户余额不能超过100000元)
result = BesttoneAccountHelper.QueryAccountBalance(account_entity.BestPayAccount, out accountBalance, out ErrMsg);
if (result != 0)
{
CommonBizRules.ErrorHappenedRedircet(result, ErrMsg, "账户信息异常", this.Context);
return;
}
if ((accountBalance + balance) > CurrentAmountLimit)
{
result = 100002;
ErrMsg = String.Format("您的账户余额为:{0}元，本次充值将超过您的账户余额上限:{1}元，请消费后再进行充值操作!",
BesttoneAccountHelper.ConvertAmountToYuan(accountBalance), BesttoneAccountHelper.ConvertAmountToYuan(CurrentAmountLimit));
CommonBizRules.ErrorHappenedRedircet(result, ErrMsg, "充值金额超过上限", this.Context);
return;
}
}
#endregion
bool Result = false;
#region 生成订单信息
/***************************************************************************/
String orderSeq = BesttoneAccountHelper.CreateOrderSeq(); //订单号
String transactionID = BesttoneAccountHelper.CreateTransactionID(); //流水号
// 在发起网银扣款请求，主表状态为1，扣款子表状态为0
//初始化充值订单
//2013-04-13 add -start
if (String.IsNullOrEmpty(NeedInvoice))
{
NeedInvoice = "0";
}
//2013-04-13 add -end
RechargeOrder _recharge_order = new RechargeOrder(orderSeq, transactionID, reqTime.ToString("yyyyMMdd"), "RMB",
balance, balance, 0, "网银充值", custid, account_entity.BestPayAccount, "0", spid, reqTime, new DateTime(1900, 1, 1),
new DateTime(1900, 1, 1), 1, 0, "", "", "", NeedInvoice); //2013-04-13 add NeedInvoice 字段
//初始化网银扣款流水记录
BankRechargeRecord _bankRecharge_record = new BankRechargeRecord(orderSeq, transactionID, reqTime.ToString("yyyyMMdd"), "RMB",
balance, balance, 0, "网银充值", account_entity.BestPayAccount, 0, reqTime, new DateTime(1900, 1, 1), "", "", "", "", "");
Result = _rechargeOrder_dao.Insert(_recharge_order);
if (!Result)
{
CommonBizRules.ErrorHappenedRedircet(result, ErrMsg, "网银充值失败1", this.Context);
return;
}
//如果需要开发票 -- 插入发票表 2013-04-14 add-start
if ("1".Equals(NeedInvoice))
{
System.Text.StringBuilder datalog = new System.Text.StringBuilder();
//Result = _rechargeOrder_dao.InsertInvoice(orderSeq, InvoiceType, "", InvoiceTitle, ContactPerson, ContactPhone, Address, Zip, Mem, out datalog);
if ("0".Equals("InvoiceType"))
{
InvoiceTitle = "个人";
}
if (String.IsNullOrEmpty(InvoiceTitle))
{
InvoiceTitle = "个人";
}
if (String.IsNullOrEmpty(InvoiceContent))
{
InvoiceContent = "日用品";
}
Result = _rechargeOrder_dao.InsertInvoice(orderSeq, InvoiceType, InvoiceContent, InvoiceTitle, ContactPerson, ContactPhone, Address, Zip, Mem, "9", out datalog); // "9" 代表需要开票
if (!Result)
{
CommonBizRules.ErrorHappenedRedircet(result, ErrMsg, "网银充值失败-发票生成失败", this.Context);
return;
}
}
//2013-04-14 add-end
Result = _bankRechargeRecord_dao.Insert(_bankRecharge_record);
if (!Result)
{
CommonBizRules.ErrorHappenedRedircet(result, ErrMsg, "网银充值失败2", this.Context);
return;
}
/***************************************************************************/
#endregion
this._ORDERSEQ = orderSeq;
this._ORDERREQTRANSEQ = transactionID;
this._ORDERDATE = reqTime.ToString("yyyyMMddHHmmss");
this._ORDERAMOUNT = balance.ToString();
this._PRODUCTAMOUNT = balance.ToString();
//MAC签名
String mac = String.Format("MERCHANTID={0}&ORDERSEQ={1}&ORDERDATE={2}&ORDERAMOUNT={3}", this.MERCHANTID, this._ORDERSEQ, this._ORDERDATE, this._ORDERAMOUNT);
mac = BesttoneAccountHelper.MACSign(mac);
this._MAC = mac;
}
catch (Exception ex)
{
CommonBizRules.ErrorHappenedRedircet(result, ErrMsg, "网银充值失败", this.Context);
return;
}
}
}
/// <summary>
/// 卡充值
/// </summary>
protected String AccountRechargeByCard(out StringBuilder strLog)
{
Int32 Result = ErrorDefinition.CIP_IError_Result_UnknowError_Code;
String ErrMsg = ErrorDefinition.CIP_IError_Result_UnknowError_Msg;
strLog = new StringBuilder();
strLog.AppendFormat("【消费卡充值，DateTime:{0}】\r\n[参数]:", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
//获取参数
String spid = Request["SPID"];
String custid = Request["CustID"];
String cardNo = Request["CardNo"];
String cardPwd = Request["CardPassword"];
String cardType = Request["CardType"];
strLog.AppendFormat("SPID:{0},CustID:{1},CardNo:{2},CardPwd:{3},CardType:{4}\r\n", spid, custid, cardNo, cardPwd, cardType);
//String CheckCardErrMsg = "";
//Int32 CheckCardResult = BesttoneAccountHelper.VerifyCardNo(cardNo, out CheckCardErrMsg);
//if(CheckCardResult!=0)
// return "[{\"result\":\"false\",\"step\":\"query\",\"errorcode\":\"" + CheckCardResult + "\",\"info\":\"" + CheckCardErrMsg + "}]";
long accountBalance = 0; //账户余额
long cardBalance = 0; //卡余额
String accountType = BesttoneAccountHelper.ConvertAccountType(cardType); //转换卡类型
/*********************************************查询账户信息*****************************************************/
BesttoneAccountDAO _besttoneAccount_dao = new BesttoneAccountDAO();
BesttoneAccount account_entity = _besttoneAccount_dao.QueryByCustID(custid);
#region 卡余额查询
//查询卡余额
Result = BesttoneAccountHelper.QueryCardBalance(cardNo, accountType, out cardBalance, out ErrMsg);
strLog.AppendFormat("[查询卡余额]:Result:{0},Balance:{1}\r\n", Result, cardBalance);
//查询失败
if (Result != 0)
{
return("[{\"result\":\"false\",\"step\":\"query\",\"errorcode\":\"" + Result + "\",\"info\":\"查询余额失败\"}]");
}
//卡余额为0
if (cardBalance == 0)
{
return("[{\"result\":\"false\",\"step\":\"query\",\"errorcode\":\"200020\",\"info\":\"卡内余额为0\"}]");
}
#endregion
#region 账户充值金额上限校验
long OnceRechargeLimit = BesttoneAccountConstDefinition.DefaultInstance.AccountRechargeLimitedOne; //单笔充值金额上限
long RechargeAmountLimit = BesttoneAccountConstDefinition.DefaultInstance.AccountRechargeLimitedDay; //账户单日充值额度上限
long CurrentAmountLimit = BesttoneAccountConstDefinition.DefaultInstance.AccountBalanceLimited; //账户余额上限
if (OnceRechargeLimit > 0)
{
//检测用户单笔充值金额是否超限(10000元)
if (cardBalance > OnceRechargeLimit)
{
return("[{\"result\":\"false\",\"step\":\"query\",\"errorcode\":\"100003\",\"rechargeamount\":\"" + BesttoneAccountHelper.ConvertAmountToYuan(cardBalance) + "\",\"rechargeamountlimit\":\"" + BesttoneAccountHelper.ConvertAmountToYuan(OnceRechargeLimit) + "\",\"info\":\"卡内余额为0\"}]");
}
}
if (RechargeAmountLimit > 0)
{
//检测用户当日充值是否超限(当日充值金额不能超过50000元)
long hadRechargeAmount = _rechargeOrder_dao.QueryCurrentRechargeAmount(account_entity.BestPayAccount);
if ((hadRechargeAmount + cardBalance) > RechargeAmountLimit)
{
return("[{\"result\":\"false\",\"step\":\"query\",\"errorcode\":\"100001\",\"rechargeamount\":\"" + BesttoneAccountHelper.ConvertAmountToYuan(hadRechargeAmount) + "\",\"rechargeamountlimit\":\"" + BesttoneAccountHelper.ConvertAmountToYuan(RechargeAmountLimit) + "\",\"info\":\"卡内余额为0\"}]");
}
}
if (CurrentAmountLimit > 0)
{
//检测用户帐户余额(个人账户余额不能超过100000元)
Result = BesttoneAccountHelper.QueryAccountBalance(account_entity.BestPayAccount, out accountBalance, out ErrMsg);
if (Result != 0)
{
return("[{\"result\":\"false\",\"step\":\"query\",\"errorcode\":\"" + Result + "\",\"info\":\"账户信息查询失败\"}]");
}
if ((accountBalance + cardBalance) > CurrentAmountLimit)
{
return("[{\"result\":\"false\",\"step\":\"query\",\"errorcode\":\"100002\",\"accountbalance\":\"" + BesttoneAccountHelper.ConvertAmountToYuan(accountBalance) + "\",\"CurrentAmountLimit\":\"" + BesttoneAccountHelper.ConvertAmountToYuan(CurrentAmountLimit) + "\",\"info\":\"卡内余额为0\"}]");
}
accountBalance = 0;
}
#endregion
#region 卡扣款
String transactionID = BesttoneAccountHelper.CreateTransactionID();
String orderSeq = BesttoneAccountHelper.CreateOrderSeq();
DateTime reqTime = DateTime.Now;
RechargeOrder _recharge_order; //充值订单
CardRechargeRecord cardrecharge_entity; //卡扣款流水记录
//初始化充值订单
_recharge_order = new RechargeOrder(orderSeq, transactionID, reqTime.ToString("yyyyMMdd"), "RMB", cardBalance, cardBalance, 0, "消费卡向账户充值扣款",
custid, account_entity.BestPayAccount, cardType, spid, reqTime, new DateTime(1900, 1, 1), new DateTime(1900, 1, 1), 1, 0, "", "", "", "0"); //2013-04-13 add 最后一个字段 0 代表是否需要开票
//初始化充值订单—测试
//_recharge_order = new RechargeOrder(orderSeq, transactionID, reqTime.ToString("yyyyMMdd"), "RMB", 1, 1, 0, "消费卡向账户充值扣款",
// custid, account_entity.BestPayAccount, cardType, spid, reqTime, new DateTime(1900, 1, 1), new DateTime(1900, 1, 1), 1, 0, "", "", "");
//初始化卡扣款流水
cardrecharge_entity = new CardRechargeRecord(transactionID, orderSeq, reqTime.ToString("yyyyMMdd"), "RMB", cardBalance, "消费卡向账户充值扣款", cardNo, cardPwd, cardType,
account_entity.BestPayAccount, 0, reqTime, new DateTime(1900, 1, 1), "", "", "", "", "");
//初始化卡扣款流水—测试
//cardrecharge_entity = new CardRechargeRecord(transactionID, orderSeq, reqTime.ToString("yyyyMMdd"), "RMB", 1, "消费卡向账户充值扣款", cardNo, cardPwd, cardType,
// account_entity.BestPayAccount, 0, reqTime, new DateTime(1900, 1, 1), "", "", "", "", "");
strLog.AppendFormat("[订单信息]：TransactionID:{0},OrderSeq:{1},ReqTime:{2}\r\n", transactionID, orderSeq, reqTime.ToString("yyyy-MM-dd HH:mm:ss"));
/***********************************************************开始扣款*******************************************************/
String uptranSeq = String.Empty; //交易流水号，支付平台返回的，后期对账用
Result = BesttoneAccountHelper.CardDeductionBalance(transactionID, orderSeq, cardNo, cardPwd, cardType, cardBalance, reqTime, "", out uptranSeq, out ErrMsg);
//扣款—测试
//Result = BesttoneAccountHelper.CardDeductionBalance(transactionID, orderSeq, cardNo, cardPwd, cardType, 1, reqTime, "", out uptranSeq, out ErrMsg);
strLog.AppendFormat("[卡扣款]:Result:{0},ErrMsg:{1}\r\n", Result, ErrMsg);
_recharge_order.UptranSeq = uptranSeq;
cardrecharge_entity.UptranSeq = uptranSeq;
if (Result != 0)
{
//修改订单信息
_recharge_order.Status = 4; // 这里要对调网关发生异常做分别处理 ，定位6
if (Result == -3024)
{
_recharge_order.Status = 6;
}
_recharge_order.PayTime = DateTime.Now;
_recharge_order.ReturnCode = Result.ToString();
_recharge_order.ReturnDesc = ErrMsg;
_rechargeOrder_dao.Insert(_recharge_order);
//修改卡扣款记录信息
//cardrecharge_entity.Status = 2; //为统一rechargeorder 和 cardrechargerecord 的状态值，这里做修改 2013-05-15
cardrecharge_entity.Status = 4;
if (Result == -3024)
{
cardrecharge_entity.Status = 6;
}
//以上和rechargeorder 的状态处理方式统一
cardrecharge_entity.PayTime = DateTime.Now;
cardrecharge_entity.ReturnCode = Result.ToString();
cardrecharge_entity.ReturnDesc = ErrMsg;
_cardRechargeRecord_dao.Insert(cardrecharge_entity);
return("[{\"result\":\"false\",\"step\":\"deduction\",\"errorcode\":\"" + Result + "\",\"info\":\"卡扣款失败\"}]");
}
else
{
//修改订单信息
_recharge_order.Status = 2;
_recharge_order.PayTime = DateTime.Now;
_recharge_order.ReturnCode = "0000";
_recharge_order.ReturnDesc = "已扣款待充值"; // 原：扣款成功
_rechargeOrder_dao.Insert(_recharge_order);
//修改卡充值记录信息
//cardrecharge_entity.Status = 1; // 这里为和 rechargeorder 状态统一 ,修改为2
cardrecharge_entity.Status = 2;
cardrecharge_entity.PayTime = DateTime.Now;
cardrecharge_entity.ReturnCode = "0000";
cardrecharge_entity.ReturnDesc = "已扣款待充值"; // 原：扣款成功
_cardRechargeRecord_dao.Insert(cardrecharge_entity);
}
#endregion
#region 充值
transactionID = BesttoneAccountHelper.CreateTransactionID(); //充值流水记录
DateTime rechargeTime = DateTime.Now; //充值请求时间
String returnMsg = String.Empty;
bool resultBoolean = false;
//初始化充值流水类
AccountRechargeRecord rechargeRecord_entity = new AccountRechargeRecord(transactionID, rechargeTime.ToString("yyyyMMdd"), orderSeq,
cardBalance, cardType, "消费卡充值", rechargeTime, new DateTime(1900, 1, 1), 0, "", "");
try
{
#region 开始充值
//调用接口给账户充值
Result = BesttoneAccountHelper.AccountRecharge(transactionID, account_entity.BestPayAccount, cardBalance, rechargeTime, out accountBalance, out ErrMsg);
//调用接口给账户充值—测试
//Result = BesttoneAccountHelper.AccountRecharge(transactionID, account_entity.BestPayAccount, 1, rechargeTime, out accountBalance, out ErrMsg);
strLog.AppendFormat("[账户充值]:TransactionID:{0},Result:{1},ErrMsg:{2}\r\n", transactionID, Result, ErrMsg);
if (Result == 0)
{
//修改订单信息
_recharge_order = _rechargeOrder_dao.QueryByOrderSeq(orderSeq);
_recharge_order.Status = 3;
_recharge_order.RechargeCount = 1;
_recharge_order.CompleteTime = DateTime.Now;
_recharge_order.ReturnCode = "0000";
_recharge_order.ReturnDesc = "已充值"; // 原：充值成功
_recharge_order.RechargeTransactionID = transactionID; // 回填充值流水号
resultBoolean = _rechargeOrder_dao.Update(_recharge_order);
//修改充值流水记录信息
rechargeRecord_entity.Status = 3; // 原: 1 ,为和总表rechargeorder 统一改为3
rechargeRecord_entity.CompleteTime = DateTime.Now;
rechargeRecord_entity.ReturnCode = "0000";
rechargeRecord_entity.ReturnDesc = "已充值"; // 原:充值成功
strLog.AppendFormat("[更新订单状态]ResultBoolean:{0}\r\n", resultBoolean);
returnMsg = "[{\"result\":\"true\",\"info\":\"账户充值成功\",\"deductionBalance\":\"" + BesttoneAccountHelper.ConvertAmountToYuan(cardBalance) + "\",\"accountBalance\":\"" + BesttoneAccountHelper.ConvertAmountToYuan(accountBalance) + "\"}]";
}
else
{
//修改订单信息
_recharge_order = _rechargeOrder_dao.QueryByOrderSeq(orderSeq);
_recharge_order.RechargeCount = 1;
_recharge_order.Status = 5; // 原：没有这句
if (Result == -3025)
{
_recharge_order.Status = 7; //原：没有这句
}
_recharge_order.ReturnCode = Result.ToString();
_recharge_order.ReturnDesc = ErrMsg;
_recharge_order.RechargeTransactionID = transactionID; // 回填充值流水号
resultBoolean = _rechargeOrder_dao.Update(_recharge_order);
//修改充值流水记录信息
rechargeRecord_entity.Status = 5; // 5 代表充值失败 原：2
if (Result == -3025)
{
rechargeRecord_entity.Status = 7;// 充值异常
}
rechargeRecord_entity.CompleteTime = DateTime.Now;
rechargeRecord_entity.ReturnCode = Result.ToString();
rechargeRecord_entity.ReturnDesc = ErrMsg;
returnMsg = "[{\"result\":\"false\",\"step\":\"recharge\",\"errorcode\":\"" + Result + "\",\"info\":\"账户充值失败\"}]";
}
#endregion
}
catch (Exception ex)
{
rechargeRecord_entity.ReturnDesc += ex.Message;
throw ex;
}
finally
{
_accountRechargeRecord_dao.Insert(rechargeRecord_entity);
}
#endregion
return(returnMsg);
}