Esempio n. 1
0
        /// <summary>
        /// add
        /// </summary>
        /// <param name="txyInfo"></param>
        /// <returns></returns>
        public int Add(txyInfo model)
        {
            var str  = GetInsertStr(model) + " select @@identity";
            var dict = GetParameters(model);

            return(Convert.ToInt32(SqlHelperHere.ExecuteScalar(str, dict)));
        }
Esempio n. 2
0
        /// <summary>
        /// 检查阿里支付。正确返回订单号,错误返回null
        /// </summary>
        /// <param name="dict"></param>
        /// <param name="Total_amount"></param>
        /// <returns></returns>
        public string CheckAliPay(IDictionary <string, string> dict, string Total_amount)
        {
            bool flag = AlipaySignature.RSACheckV1(dict, alipayPublicKey, "utf-8", "RSA2", false);

            txyInfo info = new txyInfo();

            info.content = JsonConvert.SerializeObject(dict + "==flag===" + flag);
            txyInfoOper.Instance.Add(info);

            if (flag)
            {
                var    total_amount = dict["total_amount"];
                var    out_trade_no = dict["out_trade_no"];
                string status       = dict["trade_status"];
                string seller_id    = dict["seller_id"];
                string app_id       = dict["app_id"];

                if (total_amount == Total_amount && seller_id == sellerId && app_id == appId)
                {
                    switch (status)
                    {
                    case "TRADE_SUCCESS":
                        return(out_trade_no);
                    }
                }
            }
            return(null);
        }
Esempio n. 3
0
        /// <summary>
        /// update
        /// </summary>
        /// <param name="txyInfo"></param>
        /// <returns></returns>
        public void Update(txyInfo model)
        {
            var str  = GetUpdateStr(model);
            var dict = GetParameters(model);

            SqlHelperHere.ExcuteNon(str, dict);
        }
Esempio n. 4
0
        /// <summary>
        /// 微信支付订单异步通知
        /// </summary>
        /// <returns></returns>
        public string wxpayNotify()
        {
            var success = "<xml><return_code><![CDATA[SUCCESS]]></return_code>\n<return_msg><![CDATA[OK]]></return_msg></xml>";

            var    error  = "<xml><return_code><![CDATA[FAIL]]></return_code>\n<return_msg><![CDATA[error]]></return_msg></xml>";
            string xmlStr = getPostStr();

            var     outTradeNo = WXCheck(xmlStr);
            txyInfo info       = new txyInfo();

            info.content = "outTradeNo ====" + outTradeNo;
            txyInfoOper.Instance.Add(info);

            if (outTradeNo == null)
            {
                return(error);
            }
            var orderList2 = CacheHelper.GetByCondition <OrderInfo>("orderinfo", " orderNo= " + outTradeNo);

            if (orderList2.Count < 1)
            {
                return(error);
            }
            var order = orderList2.First();

            if (order.status == 1)
            {
                return(success);
            }

            order.payType = "wxpay";
            if ((bool)order.isTake)
            {
                order.status = 2;
            }
            else
            {
                order.status = 1;
            }
            order.payTime = DateTime.Now;
            OrderInfoOper.Instance.Update(order);
            var user = UserInfoOper.Instance.GetById((int)order.userId);

            user.userBalance -= order.useBalance;
            user.coupon      -= order.useCoupon;
            UserInfoOper.Instance.Update(user);
            UPushHelper.Instance.PushAfterPayOrder(order);

            UserPayOper.Instance.payOrderAddRecord(order);
            return(success);
        }
Esempio n. 5
0
        /// <summary>
        /// 微信充值余额异步通知
        /// </summary>
        /// <returns></returns>
        public string ChargeByWxNotify()
        {
            var success = "<xml><return_code><![CDATA[SUCCESS]]></return_code>\n<return_msg><![CDATA[OK]]></return_msg></xml>";

            var    error  = "<xml><return_code><![CDATA[FAIL]]></return_code>\n<return_msg><![CDATA[error]]></return_msg></xml>";
            string xmlStr = getPostStr();

            var     outTradeNo = WXCheck(xmlStr);
            txyInfo info       = new txyInfo();

            info.content = "wx--outTradeNo ====" + outTradeNo;
            txyInfoOper.Instance.Add(info);

            if (outTradeNo == null)
            {
                return(error);
            }
            var list = CacheHelper.GetByCondition <UserPay>("UserPay", " outTradeNo= \'" + outTradeNo + "\'");

            if (list.Count < 1)
            {
                return(error);
            }
            var up = list.First();

            if ((bool)up.status)
            {
                return(success);
            }

            up.status = true;

            UserPayOper.Instance.Update(up);
            //orderOper.Update(up);
            var user2 = UserInfoOper.Instance.GetById((int)up.userId);
            //user2.userBalance += up.money;
            var userHere = new UserInfo();

            userHere.id          = user2.id;
            userHere.userBalance = user2.userBalance + up.money;
            //user2.coupon -= up.useCoupon;
            UserInfoOper.Instance.Update(userHere);
            return(success);
        }
Esempio n. 6
0
        /// <summary>
        /// 更新
        /// </summary>
        /// <param name="txyinfo"></param>
        /// <returns>是否成功</returns>
        public string GetUpdateStr(txyInfo txyinfo)
        {
            StringBuilder part1 = new StringBuilder();

            part1.Append("update txyinfo set ");
            if (txyinfo.content != null)
            {
                part1.Append("content = @content,");
            }
            if (txyinfo.ttime != null)
            {
                part1.Append("ttime = @ttime,");
            }
            int n = part1.ToString().LastIndexOf(",");

            part1.Remove(n, 1);
            part1.Append(" where id= @id  ");
            return(part1.ToString());
        }
Esempio n. 7
0
        /// 获取参数
        /// </summary>
        /// <param name="txyinfo"></param>
        /// <returns></returns>
        public Dictionary <string, string> GetParameters(txyInfo txyinfo)
        {
            Dictionary <string, string> dict = new Dictionary <string, string>();

            if (txyinfo.id != null)
            {
                dict.Add("@id", txyinfo.id.ToString());
            }
            if (txyinfo.content != null)
            {
                dict.Add("@content", txyinfo.content.ToString());
            }
            if (txyinfo.ttime != null)
            {
                dict.Add("@ttime", txyinfo.ttime.ToString());
            }

            return(dict);
        }
Esempio n. 8
0
        /// <summary>
        /// 支付宝充值余额异步通知
        /// </summary>
        /// <returns></returns>
        public string chargeByAlipayNotify()
        {
            string success      = "success";
            string failure      = "failure";
            var    dict2        = GetRequestPost();
            var    out_trade_no = dict2["out_trade_no"];

            var list = CacheHelper.GetByCondition <UserPay>("UserPay", " outTradeNo= \'" + out_trade_no + "\'");

            if (list.Count < 0)
            {
                return(failure);
            }
            var up = list.First();

            var     outTradeNo = CheckAliPay(dict2, up.money.ToString());
            txyInfo info       = new txyInfo();

            info.content = "alipay--outTradeNo=====" + outTradeNo;
            txyInfoOper.Instance.Add(info);

            if (outTradeNo == null)
            {
                return(failure);
            }

            if ((bool)up.status)
            {
                return(success);
            }
            up.status = true;

            UserPayOper.Instance.Update(up);
            var user = UserInfoOper.Instance.GetById((int)up.userId);
            //user.userBalance += up.money;
            var userHere = new UserInfo();

            userHere.id          = user.id;
            userHere.userBalance = user.userBalance + up.money;
            UserInfoOper.Instance.Update(userHere);
            return(success);
        }
Esempio n. 9
0
        /// <summary>
        /// 插入
        /// </summary>
        /// <param name="txyinfo"></param>
        /// <returns>是否成功</returns>
        public string GetInsertStr(txyInfo txyinfo)
        {
            StringBuilder part1 = new StringBuilder();
            StringBuilder part2 = new StringBuilder();

            if (txyinfo.content != null)
            {
                part1.Append("content,");
                part2.Append("@content,");
            }
            if (txyinfo.ttime != null)
            {
                part1.Append("ttime,");
                part2.Append("@ttime,");
            }
            StringBuilder sql = new StringBuilder();

            sql.Append("insert into txyinfo(").Append(part1.ToString().Remove(part1.Length - 1)).Append(") values (").Append(part2.ToString().Remove(part2.Length - 1)).Append(")");
            return(sql.ToString());
        }
Esempio n. 10
0
        /// <summary>
        /// 成功返回订单号out_trade_no 错误返回 null
        /// </summary>
        /// <param name="xmlStr"></param>
        /// <returns></returns>
        public string WXCheck(string xmlStr)
        {
            try
            {
                var         signFromWX = "";
                XmlDocument xml        = new XmlDocument();
                xml.LoadXml(xmlStr);
                var dict = new Dictionary <string, string>();
                foreach (XmlNode item in xml.FirstChild)
                {
                    if (item.Name != "sign")
                    {
                        dict.Add(item.Name, item.InnerText);
                    }
                    else
                    {
                        signFromWX = item.InnerText;
                    }
                }

                string sign = StringHelperHere.Instance.GetWXSign(dict, mchKey);
                if (dict["result_code"] == "SUCCESS")
                {
                    //交易成功
                    string out_trade_no = dict["out_trade_no"];//商户订单号
                    if (sign != signFromWX)
                    {
                        return(null);
                    }
                    return(out_trade_no);
                }
            }
            catch (Exception e)
            {
                txyInfo info = new txyInfo();
                info.content = e.Message;
                txyInfoOper.Instance.Add(info);
            }
            return(null);
        }
Esempio n. 11
0
        /// <summary>
        /// 支付宝支付订单异步通知
        /// </summary>
        /// <returns></returns>
        public string alipayNotify()
        {
            string success = "success";
            string failure = "failure";

            try
            {
                var dict2        = GetRequestPost();
                var out_trade_no = dict2["out_trade_no"];
                var orderList    = CacheHelper.GetByCondition <OrderInfo>("orderinfo", " orderNo= " + out_trade_no);
                if (orderList.Count < 0)
                {
                    return(failure);
                }
                var order = orderList.First();
                if (order.status == 1)
                {
                    return(success);
                }
                var outTradeNo = CheckAliPay(dict2, order.payMoney.ToString());

                txyInfo info = new txyInfo();
                info.content = "outTradeNo=====" + outTradeNo;
                txyInfoOper.Instance.Add(info);

                if (outTradeNo == null)
                {
                    return(failure);
                }


                var areaId = order.orderAreaId;
                order.payType = "alipay";
                if ((bool)order.isTake)
                {
                    order.status = 2;
                }
                else
                {
                    order.status = 1;
                }
                order.payTime = DateTime.Now;
                OrderInfoOper.Instance.Update(order);
                var user = UserInfoOper.Instance.GetById((int)order.userId);
                user.userBalance -= order.useBalance;
                user.coupon      -= order.useCoupon;
                UserInfoOper.Instance.Update(user);
                UPushHelper.Instance.PushAfterPayOrder(order);


                UserPayOper.Instance.payOrderAddRecord(order);
            }
            catch (Exception e)
            {
                txyInfo info = new txyInfo();
                info.content = e.Message;
                txyInfoOper.Instance.Add(info);
                return(failure);
            }
            return(success);
        }
Esempio n. 12
0
        public HttpResponseMessage Charge(UserReq req)
        {
            var tokenStr = req.Token;
            var userId   = Convert.ToInt32(req.userId);

            Token token = CacheHelper.GetUserToken(tokenStr);

            if (token == null)
            {
                return(ControllerHelper.Instance.JsonResult(400, "token失效"));
            }
            if (token.Payload.UserID != userId)
            {
                return(ControllerHelper.Instance.JsonResult(400, "token错误"));
            }


            var     payType          = req.payType;
            var     payMoney         = Convert.ToDecimal(req.payMoney);
            var     Spbill_create_ip = req.spbill_create_ip;
            var     out_trade_no     = StringHelperHere.Instance.GetTimeStamp() + StringHelperHere.Instance.GetLastFiveStr(userId.ToString());
            UserPay up = new UserPay();

            up.type       = 0;
            up.status     = false;
            up.userId     = userId;
            up.createTime = DateTime.Now;
            up.takeType   = payType;
            up.outTradeNo = out_trade_no;
            up.money      = payMoney;
            UserPayOper.Instance.Add(up);

            if (payType == "alipay")
            {
                //var str = alipay.CreateAlipayOrder(chargeMoney, out_trade_no, "http://" + apiHost + "/user/chargeByAlipayNotify");

                AlipayHelperHere a = new AlipayHelperHere();
                var b = a.CreateAlipayOrder(req.payMoney, out_trade_no, "https://fan-di.com/notify/chargeByAlipayNotify");

                JObject jo = new JObject();
                jo.Add("payType", "alipay");
                jo.Add("payStr", b);

                return(ControllerHelper.Instance.JsonResult(200, JsonConvert.SerializeObject(jo), ""));
            }
            else
            {
                WXPayHelperHere w = new WXPayHelperHere();
                var             b = w.CreateWXOrder(payMoney, out_trade_no, "https://fan-di.com/notify/ChargeByWxNotify", Spbill_create_ip);

                XmlDocument doc = new XmlDocument();
                doc.LoadXml(b);
                if (doc.DocumentElement["return_code"].InnerText != "SUCCESS")
                {
                    txyInfo txy = new txyInfo();
                    txy.content = JsonConvert.SerializeObject(doc);
                    //txyInfoOper txyOper = new txyInfoOper();
                    txyInfoOper.Instance.Add(txy);
                    return(ControllerHelper.Instance.JsonResult(500, "网络不稳定,请稍后"));
                }

                JObject jo = new JObject();
                jo.Add("payType", "wxpay");
                foreach (XmlNode item in doc.DocumentElement.ChildNodes)
                {
                    if (item.Name != "sign")
                    {
                        jo.Add(item.Name, item.InnerText);
                    }
                }

                var timestamp = StringHelperHere.Instance.GetTimeStamp();
                jo.Add("timestamp", timestamp);
                var dict = new Dictionary <string, string>();

                foreach (var item in jo)
                {
                    if (item.Key == "prepay_id")
                    {
                        dict.Add("prepayid", item.Value.ToString());
                    }
                    if (item.Key == "nonce_str")
                    {
                        dict.Add("noncestr", item.Value.ToString());
                    }
                }

                dict.Add("appid", "wxd8482615c33b8859");
                dict.Add("partnerid", "1494504712");
                dict.Add("package", "Sign=WXPay");
                dict.Add("timestamp", timestamp);

                string sign = StringHelperHere.Instance.GetWXSign(dict, "2BCF8DD9490E328D2FCEDE7B26643231");
                jo.Add("sign", sign);
                return(ControllerHelper.Instance.JsonResult(200, JsonConvert.SerializeObject(jo), ""));
            }
        }