public ActionResult GetPageListJson(Pagination pagination, string queryJson) { var watch = CommonHelper.TimerStart(); var queryParam = queryJson.ToJObject(); var para = new DeliverOrderEntity(); if (!queryParam["keyword"].IsEmpty()) { para.KeyWord = queryParam["keyword"].ToString(); } if (!queryParam["orderno"].IsEmpty()) { para.BillCode = queryParam["orderno"].ToString(); } if (!queryParam["saleorderno"].IsEmpty()) { para.SaleOrderNo = queryParam["saleorderno"].ToString(); } if (!queryParam["orderstatus"].IsEmpty()) { para.OrderStatus = int.Parse(queryParam["orderstatus"].ToString()); } if (!queryParam["StartTime"].IsEmpty()) { para.StartTime = queryParam["StartTime"].ToString(); } if (!queryParam["EndTime"].IsEmpty()) { para.EndTime = queryParam["EndTime"].ToString(); } //数据对象 var pageList = DeliverOrderBLL.Instance.GetPageList(para, ref pagination); if (pageList != null) { foreach (var o in pageList) { if (o.AddressId != null) { var address = MemberAddressBLL.Instance.GetEntity(o.AddressId); if (address != null) { o.Address = address; o.Address.AddressExtInfo = address.ProvinceName + address.CityName + address.CountyName + address.Address; } } } } var JsonData = new { rows = pageList, total = pagination.total, page = pagination.page, records = pagination.records, costtime = CommonHelper.TimerEnd(watch) }; return(Content(JsonData.ToJson())); }
public ActionResult DoDispose(string keyValue, DeliverOrderEntity entity) { try { var deliverorder = DeliverOrderBLL.Instance.GetEntity(keyValue); if (deliverorder != null) { if (deliverorder.OrderStatus != (int)Trade.Model.Enums.DeliverOrderSatus.已支付) { return(Error("非[已支付]状态的订单不能此操作")); } deliverorder.LogisticsNo = entity.LogisticsNo; deliverorder.LogisticsName = entity.LogisticsName; deliverorder.LogisticsTime = entity.LogisticsTime; deliverorder.OrderStatus = (int)Trade.Model.Enums.DeliverOrderSatus.已发货; if (DeliverOrderBLL.Instance.Update(deliverorder)) { //修改对应修改销售订单产品状态 var deliverdetaillist = DeliverOrderDetailBLL.Instance.GetList(new DeliverOrderDetailEntity() { DeliverOrderId = deliverorder.DeliverOrderId }); foreach (var deliverdetailitem in deliverdetaillist) { var orderdetail = OrderDetailBLL.Instance.GetEntity(deliverdetailitem.OrderdetailId); if (orderdetail != null) { orderdetail.Status = (int)Trade.Model.Enums.OrderDetailStatus.已发货; OrderDetailBLL.Instance.Update(orderdetail); } } //修改销售订单状态 var order = OrderBLL.Instance.GetEntity(deliverorder.OrderId); if (order != null) { var detailList = OrderDetailBLL.Instance.GetList(new OrderDetailEntity() { OrderId = deliverorder.OrderId }); detailList = detailList.Where(p => p.Status == (int)Trade.Model.Enums.OrderDetailStatus.未到货 || p.Status == (int)Trade.Model.Enums.OrderDetailStatus.已到货).ToList(); if (detailList.Count > 0) { order.OrderStatus = (int)Trade.Model.Enums.OrderStatus.部分发货; } else { order.OrderStatus = (int)Trade.Model.Enums.OrderStatus.完成; } OrderBLL.Instance.Update(order); } } } return(Success("操作成功")); } catch (Exception ex) { ex.Data["Method"] = "DeliverOrderDetailController>>Dispose"; new ExceptionHelper().LogException(ex); return(Error("操作失败")); } }
/// <summary> /// 导出EXCEL /// </summary> public void ExportExcel(string queryJson) { string cacheKey = Request["cacheid"] as string; HttpRuntime.Cache[cacheKey + "-state"] = "processing"; HttpRuntime.Cache[cacheKey + "-row"] = "0"; var para = new DeliverOrderEntity(); try { //这里要url解码 var queryParam = Server.UrlDecode(queryJson).ToJObject(); if (!queryParam["keyword"].IsEmpty()) { para.KeyWord = queryParam["keyword"].ToString(); } if (!queryParam["orderno"].IsEmpty()) { para.BillCode = queryParam["orderno"].ToString(); } if (!queryParam["orderstatus"].IsEmpty()) { para.OrderStatus = int.Parse(queryParam["orderstatus"].ToString()); } if (!queryParam["StartTime"].IsEmpty()) { para.StartTime = queryParam["StartTime"].ToString(); } if (!queryParam["EndTime"].IsEmpty()) { para.EndTime = queryParam["EndTime"].ToString(); } List <DeliverOrderExportEntity> listnew = new List <DeliverOrderExportEntity>(); //数据对象 var list = DeliverOrderBLL.Instance.GetList(para); if (list != null) { foreach (var o in list) { //明细 var detailList = DeliverOrderDetailBLL.Instance.GetList(new DeliverOrderDetailEntity() { DeliverOrderId = o.DeliverOrderId }); foreach (var detailitem in detailList) { DeliverOrderExportEntity entity = new DeliverOrderExportEntity(); entity.BillCode = o.BillCode; entity.CreateDate = o.CreateDate == null ? "" : o.CreateDate.ToString(); entity.Freight = o.Freight == null ? "" : o.Freight.ToString(); entity.Remark = o.Remark; entity.LogisticsName = o.LogisticsName; entity.LogisticsNo = o.LogisticsNo; entity.SaleOrderNo = o.SaleOrderNo; entity.LogisticsTime = o.LogisticsTime == null ? "" : o.LogisticsTime.ToString(); if (o.AddressId != null) { var address = MemberAddressBLL.Instance.GetEntity(o.AddressId); if (address != null) { entity.AddressExtInfo = address.ProvinceName + address.CityName + address.CountyName + address.Address; entity.Consignee = address.Consignee; entity.Mobile = address.Mobile; } } if (o.OrderStatus != null) { entity.OrderStatusName = ((Trade.Model.Enums.DeliverOrderSatus)o.OrderStatus).ToString(); } entity.ProductCount = detailitem.BuyCount.ToString(); entity.ProductPrice = detailitem.Price.ToString(); var product = ProductBLL.Instance.GetEntity(detailitem.ProductId); if (product != null) { entity.ProductNO = product.ProductNO; entity.ProductName = product.ProductName; } listnew.Add(entity); } } //设置导出格式 ExcelConfig excelconfig = new ExcelConfig(); excelconfig.Title = "发货订单信息列表"; excelconfig.TitleFont = "微软雅黑"; excelconfig.TitlePoint = 10; excelconfig.FileName = "发货订单信息列表.xls"; excelconfig.IsAllSizeColumn = true; //每一列的设置,没有设置的列信息,系统将按datatable中的列名导出 List <ColumnEntity> listColumnEntity = new List <ColumnEntity>(); excelconfig.ColumnEntity = listColumnEntity; ColumnEntity columnentity = new ColumnEntity(); excelconfig.ColumnEntity.Add(new ColumnEntity() { Column = "BillCode", ExcelColumn = "业务单号", Width = 15 }); excelconfig.ColumnEntity.Add(new ColumnEntity() { Column = "CreateDate", ExcelColumn = "订单时间", Width = 20 }); excelconfig.ColumnEntity.Add(new ColumnEntity() { Column = "SaleOrderNo", ExcelColumn = "销售订单号", Width = 10 }); excelconfig.ColumnEntity.Add(new ColumnEntity() { Column = "Freight", ExcelColumn = "配送费用", Width = 10 }); excelconfig.ColumnEntity.Add(new ColumnEntity() { Column = "OrderStatusName", ExcelColumn = "订单状态", Width = 10 }); excelconfig.ColumnEntity.Add(new ColumnEntity() { Column = "Remark", ExcelColumn = "客户留言", Width = 10 }); excelconfig.ColumnEntity.Add(new ColumnEntity() { Column = "Consignee", ExcelColumn = "收货人", Width = 10 }); excelconfig.ColumnEntity.Add(new ColumnEntity() { Column = "Mobile", ExcelColumn = "收货人电话", Width = 10 }); excelconfig.ColumnEntity.Add(new ColumnEntity() { Column = "AddressExtInfo", ExcelColumn = "收货地址", Width = 20 }); excelconfig.ColumnEntity.Add(new ColumnEntity() { Column = "LogisticsNo", ExcelColumn = "物流单号", Width = 20 }); excelconfig.ColumnEntity.Add(new ColumnEntity() { Column = "LogisticsName", ExcelColumn = "物流公司", Width = 20 }); excelconfig.ColumnEntity.Add(new ColumnEntity() { Column = "LogisticsTime", ExcelColumn = "发货时间", Width = 20 }); excelconfig.ColumnEntity.Add(new ColumnEntity() { Column = "ProductNO", ExcelColumn = "产品编号", Width = 10 }); excelconfig.ColumnEntity.Add(new ColumnEntity() { Column = "ProductName", ExcelColumn = "产品名称", Width = 10 }); excelconfig.ColumnEntity.Add(new ColumnEntity() { Column = "ProductCount", ExcelColumn = "产品数量", Width = 10 }); excelconfig.ColumnEntity.Add(new ColumnEntity() { Column = "ProductPrice", ExcelColumn = "产品价格", Width = 10 }); //需合并索引 excelconfig.MergeRangeIndexArr = new int[] { 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11 }; //调用导出方法 ExcelHelper <DeliverOrderExportEntity> .ExcelDownload(listnew, excelconfig); HttpRuntime.Cache[cacheKey + "-state"] = "done"; } } catch (Exception ex) { HttpRuntime.Cache[cacheKey + "-state"] = "error"; } }