Exemplo n.º 1
0
        public string GetOrderByShopBYcode(string platform_code)
        {
            GY     gy  = new GY();
            string cmd = "{" +
                         "\"appkey\":\"171736\"," +
                         "\"method\":\"gy.erp.trade.get\"," +
                         "\"page_no\":1," +
                         "\"page_size\":10," +
                         "\"platform_code\":\"" + platform_code + "\"," +
                         "\"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);
            Thread.Sleep(1600);
            if (jsonData.Count == 6 || jsonData["orders"].Count == 0)
            {
                cmd = "{" +
                      "\"appkey\":\"171736\"," +
                      "\"method\":\"gy.erp.trade.history.get\"," +
                      "\"page_no\":1," +
                      "\"page_size\":10," +
                      "\"platform_code\":\"" + platform_code + "\"," +
                      "\"sessionkey\":\"f5885504d9c84d1d8146200a4841f4b7\"" +
                      "}";
                sign = gy.Sign(cmd);
                cmd  = cmd.Replace("}", ",\"sign\":\"" + sign + "\"}");
                ret  = gy.DoPost("http://api.guanyierp.com/rest/erp_open", cmd);
            }
            return(ret);
        }
Exemplo n.º 2
0
        public JsonResult ViewReceiptAddSave(T_Receipt model, string jsonStr)
        {
            using (TransactionScope sc = new TransactionScope())
            {
                try
                {
                    GY     gy  = new GY();
                    string cmd = "";

                    cmd = "{" +
                          "\"appkey\":\"171736\"," +
                          "\"method\":\"gy.erp.trade.get\"," +
                          "\"page_no\":1," +
                          "\"page_size\":10," +
                          "\"platform_code\":\"" + model.OrderCode + "\"," +
                          "\"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);

                    if (jsonData.Count == 6 || jsonData["orders"].Count == 0)
                    {
                        cmd = "{" +
                              "\"appkey\":\"171736\"," +
                              "\"method\":\"gy.erp.trade.history.get\"," +
                              "\"page_no\":1," +
                              "\"page_size\":10," +
                              "\"platform_code\":\"" + model.OrderCode + "\"," +
                              "\"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["orders"].Count == 0)
                        {
                            return(Json(new { State = "Faile", Message = "订单号不存在" }));
                        }
                    }
                    JsonData jsonOrders             = jsonData["orders"][0];
                    List <T_ReceiptDetails> details = Com.Deserialize <T_ReceiptDetails>(jsonStr);
                    //T_OrderList order = db.T_OrderList.Find(model.OrderId);
                    string           code = "SKSJ";
                    string           date = DateTime.Now.ToString("yyyyMMdd");
                    List <T_Receipt> list = db.T_Receipt.Where(s => s.Code.Contains(date)).OrderByDescending(s => s.ID).ToList();
                    if (list.Count == 0)
                    {
                        code += date + "0001";
                    }
                    else
                    {
                        string old     = list[0].Code.Substring(12);
                        int    newCode = int.Parse(old) + 1;
                        code += date + newCode.ToString().PadLeft(4, '0');
                    }
                    model.Code       = code;
                    model.Date       = DateTime.Now;
                    model.IsDelete   = 0;
                    model.ShopDate   = DateTime.Parse(jsonOrders["createtime"].ToString());
                    model.PostUser   = UserModel.Nickname;
                    model.PrintCount = 0;
                    db.T_Receipt.Add(model);
                    db.SaveChanges();
                    if (details != null)
                    {
                        foreach (var item in details)
                        {
                            item.ReceiptOrderID = model.ID;
                            db.T_ReceiptDetails.Add(item);
                        }
                        db.SaveChanges();
                    }
                    sc.Complete();
                    return(Json(new { State = "Success" }, JsonRequestBehavior.AllowGet));
                }
                catch (Exception ex)
                {
                    return(Json(new { State = "Faile", Message = ex.Message }, JsonRequestBehavior.AllowGet));
                }
            }
        }
Exemplo n.º 3
0
        public JsonResult Approve(int id)
        {
            T_ManualOrder order = new T_ManualOrder();

            order = db.T_ManualOrder.Find(id);
            if (order != null)
            {
                try
                {
                    using (TransactionScope sc = new TransactionScope())
                    {
                        order.orderstatus = 1;
                        db.SaveChanges();
                        //详情
                        IQueryable <T_ManualorderDetail> details = null;
                        details = db.T_ManualorderDetail.Where(a => a.OrderCode.Equals(order.platform_code));
                        //构造商品明细
                        string detail = "";
                        foreach (var item in details)
                        {
                            detail += "{\"qty\":" + item.qty + ",\"price\":\"" + item.price + "\",\"note\":\"\",\"refund\":0,\"item_code\":\"" + System.Web.HttpContext.Current.Server.UrlEncode(item.item_code) + "\"}";
                        }
                        //构造付款信息  必须要付款信息 否则全让利了 应收成0
                        string payment = "";
                        //discount_fee 让利直接给出 无效 此字段改成实收金额
                        payment += "{\"pay_type_code\":\"wangyin\",\"payment\":\"" + order.payment + "\"}";
                        GY     gy  = new GY();
                        string cmd = "";
                        cmd = "{" +
                              "\"appkey\":\"171736\"," +
                              "\"method\":\"gy.erp.trade.add\"," +
                              "\"sessionkey\":\"f5885504d9c84d1d8146200a4841f4b7\"," +
                              "\"order_type_code\":\"" + order.order_type_code + "\"," +
                              "\"platform_code\":\"" + order.platform_code + "\"," +
                              "\"shop_code\":\"" + order.shop_code + "\"," +
                              "\"express_code\":\"" + order.express_code + "\"," +
                              "\"receiver_province\":\"" + order.receiver_province + "\"," +
                              "\"receiver_city\":\"" + order.receiver_city + "\"," +
                              "\"receiver_district\":\"" + order.receiver_district + "\"," +
                              "\"warehouse_code\":\"" + order.warehouse_code + "\"," +
                              "\"vip_code\":\"" + order.vip_code + "\"," +
                              "\"vip_name\":\"" + order.vip_name + "\"," +
                              "\"receiver_name\":\"" + order.receiver_name + "\"," +
                              "\"receiver_address\":\"" + order.receiver_address + "\"," +
                              "\"receiver_mobile\":\"" + order.receiver_mobile + "\"," +
                              "\"receiver_phone\":\"" + order.receiver_phone + "\"," +
                              "\"deal_datetime\":\"" + order.deal_datetime.ToString() + "\"," +
                              "\"pay_datetime\":\"" + order.deal_datetime.ToString() + "\"," +
                              "\"buyer_memo\":\"" + order.buyer_memo + "\"," +
                              "\"seller_memo\":\"" + order.seller_memo + "\"," +
                              "\"business_man_code\":\"" + order.business_man_code + "\"," +
                              "\"payments\":[" + payment + "]," +           //payment 支付金额 设置了也无效 应该是根据明细里面的单价 自动算出来的
                              "\"details\":[" + detail + "]" +
                              "}";
                        string sign    = gy.Sign(cmd);
                        string comcode = "{" +
                                         "\"appkey\":\"171736\"," +
                                         "\"method\":\"gy.erp.trade.add\"," +
                                         "\"sessionkey\":\"f5885504d9c84d1d8146200a4841f4b7\"," +
                                         "\"order_type_code\":\"" + order.order_type_code + "\"," +
                                         "\"platform_code\":\"" + order.platform_code + "\"," +
                                         "\"shop_code\":\"" + order.shop_code + "\"," +
                                         "\"express_code\":\"" + order.express_code + "\"," +
                                         "\"receiver_province\":\"" + order.receiver_province + "\"," +
                                         "\"receiver_city\":\"" + order.receiver_city + "\"," +
                                         "\"receiver_district\":\"" + order.receiver_district + "\"," +
                                         "\"warehouse_code\":\"" + order.warehouse_code + "\"," +
                                         "\"vip_code\":\"" + order.vip_code + "\"," +
                                         "\"vip_name\":\"" + order.vip_name + "\"," +
                                         "\"receiver_name\":\"" + order.receiver_name + "\"," +
                                         "\"receiver_address\":\"" + order.receiver_address + "\"," +
                                         "\"receiver_mobile\":\"" + order.receiver_mobile + "\"," +
                                         "\"receiver_phone\":\"" + order.receiver_phone + "\"," +
                                         "\"deal_datetime\":\"" + order.deal_datetime.ToString() + "\"," +
                                         "\"pay_datetime\":\"" + order.deal_datetime.ToString() + "\"," +
                                         "\"sign\":\"" + sign + "\"," +
                                         "\"buyer_memo\":\"" + order.buyer_memo + "\"," +
                                         "\"seller_memo\":\"" + order.seller_memo + "\"," +
                                         "\"business_man_code\":\"" + order.business_man_code + "\"," +
                                         "\"payments\":[" + payment + "]," +
                                         "\"details\":[" + detail + "]" +
                                         "}";
                        string   ret      = gy.DoPost("http://api.guanyierp.com/rest/erp_open", comcode);
                        JsonData jsonData = null;
                        jsonData = JsonMapper.ToObject(ret);
                        string result = jsonData[0].ToString();
                        if (result == "True")
                        {
                            sc.Complete();
                            return(Json(new { State = "Success" }, JsonRequestBehavior.AllowGet));
                        }
                        else
                        {
                            return(Json(new { State = "Faile", Message = "数据有误,请联系管理员" }, JsonRequestBehavior.AllowGet));
                        }
                    }
                }
                catch (Exception ex)
                {
                    return(Json(new { State = "Faile", Message = ex.Message }, JsonRequestBehavior.AllowGet));
                }
            }
            else
            {
                return(Json(new { State = "Faile", Message = "数据出错,请联系技术人员" }, JsonRequestBehavior.AllowGet));
            }
        }
Exemplo n.º 4
0
        /// <summary>
        /// 查询管易订单
        /// </summary>
        /// <param name="code"></param>
        /// <returns></returns>
        public JsonResult GetReceiptByGy(string code)
        {
            GY     gy  = new GY();
            string cmd = "";

            cmd = "{" +
                  "\"appkey\":\"171736\"," +
                  "\"method\":\"gy.erp.trade.get\"," +
                  "\"page_no\":1," +
                  "\"page_size\":10," +
                  "\"platform_code\":\"" + code + "\"," +
                  "\"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);

            if (jsonData.Count == 6 || jsonData["orders"].Count == 0)
            {
                cmd = "{" +
                      "\"appkey\":\"171736\"," +
                      "\"method\":\"gy.erp.trade.history.get\"," +
                      "\"page_no\":1," +
                      "\"page_size\":10," +
                      "\"platform_code\":\"" + code + "\"," +
                      "\"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["orders"].Count == 0)
                {
                    return(Json(new { State = "Faile", Message = "订单号不存在" }));
                }
            }
            JsonData jsonOrders = jsonData["orders"][0];
            //订单信息
            string platform_code = isNULL(jsonOrders["platform_code"]).ToString();
            //店铺名称
            string shop_name = isNULL(jsonOrders["shop_name"]).ToString();
            //旺旺帐号
            string    vip_name      = isNULL(jsonOrders["vip_name"]).ToString();
            string    receiver_name = isNULL(jsonOrders["receiver_name"]).ToString();
            string    payment       = isNULL(jsonOrders["payment"]).ToString();
            T_Receipt model         = new T_Receipt();

            model.OrderCode  = code;
            model.Receivings = receiver_name;
            model.Money      = decimal.Parse(payment);
            model.Vip_Name   = receiver_name;
            model.StorName   = shop_name;
            List <T_ReceiptDetails> DetailsList = new List <T_ReceiptDetails>();

            JsonData jsonDetails = jsonOrders["details"];

            for (int i = 0; i < jsonDetails.Count; i++)
            {
                T_ReceiptDetails DetailsModel = new T_ReceiptDetails();
                DetailsModel.ProductName = jsonDetails[i]["item_name"] == null ? "" : jsonDetails[i]["item_name"].ToString();
                DetailsModel.Unit        = jsonDetails[i]["item_simple_name"] == null ? "" : jsonDetails[i]["item_simple_name"].ToString();
                DetailsModel.Qty         = jsonDetails[i]["qty"] == null ? 0 : int.Parse(jsonDetails[i]["qty"].ToString());
                DetailsList.Add(DetailsModel);
            }
            var json = new
            {
                rows = (from r in DetailsList
                        select new T_ReceiptDetails
                {
                    ProductName = r.ProductName,
                    Unit = r.Unit,
                    Qty = r.Qty
                }).ToArray()
            };

            return(Json(new { State = "Success", ModelList = model, Json = json }, JsonRequestBehavior.AllowGet));
        }
Exemplo n.º 5
0
        public JsonResult Check(string UserName, int approveID, int status, string memo)
        {
            using (TransactionScope sc = new TransactionScope())
            {
                try
                {
                    int TotalStep            = db.T_ReissueConfig.ToList().Count;
                    T_ReissueApprove approve = db.T_ReissueApprove.Find(approveID);
                    string           name    = approve.ApproveName;
                    T_Reissue        model   = db.T_Reissue.Find(approve.Pid);
                    approve.ApproveName   = UserName;
                    approve.ApproveStatus = status;
                    approve.ApproveTime   = DateTime.Now;
                    approve.Memo          = memo;
                    model.Status          = status;
                    db.SaveChanges();
                    if (status == 2)//不同意
                    {
                        model.Step = model.Step + 1;
                        db.SaveChanges();
                    }
                    else//同意
                    {
                        int type     = db.T_ReissueReson.SingleOrDefault(s => s.Reson.Equals(model.ReissueReson)).Type;
                        int LastStep = db.T_ReissueConfig.OrderByDescending(s => s.Step).FirstOrDefault(s => s.Reson == type).Step;
                        if (LastStep > model.Step)//判断是否存在下一级
                        {
                            //获得下一级审核部门
                            string           nextapproveType = db.T_ReissueConfig.OrderBy(s => s.Step).FirstOrDefault(s => s.Reson == type && s.Step > model.Step).ApproveType;
                            T_ReissueApprove newApprove      = new T_ReissueApprove();
                            newApprove.ApproveStatus = -1;
                            newApprove.ApproveName   = nextapproveType;
                            newApprove.ApproveTime   = null;
                            newApprove.Pid           = approve.Pid;
                            db.T_ReissueApprove.Add(newApprove);
                            db.SaveChanges();
                            model.Status = 0;
                            model.Step   = model.Step + 1;
                            db.SaveChanges();
                        }
                        if (name.Equals("售后主管") || name.Equals("呼吸机主管"))//售后主管审核后直接加入补发货
                        {
                            //T_OrderList order = db.T_OrderList.Find(model.OrderId);

                            //List<T_Reissue> reissue = db.T_Reissue.Where(s => s.OrderCode.Equals(model.OrderCode) && s.IsDelete == 0).ToList();
                            ////判断是否为第一次补发
                            //if (reissue.Count() == 1)
                            //{
                            //    order.ReissueStatus = 2;
                            //}
                            //List<T_ReissueDetail> reiDetails = db.T_ReissueDetail.Where(s => s.ReissueId == model.ID).ToList();
                            //foreach (var item in reiDetails)
                            //{
                            //    T_OrderDetail Orderdetail = db.T_OrderDetail.FirstOrDefault(s => s.oid.Equals(order.code) && s.item_code.Equals(item.ProductCode));
                            //    if (Orderdetail != null)
                            //    {
                            //        Orderdetail.ReissueStatus = 1;
                            //        Orderdetail.ReissueQty += item.Num;
                            //    }
                            //}
                            db.SaveChanges();
                            #region 加入快递赔付

                            if (model.ReissueReson.Equals("快递破损"))
                            {
                                GY     gy  = new GY();
                                string cmd = "";

                                cmd = "{" +
                                      "\"appkey\":\"171736\"," +
                                      "\"method\":\"gy.erp.trade.get\"," +
                                      "\"page_no\":1," +
                                      "\"page_size\":10," +
                                      "\"platform_code\":\"" + model.OrderCode + "\"," +
                                      "\"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);

                                if (jsonData.Count == 6 || jsonData["orders"].Count == 0)
                                {
                                    cmd = "{" +
                                          "\"appkey\":\"171736\"," +
                                          "\"method\":\"gy.erp.trade.history.get\"," +
                                          "\"page_no\":1," +
                                          "\"page_size\":10," +
                                          "\"platform_code\":\"" + model.OrderCode + "\"," +
                                          "\"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["orders"].Count == 0)
                                    {
                                        return(Json(new { State = "Faile", Message = "订单号不存在" }));
                                    }
                                }
                                JsonData jsonOrders = jsonData["orders"][0];
                                var      deliver    = jsonOrders["deliverys"][0];
                                //快递单号
                                string mail_no = isNULL(deliver["mail_no"]).ToString();
                                //订单金额
                                string amount = isNULL(jsonOrders["amount"]).ToString();
                                //快递名称
                                string             express_name = isNULL(jsonOrders["express_name"]).ToString();
                                T_ExpressIndemnity Inde         = new T_ExpressIndemnity
                                {
                                    PostUserName       = model.PostUser,
                                    Date               = DateTime.Now,
                                    OrderNum           = model.OrderCode,
                                    wangwang           = model.VipCode,
                                    ShopName           = model.StoreName,
                                    RetreatExpressNum  = mail_no,
                                    State              = "0",
                                    OrderMoney         = Convert.ToDouble(amount),
                                    Type               = "破损",
                                    Second             = "0",
                                    CurrentApproveName = "快递组",
                                    IsDelete           = 0,
                                    ExpressName        = express_name,
                                    IndemnityMoney     = 0
                                };
                                db.T_ExpressIndemnity.Add(Inde);
                                db.SaveChanges();
                                List <T_ReissuePic> picList = db.T_ReissuePic.Where(s => s.ReissueId == model.ID).ToList();
                                foreach (var item in picList)
                                {
                                    T_ExpressIndemnityPic expressPic = new T_ExpressIndemnityPic
                                    {
                                        EID    = Inde.ID,
                                        PicURL = item.Url
                                    };
                                    db.T_ExpressIndemnityPic.Add(expressPic);
                                }
                                db.SaveChanges();
                            }
                            else if (model.ReissueReson.Equals("丢件"))
                            {
                                GY     gy  = new GY();
                                string cmd = "";

                                cmd = "{" +
                                      "\"appkey\":\"171736\"," +
                                      "\"method\":\"gy.erp.trade.get\"," +
                                      "\"page_no\":1," +
                                      "\"page_size\":10," +
                                      "\"platform_code\":\"" + model.OrderCode + "\"," +
                                      "\"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);

                                if (jsonData.Count == 6 || jsonData["orders"].Count == 0)
                                {
                                    cmd = "{" +
                                          "\"appkey\":\"171736\"," +
                                          "\"method\":\"gy.erp.trade.history.get\"," +
                                          "\"page_no\":1," +
                                          "\"page_size\":10," +
                                          "\"platform_code\":\"" + model.OrderCode + "\"," +
                                          "\"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["orders"].Count == 0)
                                    {
                                        return(Json(new { State = "Faile", Message = "订单号不存在" }));
                                    }
                                }
                                JsonData jsonOrders = jsonData["orders"][0];
                                var      deliver    = jsonOrders["deliverys"][0];
                                //快递单号
                                string mail_no = isNULL(deliver["mail_no"]).ToString();
                                //订单金额
                                string amount = isNULL(jsonOrders["amount"]).ToString();
                                //快递名称
                                string             express_name = isNULL(jsonOrders["express_name"]).ToString();
                                T_ExpressIndemnity Inde         = new T_ExpressIndemnity
                                {
                                    PostUserName       = model.PostUser,
                                    Date               = DateTime.Now,
                                    OrderNum           = model.OrderCode,
                                    wangwang           = model.VipCode,
                                    ShopName           = model.StoreName,
                                    RetreatExpressNum  = mail_no,
                                    State              = "0",
                                    OrderMoney         = Convert.ToDouble(amount),
                                    Type               = "丢件",
                                    Second             = "0",
                                    CurrentApproveName = "快递组",
                                    IsDelete           = 0,
                                    ExpressName        = express_name,
                                    IndemnityMoney     = 0
                                };
                                db.T_ExpressIndemnity.Add(Inde);
                                db.SaveChanges();
                            }

                            #endregion

                            if (PostGy(model) != "True")
                            {
                                return(Json(new { State = "Faile", Message = "上传管易错误,请联系管理员" }, JsonRequestBehavior.AllowGet));
                            }
                        }
                    }

                    db.SaveChanges();
                    List <T_ModularNotaudited> ModularNotaudited = db.T_ModularNotaudited.Where(a => a.ModularName == "补发货未审核").ToList();
                    if (ModularNotaudited.Count > 0)
                    {
                        foreach (var item in ModularNotaudited)
                        {
                            db.T_ModularNotaudited.Remove(item);
                        }
                        db.SaveChanges();
                    }
                    string         RetreatAppRoveSql   = "select isnull(ApproveUser,ApproveName) as PendingAuditName,COUNT(*) as NotauditedNumber from T_ReissueApprove where  Pid in ( select ID from T_Reissue where IsDelete=0 ) and  ApproveStatus=-1 and ApproveTime is null GROUP BY ApproveName,ApproveUser  ";
                    List <Modular> RetreatAppRoveQuery = db.Database.SqlQuery <Modular>(RetreatAppRoveSql).ToList();
                    string         Nickname            = Server.UrlDecode(Request.Cookies["Nickname"].Value);
                    for (int e = 0; e < RetreatAppRoveQuery.Count; e++)
                    {
                        string PendingAuditName = RetreatAppRoveQuery[e].PendingAuditName;

                        T_ModularNotaudited NotauditedModel = db.T_ModularNotaudited.SingleOrDefault(a => a.ModularName == "补发货未审核" && a.PendingAuditName == PendingAuditName);
                        if (NotauditedModel != null)
                        {
                            NotauditedModel.NotauditedNumber = RetreatAppRoveQuery[e].NotauditedNumber;
                            db.Entry <T_ModularNotaudited>(NotauditedModel).State = System.Data.EntityState.Modified;
                        }
                        else
                        {
                            T_ModularNotaudited ModularNotauditedModel = new T_ModularNotaudited();
                            ModularNotauditedModel.ModularName      = "补发货未审核";
                            ModularNotauditedModel.NotauditedNumber = RetreatAppRoveQuery[e].NotauditedNumber;
                            ModularNotauditedModel.PendingAuditName = RetreatAppRoveQuery[e].PendingAuditName;
                            ModularNotauditedModel.ToupdateDate     = DateTime.Now; ModularNotauditedModel.ToupdateName = Nickname;
                            db.T_ModularNotaudited.Add(ModularNotauditedModel);
                        }
                        db.SaveChanges();
                    }
                    sc.Complete();
                    return(Json(new { State = "Success" }, JsonRequestBehavior.AllowGet));
                }
                catch (Exception ex)
                {
                    return(Json(new { State = "Faile", Message = ex.Message }, JsonRequestBehavior.AllowGet));
                }
            }
        }
Exemplo n.º 6
0
        /// <summary>
        /// 提交管易
        /// </summary>
        /// <returns></returns>
        public string PostGy(T_Reissue model)
        {
            string shangp = "";
            List <T_ReissueDetail> commodel = db.T_ReissueDetail.Where(a => a.ReissueId == model.ID).ToList();

            for (int i = 0; i < commodel.Count; i++)
            {
                if (i == commodel.Count - 1)
                {
                    shangp += "{\"qty\":" + commodel[i].Num + ",\"price\":0,\"note\":\"\",\"refund\":0,\"item_code\":\"" + commodel[i].ProductCode + "\"}";
                }
                else
                {
                    shangp += "{\"qty\":" + commodel[i].Num + ",\"price\":0,\"note\":\"\",\"refund\":0,\"item_code\":\"" + commodel[i].ProductCode + "\"},";
                }
            }


            string datetime      = DateTime.Parse(model.SingleTime.ToString()).ToString("yyyy-MM-dd hh:mm:ss");
            string sellerremarks = "";

            if (!string.IsNullOrWhiteSpace(model.SalesRemark))
            {
                sellerremarks = Regex.Replace(model.SalesRemark.ToUpper().Replace((char)32, ' ').Replace((char)13, ' ').Replace((char)10, ' '), "[ \\[ \\] \\^ \t \\-×――(^)$%~!@#$…&%¥—+=<>《》!!???::•`·、。,;;\"‘’“”-]", "☆").Replace("☆", "").Replace(" ", "");
            }
            else
            {
                sellerremarks = "";
            }
            string BuyersRemarks = "";

            if (!string.IsNullOrWhiteSpace(model.BuyRemark))
            {
                BuyersRemarks = Regex.Replace(model.BuyRemark.ToUpper().Replace((char)32, ' ').Replace((char)13, ' ').Replace((char)10, ' '), "[ \\[ \\] \\^ \t \\-×――(^)$%~!@#$…&%¥—+=<>《》!!???::•`·、。,;;\"‘’“”-]", "☆").Replace("☆", "").Replace(" ", "");
            }
            else
            {
                BuyersRemarks = "";
            }

            string[] address           = model.AddressMessage.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];
            }
            DateTime dtshottime = DateTime.Now;
            DateTime shoptime   = dtshottime.AddDays(-3);

            List <T_Reissue> ReissOrederModelList = db.T_Reissue.Where(a => a.OrderCode == model.OrderCode && a.CreatDate >= shoptime).ToList();
            string           sellerRemarksList    = "";

            if (ReissOrederModelList.Count >= 2)
            {
                sellerRemarksList = "三天内多次补发换货," + sellerremarks + "制单人:" + model.PostUser;
            }
            else
            {
                sellerRemarksList = sellerremarks + "制单人:" + model.PostUser;
            }


            GY     gy  = new GY();
            string cmd = "";

            cmd = "{" +
                  "\"appkey\":\"171736\"," +
                  "\"method\":\"gy.erp.trade.add\"," +
                  "\"sessionkey\":\"f5885504d9c84d1d8146200a4841f4b7\"," +
                  "\"platform_code\":\"" + model.NewOrderCode + "\"," +
                  "\"order_type_code\":\"" + model.OrderType + "\"," +
                  "\"shop_code\":\"" + model.StoreCode + "\"," +
                  "\"express_code\":\"" + model.ExpressName + "\"," +
                  "\"receiver_province\":\"" + receiver_province + "\"," +
                  "\"receiver_city\":\"" + receiver_city + "\"," +
                  "\"receiver_district\":\"" + receiver_district + "\"," +
                  "\"warehouse_code\":\"" + model.WarhouseName + "\"," +
                  "\"vip_code\":\"" + model.VipCode + "\"," +
                  "\"vip_name\":\"" + model.VipName + "\"," +
                  "\"receiver_name\":\"" + model.ReceivingName + "\"," +
                  "\"receiver_address\":\"" + model.Address + "\"," +
                  "\"receiver_zip\":\"" + model.PostalCode + "\"," +
                  "\"receiver_mobile\":\"" + model.TelPhone + "\"," +
                  "\"receiver_phone\":\"" + model.Phone + "\"," +
                  "\"deal_datetime\":\"" + datetime + "\"," +
                  "\"buyer_memo\":\"" + BuyersRemarks + "\"," +
                  "\"seller_memo\":\"" + sellerRemarksList + "\"," +
                  "\"business_man_code\":\"" + model.BusinessName + "\"," +
                  "\"details\":[" + shangp + "]" +
                  "}";
            string sign    = gy.Sign(cmd);
            string comcode = "{" +
                             "\"appkey\":\"171736\"," +
                             "\"method\":\"gy.erp.trade.add\"," +
                             "\"sessionkey\":\"f5885504d9c84d1d8146200a4841f4b7\"," +
                             "\"platform_code\":\"" + model.NewOrderCode + "\"," +
                             "\"order_type_code\":\"" + model.OrderType + "\"," +
                             "\"shop_code\":\"" + model.StoreCode + "\"," +
                             "\"express_code\":\"" + model.ExpressName + "\"," +
                             "\"receiver_province\":\"" + receiver_province + "\"," +
                             "\"receiver_city\":\"" + receiver_city + "\"," +
                             "\"receiver_district\":\"" + receiver_district + "\"," +
                             "\"warehouse_code\":\"" + model.WarhouseName + "\"," +
                             "\"vip_code\":\"" + model.VipCode + "\"," +
                             "\"vip_name\":\"" + model.VipName + "\"," +
                             "\"receiver_name\":\"" + model.ReceivingName + "\"," +
                             "\"receiver_address\":\"" + model.Address + "\"," +
                             "\"receiver_zip\":\"" + model.PostalCode + "\"," +
                             "\"receiver_mobile\":\"" + model.TelPhone + "\"," +
                             "\"receiver_phone\":\"" + model.Phone + "\"," +
                             "\"deal_datetime\":\"" + datetime + "\"," +
                             "\"buyer_memo\":\"" + BuyersRemarks + "\"," +
                             "\"sign\":\"" + sign + "\"," +
                             "\"seller_memo\":\"" + sellerRemarksList + "\"," +
                             //   "\"receiver_province\":\"" + listmodel.address + "\"," +
                             "\"business_man_code\":\"" + model.BusinessName + "\"," +
                             "\"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();

            return(sd);
        }
Exemplo n.º 7
0
        public JsonResult Check(string UserName, int approveID, int status, string memo)
        {
            using (TransactionScope sc = new TransactionScope())
            {
                try
                {
                    int TotalStep = db.T_ExchangeCenterConfig.ToList().Count;
                    T_ExchangeCenterApprove approve = db.T_ExchangeCenterApprove.Find(approveID);
                    string           name           = approve.ApproveName;
                    T_ExchangeCenter model          = db.T_ExchangeCenter.Find(approve.Pid);
                    approve.ApproveName   = UserName;
                    approve.ApproveStatus = status;
                    approve.ApproveTime   = DateTime.Now;
                    approve.Memo          = memo;
                    db.SaveChanges();
                    if (status == 2)//不同意
                    {
                        model.Status = status;
                        model.Step   = model.Step + 1;
                        db.SaveChanges();
                    }
                    else//同意
                    {
                        int type     = db.T_ExchangeReson.SingleOrDefault(s => s.Reson.Equals(model.ExchangeReson)).Type;
                        int LastStep = db.T_ExchangeCenterConfig.OrderByDescending(s => s.Step).FirstOrDefault(s => s.Reson == type).Step;
                        if (LastStep > model.Step)//判断是否存在下一级
                        {
                            //获得下一级审核部门
                            string nextapproveType             = db.T_ExchangeCenterConfig.OrderBy(s => s.Step).FirstOrDefault(s => s.Reson == type && s.Step > model.Step).ApproveType;
                            T_ExchangeCenterApprove newApprove = new T_ExchangeCenterApprove();
                            newApprove.ApproveStatus = -1;
                            newApprove.ApproveName   = nextapproveType;
                            newApprove.ApproveTime   = null;
                            newApprove.Pid           = approve.Pid;
                            db.T_ExchangeCenterApprove.Add(newApprove);
                            db.SaveChanges();
                            model.Status = 0;
                            model.Step   = model.Step + 1;
                            db.SaveChanges();
                        }
                        if (name.Equals("售后主管") || name.Equals("呼吸机主管"))//售后主管审核后直接加入补发货
                        {
                            //T_OrderList order = db.T_OrderList.Find(model.OrderId);
                            List <T_ExchangeDetail> exchangedetail = db.T_ExchangeDetail.Where(s => s.ExchangeCenterId == model.ID).ToList();

                            #region 加入快递赔付

                            if (model.ExchangeReson.Equals("快递破损"))
                            {
                                GY     gy  = new GY();
                                string cmd = "";

                                cmd = "{" +
                                      "\"appkey\":\"171736\"," +
                                      "\"method\":\"gy.erp.trade.get\"," +
                                      "\"page_no\":1," +
                                      "\"page_size\":10," +
                                      "\"platform_code\":\"" + model.OrderCode + "\"," +
                                      "\"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);

                                if (jsonData.Count == 6 || jsonData["orders"].Count == 0)
                                {
                                    cmd = "{" +
                                          "\"appkey\":\"171736\"," +
                                          "\"method\":\"gy.erp.trade.history.get\"," +
                                          "\"page_no\":1," +
                                          "\"page_size\":10," +
                                          "\"platform_code\":\"" + model.OrderCode + "\"," +
                                          "\"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["orders"].Count == 0)
                                    {
                                        return(Json(new { State = "Faile", Message = "订单号不存在" }));
                                    }
                                }
                                JsonData jsonOrders = jsonData["orders"][0];
                                var      deliver    = jsonOrders["deliverys"][0];
                                //快递单号
                                string mail_no = isNULL(deliver["mail_no"]).ToString();
                                //订单金额
                                string amount = isNULL(jsonOrders["amount"]).ToString();
                                //快递名称
                                string             express_name = isNULL(jsonOrders["express_name"]).ToString();
                                T_ExpressIndemnity Inde         = new T_ExpressIndemnity
                                {
                                    PostUserName       = model.PostUser,
                                    Date               = DateTime.Now,
                                    OrderNum           = model.OrderCode,
                                    wangwang           = model.VipCode,
                                    ShopName           = model.StoreName,
                                    RetreatExpressNum  = mail_no,
                                    State              = "0",
                                    OrderMoney         = Convert.ToDouble(amount),
                                    Type               = "破损",
                                    Second             = "0",
                                    CurrentApproveName = "快递组",
                                    IsDelete           = 0,
                                    ExpressName        = express_name,
                                    IndemnityMoney     = 0
                                };
                                db.T_ExpressIndemnity.Add(Inde);
                                db.SaveChanges();
                                List <T_ExchangePic> picList = db.T_ExchangePic.Where(s => s.ExchangeId == model.ID).ToList();
                                foreach (var item in picList)
                                {
                                    T_ExpressIndemnityPic expressPic = new T_ExpressIndemnityPic
                                    {
                                        EID    = Inde.ID,
                                        PicURL = item.Url
                                    };
                                    db.T_ExpressIndemnityPic.Add(expressPic);
                                }
                                db.SaveChanges();
                            }

                            #endregion

                            //#region 新增订单数据

                            //string newOrderCode = "";
                            //string newCode = "";
                            //string usedOrderCode = model.OrderCode;
                            //string userCode = order.code;
                            //List<T_OrderList> HEmodel = db.T_OrderList.Where(a => a.platform_code.Contains(usedOrderCode)).ToList();
                            //List<T_OrderList> orderList = db.T_OrderList.Where(a => a.code.Contains(userCode)).ToList();
                            //if (HEmodel.Count > 1)
                            //{
                            //    string HEmodelCount = HEmodel.Count.ToString();
                            //    newOrderCode = usedOrderCode + HEmodelCount;
                            //}
                            //else
                            //    newOrderCode = usedOrderCode + "1";
                            //if (orderList.Count > 1)
                            //{
                            //    string listCount = orderList.Count.ToString();
                            //    newCode = userCode + listCount;
                            //}
                            //else
                            //    newCode = userCode + "1";
                            //model.NewOrderCode = newOrderCode;
                            //db.SaveChanges();
                            //T_OrderList newOrder = new T_OrderList
                            //{
                            //    code = newCode,
                            //    order_type_name = "换货订单",
                            //    platform_code = newOrderCode,
                            //    createtime = DateTime.Now,
                            //    dealtime = model.SingleTime.ToString(),
                            //    cod = order.cod,
                            //    approve = order.approve,
                            //    delivery_state = order.delivery_state,
                            //    warehouse_code = model.ReturnWarhouse,
                            //    warehouse_name = db.T_Warehouses.SingleOrDefault(s => s.code.Equals(model.ReturnWarhouse)).name,
                            //    shop_code = model.StoreCode,
                            //    shop_name = model.StoreName,
                            //    express_code = model.ReturnExpressName,
                            //    express_name = db.T_Express.SingleOrDefault(s => s.Code.Equals(model.ReturnExpressName)).Name,
                            //    buyer_memo = model.BuyRemark,
                            //    seller_memo = model.SalesRemark,
                            //    vip_code = model.VipCode,
                            //    vip_name = model.VipName,
                            //    receiver_name = model.ReceivingName,
                            //    receiver_mobile = model.ReceivingTelPhone,
                            //    receiver_phone = model.ReceivingPhone,
                            //    receiver_zip = model.NeedPostalCode,
                            //    receiver_area = model.AddressMessage,
                            //    receiver_address = model.ReceivingAddress,
                            //    payCode = order.payCode,
                            //    vipIdCard = order.vipIdCard,
                            //    vipRealName = order.vipRealName,
                            //    vipEmail = order.vipEmail,
                            //    amount = 0,
                            //    payment_amount = 0,
                            //    post_fee = 0,
                            //    discount_fee = 0,
                            //    payment = 0,
                            //    qty = "1",
                            //    weight_origin = "0",
                            //    post_cost = 0,
                            //    mail_no = model.ReturnExpressCode,
                            //    platform_flag = "0",
                            //    IsGeneralize = 0,
                            //    Status_CashBack = 0,
                            //    Status_Retreat = 0,
                            //    Status_ExpressIndemnity = 0,
                            //    ExchangeStatus = 0,
                            //    ReissueStatus = 0
                            //};
                            //db.T_OrderList.Add(newOrder);
                            //db.SaveChanges();
                            //foreach (var item in exchangedetail)
                            //{
                            //    T_OrderDetail Orderdetail = db.T_OrderDetail.FirstOrDefault(s => s.oid.Equals(order.code) && s.item_code.Equals(item.SendProductCode));
                            //    if (Orderdetail != null)//修改原订单详情换货状态与换货数量
                            //    {
                            //        Orderdetail.ExchangeStatus = 1;
                            //        Orderdetail.ExchangeQty += item.SendProductNum;
                            //        db.SaveChanges();
                            //    }
                            //    T_OrderDetail t = new T_OrderDetail
                            //    {
                            //        oid = newCode,
                            //        refund = 0,
                            //        item_code = item.NeedProductCode,
                            //        item_name = item.NeedProductName,
                            //        item_simple_name = "",
                            //        sku_code = "",
                            //        sku_name = "",
                            //        qty = 0,
                            //        price = 0,
                            //        amount = 0,
                            //        discount_fee = 0,
                            //        amount_after = 0,
                            //        post_fee = 0,
                            //        platform_item_name = "",
                            //        platform_sku_name = "",
                            //        note = "",
                            //        ExchangeStatus = 0,
                            //        ExchangeQty = 0,
                            //        ReissueStatus = 0,
                            //        ReissueQty = 0,
                            //        RetreatQty = 0,
                            //        RetreatStatus = 0
                            //    };
                            //    db.T_OrderDetail.Add(t);
                            //    db.SaveChanges();
                            //}

                            //#endregion

                            #region 加入补发货

                            string    remark = "";
                            T_Reissue re     = db.T_Reissue.FirstOrDefault(s => s.OrderCode.Equals(model.OrderCode) && s.IsDelete == 0);
                            if (re != null)
                            {
                                var date      = Convert.ToDateTime(DateTime.Now).ToString("yyyyMMdd");
                                var modeldate = Convert.ToDateTime(re.CreatDate).ToString("yyyyMMdd");

                                if (re != null && int.Parse(date) - int.Parse(modeldate) <= 3)
                                {
                                    remark = model.SystemRemark + "3天内补发货重复";
                                }
                            }
                            //更改订单主表补发货状态
                            //else
                            //{
                            //    order.ReissueStatus = 1;
                            //    db.SaveChanges();
                            //}
                            T_Reissue reissue = new T_Reissue
                            {
                                OrderCode      = model.OrderCode,
                                NewOrderCode   = "8" + DateTime.Now.ToString("yyyyMMddHHmmss"),
                                VipName        = model.VipName,
                                StoreName      = model.StoreName,
                                WarhouseName   = model.NeedWarhouse,
                                ExpressName    = model.NeedExpress,
                                OrderType      = "Return",
                                SingleTime     = model.SingleTime,
                                ReceivingName  = model.ReceivingName,
                                PostalCode     = model.NeedPostalCode,
                                Phone          = model.ReceivingPhone,
                                TelPhone       = model.ReceivingTelPhone,
                                VipCode        = model.VipCode,
                                Address        = model.ReceivingAddress,
                                AddressMessage = model.AddressMessage,
                                SalesRemark    = model.SalesRemark,
                                BuyRemark      = model.BuyRemark,
                                StoreCode      = model.StoreCode,
                                Step           = 0,
                                Status         = -2,
                                BusinessName   = Com.GetReissueName(model.StoreCode, model.ExchangeReson),
                                PostUser       = model.PostUser,
                                DraftName      = Com.GetReissueName(model.StoreCode, model.ExchangeReson),
                                CreatDate      = DateTime.Now,
                                IsDelete       = 0,
                                ReissueReson   = model.ExchangeReson,
                                SystemRemark   = remark
                            };
                            db.T_Reissue.Add(reissue);
                            db.SaveChanges();
                            IQueryable <T_ExchangeDetail> detail = db.T_ExchangeDetail.Where(s => s.ExchangeCenterId == model.ID);
                            foreach (var item in detail)
                            {
                                T_ReissueDetail items = new T_ReissueDetail
                                {
                                    ProductCode = item.NeedProductCode,
                                    ProductName = item.NeedProductName,
                                    Num         = item.NeedProductNum,
                                    ReissueId   = reissue.ID
                                };
                                db.T_ReissueDetail.Add(items);
                            }
                            db.SaveChanges();

                            #endregion

                            #region 判断仓库是否收货

                            T_ReturnToStorage storge = db.T_ReturnToStorage.SingleOrDefault(s => s.Retreat_expressNumber.Equals(model.ReturnExpressCode));
                            if (storge != null)
                            {
                                //List<T_ExchangeCenter> exchange = db.T_ExchangeCenter.Where(s => s.OrderCode.Equals(model.OrderCode) && s.IsDelete == 0).ToList();

                                model.WarhouseStatus = 1;
                                model.Status         = 1;
                                T_ExchangeCenterApprove approve1 = db.T_ExchangeCenterApprove.SingleOrDefault(s => s.ApproveName.Equals("仓库") && !s.ApproveTime.HasValue && s.Pid == model.ID);
                                approve1.ApproveName   = "仓库";
                                approve1.ApproveStatus = 1;
                                approve1.ApproveTime   = DateTime.Now;
                                //判断是否第一次换货,如果是则修改订单状态为已收货
                                //if (exchange.Count() == 1)
                                //{
                                //    order.ExchangeStatus = 2;
                                //}
                            }


                            #endregion
                        }
                    }
                    List <T_ModularNotaudited> ModularNotaudited = db.T_ModularNotaudited.Where(a => a.ModularName == "换货未审核").ToList();
                    if (ModularNotaudited.Count > 0)
                    {
                        foreach (var item in ModularNotaudited)
                        {
                            db.T_ModularNotaudited.Remove(item);
                        }
                        db.SaveChanges();
                    }
                    string         RetreatAppRoveSql   = "  select isnull(ApproveUser,ApproveName) as PendingAuditName,COUNT(*) as NotauditedNumber from T_ExchangeCenterApprove where  Pid in ( select ID from T_ExchangeCenter where IsDelete=0 ) and  ApproveStatus=-1 and ApproveTime is null GROUP BY ApproveName,ApproveUser";
                    List <Modular> RetreatAppRoveQuery = db.Database.SqlQuery <Modular>(RetreatAppRoveSql).ToList();
                    string         Nickname            = Server.UrlDecode(Request.Cookies["Nickname"].Value);
                    for (int e = 0; e < RetreatAppRoveQuery.Count; e++)
                    {
                        string PendingAuditName = RetreatAppRoveQuery[e].PendingAuditName;

                        T_ModularNotaudited NotauditedModel = db.T_ModularNotaudited.SingleOrDefault(a => a.ModularName == "换货未审核" && a.PendingAuditName == PendingAuditName);
                        if (NotauditedModel != null)
                        {
                            NotauditedModel.NotauditedNumber = RetreatAppRoveQuery[e].NotauditedNumber;
                            db.Entry <T_ModularNotaudited>(NotauditedModel).State = System.Data.EntityState.Modified;
                        }
                        else
                        {
                            T_ModularNotaudited ModularNotauditedModel = new T_ModularNotaudited();
                            ModularNotauditedModel.ModularName      = "换货未审核";
                            ModularNotauditedModel.NotauditedNumber = RetreatAppRoveQuery[e].NotauditedNumber;
                            ModularNotauditedModel.PendingAuditName = RetreatAppRoveQuery[e].PendingAuditName;
                            ModularNotauditedModel.ToupdateDate     = DateTime.Now; ModularNotauditedModel.ToupdateName = Nickname;
                            db.T_ModularNotaudited.Add(ModularNotauditedModel);
                        }
                        db.SaveChanges();
                    }
                    sc.Complete();
                    return(Json(new { State = "Success" }, JsonRequestBehavior.AllowGet));
                }
                catch (Exception ex)
                {
                    return(Json(new { State = "Faile", Message = ex.Message }, JsonRequestBehavior.AllowGet));
                }
            }
        }
Exemplo n.º 8
0
        public ContentResult TBguanyi()
        {
            GY gy = new GY();

            string cmd = "{" +
                         "\"appkey\":\"171736\"," +
                         "\"method\":\"gy.erp.items.get\"," +
                         "\"page_no\":1," +
                         "\"page_size\":50," +

                         "\"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);
            //   jsonData["success"]
            int shuliang = int.Parse(jsonData["total"].ToString());
            int i        = 0;
            int yeshu    = shuliang / 50 + (shuliang % 50 == 0 ? 0 : 1);

            for (int x = 1; x <= yeshu; x++)
            {
                cmd = "{" +
                      "\"appkey\":\"171736\"," +
                      "\"method\":\"gy.erp.items.get\"," +
                      "\"page_no\":" + x + "," +
                      "\"page_size\":50," +

                      "\"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);
                T_goodsGY model = new T_goodsGY();
                int       ss    = 50;
                if (x == yeshu)
                {
                    ss = int.Parse(shuliang.ToString().Substring(shuliang.ToString().Length - 2, 2));
                }
                for (int z = 0; z < ss; z++)
                {
                    i++;
                    JsonData skus = jsonData["items"][z];

                    DateTime create_date       = new DateTime();
                    string   name              = "";
                    string   code              = "";
                    string   note              = "";
                    string   combine           = "";
                    double   weight            = 0;
                    string   simple_name       = "";
                    string   category_code     = "";
                    string   category_name     = "";
                    string   supplier_code     = "";
                    string   item_unit_code    = "";
                    double   package_point     = 0;
                    double   sales_point       = 0;
                    decimal  sales_price       = 0;
                    decimal  purchase_price    = 0;
                    decimal  agent_price       = 0;
                    decimal  cost_price        = 0;
                    string   pic_url           = "";
                    string   stock_status_code = "";
                    if (skus["create_date"] != null)
                    {
                        create_date = DateTime.Parse(skus["create_date"].ToString());
                    }
                    if (skus["name"] != null)
                    {
                        name = skus["name"].ToString();
                    }
                    if (skus["code"] != null)
                    {
                        code = skus["code"].ToString();
                    }
                    if (skus["note"] != null)
                    {
                        note = skus["note"].ToString();
                    }
                    if (skus["combine"] != null)
                    {
                        combine = skus["combine"].ToString();
                    }
                    if (skus["weight"] != null)
                    {
                        weight = double.Parse(skus["weight"].ToString());
                    }
                    if (skus["simple_name"] != null)
                    {
                        simple_name = skus["simple_name"].ToString();
                    }
                    if (skus["category_code"] != null)
                    {
                        category_code = skus["category_code"].ToString();
                    }
                    if (skus["category_name"] != null)
                    {
                        category_name = skus["category_name"].ToString();
                    }
                    if (skus["supplier_code"] != null)
                    {
                        supplier_code = skus["supplier_code"].ToString();
                    }
                    if (skus["item_unit_code"] != null)
                    {
                        item_unit_code = skus["item_unit_code"].ToString();
                    }
                    if (skus["package_point"] != null)
                    {
                        package_point = double.Parse(skus["package_point"].ToString());
                    }
                    if (skus["sales_point"] != null)
                    {
                        sales_point = double.Parse(skus["sales_point"].ToString());
                    }
                    if (skus["sales_price"] != null)
                    {
                        sales_price = decimal.Parse(skus["sales_price"].ToString());
                    }
                    if (skus["purchase_price"] != null)
                    {
                        purchase_price = decimal.Parse(skus["purchase_price"].ToString());
                    }
                    if (skus["agent_price"] != null)
                    {
                        agent_price = decimal.Parse(skus["agent_price"].ToString());
                    }
                    if (skus["cost_price"] != null)
                    {
                        cost_price = decimal.Parse(skus["cost_price"].ToString());
                    }
                    if (skus["pic_url"] != null)
                    {
                        pic_url = skus["pic_url"].ToString();
                    }
                    if (skus["stock_status_code"] != null)
                    {
                        stock_status_code = skus["stock_status_code"].ToString();
                    }
                    List <T_goodsGY> Querymodel = db.T_goodsGY.Where(a => a.code == code).ToList();
                    if (Querymodel.Count == 0)
                    {
                        model.create_date       = create_date;
                        model.name              = name;
                        model.code              = code;
                        model.note              = note;
                        model.weight            = weight;
                        model.combine           = combine;
                        model.simple_name       = simple_name;
                        model.category_code     = category_code;
                        model.category_name     = category_name;
                        model.supplier_code     = supplier_code;
                        model.item_unit_code    = item_unit_code;
                        model.package_point     = package_point;
                        model.sales_point       = sales_point;
                        model.sales_price       = sales_price;
                        model.purchase_price    = purchase_price;
                        model.agent_price       = agent_price;
                        model.cost_price        = cost_price;
                        model.stock_status_code = stock_status_code;
                        model.pic_url           = pic_url;
                        db.T_goodsGY.Add(model);
                        db.SaveChanges();
                    }
                }
            }

            if (i == shuliang)
            {
                return(Content(i.ToString()));
            }
            else
            {
                return(Content("0"));
            }
        }