예제 #1
0
    protected void Page_Load(object sender, EventArgs e)
    {
        CustID    = Request["CustID"];
        SPID      = Request["SPID"];
        ReturnUrl = Request["ReturnUrl"];

        this.hdCustID.Value    = CustID;
        this.hdSPID.Value      = SPID;
        this.hdReturnUrl.Value = ReturnUrl;

        if (String.IsNullOrEmpty(CustID))
        {
            CommonBizRules.ErrorHappenedRedircet(result, ErrMsg, "您尚未登录,请登录", this.Context);
            return;
        }

        BesttoneAccount _besttoneAccount_entity = _besttoneAccount_dao.QueryByCustID(CustID);

        if (_besttoneAccount_entity == null)
        {
            HttpContext.Current.Response.Redirect("AccountNotBind.aspx");
            return;
        }
        else
        {
            _bestPayAccount = _besttoneAccount_entity.BestPayAccount;
        }

        this.OnceRechargeLimited   = BesttoneAccountHelper.ConvertAmountToYuan(BesttoneAccountConstDefinition.DefaultInstance.AccountRechargeLimitedOne);
        this.DayRechargeLimited    = BesttoneAccountHelper.ConvertAmountToYuan(BesttoneAccountConstDefinition.DefaultInstance.AccountRechargeLimitedDay);
        this.AccountBalanceLimited = BesttoneAccountHelper.ConvertAmountToYuan(BesttoneAccountConstDefinition.DefaultInstance.AccountBalanceLimited);
    }
예제 #2
0
    protected void Page_Load(object sender, EventArgs e)
    {
        //测试用117663797
        //this.hdCustID.Value = "117663797";//116694907
        //this.hdSPID.Value = "35000000";
        //this.hdReturnUrl.Value = "http://www.118114.cn";

        this.hdCustID.Value    = base.CustID;
        this.hdSPID.Value      = base.SPID;
        this.hdReturnUrl.Value = base.ReturnUrl;
        this.hdHeadFoot.Value  = base.IsNeedHeadFoot == "yes" ? "1" : "0";

        this.OnceRechargeLimited   = BesttoneAccountHelper.ConvertAmountToYuan(BesttoneAccountConstDefinition.DefaultInstance.AccountRechargeLimitedOne);
        this.DayRechargeLimited    = BesttoneAccountHelper.ConvertAmountToYuan(BesttoneAccountConstDefinition.DefaultInstance.AccountRechargeLimitedDay);
        this.AccountBalanceLimited = BesttoneAccountHelper.ConvertAmountToYuan(BesttoneAccountConstDefinition.DefaultInstance.AccountBalanceLimited);
    }
예제 #3
0
    /// <summary>
    /// 账户余额查询
    /// </summary>
    protected string QueryAcountBalance()
    {
        String bestPayAccount = Request["BestPayAccount"];

        long   balance;
        Int32  Result = ErrorDefinition.CIP_IError_Result_UnknowError_Code;
        String ErrMsg = ErrorDefinition.CIP_IError_Result_UnknowError_Msg;

        //查询余额
        Result = BesttoneAccountHelper.QueryAccountBalance(bestPayAccount, out balance, out ErrMsg);
        if (Result == 0)
        {
            return("[{\"result\":\"true\",\"balance\":\"" + BesttoneAccountHelper.ConvertAmountToYuan(balance) + "\"}]");
        }
        else
        {
            return("[{\"result\":\"false\",\"info\":\"查询余额失败\"}]");
        }
    }
예제 #4
0
    /// <summary>
    /// 卡余额查询
    /// </summary>
    protected String CardBalanceQuery()
    {
        String cardNo   = Request["CardNo"];
        String cardPwd  = Request["CardPassword"];
        String cardType = Request["CardType"];

        long   balance;
        Int32  Result = ErrorDefinition.CIP_IError_Result_UnknowError_Code;
        String ErrMsg = ErrorDefinition.CIP_IError_Result_UnknowError_Msg;

        //查询余额
        Result = BesttoneAccountHelper.CardAuthen(cardNo, cardPwd, cardType, out balance, out ErrMsg);
        if (Result == 0)
        {
            return("[{\"result\":\"true\",\"balance\":\"" + BesttoneAccountHelper.ConvertAmountToYuan(balance) + "\"}]");
        }
        else
        {
            return("[{\"result\":\"false\",\"info\":\"查询余额失败\"}]");
        }
    }
예제 #5
0
    protected void Page_Load(object sender, EventArgs e)
    {
        StringBuilder strLog = new StringBuilder();

        try
        {
            if (!IsPostBack)
            {
                strLog.AppendFormat("BesttoneAccountMain");
                ParseSPTokenRequest();

                if (Result == 0)
                {
                    CreateSPTokenRequest();

                    //int QueryResult = 0;
                    strLog.AppendFormat("CustID:{0},SPID{1},HeadFooter{2}", CustID, SPID, HeadFooter);
                    if ("yes".Equals(HeadFooter))
                    {
                        this.header.Visible = true;
                        this.footer.Visible = true;
                    }
                    else
                    {
                        this.header.Visible = false;
                        this.footer.Visible = false;
                    }

                    //PhoneRecord[] phones = CustBasicInfo.getPhoneRecord(CustID, out QueryResult, out ErrMsg);
                    String qryPhone = "";
                    //if (QueryResult == 0 && phones != null && phones.Length > 0)                    {
                    //    strLog.AppendFormat("getPhoneRecord成功!");
                    //    phoneNum = phones[0].Phone;

                    //    strLog.AppendFormat("根据CustID获得手机号:CustID:{0},phoneNum:{1}", CustID, phoneNum);

                    string BindedBestpayAccount = "";
                    IsBesttoneAccountBindV5Result = CIP2BizRules.IsBesttoneAccountBindV5(CustID, out BindedBestpayAccount, out CreateTime, out ErrMsg);
                    strLog.AppendFormat("IsBesttoneAccountBindV5Result:{0},ErrMsg:{1},CustID:{2},CreateTime:{3},BindedBestpayAccount:{4}", IsBesttoneAccountBindV5Result, ErrMsg, CustID, CreateTime, BindedBestpayAccount);

                    // 0 代表 绑定
                    if (IsBesttoneAccountBindV5Result == 0)
                    {
                        AccountItem ai = new AccountItem();
                        BesttoneAccount = phoneNum;
                        BesttoneAccount = ai.AccountName;


                        if (!String.IsNullOrEmpty(BindedBestpayAccount))
                        {
                            qryPhone = BindedBestpayAccount;
                        }
                        else
                        {
                            qryPhone = phoneNum;
                        }


                        String ResponseCode = "";
                        int    QueryBesttoneAccountResult = BesttoneAccountHelper.BesttoneAccountInfoQuery(qryPhone, out ai, out ResponseCode, out ErrMsg);

                        Linkage.BestTone.Interface.Rule.CustInfo custInfo = new Linkage.BestTone.Interface.Rule.CustInfo();
                        int resultQuerycustInfo = BesttoneAccountHelper.QueryCustInfo(qryPhone, out custInfo, out ErrMsg);
                        if (resultQuerycustInfo == 0)
                        {
                            BesttoneAccount = custInfo.CustomerName;
                        }

                        if (QueryBesttoneAccountResult == 0)
                        {
                            if (ai != null)
                            {
                                //页面赋值

                                if ("0".Equals(ai.AccountStatus))
                                {
                                    //this.AccountStatus.InnerText = "未激活";
                                    BesttoneAccountStatus = "未激活";
                                }
                                else if ("1".Equals(ai.AccountStatus))
                                {
                                    //this.AccountStatus.InnerText = "正常";
                                    BesttoneAccountStatus = "正常";
                                }
                                else if ("2".Equals(ai.AccountStatus))
                                {
                                    //this.AccountStatus.InnerText = "挂失";
                                    BesttoneAccountStatus = "挂失";
                                }
                                else if ("3".Equals(ai.AccountStatus))
                                {
                                    //this.AccountStatus.InnerText = "冻结";
                                    BesttoneAccountStatus = "冻结";
                                }
                                else if ("4".Equals(ai.AccountStatus))
                                {
                                    //this.AccountStatus.InnerText = "锁定";
                                    BesttoneAccountStatus = "锁定";
                                }
                                else if ("9".Equals(ai.AccountStatus))
                                {
                                    //this.AccountStatus.InnerText = "已销户";
                                    BesttoneAccountStatus = "已销户";
                                }
                                else
                                {
                                    //this.AccountStatus.InnerText = "";
                                    BesttoneAccountStatus = "";
                                }

                                BesttoneAccountBalance = BesttoneAccountHelper.ConvertAmountToYuan(ai.AccountBalance);
                            }
                            else
                            {
                            }
                        }
                        else
                        {
                            if ("200010".Equals(ResponseCode))
                            {
                                BesttoneAccountStatus  = "账户未开通";
                                BesttoneAccountBalance = "0.00";
                            }
                        }
                    }


                    Int64 balance = 0;

                    // 最近交易查询

                    String txnType = "";       // 121020充值
                    //131010消费
                    //131030退费

                    String txnChannel = "02";      //WEB

                    int maxReturnRecord = 30;
                    int startRecord     = 1;
                    //int QueryAllTypeTxnResult = BesttoneAccountHelper.QueryAllTypeTxn(phoneNum, txnType, txnChannel, out txnItemList, out ErrMsg);

                    int QueryChargeResult = CIP2BizRules.QueryBestPayAllTxn(qryPhone, txnType, txnChannel, maxReturnRecord, startRecord, out txnItemList, out ErrMsg);

                    //txnType = "131090";

                    //}  // custphone query end
                    //else   // custphone query end
                    //{
                    //    strLog.AppendFormat("ErrMsg:{0}", ErrMsg);

                    //}  // custphone query end
                }
                else
                {
                    Response.Redirect("ErrorInfo.aspx?ErrorInfo=" + ErrMsg);
                }
            }
        }
        catch (System.Exception ex)
        {
            log(ex.ToString());
        }
        finally
        {
            log(strLog.ToString());
        }
    }
예제 #6
0
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            System.Threading.Thread.Sleep(200);
            //客户ID,账户号,订单号
            String CustID, BestPayAccount, OrderSeq;
            //充值金额,账户余额
            long RechargeBalance, Balance;

            try
            {
                #region 获取支付平台post过来的一些变量

                //获取支付平台post过来的一些变量
                String uptranSeq       = Request.Form["UPTRANSEQ"];             //支付平台交易流水号
                String tranDate        = Request.Form["TRANDATE"];              //支付平台交易日期
                String retnCode        = Request.Form["RETNCODE"];              //处理结果码
                String retnInfo        = Request.Form["RETNINFO"];              //处理结果解释码
                String orderReqtranSeq = Request.Form["ORDERREQTRANSEQ"];       //订单请求交易流水号
                String orderSeq        = Request.Form["ORDERSEQ"];              //订单号
                String orderAmount     = Request.Form["ORDERAMOUNT"];           //订单总金额
                String productAmount   = Request.Form["PRODUCTAMOUNT"];         //产品金额
                String attachAmount    = Request.Form["ATTACHAMOUNT"];          //附加金额
                String curType         = Request.Form["CURTYPE"];               //币种
                String encodeType      = Request.Form["ENCODETYPE"];            //加密方式
                String attach          = Request.Form["ATTACH"];                //SP附加信息
                String sign            = Request.Form["SIGN"];                  //数字签名

                //验证签名
                #endregion

                #region 查看订单状态

                //根据订单号查询该订单是否已经支付
                RechargeOrder _recharge_order = _rechargeOrder_dao.QueryByOrderSeq(orderSeq);
                if (_recharge_order == null)
                {
                    return;
                }

                CustID          = _recharge_order.CustID;
                BestPayAccount  = _recharge_order.TargetAccount;
                OrderSeq        = _recharge_order.OrderSeq;
                RechargeBalance = _recharge_order.OrderAmount;

                //如果不是待付款状态则跳转错误页面
                if (_recharge_order.Status != 3)
                {
                    this.lblMsg.Text = "提示:您的充值申请已提交,系统正在处理中……请耐心等待!";
                }
                else
                {
                    //查询账户余额
                    Result           = BesttoneAccountHelper.QueryAccountBalance(BestPayAccount, out Balance, out ErrMsg);
                    this.lblMsg.Text = "您已成功充值<font color=red>&nbsp;" + BesttoneAccountHelper.ConvertAmountToYuan(_recharge_order.OrderAmount) + "&nbsp;</font>元,账户余额&nbsp;<font color=red>" + BesttoneAccountHelper.ConvertAmountToYuan(Balance) + "</font>&nbsp;元";
                }

                #endregion
            }
            catch { }
        }
    }
    /// <summary>
    /// 获取近三个月交易明细
    /// </summary>
    protected String GetThreeMonthsHistoryDetails(String SPID, String CustID, String wt)
    {
        Int32  Result = ErrorDefinition.CIP_IError_Result_UnknowError_Code;
        String ErrMsg = ErrorDefinition.CIP_IError_Result_UnknowError_Msg;

        StringBuilder returnMsg = new StringBuilder();
        DateTime      startDate = new DateTime(DateTime.Now.AddMonths(-2).Year, DateTime.Now.AddMonths(-2).Month, 1);
        DateTime      endDate   = DateTime.Now;

        wt = "json";    //仅支持json

        if (String.IsNullOrEmpty(SPID))
        {
            returnMsg.Length = 0;
            if ("json".Equals(wt))
            {
                returnMsg.Append("{");
                returnMsg.AppendFormat("\"errcode\":\"{0}\",", "995");
                returnMsg.AppendFormat("\"errmsg\":\"{0}\"", "SPID不能为空!");
                returnMsg.Append("}");
            }
            else
            {
                returnMsg.Append("<?xml version=\"1.0\" encoding=\"UTF-8\"?>");
                returnMsg.Append("<PayPlatRequestParameter>");
                returnMsg.Append("<PARAMETERS>");
                returnMsg.AppendFormat("<ErrCode>{0}</ErrCode>", "995");
                returnMsg.AppendFormat("<ErrMsg>{0}</ErrMsg>", "SPID不能为空!");
                returnMsg.Append("</PARAMETERS>");
                returnMsg.Append("</PayPlatRequestParameter>");
            }
            return(returnMsg.ToString());
        }


        if (String.IsNullOrEmpty(CustID))
        {
            returnMsg.Length = 0;
            if ("json".Equals(wt))
            {
                returnMsg.Append("{");
                returnMsg.AppendFormat("\"errcode\":\"{0}\",", "996");
                returnMsg.AppendFormat("\"errmsg\":\"{0}\"", "CustID不能为空!");
                returnMsg.Append("}");
            }
            else
            {
                returnMsg.Append("<?xml version=\"1.0\" encoding=\"UTF-8\"?>");
                returnMsg.Append("<PayPlatRequestParameter>");
                returnMsg.Append("<PARAMETERS>");
                returnMsg.AppendFormat("<ErrCode>{0}</ErrCode>", "996");
                returnMsg.AppendFormat("<ErrMsg>{0}</ErrMsg>", "CustID不能为空!");
                returnMsg.Append("</PARAMETERS>");
                returnMsg.Append("</PayPlatRequestParameter>");
            }
            return(returnMsg.ToString());
        }

        String bestPayAccount = String.Empty;

        try
        {
            BesttoneAccount _besttoneAccount_entity = _besttoneAccount_dao.QueryByCustID(CustID);
            if (_besttoneAccount_entity == null)
            {
                returnMsg.Length = 0;
                if ("json".Equals(wt))
                {
                    returnMsg.Append("{");
                    returnMsg.AppendFormat("\"errcode\":\"{0}\",", "997");
                    returnMsg.AppendFormat("\"errmsg\":\"{0}\"", "号码百事通账户未开通!");
                    returnMsg.Append("}");
                }
                else
                {
                    returnMsg.Append("<?xml version=\"1.0\" encoding=\"UTF-8\"?>");
                    returnMsg.Append("<PayPlatRequestParameter>");
                    returnMsg.Append("<PARAMETERS>");
                    returnMsg.AppendFormat("<ErrCode>{0}</ErrCode>", "997");
                    returnMsg.AppendFormat("<ErrMsg>{0}</ErrMsg>", "号码百事通账户未开通!");
                    returnMsg.Append("</PARAMETERS>");
                    returnMsg.Append("</PayPlatRequestParameter>");
                }
                return(returnMsg.ToString());
            }
            else
            {
                bestPayAccount = _besttoneAccount_entity.BestPayAccount;
            }

            List <TxnItem>  list = new List <TxnItem>();
            IList <TxnItem> list1, list2;

            Result = BesttoneAccountHelper.QueryAllTxnCurrentDay(bestPayAccount, out list1, out ErrMsg);
            Result = BesttoneAccountHelper.QueryAllTxnHistory(startDate, endDate, bestPayAccount, 10000, 1, out list2, out ErrMsg);

            if (list1 != null && list1.Count > 0)
            {
                foreach (TxnItem item in list1)
                {
                    list.Add(item);
                }
            }

            if (list2 != null && list2.Count > 0)
            {
                foreach (TxnItem item in list2)
                {
                    list.Add(item);
                }
            }
            //测试数据
            //list = CreateTestList();
            if (list != null && list.Count > 0)
            {
                list.Sort();
                returnMsg.Length = 0;
                foreach (TxnItem item in list)
                {
                    //如果是交易类型是“退货退还手续费”记录,则过滤掉不显示
                    if (item.TxnType == "261020")
                    {
                        continue;
                    }

                    String sign    = "+";
                    String txnType = BesttoneAccountHelper.ConvertTxnType(item.TxnType);
                    String flag    = item.CancelFlag == "1" ? "已撤销" : "成功";
                    if (item.TxnType == "131090")
                    {
                        sign = "-";
                    }

                    AccountRechargeRecord _recharge_redcord = _accountRechargeRecord_dao.QueryByTransactionID(item.AcceptSeqNO);

                    returnMsg.Append("{");
                    returnMsg.AppendFormat("\"AcceptSeqNO\":\"{0}\",", item.AcceptSeqNO);
                    returnMsg.AppendFormat("\"AcceptDate\":\"{0}\",", item.AcceptDate);
                    returnMsg.AppendFormat("\"AcceptTime\":\"{0}\",", item.AcceptTime);
                    returnMsg.AppendFormat("\"TxnAmount\":\"{0}\",", sign + BesttoneAccountHelper.ConvertAmountToYuan(item.TxnAmount));
                    returnMsg.AppendFormat("\"TxnType\":\"{0}\",", txnType);
                    returnMsg.AppendFormat("\"TxnChannel\":\"{0}\",", item.TxnChannel);
                    returnMsg.AppendFormat("\"MerchantName\":\"{0}\",", item.MerchantName);
                    returnMsg.AppendFormat("\"TxnDscpt\":\"{0}\",", item.TxnDscpt);
                    returnMsg.AppendFormat("\"CancelFlag\":\"{0}\",", flag);
                    if (_recharge_redcord != null)
                    {
                        returnMsg.AppendFormat("\"OrderSeq\":\"{0}\",", _recharge_redcord.OrderSeq);
                    }
                    returnMsg.AppendFormat("\"TxnTime\":\"{0}\"", item.TxnTime);

                    returnMsg.Append("},");
                }

                returnMsg.Insert(0, "{\"errcode\":\"0\",\"errmsg\":\"\",\"txninfo\":[");
                returnMsg = returnMsg.Remove(returnMsg.Length - 1, 1);
                returnMsg.Append("]}");
            }
            else
            {
                returnMsg.Append("{\"errcode\":\"-2012\",\"errmsg\":\"NoData\"}");
            }
        }
        catch (Exception ex)
        {
            returnMsg.Append("{\"errcode\":\"-2013\",\"errmsg\":\"异常:" + ex.Message + "\"}");
        }

        return(returnMsg.ToString());
    }
예제 #8
0
    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;
            }
        }
    }
예제 #9
0
    /// <summary>
    /// 获取近三个月交易明细
    /// </summary>
    protected String GetThreeMonthsHistoryDetails()
    {
        Int32  Result = ErrorDefinition.CIP_IError_Result_UnknowError_Code;
        String ErrMsg = ErrorDefinition.CIP_IError_Result_UnknowError_Msg;

        StringBuilder returnMsg = new StringBuilder();
        DateTime      startDate = new DateTime(DateTime.Now.AddMonths(-2).Year, DateTime.Now.AddMonths(-2).Month, 1);
        DateTime      endDate   = DateTime.Now;

        try
        {
            String bestPayAccount = Request["BestPayAccount"];

            List <TxnItem>  list = new List <TxnItem>();
            IList <TxnItem> list1, list2;

            Result = BesttoneAccountHelper.QueryAllTxnCurrentDay(bestPayAccount, out list1, out ErrMsg);
            Result = BesttoneAccountHelper.QueryAllTxnHistory(startDate, endDate, bestPayAccount, 10000, 1, out list2, out ErrMsg);

            if (list1 != null && list1.Count > 0)
            {
                foreach (TxnItem item in list1)
                {
                    list.Add(item);
                }
            }

            if (list2 != null && list2.Count > 0)
            {
                foreach (TxnItem item in list2)
                {
                    list.Add(item);
                }
            }
            //测试数据
            //list = CreateTestList();
            if (list != null && list.Count > 0)
            {
                list.Sort();
                foreach (TxnItem item in list)
                {
                    //如果是交易类型是“退货退还手续费”记录,则过滤掉不显示
                    if (item.TxnType == "261020")
                    {
                        continue;
                    }

                    String sign    = "+";
                    String txnType = BesttoneAccountHelper.ConvertTxnType(item.TxnType);
                    String flag    = item.CancelFlag == "1" ? "已撤销" : "成功";
                    if (item.TxnType == "131090")
                    {
                        sign = "-";
                    }

                    AccountRechargeRecord _recharge_redcord = _accountRechargeRecord_dao.QueryByTransactionID(item.AcceptSeqNO);

                    returnMsg.Append("{");
                    returnMsg.AppendFormat("\"AcceptSeqNO\":\"{0}\",", item.AcceptSeqNO);
                    returnMsg.AppendFormat("\"AcceptDate\":\"{0}\",", item.AcceptDate);
                    returnMsg.AppendFormat("\"AcceptTime\":\"{0}\",", item.AcceptTime);
                    returnMsg.AppendFormat("\"TxnAmount\":\"{0}\",", sign + BesttoneAccountHelper.ConvertAmountToYuan(item.TxnAmount));
                    returnMsg.AppendFormat("\"TxnType\":\"{0}\",", txnType);
                    returnMsg.AppendFormat("\"TxnChannel\":\"{0}\",", item.TxnChannel);
                    returnMsg.AppendFormat("\"MerchantName\":\"{0}\",", item.MerchantName);
                    returnMsg.AppendFormat("\"TxnDscpt\":\"{0}\",", item.TxnDscpt);
                    returnMsg.AppendFormat("\"CancelFlag\":\"{0}\",", flag);
                    if (_recharge_redcord != null)
                    {
                        returnMsg.AppendFormat("\"OrderSeq\":\"{0}\",", _recharge_redcord.OrderSeq);
                    }
                    returnMsg.AppendFormat("\"TxnTime\":\"{0}\"", item.TxnTime);

                    returnMsg.Append("},");
                }
                returnMsg.Insert(0, "{\"result\":\"true\",\"txninfo\":[");
                returnMsg = returnMsg.Remove(returnMsg.Length - 1, 1);
                returnMsg.Append("]}");
            }
            else
            {
                returnMsg.Append("{\"result\":\"NoData\"}");
            }
        }
        catch (Exception ex)
        {
            returnMsg.Append("{\"result\":\"false\",\"info\":\"异常:" + ex.Message + "\"}");
        }

        return(returnMsg.ToString());
    }
예제 #10
0
    /// <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);
    }