コード例 #1
0
        /// <summary>
        /// Excel打印
        /// </summary>
        /// <param name="order"></param>
        /// <param name="orderDetailList"></param>
        private void ExcelPrint(OrderInfo order, List <OrderDetailInfo> orderDetailList)
        {
            try
            {
                string templetFile = Server.MapPath("/Admin/Print/Template.xls");
                string outFile     = "/Admin/Print/Order/" + DateTime.Now.ToString("yyyy-MM-dd") + "/" + Guid.NewGuid().ToString() + ".xls";
                string outFullFile = Server.MapPath(outFile);

                OrderExcelHelper orderExcel = new OrderExcelHelper(templetFile, outFullFile);
                orderExcel.CellParameters = ReadCellParameters(order);
                orderExcel.Dt             = ReadDataTable(orderDetailList);
                orderExcel.Rows           = 14;
                orderExcel.Left           = 0;
                orderExcel.Top            = 7;
                orderExcel.DataTableToExcel();

                string excelPath = "http://" + HttpContext.Current.Request.ServerVariables["Http_Host"] + outFile.Replace("\\", "/");
                ResponseHelper.Redirect(excelPath);
            }
            catch (Exception ex)
            {
                ExceptionHelper.ProcessException(ex, true);
            }
        }
コード例 #2
0
        /// <summary>
        /// 导出
        /// </summary>
        private void ExportSingle()
        {
            int orderId         = RequestHelper.GetQueryString <int>("OrderId");
            var order           = OrderBLL.Read(orderId);
            var orderDetailList = OrderDetailBLL.ReadList(orderId);

            try
            {
                string templetFile = Server.MapPath("/Admin/Print/Template_ExportSingle.xls");
                string outFile     = "/Admin/Print/Order/" + DateTime.Now.ToString("yyyy-MM-dd") + "/" + Guid.NewGuid().ToString() + ".xls";
                string outFullFile = Server.MapPath(outFile);

                OrderExcelHelper orderExcel = new OrderExcelHelper(templetFile, outFullFile);

                /*---------组装订单详细 start-----------------------------------*/
                DataTable dt = new DataTable();
                dt.Columns.Add(new DataColumn("Index", Type.GetType("System.Int32")));
                dt.Columns.Add(new DataColumn("ProductName", Type.GetType("System.String")));
                dt.Columns.Add(new DataColumn("BuyCount", Type.GetType("System.Int32")));
                dt.Columns.Add(new DataColumn("ProductPrice", Type.GetType("System.String")));
                dt.Columns.Add(new DataColumn("Weight", Type.GetType("System.String")));
                dt.Columns.Add(new DataColumn("TotalProductPrice", Type.GetType("System.String")));
                int i = 0;
                foreach (OrderDetailInfo orderDetail in orderDetailList)
                {
                    i++;
                    DataRow row = dt.NewRow();
                    row["Index"]             = i;
                    row["ProductName"]       = orderDetail.ProductName;
                    row["BuyCount"]          = orderDetail.BuyCount;
                    row["ProductPrice"]      = (orderDetail.ProductPrice).ToString("n");
                    row["Weight"]            = (orderDetail.ProductWeight).ToString("n");
                    row["TotalProductPrice"] = (orderDetail.BuyCount * orderDetail.ProductPrice).ToString("n");
                    dt.Rows.Add(row);
                }

                orderExcel.Dt = dt;
                /*---------组装订单详细 end-------------------------------------*/

                /*---------设置单元格值 start-----------------------------------*/
                Dictionary <int[], string> cellDic = new Dictionary <int[], string>();

                //基本信息
                cellDic.Add(new int[] { 2, 1 }, order.OrderNumber);
                cellDic.Add(new int[] { 2, 3 }, OrderBLL.ReadOrderStatus(order.OrderStatus, order.IsDelete));
                cellDic.Add(new int[] { 2, 5 }, order.PayName);
                cellDic.Add(new int[] { 2, 7 }, order.UserName);
                cellDic.Add(new int[] { 3, 1 }, order.AddDate.ToString());
                cellDic.Add(new int[] { 3, 3 }, order.PayDate.ToString());

                //邮寄信息
                cellDic.Add(new int[] { 5, 1 }, order.Consignee);
                cellDic.Add(new int[] { 5, 3 }, RegionBLL.RegionNameList(order.RegionId));
                cellDic.Add(new int[] { 5, 5 }, order.ZipCode);
                cellDic.Add(new int[] { 6, 1 }, order.Address);
                cellDic.Add(new int[] { 7, 1 }, order.Tel);
                cellDic.Add(new int[] { 7, 3 }, order.Email);
                cellDic.Add(new int[] { 7, 5 }, order.Mobile);
                cellDic.Add(new int[] { 8, 1 }, ShippingBLL.Read(order.ShippingId).Name);
                cellDic.Add(new int[] { 8, 3 }, order.ShippingDate.ToString("yyyy-MM-dd"));
                cellDic.Add(new int[] { 8, 5 }, order.ShippingNumber);

                //其他信息
                cellDic.Add(new int[] { 10, 1 }, order.UserMessage);
                cellDic.Add(new int[] { 11, 1 }, order.OrderNote);

                //汇总信息
                cellDic.Add(new int[] { 28, 0 }, "产品金额:" + order.ProductMoney + " 元" + " + 运费:" + order.ShippingMoney + " 元 + 其它费用:" + order.OtherMoney + "元 - 积分抵扣金额:" + order.PointMoney + " 元 - 余额:" + order.Balance + " 元");
                cellDic.Add(new int[] { 29, 0 }, "应付金额:" + OrderBLL.ReadNoPayMoney(order).ToString() + " 元");
                cellDic.Add(new int[] { 30, 0 }, "打印时间:" + RequestHelper.DateNow.ToString("yyyy-MM-dd") + "  操作者:" + Cookies.Admin.GetAdminName(false));

                orderExcel.CellParameters = cellDic;
                /*---------设置单元格值 end-------------------------------------*/
                orderExcel.Rows            = 14;
                orderExcel.Left            = 0;
                orderExcel.Top             = 14;
                orderExcel.SheetPrefixName = order.OrderNumber;
                orderExcel.DataTableToExcel();

                string excelPath = "http://" + HttpContext.Current.Request.ServerVariables["Http_Host"] + outFile.Replace("\\", "/");
                ResponseHelper.Redirect(excelPath);
            }
            catch (Exception ex)
            {
                ExceptionHelper.ProcessException(ex, true);
            }
        }