Example #1
0
        public JsonResult SingleProductAddSave(T_goodsGY model)
        {
            string name = Server.UrlDecode(Request.Cookies["Nickname"].Value);

            using (TransactionScope sc = new TransactionScope())
            {
                model.create_date = DateTime.Now;
                model.create_Name = name;
                db.T_goodsGY.Add(model);
                try
                {
                    int i = db.SaveChanges();
                    if (i > 0)
                    {
                        App_Code.GY gy  = new App_Code.GY();
                        string      cmd = "";
                        cmd = "{" +
                              "\"appkey\":\"171736\"," +
                              "\"method\":\"gy.erp.item.add\"," +
                              "\"sessionkey\":\"f5885504d9c84d1d8146200a4841f4b7\"," +
                              "\"code\":\"" + model.code + "\"," +
                              "\"name\":\"" + model.name + "\"," +
                              "\"simple_name\":\"" + model.simple_name + "\"," +
                              "\"skus\":[]" +
                              "}";
                        string sign    = gy.Sign(cmd);
                        string comcode = "{" +
                                         "\"appkey\":\"171736\"," +
                                         "\"method\":\"gy.erp.item.add\"," +
                                         "\"sessionkey\":\"f5885504d9c84d1d8146200a4841f4b7\"," +
                                         "\"code\":\"" + model.code + "\"," +
                                         "\"name\":\"" + model.name + "\"," +
                                         "\"simple_name\":\"" + model.simple_name + "\"," +
                                         "\"sign\":\"" + sign + "\"," +
                                         "\"skus\":[]" +
                                         "}";
                        string   ret      = gy.DoPost("http://api.guanyierp.com/rest/erp_open", comcode);
                        JsonData jsonData = null;
                        jsonData = JsonMapper.ToObject(ret);
                        string sd = jsonData[0].ToString();
                        if (sd == "True")
                        {
                            sc.Complete();
                            return(Json(new { State = "Success" }, JsonRequestBehavior.AllowGet));
                        }
                        else
                        {
                            return(Json(new { State = "Faile" }, JsonRequestBehavior.AllowGet));
                        }
                    }
                }
                catch (DbEntityValidationException ex)
                {
                    return(Json(new { State = "Faile", Message = ex.EntityValidationErrors.First().ValidationErrors.First().ErrorMessage }, JsonRequestBehavior.AllowGet));
                }
                return(Json(new { State = "Faile" }, JsonRequestBehavior.AllowGet));
            }
        }
Example #2
0
 public JsonResult ViewSingleProductsplitCheckSave(string code)
 {
     using (TransactionScope sc = new TransactionScope())
     {
         T_goodsGY model = db.T_goodsGY.SingleOrDefault(a => a.code == code);
         model.isexamine = "1";
         db.Entry <T_goodsGY>(model).State = System.Data.Entity.EntityState.Modified;
         try
         {
             int i = db.SaveChanges();
             if (i > 0)
             {
                 App_Code.GY gy  = new App_Code.GY();
                 string      cmd = "";
                 cmd = "{" +
                       "\"appkey\":\"171736\"," +
                       "\"method\":\"gy.erp.item.add\"," +
                       "\"sessionkey\":\"f5885504d9c84d1d8146200a4841f4b7\"," +
                       "\"code\":\"" + model.code + "\"," +
                       "\"name\":\"" + model.name + "\"," +
                       "\"simple_name\":\"" + model.simple_name + "\"," +
                       "\"skus\":[]" +
                       "}";
                 string sign    = gy.Sign(cmd);
                 string comcode = "{" +
                                  "\"appkey\":\"171736\"," +
                                  "\"method\":\"gy.erp.item.add\"," +
                                  "\"sessionkey\":\"f5885504d9c84d1d8146200a4841f4b7\"," +
                                  "\"code\":\"" + model.code + "\"," +
                                  "\"name\":\"" + model.name + "\"," +
                                  "\"simple_name\":\"" + model.simple_name + "\"," +
                                  "\"sign\":\"" + sign + "\"," +
                                  "\"skus\":[]" +
                                  "}";
                 string   ret      = gy.DoPost("http://api.guanyierp.com/rest/erp_open", comcode);
                 JsonData jsonData = null;
                 jsonData = JsonMapper.ToObject(ret);
                 string sd = jsonData[0].ToString();
                 if (sd == "True")
                 {
                     sc.Complete();
                     return(Json(new { State = "Success" }, JsonRequestBehavior.AllowGet));
                 }
                 else
                 {
                     return(Json(new { State = "Faile", Message = "审核失败" }, JsonRequestBehavior.AllowGet));
                 }
             }
         }
         catch (DbEntityValidationException ex)
         {
             return(Json(new { State = "Faile", Message = "审核失败" }, JsonRequestBehavior.AllowGet));
         }
         return(Json(new { State = "Faile", Message = "审核失败" }, JsonRequestBehavior.AllowGet));
     }
 }
Example #3
0
        public JsonResult WDTExpressTb()
        {
            int page_no = 0;
            int c       = 0;
            int s       = 0;

            App_Code.GY gy = new App_Code.GY();


            //do
            //{

            dic.Clear();
            //dic.Add("mine", "0");
            dic.Add("sid", "hhs2");
            dic.Add("appkey", "hhs2-ot");
            dic.Add("timestamp", GetTimeStamp());
            //dic.Add("page_no", page_no.ToString());//页号
            var      cmd      = CreateParam(dic, true);
            string   ret      = gy.DoPostnew("http://121.41.177.115/openapi2/logistics.php", cmd, Encoding.UTF8);
            string   ssx      = Regex.Unescape(ret);
            JsonData jsonData = null;

            jsonData = JsonMapper.ToObject(ret);
            string iscode = jsonData["code"].ToString();

            if (iscode != "0")
            {
                return(Json("", JsonRequestBehavior.AllowGet));
            }
            JsonData jsontrades = jsonData["logistics_list"];

            c = jsontrades.Count;



            return(Json(new { State = "Faile" }, JsonRequestBehavior.AllowGet));
        }
        /// <summary>
        /// 获取旺店通
        /// </summary>
        /// <param name="code"></param>
        /// <returns></returns>
        public JsonResult QuyerOrderBYcode(string code)
        {
            Dictionary <string, string> dic = new Dictionary <string, string>();

            if (code == "" || code == null)
            {
                return(Json("", JsonRequestBehavior.AllowGet));
            }
            App_Code.GY gy     = new App_Code.GY();
            string      repeat = "";
            List <T_InterceptLogistics> modelList = db.T_InterceptLogistics.Where(a => a.OrderNumber.Equals(code.Trim()) && a.Del == 0).ToList();

            if (modelList.Count > 0)
            {
                repeat += "物流拦截记录已存在此订单号";
            }
            #region
            ////查询旺店通
            //List<T_Retreat> modelList = db.T_Retreat.Where(a => a.Retreat_OrderNumber.Equals(code.Trim()) && a.Isdelete == "0").ToList();
            //if (modelList.Count > 0)
            //{

            //    repeat += "退货退款记录重复,";
            //}
            ////查是否有返现记录

            //List<T_CashBack> cash = db.T_CashBack.Where(a => a.OrderNum.Equals(code.Trim()) && a.For_Delete == 0 && a.Status != 2).ToList();
            //if (cash.Count > 0)
            //{
            //    repeat += "有返现记录重复,";
            //}
            //List<T_Reissue> Reissue = db.T_Reissue.Where(a => a.OrderCode.Equals(code.Trim()) && a.IsDelete == 0 && a.Status != 2).ToList();
            //if (Reissue.Count > 0)
            //{
            //    repeat += "有补发记录重复,";
            //}
            //List<T_ExchangeCenter> ExchangeCenter = db.T_ExchangeCenter.Where(a => a.OrderCode.Equals(code.Trim()) && a.IsDelete == 0 && a.Status != 2).ToList();
            //if (ExchangeCenter.Count > 0)
            //{
            //    repeat += "有换货记录重复,";
            //}
            //List<T_Intercept> Intercept = db.T_Intercept.Where(a => a.OrderNumber.Equals(code.Trim()) && a.IsDelete == 0 && a.Status != 2).ToList();
            //if (Intercept.Count > 0)
            //{
            //    repeat += "拦截模块有记录,";
            //}
            #endregion

            dic.Clear();
            dic.Add("src_tid", code);
            //dic.Add("trade_no", code);
            dic.Add("sid", "hhs2");
            dic.Add("appkey", "hhs2-ot");
            dic.Add("timestamp", GetTimeStamp());
            string   cmd      = CreateParam(dic, true);
            string   ret      = gy.DoPostnew("http://api.wangdian.cn/openapi2/trade_query.php", cmd, Encoding.UTF8);
            string   ssx      = Regex.Unescape(ret);
            JsonData jsonData = null;
            jsonData = JsonMapper.ToObject(ret);
            string iscode = jsonData["total_count"].ToString();
            if (iscode != "0")
            {
                JsonData jsontrades = jsonData["trades"];

                if (jsontrades.Count != 0)
                {
                    JsonData trades = jsontrades[0];
                    //店铺名称
                    string shop_name = trades["shop_name"].ToString();
                    //仓库编码
                    string warehouse_no = trades["warehouse_no"].ToString();
                    //原始订单编号
                    string src_tids = trades["src_tids"].ToString();
                    //下单时间
                    string trade_time = trades["trade_time"].ToString();
                    //付款时间
                    string pay_time = trades["pay_time"].ToString();
                    //旺旺号
                    string customer_name = trades["buyer_nick"].ToString();
                    //订单状态
                    string trade_status = trades["trade_status"].ToString();

                    //收件人姓名
                    string receiver_name = trades["receiver_name"].ToString();
                    //省
                    string receiver_province = trades["receiver_province"].ToString();
                    //市
                    string receiver_city = trades["receiver_city"].ToString();
                    //区
                    string receiver_district = trades["receiver_district"].ToString();
                    //详细地址
                    string receiver_address = trades["receiver_address"].ToString();
                    //电话号码
                    string receiver_mobile = trades["receiver_mobile"].ToString();
                    //邮政编码
                    string receiver_zip = trades["receiver_zip"].ToString();
                    //省市县
                    string receiver_area = trades["receiver_area"].ToString();
                    //快递公司编号
                    string logistics_code = trades["logistics_code"].ToString();
                    //快递公司名称
                    string logistics_name = trades["logistics_name"].ToString();
                    //快递单号
                    string logistics_no = trades["logistics_no"].ToString();
                    //买家留言
                    string buyer_message = trades["buyer_message"].ToString();
                    //客服备注
                    string cs_remark = trades["cs_remark"].ToString();
                    //实付金额
                    // string paid = trades["paid"].ToString();
                    //商品详情
                    List <T_RetreatDetails> DetailsList = new List <T_RetreatDetails>();
                    double paid = 0.00;
                    for (int c = 0; c < jsontrades.Count; c++)
                    {
                        paid += double.Parse(jsontrades[c]["paid"].ToString());
                        //JsonData goods_list = jsontrades[c]["goods_list"];
                        //for (int i = 0; i < goods_list.Count; i++)
                        //{
                        //    T_RetreatDetails DetailsModel = new T_RetreatDetails();
                        //    string ss = goods_list[i]["goods_no"] == null ? "" : goods_list[i]["goods_no"].ToString();
                        //    DetailsModel.item_code = ss;
                        //    DetailsModel.item_name = goods_list[i]["goods_name"] == null ? "" : goods_list[i]["goods_name"].ToString();
                        //    //   double ssds=double.Parse(goods_list[i]["paid"].ToString()) / double.Parse(goods_list[i]["actual_num"].ToString());

                        //    decimal dec = Convert.ToDecimal(Math.Round(double.Parse(goods_list[i]["share_amount"].ToString()), 2));
                        //    DetailsModel.amount = (double)dec;//分摊邮费


                        //    int qyt = Convert.ToInt32(Convert.ToDecimal(goods_list[i]["actual_num"].ToString()));
                        //    if (qyt != 0)
                        //    {
                        //        DetailsModel.qty = qyt;
                        //        DetailsModel.price = (double)dec / DetailsModel.qty;
                        //    }
                        //    else
                        //    {
                        //        DetailsModel.qty = 0;
                        //        DetailsModel.price = (double)dec;
                        //    }
                        //    if (qyt > 0)
                        //    {
                        //        DetailsList.Add(DetailsModel);
                        //    }

                        //}
                    }
                    T_InterceptLogistics model = new T_InterceptLogistics();
                    model.OrderNumber   = code;
                    model.ExpressName   = logistics_name;
                    model.ExpressNumber = logistics_no;
                    model.OrderMoney    = Convert.ToDecimal(paid);


                    //var json = new
                    //{

                    //    rows = (from r in DetailsList
                    //            select new T_RetreatDetails
                    //            {
                    //                item_code = r.item_code,
                    //                item_name = r.item_name,
                    //                price = r.price,
                    //                amount = r.amount,
                    //                qty = r.qty,
                    //                Simplename = r.Simplename,
                    //            }).ToArray()
                    //};
                    return(Json(new { ModelList = model, Repeat = repeat }, JsonRequestBehavior.AllowGet));
                }
            }
            return(Json("-1", JsonRequestBehavior.AllowGet));
        }
Example #5
0
        public JsonResult ViewSingleProductPartsAddSave(T_goodsGY model)
        {
            string name = Server.UrlDecode(Request.Cookies["Nickname"].Value);

            using (TransactionScope sc = new TransactionScope())
            {
                T_ProductClass      ProductClassmodel      = db.T_ProductClass.SingleOrDefault(a => a.ClassName == model.classify);
                string              ClassCode              = ProductClassmodel.ClassCode;
                T_ProductManufactor ProductManufactormodel = db.T_ProductManufactor.SingleOrDefault(a => a.ManufactorName == model.Manufactor);
                string              ManufactorCode         = ProductManufactormodel.ManufactorCode;
                string              Specifications         = model.Specifications;

                string code = "S" + ClassCode + ManufactorCode + Specifications;

                List <T_goodsGY> goodsList = db.T_goodsGY.Where(a => a.code == code).ToList();
                if (goodsList.Count > 0)
                {
                    return(Json(new { State = "Faile", Message = "该组合方式的配件已存在" }, JsonRequestBehavior.AllowGet));
                }

                model.code = code;

                model.create_date = DateTime.Now;
                model.create_Name = name;
                db.T_goodsGY.Add(model);
                try
                {
                    int i = db.SaveChanges();
                    if (i > 0)
                    {
                        App_Code.GY gy  = new App_Code.GY();
                        string      cmd = "";
                        cmd = "{" +
                              "\"appkey\":\"171736\"," +
                              "\"method\":\"gy.erp.item.add\"," +
                              "\"sessionkey\":\"f5885504d9c84d1d8146200a4841f4b7\"," +
                              "\"code\":\"" + model.code + "\"," +
                              "\"name\":\"" + model.name + "\"," +
                              "\"simple_name\":\"" + model.simple_name + "\"," +
                              "\"skus\":[]" +
                              "}";
                        string sign    = gy.Sign(cmd);
                        string comcode = "{" +
                                         "\"appkey\":\"171736\"," +
                                         "\"method\":\"gy.erp.item.add\"," +
                                         "\"sessionkey\":\"f5885504d9c84d1d8146200a4841f4b7\"," +
                                         "\"code\":\"" + model.code + "\"," +
                                         "\"name\":\"" + model.name + "\"," +
                                         "\"simple_name\":\"" + model.simple_name + "\"," +
                                         "\"sign\":\"" + sign + "\"," +
                                         "\"skus\":[]" +
                                         "}";
                        string   ret      = gy.DoPost("http://api.guanyierp.com/rest/erp_open", comcode);
                        JsonData jsonData = null;
                        jsonData = JsonMapper.ToObject(ret);
                        string sd = jsonData[0].ToString();
                        if (sd == "True")
                        {
                            sc.Complete();
                            return(Json(new { State = "Success" }, JsonRequestBehavior.AllowGet));
                        }
                        else
                        {
                            return(Json(new { State = "Faile", Message = "保存失败" }, JsonRequestBehavior.AllowGet));
                        }
                    }
                }
                catch (DbEntityValidationException ex)
                {
                    return(Json(new { State = "Faile", Message = "保存失败" }, JsonRequestBehavior.AllowGet));
                }
                return(Json(new { State = "Faile", Message = "保存失败" }, JsonRequestBehavior.AllowGet));
            }
        }
Example #6
0
        //根据订单号查询查询数据
        public JsonResult QueryDataByCode(string Ordercode)
        {
            if (!string.IsNullOrWhiteSpace(Ordercode))
            {
                List <T_RespiratorOrder> orders = db.T_RespiratorOrder.Where(a => a.OrderCode == Ordercode.Trim()).ToList();
                if (orders.Count > 0)
                {
                    return(Json(-1));
                }
            }
            if (Ordercode != "" && Ordercode != null)
            {
                App_Code.GY gy  = new App_Code.GY();
                string      cmd = "";
                cmd = "{" +
                      "\"appkey\":\"171736\"," +
                      "\"method\":\"gy.erp.trade.get\"," +
                      "\"page_no\":1," +
                      "\"page_size\":10," +
                      "\"platform_code\":\"" + Ordercode + "\"," +
                      "\"sessionkey\":\"f5885504d9c84d1d8146200a4841f4b7\"" +
                      "}";
                string sign = gy.Sign(cmd);
                cmd = cmd.Replace("}", ",\"sign\":\"" + sign + "\"}");
                string   retnum      = gy.DoPost("http://api.guanyierp.com/rest/erp_open", cmd);
                JsonData jsonDatanum = null;
                jsonDatanum = JsonMapper.ToObject(retnum);
                int successnum = int.Parse(jsonDatanum[7].ToString());
                if (successnum > 0)
                {
                    //赋值

                    JsonData orders = jsonDatanum["orders"][0];
                    //收货人
                    string receiver_name = isNULL(orders["receiver_name"]).ToString();
                    //收货人电话
                    string receiver_phone = isNULL(orders["receiver_phone"]).ToString();
                    //收货人手机
                    string receiver_mobile = isNULL(orders["receiver_mobile"]).ToString();
                    //收货人地址
                    string            receiver_address = isNULL(orders["receiver_address"]).ToString();
                    T_RespiratorOrder model            = new T_RespiratorOrder();
                    model.CustomerName = receiver_name;
                    if (receiver_phone != "")
                    {
                        model.Customerphone = receiver_phone;
                    }
                    else
                    {
                        model.Customerphone = receiver_mobile;
                    }

                    model.Customeraddress = receiver_address;

                    JsonData details = orders["details"];
                    List <T_RespiratorOrderDetails> detalislist = new List <T_RespiratorOrderDetails>();
                    for (int s = 0; s < details.Count; s++)
                    {
                        T_RespiratorOrderDetails detalis = new T_RespiratorOrderDetails();
                        JsonData detailsxiangqing        = details[s];
                        detalis.ProductName = isNULL(detailsxiangqing["item_name"]).ToString();
                        detalis.Company     = isNULL(detailsxiangqing["item_simple_name"]).ToString();
                        detalislist.Add(detalis);
                    }
                    return(Json(new { i = model, d = detalislist }, JsonRequestBehavior.AllowGet));
                    //return View(model);
                }
                else
                {
                    App_Code.GY gynum = new App_Code.GY();

                    string cmdnum = "";
                    cmdnum = "{" +
                             "\"appkey\":\"171736\"," +
                             "\"method\":\"gy.erp.trade.history.get\"," +
                             "\"page_no\":1," +
                             "\"page_size\":10," +
                             "\"platform_code\":\"" + Ordercode + "\"," +
                             "\"sessionkey\":\"f5885504d9c84d1d8146200a4841f4b7\"" +
                             "}";
                    string signnum = gynum.Sign(cmdnum);
                    cmdnum      = cmdnum.Replace("}", ",\"sign\":\"" + signnum + "\"}");
                    retnum      = gy.DoPost("http://api.guanyierp.com/rest/erp_open", cmdnum);
                    jsonDatanum = null;
                    jsonDatanum = JsonMapper.ToObject(retnum);
                    successnum  = int.Parse(jsonDatanum[7].ToString());
                    if (successnum > 0)
                    {
                        //赋值

                        JsonData orders = jsonDatanum["orders"][0];
                        //收货人
                        string receiver_name = isNULL(orders["receiver_name"]).ToString();
                        //收货人电话
                        string receiver_phone = isNULL(orders["receiver_phone"]).ToString();
                        //收货人手机
                        string receiver_mobile = isNULL(orders["receiver_mobile"]).ToString();
                        //收货人地址
                        string            receiver_address = isNULL(orders["receiver_address"]).ToString();
                        T_RespiratorOrder model            = new T_RespiratorOrder();
                        model.CustomerName = receiver_name;
                        if (receiver_phone != "")
                        {
                            model.Customerphone = receiver_phone;
                        }
                        else
                        {
                            model.Customerphone = receiver_mobile;
                        }

                        model.Customeraddress = receiver_address;

                        JsonData details = orders["details"];
                        List <T_RespiratorOrderDetails> detalislist = new List <T_RespiratorOrderDetails>();
                        for (int s = 0; s < details.Count; s++)
                        {
                            T_RespiratorOrderDetails detalis = new T_RespiratorOrderDetails();
                            JsonData detailsxiangqing        = details[s];
                            detalis.ProductName = detailsxiangqing["item_name"].ToString();
                            detalis.Company     = detailsxiangqing["item_simple_name"].ToString();
                            detalis.ProductCode = detailsxiangqing["item_code"].ToString();
                            detalis.Number      = Convert.ToInt32(detailsxiangqing["qty"].ToString());
                            detalislist.Add(detalis);
                        }
                        return(Json(new { i = model, d = detalislist }, JsonRequestBehavior.AllowGet));
                    }
                }
            }
            int i = 0;

            return(Json(i, JsonRequestBehavior.AllowGet));
            //if (!string.IsNullOrWhiteSpace(Ordercode))
            //{
            //    List<T_RespiratorOrder> RespiratorOrder = db.T_RespiratorOrder.Where(a => a.OrderCode == Ordercode.Trim()).ToList();



            //    if (RespiratorOrder.Count > 0)
            //    {
            //        return Json(-1);//已添加该订单
            //    }
            //    else
            //    {
            //        T_OrderList Order = db.T_OrderList.SingleOrDefault(a => a.platform_code == Ordercode);
            //        if (Order != null)
            //        {
            //            string oid=Order.code;
            //            List<T_OrderDetail> detail = db.T_OrderDetail.Where(a => a.oid == oid).ToList();
            //            return Json(new { i = Order,d=detail }, JsonRequestBehavior.AllowGet);
            //        }
            //        else
            //        {
            //            return Json(0, JsonRequestBehavior.AllowGet);
            //        }
            //    }
            //}
            //else
            //{
            //    return Json(0, JsonRequestBehavior.AllowGet);
            //}
        }
Example #7
0
        public JsonResult QuyerRetreatDetailBYcode(string code = "")
        {
            string [] codes = code.Split(',');
            List <T_ElectronicInvoice>        ElectronicModel = new List <T_ElectronicInvoice>();
            List <T_ElectronicInvoiceDetails> DetailsList     = new List <T_ElectronicInvoiceDetails>();

            for (int x = 0; x < codes.Length; x++)
            {
                string      codez  = codes[x];
                App_Code.GY gy     = new App_Code.GY();
                string      cmd    = "";
                string      repeat = "";


                dic.Clear();

                dic.Add("src_tid", codez);
                //dic.Add("trade_no", code);

                dic.Add("sid", "hhs2");
                dic.Add("appkey", "hhs2-ot");
                dic.Add("timestamp", GetTimeStamp());
                cmd = CreateParam(dic, true);

                string   ret      = gy.DoPostnew("http://api.wangdian.cn/openapi2/trade_query.php", cmd, Encoding.UTF8);
                string   ssx      = Regex.Unescape(ret);
                JsonData jsonData = null;
                jsonData = JsonMapper.ToObject(ret);
                string iscode = jsonData["total_count"].ToString();
                if (iscode != "0")
                {
                    JsonData jsontrades = jsonData["trades"];

                    if (jsontrades.Count != 0)
                    {
                        JsonData trades = jsontrades[0];
                        //店铺名称
                        string shop_name = trades["shop_name"].ToString();
                        //仓库编码
                        string warehouse_no = trades["warehouse_no"].ToString();
                        //原始订单编号
                        string src_tids = trades["src_tids"].ToString();
                        //下单时间
                        string trade_time = trades["trade_time"].ToString();
                        //付款时间
                        string pay_time = trades["pay_time"].ToString();
                        //旺旺号
                        string customer_name = trades["buyer_nick"].ToString();
                        //收件人姓名
                        string receiver_name = trades["receiver_name"].ToString();
                        //省
                        string receiver_province = trades["receiver_province"].ToString();
                        //市
                        string receiver_city = trades["receiver_city"].ToString();
                        //区
                        string receiver_district = trades["receiver_district"].ToString();
                        //详细地址
                        string receiver_address = trades["receiver_address"].ToString();
                        //电话号码
                        string receiver_mobile = trades["receiver_mobile"].ToString();
                        //邮政编码
                        string receiver_zip = trades["receiver_zip"].ToString();
                        //省市县
                        string receiver_area = trades["receiver_area"].ToString();
                        //快递公司编号
                        string logistics_code = trades["logistics_code"].ToString();
                        //快递单号
                        string logistics_no = trades["logistics_no"].ToString();
                        //买家留言
                        string buyer_message = trades["buyer_message"].ToString();
                        //客服备注
                        string cs_remark = trades["cs_remark"].ToString();
                        //实付金额
                        string paid = trades["paid"].ToString();
                        //商品详情
                        JsonData goods_list = trades["goods_list"];
                        //查询3次。对应到具体的省市区


                        //查询一次..
                        string shop_Code = "";


                        T_ElectronicInvoice model = new T_ElectronicInvoice();
                        model.OrderNumber      = codez;
                        model.ShopName         = shop_name;
                        model.TheInvoiceAmount = decimal.Parse(paid.ToString());
                        ElectronicModel.Add(model);



                        for (int i = 0; i < goods_list.Count; i++)
                        {
                            T_ElectronicInvoiceDetails DetailsModel = new T_ElectronicInvoiceDetails();


                            DetailsModel.Code     = goods_list[i]["goods_no"] == null ? "" : goods_list[i]["goods_no"].ToString();
                            DetailsModel.Name     = goods_list[i]["goods_name"] == null ? "" : goods_list[i]["goods_name"].ToString();
                            DetailsModel.specname = goods_list[i]["spec_name"] == null ? "" : goods_list[i]["spec_name"].ToString();

                            DetailsModel.UnitPrice = decimal.Parse(goods_list[i]["order_price"].ToString());

                            decimal qyt = decimal.Parse(goods_list[i]["actual_num"].ToString());
                            DetailsModel.qty = int.Parse(Math.Round(qyt).ToString());
                            DetailsList.Add(DetailsModel);
                        }
                    }
                }
            }
            var json = new
            {
                rows = (from r in DetailsList
                        select new T_ElectronicInvoiceDetails
                {
                    Code = r.Code,
                    Name = r.Name,
                    specname = r.specname,
                    UnitPrice = r.UnitPrice,
                    qty = r.qty,
                }).ToArray()
            };

            if (ElectronicModel.Count > 0)
            {
                string  ShopName         = ElectronicModel[0].ShopName;
                decimal TheInvoiceAmount = 0.00m;
                for (int d = 0; d < ElectronicModel.Count; d++)
                {
                    if (ShopName != ElectronicModel[d].ShopName)
                    {
                        return(Json("-1", JsonRequestBehavior.AllowGet));
                    }
                    TheInvoiceAmount += decimal.Parse(ElectronicModel[d].TheInvoiceAmount.ToString());
                }
                T_ElectronicInvoice model = new T_ElectronicInvoice();
                model.OrderNumber      = code;
                model.ShopName         = ShopName;
                model.TheInvoiceAmount = TheInvoiceAmount;
                return(Json(new { ModelList = model, Json = json }, JsonRequestBehavior.AllowGet));
            }
            else
            {
                return(Json("", JsonRequestBehavior.AllowGet));
            }
        }
Example #8
0
        //[Description("新增保存")]
        public JsonResult StockDetailAdd(T_StockStorage Model, string jsonStr, string CurUser)
        {
            using (TransactionScope sc = new TransactionScope())
            {
                try
                {
                    string Nickname = "";
                    if (!string.IsNullOrWhiteSpace(CurUser))
                    {
                        Nickname = CurUser;
                    }
                    else
                    {
                        Nickname = Server.UrlDecode(Request.Cookies["Nickname"].Value);
                    }
                    Model.Type      = "入库";
                    Model.ApplyName = Nickname;
                    Model.ApplyDate = DateTime.Now;
                    db.T_StockStorage.Add(Model);
                    db.SaveChanges();
                    List <T_StockDetail> details = App_Code.Com.Deserialize <T_StockDetail>(jsonStr);


                    foreach (var item in details)
                    {
                        item.Oid = Model.ID;
                        db.T_StockDetail.Add(item);
                        db.SaveChanges();
                        string  code          = item.Code;
                        string  WarehouseCode = Model.WarehouseCode;
                        T_Stock Smodel        = db.T_Stock.SingleOrDefault(a => a.Code == code && a.WarehouseName == WarehouseCode);
                        if (Smodel != null)
                        {
                            Smodel.Qty += item.Qty;
                            db.Entry <T_Stock>(Smodel).State = System.Data.Entity.EntityState.Modified;
                            db.SaveChanges();
                        }
                        else
                        {
                            T_Stock StModel = new T_Stock();
                            StModel.Qty           = item.Qty;
                            StModel.Name          = item.Name;
                            StModel.Code          = item.Code;
                            StModel.WarehouseName = WarehouseCode;
                            db.T_Stock.Add(StModel);
                            db.SaveChanges();
                        }

                        T_StockOutstorage StorageModel = new T_StockOutstorage();
                        StorageModel.Code          = item.Code;
                        StorageModel.Name          = item.Name;
                        StorageModel.WarehouseCode = WarehouseCode;
                        StorageModel.number        = Model.ID.ToString();
                        StorageModel.Qty           = item.Qty;
                        StorageModel.Type          = "入库";
                        db.T_StockOutstorage.Add(StorageModel);
                        db.SaveChanges();
                    }
                    string cpcode = "";
                    for (int z = 0; z < details.Count; z++)
                    {
                        if (z == details.Count - 1)
                        {
                            cpcode += "{\"barcode\":\"" + details[z].Code + "\",\"qty\":" + details[z].Qty + "}";
                        }
                        else
                        {
                            cpcode += "{\"barcode\":\"" + details[z].Code + "\",\"qty\":" + details[z].Qty + "},";
                        }
                    }
                    EBMS.App_Code.GY gy  = new App_Code.GY();
                    string           cmd = "";
                    cmd = "{" +
                          "\"appkey\":\"171736\"," +
                          "\"method\":\"gy.erp.new.purchase.arrive.add\"," +
                          "\"sessionkey\":\"f5885504d9c84d1d8146200a4841f4b7\"," +
                          "\"warehouse_code\":\"" + Model.WarehouseCode + "\"," +
                          "\"supplier_code\":\"" + Model.SupplierName + "\"," +
                          "\"order_type\":\"001\"," +
                          "\"detail_list\":[" + cpcode + "]" +
                          "}";
                    string sign    = gy.Sign(cmd);
                    string comcode = "";
                    comcode = "{" +
                              "\"appkey\":\"171736\"," +
                              "\"method\":\"gy.erp.new.purchase.arrive.add\"," +
                              "\"sessionkey\":\"f5885504d9c84d1d8146200a4841f4b7\"," +
                              "\"sign\":\"" + sign + "\"," +
                              "\"warehouse_code\":\"" + Model.WarehouseCode + "\"," +
                              "\"supplier_code\":\"" + Model.SupplierName + "\"," +
                              "\"order_type\":\"001\"," +
                              "\"detail_list\":[" + cpcode + "]" +
                              "}";
                    string   ret      = gy.DoPost("http://api.guanyierp.com/rest/erp_open", comcode);
                    JsonData jsonData = null;
                    jsonData = JsonMapper.ToObject(ret);

                    if (jsonData.Count == 6)
                    {
                        return(Json(new { State = "Faile", Message = "写入管易失败,请联系管理员" }, JsonRequestBehavior.AllowGet));
                    }
                    else
                    {
                        sc.Complete();
                        return(Json(new { State = "Success" }, JsonRequestBehavior.AllowGet));
                    }
                }
                catch (Exception ex)
                {
                    return(Json(new { State = "Faile", Message = ex.Message }, JsonRequestBehavior.AllowGet));
                }
            }
        }
Example #9
0
        //查询单据编号返回详情 数据来自管易
        public JsonResult getOrderDetail(string num)
        {
            try {
                string result = "";
                if (num != null)
                {
                    App_Code.GY gy  = new App_Code.GY();
                    string      cmd = "";

                    cmd = "{" +
                          "\"appkey\":\"171736\"," +
                          "\"method\":\"gy.erp.trade.deliverys.get\"," +
                          "\"page\":1," +
                          "\"page_size\":3," +
                          "\"code\":\"" + num + "\"," +
                          "\"sessionkey\":\"f5885504d9c84d1d8146200a4841f4b7\"" +
                          "}";

                    string sign = gy.Sign(cmd);
                    cmd = cmd.Replace("}", ",\"sign\":\"" + sign + "\"}");
                    string   ret      = gy.DoPost("http://api.guanyierp.com/rest/erp_open", cmd);
                    JsonData jsonData = null;
                    jsonData = JsonMapper.ToObject(ret);
                    DateTime dateStar = DateTime.Parse("2017-02-10 16:07:50.473");
                    DateTime dateEnd  = DateTime.Parse("2017-02-11 16:07:50.473");
                    if (jsonData["deliverys"].Count == 0)
                    {
                        cmd = "{" +
                              "\"appkey\":\"171736\"," +
                              "\"method\":\"gy.erp.trade.deliverys.history.get\"," +
                              "\"page\":1," +
                              "\"page_size\":3," +
                              "\"code\":\"" + num + "\"," +
                              "\"sessionkey\":\"f5885504d9c84d1d8146200a4841f4b7\"" +
                              "}";
                        sign     = gy.Sign(cmd);
                        cmd      = cmd.Replace("}", ",\"sign\":\"" + sign + "\"}");
                        ret      = gy.DoPost("http://api.guanyierp.com/rest/erp_open", cmd);
                        jsonData = null;
                        jsonData = JsonMapper.ToObject(ret);
                        if (jsonData.Count == 6 || jsonData["deliverys"].Count == 0)
                        {
                            result = "单据编号不存在";
                            return(Json(new { State = "Faile", Message = result }, JsonRequestBehavior.AllowGet));
                        }
                    }
                    JsonData jsonOrders = jsonData["deliverys"][0];
                    //查询管易发货字段 可是不能修改
                    //int state = int.Parse((jsonOrders["delivery_state"]).ToString());

                    //if (state != 0) {
                    //    result = "该订单已经发货";
                    //    return Json(new { State = "Faile", Message = result }, JsonRequestBehavior.AllowGet);
                    //}
                    // 查询发货表 订单是否发货
                    T_Deliver deliverFlag = db.T_Deliver.FirstOrDefault(a => a.MailNo == num);
                    if (deliverFlag != null)
                    {
                        return(Json(new { State = "Faile", Message = "该单据编号已经发货" }, JsonRequestBehavior.AllowGet));
                    }
                    JsonData      details     = jsonOrders["details"];
                    List <AddMod> detalislist = new List <AddMod>();
                    for (int s = 0; s < details.Count; s++)
                    {
                        //返回的数据构造
                        AddMod   detalis    = new AddMod();
                        JsonData detailItem = details[s];
                        string   Code       = isNULL(detailItem["item_code"]).ToString();
                        detalis.item_code = isNULL(detailItem["item_code"]).ToString();
                        detalis.item_name = isNULL(detailItem["item_name"]).ToString();
                        detalis.qty       = int.Parse(detailItem["qty"].ToString());
                        detalis.sku_name  = isNULL(detailItem["sku_name"]).ToString();
                        string Tiaoma = db.T_goodsGY.SingleOrDefault(a => a.code == Code).barcode;
                        detalis.tiaoma = Tiaoma;
                        detalislist.Add(detalis);
                    }
                    string Warehouse = isNULL(jsonOrders["warehouse_name"]).ToString();
                    string OrderNum  = isNULL(jsonOrders["platform_code"]).ToString();

                    result = "{\"rows\":" + JsonConvert.SerializeObject(detalislist) + ",\"Warehouse\":\"" + Warehouse + "\",\"OrderNum\":\"" + OrderNum + "\"}";
                }
                else
                {
                    result = "请输入正确的单据编号";
                    return(Json(new { State = "Faile", Message = result }, JsonRequestBehavior.AllowGet));
                }
                return(Json(new { State = "Success", result = result }, JsonRequestBehavior.AllowGet));
            }
            catch (Exception e)
            {
                return(Json(new { State = "Faile", Message = e.Message }, JsonRequestBehavior.AllowGet));
            }
        }
        //审核
        public JsonResult ManualBillingCheckCheck(T_ManualBilling model, string status, string Memo)
        {
            using (TransactionScope sc = new TransactionScope())
            {
                int             ID           = model.ID;
                T_ManualBilling Invoicemodel = db.T_ManualBilling.SingleOrDefault(a => a.ID == ID && a.Isdelete == 0);
                if (Invoicemodel == null)
                {
                    return(Json("数据可能被删除", JsonRequestBehavior.AllowGet));
                }

                T_ManualBillingAppRove modelApprove = db.T_ManualBillingAppRove.FirstOrDefault(a => a.Oid == ID && a.ApproveTime == null);
                string Nickname = Server.UrlDecode(Request.Cookies["Nickname"].Value);

                string result = "";
                modelApprove.ApproveName = Nickname;
                modelApprove.Memo        = Memo;
                modelApprove.ApproveTime = DateTime.Now;
                modelApprove.Status      = int.Parse(status);
                db.Entry <T_ManualBillingAppRove>(modelApprove).State = System.Data.Entity.EntityState.Modified;
                int i = db.SaveChanges();
                if (i > 0)
                {
                    if (status == "1")
                    {
                        T_ManualBillingAppRove newApprove = new T_ManualBillingAppRove();
                        int step = int.Parse(Invoicemodel.Step.ToString());
                        step++;
                        IQueryable <T_ManualBillingConfig> config = db.T_ManualBillingConfig.AsQueryable();
                        int stepLength = config.Count();//总共步骤
                        if (step < stepLength)
                        {
                            Invoicemodel.Status = 0;
                            T_ManualBillingConfig stepMod = db.T_ManualBillingConfig.SingleOrDefault(a => a.Step == step);
                            string nextName = stepMod.Name;
                            newApprove.Memo   = "";
                            newApprove.Oid    = ID;
                            newApprove.Status = -1;
                            newApprove.Step   = step.ToString();
                            if (nextName != null)
                            {
                                newApprove.ApproveName  = nextName;
                                newApprove.ApproveDName = stepMod.Type;
                            }
                            else
                            {
                                newApprove.ApproveName  = stepMod.Type;
                                newApprove.ApproveDName = stepMod.Type;
                            }
                            db.T_ManualBillingAppRove.Add(newApprove);
                            db.SaveChanges();
                        }
                        else
                        {
                            List <T_ManualBillingDetails> DetailsList = db.T_ManualBillingDetails.Where(a => a.Oid == ID).ToList();
                            string shangp = "";
                            for (int e = 0; e < DetailsList.Count; e++)
                            {
                                if (e == DetailsList.Count - 1)
                                {
                                    shangp += "{\"qty\":" + DetailsList[e].qty + ",\"note\":\"\",\"refund\":0,\"item_code\":\"" + System.Web.HttpContext.Current.Server.UrlEncode(DetailsList[e].Code) + "\"}";
                                }
                                else
                                {
                                    shangp += "{\"qty\":" + DetailsList[e].qty + ",\"note\":\"\",\"refund\":0,\"item_code\":\"" + System.Web.HttpContext.Current.Server.UrlEncode(DetailsList[e].Code) + "\"},";
                                }
                            }
                            decimal PaymentAmount = 0;
                            if (Invoicemodel.PaymentAmount != null)
                            {
                                PaymentAmount = decimal.Parse(Invoicemodel.PaymentAmount.ToString());
                            }

                            //   string payments = "{\"pay_type_code\":wangyin,\"payment\":" + PaymentAmount + "},";
                            string   payments          = "{\"pay_type_code\":\"wangyin\",\"payment\":\"" + PaymentAmount + "\"}";
                            string[] address           = Invoicemodel.GoodsAddress.Split('-');
                            string   receiver_province = "";
                            string   receiver_city     = "";
                            string   receiver_district = "";
                            if (address.Length >= 1)
                            {
                                receiver_province = address[0];
                            }
                            if (address.Length >= 2)
                            {
                                receiver_city = address[1];
                            }
                            if (address.Length >= 3)
                            {
                                receiver_district = address[2];
                            }


                            EBMS.App_Code.GY gy       = new App_Code.GY();
                            string           ShopCode = GetShopFromString(Invoicemodel.ShopName);
                            string           datetime = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss");
                            string           cmd      = "";
                            cmd = "{" +
                                  "\"appkey\":\"171736\"," +
                                  "\"method\":\"gy.erp.trade.add\"," +
                                  "\"sessionkey\":\"f5885504d9c84d1d8146200a4841f4b7\"," +
                                  "\"platform_code\":\"" + Invoicemodel.OrderNumber + "\"," +
                                  "\"order_type_code\":\"Sales\"," +
                                  "\"shop_code\":\"" + ShopCode + "\"," +
                                  "\"post_fee\":\"" + Invoicemodel.ExpressFee + "\"," +

                                  "\"receiver_province\":\"" + receiver_province + "\"," +
                                  "\"receiver_city\":\"" + receiver_city + "\"," +
                                  "\"receiver_district\":\"" + receiver_district + "\"," +
                                  "\"express_code\":\"" + Invoicemodel.ExpressCode + "\"," +
                                  "\"warehouse_code\":\"" + Invoicemodel.DeliverGoodsWarehouse + "\"," +
                                  "\"vip_code\":\"" + Invoicemodel.GoodsReceiptName + "\"," +
                                  "\"vip_name\":\"" + Invoicemodel.GoodsReceiptName + "\"," +
                                  "\"receiver_name\":\"" + Invoicemodel.GoodsReceiptName + "\"," +
                                  "\"receiver_address\":\"" + Invoicemodel.GoodsReceiptAddress + "\"," +
                                  "\"receiver_mobile\":\"" + Invoicemodel.GoodsReceiptPhone + "\"," +
                                  "\"receiver_phone\":\"" + Invoicemodel.GoodsReceiptPhone + "\"," +
                                  "\"deal_datetime\":\"" + datetime + "\"," +
                                  "\"seller_memo\":\"" + Invoicemodel.DeliverGoodsReason + "\"," +
                                  "\"payments\":[" + payments + "]," +
                                  "\"details\":[" + shangp + "]" +
                                  "}";
                            string sign    = gy.Sign(cmd);
                            string comcode = "{" +
                                             "\"appkey\":\"171736\"," +
                                             "\"method\":\"gy.erp.trade.add\"," +
                                             "\"sessionkey\":\"f5885504d9c84d1d8146200a4841f4b7\"," +
                                             "\"platform_code\":\"" + Invoicemodel.OrderNumber + "\"," +
                                             "\"order_type_code\":\"Sales\"," +
                                             "\"shop_code\":\"" + ShopCode + "\"," +
                                             "\"post_fee\":\"" + Invoicemodel.ExpressFee + "\"," +

                                             "\"receiver_province\":\"" + receiver_province + "\"," +
                                             "\"receiver_city\":\"" + receiver_city + "\"," +
                                             "\"receiver_district\":\"" + receiver_district + "\"," +
                                             "\"express_code\":\"" + Invoicemodel.ExpressCode + "\"," +
                                             "\"warehouse_code\":\"" + Invoicemodel.DeliverGoodsWarehouse + "\"," +
                                             "\"vip_code\":\"" + Invoicemodel.GoodsReceiptName + "\"," +
                                             "\"vip_name\":\"" + Invoicemodel.GoodsReceiptName + "\"," +
                                             "\"receiver_name\":\"" + Invoicemodel.GoodsReceiptName + "\"," +
                                             "\"receiver_address\":\"" + Invoicemodel.GoodsReceiptAddress + "\"," +
                                             "\"receiver_mobile\":\"" + Invoicemodel.GoodsReceiptPhone + "\"," +
                                             "\"receiver_phone\":\"" + Invoicemodel.GoodsReceiptPhone + "\"," +
                                             "\"deal_datetime\":\"" + datetime + "\"," +
                                             "\"seller_memo\":\"" + Invoicemodel.DeliverGoodsReason + "\"," +
                                             "\"sign\":\"" + sign + "\"," +
                                             "\"payments\":[" + payments + "]," +
                                             "\"details\":[" + shangp + "]" +
                                             "}";
                            string   ret      = gy.DoPost("http://api.guanyierp.com/rest/erp_open", comcode);
                            JsonData jsonData = null;
                            jsonData = JsonMapper.ToObject(ret);
                            string sd = jsonData[0].ToString();
                            if (jsonData.Count == 6)
                            {
                                // return Json(new { State = "Faile" }, JsonRequestBehavior.AllowGet);
                                result = "管理调整单失败,请核对信息";
                                return(Json(result, JsonRequestBehavior.AllowGet));
                            }
                            Invoicemodel.Status = int.Parse(status);
                        }
                        Invoicemodel.Step = step;
                        db.Entry <T_ManualBilling>(Invoicemodel).State = System.Data.Entity.EntityState.Modified;
                        int j = db.SaveChanges();
                        sc.Complete();
                        if (j > 0)
                        {
                            result = "保存成功";
                        }
                        else
                        {
                            result = "保存失败";
                        }
                    }
                    else
                    {
                        //不同意
                        Invoicemodel.Step   = 0;
                        Invoicemodel.Status = 2;
                        db.Entry <T_ManualBilling>(Invoicemodel).State = System.Data.Entity.EntityState.Modified;
                        int j = db.SaveChanges();
                        //审核流程结束 申请人编辑后插入下一条记录
                        sc.Complete();
                        if (j > 0)
                        {
                            result = "保存成功";
                        }
                        else
                        {
                            result = "保存失败";
                        }
                    }
                }
                else
                {
                    result = "保存失败";
                }


                return(Json(result, JsonRequestBehavior.AllowGet));
            }
        }
Example #11
0
        //单个产品同步
        public JsonResult WDTGoodsTbS(string query)
        {
            if (query == "" || query == null)
            {
                return(Json(new { State = "Faile" }, JsonRequestBehavior.AllowGet));
            }
            App_Code.GY gy       = new App_Code.GY();
            JsonData    jsonData = null;

            //string ret = gy.httpGetStr("http://192.168.8.89:3980/material/GetMaterialData?code=" + query.Trim());
            try
            {
                string ret = gy.httpGetStr("http://222.240.26.98:3980/material/GetMaterialData?code=" + query.Trim());
                string ssx = Regex.Unescape(ret);

                jsonData = JsonMapper.ToObject(ret);
            }
            catch (WebException ex)
            {
                return(Json(new { State = "Faile", Message = ex.Message }, JsonRequestBehavior.AllowGet));
            }
            catch (Exception ex)
            {
                return(Json(new { State = "Faile", Message = ex.Message }, JsonRequestBehavior.AllowGet));
            }


            //if (jsonData[0][0]==null)
            //{
            //    return Json(new { State = "Faile" }, JsonRequestBehavior.AllowGet);

            //}
            if (jsonData != null && jsonData.Count > 0)
            {
                for (int i = 0; i < jsonData.Count; i++)
                {
                    string SPEC = "";
                    if (jsonData[i]["SPEC"] != null)
                    {
                        SPEC = jsonData[i]["SPEC"].ToString();
                    }

                    string NAME    = jsonData[i]["NAME"].ToString();
                    string UNIT    = jsonData[i]["UNIT"].ToString();
                    string BARCODE = "";
                    if (jsonData[i]["BARCODE"] != null)
                    {
                        BARCODE = jsonData[i]["BARCODE"].ToString();
                    }
                    string     code = jsonData[i]["CODE"].ToString();;
                    T_WDTGoods list = db.T_WDTGoods.FirstOrDefault(s => s.goods_no == code);
                    if (list == null)
                    {
                        T_WDTGoods WDTGoods = new T_WDTGoods();
                        WDTGoods.goods_no        = code;
                        WDTGoods.goods_name      = NAME;
                        WDTGoods.short_name      = NAME;
                        WDTGoods.goods_type      = 1;
                        WDTGoods.unit_name       = UNIT;
                        WDTGoods.spec_count      = 1;
                        WDTGoods.spec_code       = code;
                        WDTGoods.spec_no         = code;
                        WDTGoods.barcode         = BARCODE;
                        WDTGoods.spec_name       = SPEC;
                        WDTGoods.lowest_price    = 0;
                        WDTGoods.wholesale_price = 0;
                        WDTGoods.retail_price    = 0;
                        db.T_WDTGoods.Add(WDTGoods);
                        db.SaveChanges();
                    }
                    else
                    {
                        list.unit_name = UNIT;
                        list.spec_name = SPEC;
                        db.Entry <T_WDTGoods>(list).State = System.Data.Entity.EntityState.Modified;
                        db.SaveChanges();
                    }
                }

                return(Json(new { State = "Success" }, JsonRequestBehavior.AllowGet));
            }
            else
            {
                return(Json(new { State = "Faile", Message = "NC不存在" + query }, JsonRequestBehavior.AllowGet));
            }
        }
Example #12
0
        public JsonResult ShopTb()
        {
            int page_no = 0;
            int c       = 0;
            int s       = 0;

            App_Code.GY gy = new App_Code.GY();
            //List<T_WDTshop> delMod = db.T_WDTshop.AsQueryable().ToList();
            //foreach (var item in delMod)
            //{
            //    db.T_WDTshop.Remove(item);
            //}
            //db.SaveChanges();
            do
            {
                dic.Clear();
                dic.Add("mine", "0");
                dic.Add("sid", "hhs2");
                dic.Add("appkey", "hhs2-ot");
                dic.Add("timestamp", GetTimeStamp());
                dic.Add("page_no", page_no.ToString());//页号
                var      cmd      = CreateParam(dic, true);
                string   ret      = gy.DoPostnew("http://api.wangdian.cn/openapi2/shop.php", cmd, Encoding.UTF8);
                string   ssx      = Regex.Unescape(ret);
                JsonData jsonData = null;
                jsonData = JsonMapper.ToObject(ret);
                string iscode = jsonData["code"].ToString();
                if (iscode != "0")
                {
                    return(Json("", JsonRequestBehavior.AllowGet));
                }
                JsonData jsontrades = jsonData["shoplist"];
                c = jsontrades.Count;


                for (int i = 0; i < jsontrades.Count; i++)
                {
                    string    shopno = jsontrades[i]["shop_no"].ToString();
                    T_WDTshop model  = db.T_WDTshop.FirstOrDefault(a => a.shop_no == shopno);
                    if (model == null)
                    {
                        T_WDTshop WDTshop = new T_WDTshop();
                        WDTshop.platform_id     = jsontrades[i]["platform_id"].ToString();
                        WDTshop.sub_platform_id = jsontrades[i]["sub_platform_id"].ToString();
                        WDTshop.shop_id         = jsontrades[i]["shop_id"].ToString();
                        WDTshop.shop_no         = jsontrades[i]["shop_no"].ToString();
                        WDTshop.shop_name       = jsontrades[i]["shop_name"].ToString();
                        WDTshop.account_id      = jsontrades[i]["account_id"].ToString();
                        WDTshop.account_nick    = jsontrades[i]["account_nick"].ToString();
                        WDTshop.province        = jsontrades[i]["province"].ToString();
                        WDTshop.city            = jsontrades[i]["city"].ToString();
                        WDTshop.district        = jsontrades[i]["district"].ToString();
                        WDTshop.address         = jsontrades[i]["address"].ToString();
                        WDTshop.contact         = jsontrades[i]["contact"].ToString();
                        WDTshop.zip             = jsontrades[i]["zip"].ToString();
                        WDTshop.mobile          = jsontrades[i]["mobile"].ToString();
                        WDTshop.telno           = jsontrades[i]["telno"].ToString();
                        db.T_WDTshop.Add(WDTshop);
                        s += db.SaveChanges();
                    }
                }
                page_no++;
            } while (c != 0);
            if (s > 0)
            {
                return(Json(new { State = "Success" }, JsonRequestBehavior.AllowGet));
            }
            return(Json(new { State = "Faile" }, JsonRequestBehavior.AllowGet));
        }