public static void cancel(int postOfficeID) { DeliveryProshipController.cancel(postOfficeID); }
private void importExcel(string pathFile) { // Lấy stream file var fs = new FileStream(pathFile, FileMode.Open); // Khởi tạo workbook để đọc var wb = new XSSFWorkbook(fs); // Lấy sheet đầu tiên var sheet = wb.GetSheetAt(0); var proships = new List <DeliveryProship>(); // Lấy data từ dòng thứ 3 cho đến hết file for (int index = 11; index < sheet.LastRowNum; index++) { var row = sheet.GetRow(index); var item = new DeliveryProship(); // OrderID if (!String.IsNullOrEmpty(row.GetCell(29).ToString())) { var strOrderID = Regex.Match(row.GetCell(29).ToString(), @"[0-9]+").Value; if (!String.IsNullOrEmpty(strOrderID)) { item.OrderID = Convert.ToInt32(strOrderID); } } // NumberID item.NumberID = row.GetCell(30).ToString(); // Customer item.Customer = row.GetCell(5).ToString(); // Phone item.Phone = row.GetCell(6).ToString().Replace(",", " |"); // Address item.Address = row.GetCell(7).StringCellValue; // Delivery Status item.DeliveryStatus = row.GetCell(26).StringCellValue; // Start Date item.StartDate = DateTime.ParseExact(row.GetCell(3).ToString(), "dd/MM/yyyy", CultureInfo.InvariantCulture); // Done Date if (!String.IsNullOrEmpty(row.GetCell(4).ToString())) { item.DoneDate = DateTime.ParseExact(row.GetCell(4).ToString(), "dd/MM/yyyy", CultureInfo.InvariantCulture); } // Tiền thu hộ item.COD = Convert.ToDecimal(row.GetCell(22).ToString()); // Tiền phí item.Fee = Convert.ToDecimal(row.GetCell(20).ToString()); // Staff item.Staff = String.Empty; // Setting trạng thái review với order item.Review = (int)DeliveryProshipReview.NoApprove; item.OrderStatus = (int)OrderStatus.Exist; proships.Add(item); // Thưc thi review các order sau khi đoc 100 dòng execl if (proships.Count == 100) { DeliveryProshipController.reviewOrder(proships); proships.Clear(); } } // Thưc thi review các order sau khi đoc dòng excel còn lại if (proships.Count > 0) { DeliveryProshipController.reviewOrder(proships); proships.Clear(); } wb.Close(); fs.Close(); }
public static void approve(int postOfficeID, int orderID) { DeliveryProshipController.approve(postOfficeID, orderID); }
public void LoadData() { string username = Request.Cookies["usernameLoginSystem"].Value; var acc = AccountController.GetByUsername(username); if (acc != null) { DateTime DateConfig = new DateTime(2019, 12, 15); var config = ConfigController.GetByTop1(); if (config.ViewAllOrders == 1) { DateConfig = new DateTime(2018, 6, 22); } DateTime OrderFromDate = DateConfig; DateTime OrderToDate = DateTime.Now; if (!String.IsNullOrEmpty(Request.QueryString["orderfromdate"])) { OrderFromDate = Convert.ToDateTime(Request.QueryString["orderfromdate"]); } if (!String.IsNullOrEmpty(Request.QueryString["ordertodate"])) { OrderToDate = Convert.ToDateTime(Request.QueryString["ordertodate"]).AddDays(1).AddMinutes(-1); } rOrderFromDate.SelectedDate = OrderFromDate; rOrderFromDate.MinDate = DateConfig; rOrderFromDate.MaxDate = DateTime.Now; rOrderToDate.SelectedDate = OrderToDate; rOrderToDate.MinDate = DateConfig; rOrderToDate.MaxDate = DateTime.Now; string TextSearch = String.Empty; int orderStatus = 0; string deliveryStatus = String.Empty; int review = 0; int feeStatus = 0; int Page = 1; if (Request.QueryString["textsearch"] != null) { TextSearch = Request.QueryString["textsearch"].Trim(); } if (Request.QueryString["orderstatus"] != null) { orderStatus = Request.QueryString["orderstatus"].ToInt(0); } if (Request.QueryString["deliverystatus"] != null) { deliveryStatus = Request.QueryString["deliverystatus"]; } if (Request.QueryString["review"] != null) { review = Request.QueryString["review"].ToInt(0); } if (Request.QueryString["feestatus"] != null) { feeStatus = Request.QueryString["feestatus"].ToInt(0); } if (Request.QueryString["Page"] != null) { Page = Request.QueryString["Page"].ToInt(); } txtSearchOrder.Text = TextSearch; ddlOrderStatus.SelectedValue = orderStatus.ToString(); ddlDeliveryStatus.SelectedValue = deliveryStatus.ToString(); ddlReview.SelectedValue = review.ToString(); ddlFeeStatus.SelectedValue = feeStatus.ToString(); // Create delivery post office fileter var filter = new DeliveryProshipFilterModel() { search = TextSearch, orderStatus = orderStatus, deliveryStatus = deliveryStatus, review = review, feeStatus = feeStatus, orderFromDate = OrderFromDate, orderToDate = OrderToDate }; // Create pagination var page = new PaginationMetadataModel() { currentPage = Page }; decimal lossMoney = 0; List <DeliveryProship> rs = new List <DeliveryProship>(); rs = DeliveryProshipController.Filter(filter, ref page, ref lossMoney); pagingall(rs, page); ltrNumberOfOrder.Text = String.Format("{0} số đơn Proship - Số tiền phí lệch: {1:#,###} VND", page.totalCount.ToString(), lossMoney); } }