Exemplo n.º 1
0
        public ActionResult ImportCsOrder(string path)
        {
            path = AppDomain.CurrentDomain.SetupInformation.ApplicationBase + path.Replace("..", "");
            var fileArr  = path.Split(new[] { "/" }, StringSplitOptions.RemoveEmptyEntries);
            var fileName = fileArr[fileArr.Length - 1];
            IList <CsOrderView.CsOrderImport> orders;

            try
            {
                orders = NpoiHelper.ReadExcel(path.Replace("/" + fileName, ""), fileName).ToList <CsOrderView.CsOrderImport>();
            }
            catch (Exception ex)
            {
                LogHelper.Log(ex.ToJson(), "execl文件读取失败");
                return(Json(new ResModel
                {
                    ResStatus = ResStatue.No,
                    Data = "execl 文件读取失败,请确认文件数据正确, 请检查日志描述"
                }));
            }
            if (!orders.Any())
            {
                return(Json(new ResModel
                {
                    ResStatus = ResStatue.No,
                    Data = "当前Excel中没有数据,请确认文件是否包含规定完整的数据"
                }));
            }
            var users        = _csUsersBll.GetModelList($" AND (UserName IN ('{string.Join("','", orders.Select(x => x.收货人))}') OR UserPhone IN ('{string.Join("','", orders.Select(x => x.收货人电话))}'))");
            var products     = _csProductsBll.GetModelList("");
            var parts        = _csPartsBll.GetModelList("");
            var data         = new List <CsOrderView.CsOrderAndDetail>();
            var item         = new CsOrderView.CsOrderAndDetail();
            var lastType     = ExcelRow.Other;   // 记录上一行状态
            var endEmpty     = new List <int>(); // 记录尾部空行
            var overEndEmpty = false;            // 尾部空行是否结束

            for (var i = orders.Count - 1; i >= 0; i--)
            {
                var type = ExcelRowType(orders[i]);
                if (type == ExcelRow.Empty &&
                    !overEndEmpty)
                {
                    endEmpty.Add(i);
                }
                else
                {
                    overEndEmpty = true;
                }
                if (type == ExcelRow.Empty &&
                    lastType == ExcelRow.Empty &&
                    overEndEmpty)
                {
                    return(Json(new ResModel
                    {
                        ResStatus = ResStatue.No,
                        Data = "当前Excel中,两个订单信息中间,存在连续多空行.请仔细确认数据, 数据一旦上传将无法撤回"
                    }));
                }
                lastType = type;
            }

            // 将尾部空行删除只保留一个
            endEmpty.ForEach(x => orders.RemoveAt(x));
            orders.Add(new CsOrderView.CsOrderImport());

            foreach (var order in orders)
            {
                var type = ExcelRowType(order);
                if (type == ExcelRow.Other)
                {
                    return(Json(new ResModel
                    {
                        ResStatus = ResStatue.No,
                        Data = "当前Excel中不满足格式的单元格,请仔细确认数据, 数据一旦上传将无法撤回"
                    }));
                }
                if (type == ExcelRow.Empty)
                {
                    data.Add(item);
                    item = new CsOrderView.CsOrderAndDetail();
                    continue;
                }
                var product = products.FirstOrDefault(x => x.ProductNumber == order.商品编码);
                var part    = parts.FirstOrDefault(x => x.PartNumber == order.商品编码);
                var pId     = 0;            // 商品Id
                var cType   = ChoseType.螃蟹; // 蟹或配件
                if (product == null && part == null)
                {
                    return(Json(new ResModel
                    {
                        ResStatus = ResStatue.No,
                        Data = $"商品编码:{order.商品编码},不存在与数据库中,请仔细确认数据"
                    }));
                }
                if (product != null)
                {
                    pId   = product.ProductId;
                    cType = ChoseType.螃蟹;
                }
                if (part != null)
                {
                    pId   = part.PartId;
                    cType = ChoseType.配件;
                }
                if (type == ExcelRow.Order)
                {
                    var user = users.FirstOrDefault(x => x.UserPhone == order.收货人电话 && x.UserName == order.收货人);
                    int userId;
                    if (user == null)
                    {
                        user = new CsUsers
                        {
                            UserSex     = "先生",
                            UserName    = order.收货人,
                            UserPhone   = order.收货人电话,
                            OpenId      = "",
                            Remarks     = "",
                            TotalWight  = 0,
                            UserBalance = 0,
                            UserState   = 1
                        };
                        userId = _csUsersBll.Add(user);
                    }
                    else
                    {
                        userId = user.UserId;
                    }
                    Thread.Sleep(5);
                    item.CsOrder = new CsOrder
                    {
                        RowStatus      = RowStatus.效.GetHashCode(),
                        DeleteDescribe = "",
                        OrderState     = OrderState.已发货.GetHashCode(),
                        UserId         = userId,
                        ActualMoney    = order.实收金额.ToDecimal(),
                        OrderDelivery  = order.货运单号,
                        SendAddress    = $"{order.发货人}${order.发货人电话}",
                        OrderAddress   = $"${order.收货人}" + $"({user.UserSex})$${order.收货人电话}${order.收货地址})",
                        DeleteDate     = "1900-1-1".ToDate(),
                        DiscountMoney  = order.总金额.ToDecimal() - order.实收金额.ToDecimal(),
                        OrderDate      = DateTime.Now,
                        OrderNumber    = DateTime.Now.ToString(OrderNumberFormat),
                        TotalMoney     = order.总金额.ToDecimal()
                    };
                    item.CsOrderDetails.Add(new CsOrderDetail
                    {
                        ProductId     = pId,
                        ProductNumber = order.数量.ToInt(),
                        ChoseType     = cType.GetHashCode(),
                        TotalPrice    = order.单价.ToDecimal() * order.数量.ToInt(),
                        UnitPrice     = order.单价.ToDecimal()
                    });
                }
                if (type == ExcelRow.Detail)
                {
                    item.CsOrderDetails.Add(new CsOrderDetail
                    {
                        ProductId     = pId,
                        ProductNumber = order.数量.ToInt(),
                        ChoseType     = cType.GetHashCode(),
                        TotalPrice    = order.单价.ToDecimal() * order.数量.ToInt(),
                        UnitPrice     = order.单价.ToDecimal()
                    });
                }
            }
            var count       = 0;
            var countDetail = 0;

            foreach (var d in data)
            {
                if (d.CsOrder.RowStatus == RowStatus.无效.GetHashCode())
                {
                    return(Json(new ResModel
                    {
                        ResStatus = ResStatue.No,
                        Data = "存在无效订单,请检查表格总的数据是否满足要求"
                    }));
                }
                var orderId = _csOrderBll.Add(d.CsOrder);
                foreach (var detail in d.CsOrderDetails)
                {
                    detail.OrderId = orderId;
                    _csOrderDetailBll.Add(detail);
                    countDetail++;
                }
                count++;
            }

            return(Json(new ResModel
            {
                ResStatus = ResStatue.Yes,
                Data = $"导入{count}条订单记录,以及共计{countDetail}条商品记录"
            }));
        }
Exemplo n.º 2
0
        /// <summary>
        /// 批量更新已发货
        /// </summary>
        /// <param name="path"></param>
        /// <returns></returns>
        public ActionResult BatchDis(string path)
        {
            path = AppDomain.CurrentDomain.SetupInformation.ApplicationBase + path.Replace("..", "");
            var fileArr  = path.Split(new[] { "/" }, StringSplitOptions.RemoveEmptyEntries);
            var fileName = fileArr[fileArr.Length - 1];
            IEnumerable <CsOrderView.CsOrderBatchDis> orders;

            try
            {
                orders = NpoiHelper.ReadExcel(path.Replace("/" + fileName, ""), fileName)
                         .ToList <CsOrderView.CsOrderBatchDis>()
                         .Where(x => !x.订单编号.IsNullOrEmpty() && !x.运单号.IsNullOrEmpty());
            }
            catch (Exception ex)
            {
                LogHelper.Log(ex.ToJson(), "execl文件读取失败");
                return(Json(new ResModel
                {
                    ResStatus = ResStatue.No,
                    Data = "execl 文件读取失败,请确认文件数据正确, 请检查日志描述"
                }));
            }

            if (!orders.Any())
            {
                return(Json(new ResModel
                {
                    ResStatus = ResStatue.No,
                    Data = "当前Excel中没有数据,请确认文件是否包含规定完整的数据"
                }));
            }
            if (orders.Any(x => x.订单编号.IsNullOrEmpty() || x.运单号.IsNullOrEmpty()))
            {
                return(Json(new ResModel
                {
                    ResStatus = ResStatue.No,
                    Data = "当前Excel中存在空数据,请确认数据的完整性, 数据一旦上传将无法撤回"
                }));
            }
            var distinct = orders.Distinct(x => x.订单编号);

            if (distinct.Count() != orders.Count())
            {
                return(Json(new
                {
                    code = ResStatue.Warn.GetHashCode(),
                    data = "存在重复的订单编号,请依据给出的数据检查, 数据一旦上传将无法撤回",
                    orderIds = orders.Except(distinct).Select(x => x.订单编号)
                }));
            }
            var data = _csOrderBll.GetModelList($" AND OrderNumber IN ('{string.Join("','", orders.Select(x => x.订单编号))}')");

            if (data.Count != orders.Count())
            {
                return(Json(new
                {
                    code = ResStatue.Warn.GetHashCode(),
                    data = "存在有误的订单编号,请依据给出的数据检查, 数据一旦上传将无法撤回",
                    orderIds = orders.Select(x => x.订单编号.Trim()).Except(data.Select(x => x.OrderNumber))
                }));
            }
            var count = 0;

            foreach (var order in orders)
            {
                var sh = new SqlHelper <CsOrder>();
                sh.AddUpdate("OrderState", OrderState.已发货.GetHashCode());
                sh.AddUpdate("OrderDelivery", order.运单号);
                sh.AddWhere($" AND OrderNumber = '{order.订单编号}'");
                count += sh.Update();
            }
            return(Json(new ResModel
            {
                ResStatus = ResStatue.Yes,
                Data = $"更新成功, 共计更新{count}条数据."
            }));
        }
Exemplo n.º 3
0
        /// <summary>
        /// 上传主函数
        /// </summary>
        public void Upload()
        {
            DataTable dt = new DataTable();

            dt.Columns.Add("result");
            dt.Columns.Add("message");

            if (context.Request.Files.Count == 0)
            {
                dt.Rows.Add(new object[] { "False", "文件过大或提交的信息有误!" });
            }
            else
            {

                string strFileName = Path.GetFileName(context.Request.Files[0].FileName);
                string strFileNameSelfDef = "";

                if (context.Request["fileName"] != null && context.Request["fileName"].ToString() != "")
                {
                    strFileNameSelfDef = context.Request["fileName"].ToString();
                }
                string strExtension = Path.GetExtension(context.Request.Files[0].FileName).ToLower();

                if (strFileNameSelfDef == "")
                {
                    strFileName = strFileName.Substring(0, strFileName.Length - strExtension.Length) + "-" + DateTime.Now.ToString("yyyyMMddHHmmssfff") + strExtension;

                }
                else
                {
                    strFileName = strFileNameSelfDef + strExtension;
                }

                string strFilePath = context.Request["filepath"];
                if (string.IsNullOrEmpty(strFilePath))
                {
                    dt.Rows.Add(new object[] { "False", "filepath不能为空" });
                }
                else
                {

                    int fileSize = 1024 * 1024 * 20; //20M
                    HttpPostedFile postedFile = context.Request.Files[0];
                    if (postedFile.ContentLength > fileSize)
                    {
                        dt.Rows.Add(new object[] { "False", "最大只能上传20M文件" });
                    }
                    else
                    {

                        strFilePath = "/" + strFilePath + "/" + strFileName;
                        string strLocation = context.Server.MapPath("upload") + strFilePath;
                        context.Request.Files[0].SaveAs(strLocation);

                        if (GetFileType(strFileName) == FileType.Excel)
                        {
                            //读取EXCEL信息
                            NpoiHelper excel = new NpoiHelper();
                            m_dsExcelData = excel.ReadExcel(strLocation);

                        }
                        else if (GetFileType(strFileName) == FileType.Pic)
                        {
                            if (context.Request["filepath"] == "HZY_mat")
                            {
                                CreateThumbnail(strLocation, 200, 200);
                            }
                            dt.Rows.Add(new object[] { "True", "/upload" + strFilePath + "" });
                            dt.Rows.Add(new object[] { "文件大小", postedFile.ContentLength });
                        }
                        else
                        {
                            dt.Rows.Add(new object[] { "False", "文件类型不认识!" });

                        }

                    }
                }
            }

            if (context.Request["WSID"] == null)
            {
                string strJSON = HZY.COM.Common.JsonHelper.CreateJsonParameters(dt);
                context.Response.Write(strJSON);
            }
        }