コード例 #1
0
        internal List <OrderInfo> queryOrderStatus(MainForm mainForm)
        {
            OrderInfoDao     dao           = new OrderInfoDao();
            List <OrderInfo> orderInfoList = dao.queryOrderStatus();

            if (orderInfoList != null && orderInfoList.Count > 0)
            {
                foreach (OrderInfo orderInfo in orderInfoList)
                {
                    try
                    {
                        log.Debug("orderListResult:http://chongzhi.jd.com/order/order_autoDetail.action?orderId=" + orderInfo.vender_order_no);
                        String queryOrderStatusResult = Share.getPage("http://chongzhi.jd.com/order/order_autoDetail.action", "orderId=" + orderInfo.vender_order_no, "");
                        log.Debug("queryOrderStatusResult:" + queryOrderStatusResult);
                        String orderStatus = "";
                        int    updateCount = 0;
                        if (String.IsNullOrEmpty(queryOrderStatusResult) || queryOrderStatusResult.Contains("System.Net.WebException"))
                        {
                            orderStatus = "查询失败,网络异常";
                        }
                        else if (queryOrderStatusResult.IndexOf("订单号:" + orderInfo.vender_order_no) > -1 || queryOrderStatusResult.IndexOf("订单不存在") > -1)
                        {
                            orderStatus = Share.getValue("<span class=\"ftx-02\">", "</span>", queryOrderStatusResult);
                            if ("正在充值".Equals(orderStatus))
                            {
                                orderInfo.order_status = "2";
                            }
                            else
                            {
                                if ("充值成功".Equals(orderStatus))
                                {
                                    orderInfo.order_status = "8";
                                }
                                else if ("充值失败,退款成功".Equals(orderStatus) || "充值失败,退款处理中".Equals(orderStatus))
                                {
                                    orderInfo.order_status = "4";
                                }
                                else
                                {
                                    orderInfo.order_status = "3";
                                }
                                orderInfo.fail_reason = orderStatus;
                                updateCount           = dao.updateOrderStatus(orderInfo);
                            }
                        }
                        else
                        {
                            orderStatus = "查询失败,请求返回异常,请尝试重新登录";
                        }
                        log.Debug("订单状态查询 orderId:" + orderInfo.order_id + ",订单状态:" + orderStatus + ",更新结果:" + updateCount);
                        View.write("订单状态查询 orderId:" + orderInfo.order_id + ",订单状态:" + orderStatus + ",更新结果:" + updateCount);
                    }
                    catch (Exception ex)
                    {
                        log.Debug("queryOrderStatus error:" + ex);
                    }
                }
            }
            return(orderInfoList);
        }
コード例 #2
0
        public List <OrderInfo> statusNotify(MainForm mainForm)
        {
            OrderInfoDao     dao           = new OrderInfoDao();
            List <OrderInfo> orderInfoList = dao.statusNotify();

            if (orderInfoList != null && orderInfoList.Count > 0)
            {
                foreach (OrderInfo orderInfo in orderInfoList)
                {
                    try
                    {
                        StringBuilder sb = new StringBuilder();
                        sb.Append("venderId=").Append(orderInfo.vender_id).Append("&orderId=").Append(orderInfo.order_id).Append("&venderOrderId=").Append(orderInfo.vender_order_no).Append("&orderStatus=").Append(orderInfo.order_status);
                        String sign = Share.MD5(sb.ToString() + "&key=" + Config.md5Key).ToLower();
                        log.Debug("statusNotify start:" + Config.notifyUrl + sb.ToString() + "&sign=" + sign);
                        View.write("回调通知:" + Config.notifyUrl + "?" + sb.ToString() + "&sign=" + sign);
                        String result = Share.getPageInterFace(Config.notifyUrl, sb.ToString() + "&sign=" + sign);
                        log.Debug("statusNotify result:" + result);
                        View.write("回调结果:" + result);
                        if ("success".Equals(result))
                        {
                            orderInfo.notify_status = "8";
                        }
                        else
                        {
                            if (orderInfo.notify_count >= 4)
                            {
                                orderInfo.notify_status = "4";
                            }
                        }
                    }
                    catch (Exception ex)
                    {
                        if (orderInfo.notify_count >= 4)
                        {
                            orderInfo.notify_status = "4";
                        }
                    }
                    int updateCount = dao.updateNotify(orderInfo);
                    log.Debug("回调更新结果:" + updateCount);
                }
            }
            return(orderInfoList);
        }
コード例 #3
0
        public int totalRows(String startTime, String endTime, string orderId, string phoneNo)
        {
            OrderInfoDao dao = new OrderInfoDao();

            return(dao.totalRows(startTime, endTime, orderId, phoneNo));
        }
コード例 #4
0
        public DataTable selectOrderList(String startTime, String endTime, string orderId, string phoneNo, int pageIndex, int pageSize)
        {
            OrderInfoDao dao = new OrderInfoDao();

            return(dao.selectOrderList(startTime, endTime, orderId, phoneNo, pageIndex, pageSize));
        }
コード例 #5
0
        public OrderInfo submitOrderService(MainForm frm)
        {
            OrderInfoDao dao       = new OrderInfoDao();
            OrderInfo    phoneInfo = dao.getSubmitOrderDao();

            if (phoneInfo != null)
            {
                try
                {
                    String jdOrderId     = "";
                    String jdOrderInTime = "";
                    String orderId       = phoneInfo.order_id.Trim();
                    String facePrice     = phoneInfo.face_price.Trim();
                    String telephone     = phoneInfo.phone_no.Trim();

                    View.write("实立单号:" + orderId + ",号码:" + telephone + ",面值:" + facePrice + ",开始充值提交...");
                    log.Debug("实立单号:" + orderId + ",号码:" + telephone + ",面值:" + facePrice + ",开始充值提交...");
                    if (!String.IsNullOrEmpty(orderId) && !String.IsNullOrEmpty(facePrice) && !String.IsNullOrEmpty(telephone))
                    {
                        log.Debug("searchSkuIdResult:http://chongzhi.jd.com/json/order/search_searchPhone.action?mobile=" + telephone);
                        String telephoneInfo = Share.getPage("http://chongzhi.jd.com/json/order/search_searchPhone.action", "mobile=" + telephone, "");
                        log.Debug("telephoneInfo:" + telephoneInfo);
                        if (String.IsNullOrEmpty(telephoneInfo) || telephoneInfo.Contains("System.Net.WebException"))
                        {
                            log.Debug("searchSkuIdResult:http://chongzhi.jd.com/json/order/search_searchPhone.action?mobile=" + telephone);
                            telephoneInfo = Share.getPage("http://chongzhi.jd.com/json/order/search_searchPhone.action", "mobile=" + telephone, "");
                            log.Debug("telephoneInfo:" + telephoneInfo);
                        }
                        JObject telephoneInfoJson = (JObject)JsonConvert.DeserializeObject(telephoneInfo);
                        String  area = telephoneInfoJson["area"].ToString().Trim();
                        String  ISP  = telephoneInfoJson["provider"].ToString().Trim();
                        log.Debug("searchSkuIdResult:http://chongzhi.jd.com/json/order/search_searchSkuId.action?ISP=" + ISP + "&area=" + area + "&filltype=0&faceValue=" + facePrice);
                        String searchSkuIdResult = Share.getPage("http://chongzhi.jd.com/json/order/search_searchSkuId.action", "ISP=" + ISP + "&area=" + area + "&filltype=0&faceValue=" + facePrice, "");
                        log.Debug("searchSkuIdResult:" + searchSkuIdResult);
                        if (String.IsNullOrEmpty(searchSkuIdResult) || searchSkuIdResult.Contains("System.Net.WebException"))
                        {
                            log.Debug("searchSkuIdResult:http://chongzhi.jd.com/json/order/search_searchSkuId.action?ISP=" + ISP + "&area=" + area + "&filltype=0&faceValue=" + facePrice);
                            searchSkuIdResult = Share.getPage("http://chongzhi.jd.com/json/order/search_searchSkuId.action", "ISP=" + ISP + "&area=" + area + "&filltype=0&faceValue=" + facePrice, "");
                            log.Debug("searchSkuIdResult:" + searchSkuIdResult);
                        }
                        JObject searchSkuIdResultJson = (JObject)JsonConvert.DeserializeObject(searchSkuIdResult);
                        String  skuId = searchSkuIdResultJson["skuId"].ToString();
                        log.Debug("jdPrice:http://chongzhi.jd.com/json/order/searchp_searchJdPrice.action?skuId=" + skuId);
                        String jdPrice = Share.getPage("http://chongzhi.jd.com/json/order/searchp_searchJdPrice.action", "skuId=" + skuId, "").Trim().Replace("\"", "");
                        log.Debug("jdPrice:" + jdPrice);
                        if (String.IsNullOrEmpty(jdPrice) || jdPrice.Contains("System.Net.WebException") || jdPrice.Length > 100)
                        {
                            log.Debug("jdPrice:http://chongzhi.jd.com/json/order/searchp_searchJdPrice.action?skuId=" + skuId);
                            jdPrice = Share.getPage("http://chongzhi.jd.com/json/order/searchp_searchJdPrice.action", "skuId=" + skuId, "").Trim().Replace("\"", "");
                            log.Debug("jdPrice:" + jdPrice);
                        }
                        log.Debug("获取到京东价格:" + jdPrice + ",区域ID:" + area + ",产品ID:" + skuId + ",开始匹配优惠券...");
                        View.write("获取到京东价格:" + ((jdPrice.Length > 100) ? "异常" : jdPrice) + ",区域ID:" + area + ",产品ID:" + skuId + ",开始匹配优惠券...");
                        log.Debug("youHuiQuanJson:http://chongzhi.jd.com/json/order/searchp_searchDxqInfo.action?ISP=" + ISP + "&jdPrice=" + jdPrice);
                        String youHuiQuanJson = Share.getPage("http://chongzhi.jd.com/json/order/searchp_searchDxqInfo.action", "ISP=" + ISP + "&jdPrice=" + jdPrice, "");
                        log.Debug("youHuiQuanJson:" + youHuiQuanJson);
                        if (String.IsNullOrEmpty(youHuiQuanJson) || youHuiQuanJson.Contains("System.Net.WebException"))
                        {
                            log.Debug("youHuiQuanJson:http://chongzhi.jd.com/json/order/searchp_searchDxqInfo.action?ISP=" + ISP + "&jdPrice=" + jdPrice);
                            youHuiQuanJson = Share.getPage("http://chongzhi.jd.com/json/order/searchp_searchDxqInfo.action", "ISP=" + ISP + "&jdPrice=" + jdPrice, "");
                            log.Debug("youHuiQuanJson:" + youHuiQuanJson);
                        }
                        String dxqidsStr = getdxqidsString(youHuiQuanJson, jdPrice);

                        if (!String.IsNullOrEmpty(dxqidsStr))
                        {
                            log.Debug("查找到过期最快的优惠券 dxqidsStr:" + dxqidsStr + ",开始验证是否可以提交充值等信息...");
                            View.write("查找到过期最快的优惠券 dxqidsStr:" + dxqidsStr + ",开始验证是否可以提交充值等信息...");
                            phoneInfo.features = "优惠券编号:" + dxqidsStr;
                            log.Debug("hideKeyResult:http://chongzhi.jd.com/order/order_place.action?skuId=" + skuId + "&mobile=" + telephone + "&entry=4");
                            String hideKeyResult = Share.getPage("http://chongzhi.jd.com/order/order_place.action", "skuId=" + skuId + "&mobile=" + telephone + "&entry=4", "");
                            log.Debug("hideKeyResult:" + hideKeyResult);
                            if (String.IsNullOrEmpty(hideKeyResult) || hideKeyResult.Contains("System.Net.WebException"))
                            {
                                log.Debug("hideKeyResult:http://chongzhi.jd.com/order/order_place.action?skuId=" + skuId + "&mobile=" + telephone + "&entry=4");
                                hideKeyResult = Share.getPage("http://chongzhi.jd.com/order/order_place.action", "skuId=" + skuId + "&mobile=" + telephone + "&entry=4", "");
                                log.Debug("hideKeyResult:" + hideKeyResult);
                            }
                            String hideKey = Share.getValue("<input type=\"hidden\" id=\"hideKey\" name=\"hideKey\" value=\"", "\"/>", hideKeyResult);
                            log.Debug("checkRechargeResult:http://chongzhi.jd.com/json/order/searchp_checkRecharge.action?mobile=" + telephone + "&skuId=" + skuId);
                            String checkRechargeResult = Share.getPage("http://chongzhi.jd.com/json/order/searchp_checkRecharge.action", "mobile=" + telephone + "&skuId=" + skuId, "");
                            log.Debug("checkRechargeResult:" + checkRechargeResult);
                            if (String.IsNullOrEmpty(checkRechargeResult) || checkRechargeResult.Contains("System.Net.WebException"))
                            {
                                log.Debug("checkRechargeResult:http://chongzhi.jd.com/json/order/searchp_checkRecharge.action?mobile=" + telephone + "&skuId=" + skuId);
                                checkRechargeResult = Share.getPage("http://chongzhi.jd.com/json/order/searchp_checkRecharge.action", "mobile=" + telephone + "&skuId=" + skuId, "");
                                log.Debug("checkRechargeResult:" + checkRechargeResult);
                            }
                            JObject checkRechargeResultJson = (JObject)JsonConvert.DeserializeObject(checkRechargeResult);
                            String  flag = checkRechargeResultJson["flag"].ToString().Trim().ToLower();
                            log.Debug("获取到是否可以提交充值:" + flag + ",hideKey:" + hideKey + ",开始提交充值...");
                            View.write("获取到是否可以提交充值:" + flag + ",hideKey:" + hideKey + ",开始提交充值...");

                            if (flag == "true")
                            {
                                try
                                {
                                    String mobileFor = telephone.Substring(0, 3) + "+" + telephone.Substring(3, 4) + "+" + telephone.Substring(7, 4);
                                    log.Debug("submitOrderResult:http://chongzhi.jd.com/order/order_submitOrder.action?mobile=" + telephone + "&mobileFor=" + mobileFor + "&placeOrderVo.fillType=0&radiobutton=" + facePrice + dxqidsStr + "&paymentPassword="******"&skuId=" + skuId + "&entry=4&price=" + jdPrice + "&hideKey=" + hideKey + "&areaCodeU=7&rechargeTypeU=2&messageId=&initFlag=&payType=3&canUseJingdou=&usedJingdouNum=");
                                    String submitOrderResult = Share.getPage("http://chongzhi.jd.com/order/order_submitOrder.action", "mobile=" + telephone + "&mobileFor=" + mobileFor + "&placeOrderVo.fillType=0&radiobutton=" + facePrice + dxqidsStr + "&paymentPassword="******"&skuId=" + skuId + "&entry=4&price=" + jdPrice + "&hideKey=" + hideKey + "&areaCodeU=7&rechargeTypeU=2&messageId=&initFlag=&payType=3&canUseJingdou=&usedJingdouNum=", "http://chongzhi.jd.com/order/order_place.action?skuId=" + skuId + "&mobile=" + telephone + "&entry=4");
                                    log.Debug("submitOrderResult:" + submitOrderResult);
                                    if (String.IsNullOrEmpty(submitOrderResult) || submitOrderResult.Contains("System.Net.WebException"))
                                    {
                                        phoneInfo.fail_reason      = "状态未知";
                                        phoneInfo.order_new_status = "3";
                                        log.Debug("状态未知,需要人工核实");
                                        View.write("状态未知,需要人工核实");
                                    }
                                    else
                                    {
                                        if (submitOrderResult.Contains("您已付款成功!正在为您充值"))
                                        {
                                            phoneInfo.order_new_status = "2";
                                            phoneInfo.fail_reason      = "付款成功,正在充值";
                                            log.Debug("您已付款成功!正在为您充值,开始获取京东订单号...");
                                            View.write("您已付款成功!正在为您充值,开始获取京东订单号...");
                                            try
                                            {
                                                log.Debug("orderListResult:http://order.jd.com/center/list.action?t=37&d=0&s=4096");
                                                String orderListResult = Share.getPageOrder("http://order.jd.com/center/list.action", "t=37&d=0&s=4096", "");
                                                log.Debug("orderListResult:" + orderListResult);
                                                if (String.IsNullOrEmpty(orderListResult) || orderListResult.Contains("System.Net.WebException"))
                                                {
                                                    log.Debug("orderListResult:http://order.jd.com/center/list.action?t=37&d=0&s=4096");
                                                    orderListResult = Share.getPageOrder("http://order.jd.com/center/list.action", "t=37&d=0&s=4096", "");
                                                    log.Debug("orderListResult:" + orderListResult);
                                                }
                                                String firstOrderId = Share.getValue("<span id=\"pop_sign\" style=\"display:none;\">[{\"orderType\":37,\"orderIds\":[\"", "\"", orderListResult);
                                                log.Debug("firstOrderIdResult:http://chongzhi.jd.com/order/order_autoDetail.action?orderId=" + firstOrderId);
                                                String firstOrderIdResult = Share.getPage("http://chongzhi.jd.com/order/order_autoDetail.action", "orderId=" + firstOrderId, "");
                                                log.Debug("firstOrderIdResult:" + firstOrderIdResult);
                                                if (String.IsNullOrEmpty(firstOrderIdResult) || firstOrderIdResult.Contains("System.Net.WebException"))
                                                {
                                                    log.Debug("firstOrderIdResult:http://chongzhi.jd.com/order/order_autoDetail.action?orderId=" + firstOrderId);
                                                    firstOrderIdResult = Share.getPage("http://chongzhi.jd.com/order/order_autoDetail.action", "orderId=" + firstOrderId, "");
                                                    log.Debug("firstOrderIdResult:" + firstOrderIdResult);
                                                }
                                                String orderTelephone = Share.getValue("<li>手机号码:", "</li>", firstOrderIdResult);
                                                String orderFacePrice = Share.getValue("<li>充值面额:", "元</li>", firstOrderIdResult);
                                                String orderInTime    = Share.getValue("<li>下单时间:", "</li>", firstOrderIdResult);
                                                if (float.Parse(orderFacePrice) == float.Parse(facePrice) && Share.getMacherStr(telephone, orderTelephone))
                                                {
                                                    jdOrderId                 = firstOrderId;
                                                    jdOrderInTime             = orderInTime;
                                                    phoneInfo.vender_order_no = jdOrderId;
                                                    log.Debug("获取到京东订单号:" + jdOrderId + ",京东下单时间:" + jdOrderInTime);
                                                    View.write("获取到京东订单号:" + jdOrderId + ",京东下单时间:" + jdOrderInTime);
                                                }
                                                else
                                                {
                                                    log.Debug("获取京东订单信息失败,请人工核实!");
                                                    View.write("获取京东订单信息失败,请人工核实!");
                                                }
                                            }
                                            catch (Exception exc)
                                            {
                                                log.Debug("获取京东订单信息异常,请人工核实!" + exc);
                                                View.write("获取京东订单信息异常,请人工核实!");
                                            }
                                        }
                                        else
                                        {
                                            phoneInfo.order_new_status = "4";
                                            String failReason = Share.getValue("<div class=\"success\"><s></s>", "</h4>", submitOrderResult);
                                            phoneInfo.fail_reason = failReason;
                                            log.Debug("付款失败,失败原因:" + failReason);
                                            View.write("付款失败,失败原因:" + failReason);
                                        }
                                    }
                                }
                                catch (Exception exc)
                                {
                                    phoneInfo.fail_reason      = "状态未知";
                                    phoneInfo.order_new_status = "3";
                                    log.Debug("状态未知,需要人工核实");
                                    View.write("状态未知,需要人工核实");
                                }
                            }
                            else
                            {
                                phoneInfo.order_new_status = "4";
                                phoneInfo.fail_reason      = "未付款,原因:付款前检查是否可以充值返回" + checkRechargeResult + " is false";
                                log.Debug("未付款,原因:付款前检查是否可以充值返回" + checkRechargeResult + " is false");
                                View.write("未付款,原因:付款前检查是否可以充值" + checkRechargeResult + " is false");
                            }
                        }
                        else
                        {
                            phoneInfo.order_new_status = "4";
                            phoneInfo.fail_reason      = "未查找到优惠券,付款失败";
                            log.Debug("未查找到优惠券,付款失败");
                            View.write("未查找到优惠券,付款失败");
                        }
                    }
                    else
                    {
                        phoneInfo.order_new_status = "4";
                        phoneInfo.fail_reason      = "该行面值、号码、单号参数为空,提交失败";
                        log.Debug("该行面值、号码、单号参数为空,提交失败");
                        View.write("该行面值、号码、单号参数为空,提交失败");
                    }
                }
                catch (Exception ex)
                {
                    phoneInfo.order_new_status = "4";
                    phoneInfo.fail_reason      = "程序异常提交失败";
                    log.Debug("程序异常,提交失败!" + ex);
                    View.write("异常提交失败!");
                }

                int updateCount = dao.updateOrderStatusDao(phoneInfo);
                log.Debug("updateOrderStatusDao orderId:" + phoneInfo.order_id + ",更新结果:" + updateCount);
                View.write("orderId:" + phoneInfo.order_id + ",更新结果:" + updateCount);
            }
            return(phoneInfo);
        }
コード例 #6
0
        public int selectCountByOrderId(OrderInfo phoneInfo)
        {
            OrderInfoDao dao = new OrderInfoDao();

            return(dao.selectCountByOrderId(phoneInfo));
        }
コード例 #7
0
        public int insertOrderService(OrderInfo phoneInfo)
        {
            OrderInfoDao dao = new OrderInfoDao();

            return(dao.insertOrderDao(phoneInfo));
        }
コード例 #8
0
        /// <summary>
        /// 得到sitemaster上的信息显示
        /// </summary>
        /// <returns></returns>
        protected Dictionary<string, string> GetSiteMaster()
        {
            Dictionary<string, string> sitemaster = new Dictionary<string, string>();
            if (this.CurrentUserInfo == null)
            {
                sitemaster["userid"] = "-1";
                sitemaster["EnterpriseName"] = "游客";
                sitemaster["Memberlevel"] = "匿名用户";
                sitemaster["intlevel"] = "0";
                sitemaster["isadmin"] = "0";
                sitemaster["EndTime"] = "999";

            }
            else
            {
                string username = MembershipService.GetUserName(Convert.ToInt32(this.CurrentUserInfo.UserID));
                int IsAdmin = 0;
                if (EnterPriseMemberInfo == null)
                {
                    sitemaster["userid"] = this.CurrentUserInfo.UserID;
                    sitemaster["EnterpriseName"] = username;
                    sitemaster["Memberlevel"] = "免费注册用户";
                    sitemaster["intlevel"] = "1";
                    sitemaster["isadmin"] = IsAdmin.ToString();
                    sitemaster["EndTime"] = "999";
                }
                else
                {
                    IsAdmin = new CRMService().GetMemberUser(Convert.ToInt32(this.CurrentUserInfo.UserID)).IsMemberAdmin;
                    sitemaster["userid"] = this.CurrentUserInfo.UserID;
                    sitemaster["EnterpriseName"] = EnterPriseMemberInfo.EnterpriseName + " " + username;
                    sitemaster["isadmin"] = IsAdmin.ToString();
                    IList<OrderInfo> orderlist = new OrderInfoDao().QueryUserProductOrder(EnterPriseMemberInfo.MemberID, 1);
                    if (orderlist.Count > 0)//服务期内
                    {
                        DateTime servicestarttime = orderlist[0].ServiceStartTime;
                        DateTime serviceendtime = orderlist[0].ServiceEndTime;
                        if (serviceendtime > servicestarttime.AddMonths(2))
                            sitemaster["istest"] = "0";
                        else
                            sitemaster["istest"] = "1";
                        if (orderlist[0].VersionID == 1)
                        {
                            sitemaster["Memberlevel"] = new CRMService().GetUserMemberLevel(Int32.Parse(CurrentUserInfo.UserID)).ToString();
                        }
                        else
                        {
                            sitemaster["Memberlevel"] = "定制";
                        }
                        sitemaster["intlevel"] = ((int)new CRMService().GetUserMemberLevel(Int32.Parse(CurrentUserInfo.UserID))).ToString();
                        DateTime endtime = CRMMapper.Get().QueryForObject<DateTime>("OrderInfo.GetEndTime", EnterPriseMemberInfo.MemberID);
                        TimeSpan ts = endtime.Subtract(DateTime.Now);
                        if (ts.Days < 30)
                            sitemaster["EndTime"] = ts.Days.ToString();
                        else
                            sitemaster["EndTime"] = "999";
                    }
                    else//服务到期
                    {
                        sitemaster["Memberlevel"] = "免费注册用户";
                        sitemaster["intlevel"] = "1";
                        sitemaster["EndTime"] = "999";
                    }

                }
            }

            return sitemaster;
        }