Пример #1
0
        public ActionResult SearchExport()
        {
            try
            {
                var table = new StringBuilder();
                var datefrom = DateTime.ParseExact(Request["DateFrom"], "dd/MM/yyyy", null);
                var dateto = DateTime.ParseExact(Request["DateTo"], "dd/MM/yyyy", null);
                var eService = new ExportService();
                var oService = new OrderService();
                var tService = new StockService();
                var cService = new CustomerService();
                var exports = eService.GetExportByDate(datefrom, dateto);

                table.Append("<table id='table1' class='table1'>");
                table.Append("<thead>");
                table.Append("<tr>");
                table.Append("<th>Mã đơn hàng</th>");
                table.Append("<th>Khách hàng</th>");
                table.Append("<th>Tên kho</th>");
                table.Append("<th>Ngày xuất kho</th>");
                table.Append("</tr>");
                table.Append("</thead>");

                table.Append("<tbody>");
                foreach (var export in exports)
                {
                    var order = oService.GetOrderById(export.OrderId);
                    var customer = cService.GetCustomerById(order.CustomerId);
                    var stock = tService.GetStockById(export.StockId);
                    table.Append("<tr>");
                    table.AppendFormat("<td>{0}</td>", order.Code);
                    table.AppendFormat("<td>{0}</td>", customer.Name);
                    table.AppendFormat("<td>{0}</td>", stock.Name);
                    table.AppendFormat("<td>{0}</td>", export.CreatedDate.ToShortDateString());
                    table.Append("</tr>");
                }

                table.Append("</tbody>");
                table.Append("</table>");

                return Json(new
                {
                    finish = true,
                    data = table.ToString()
                });
            }
            catch (Exception e)
            {

                return Json(new { finish = false, data = e.ToString() });

            }
        }
Пример #2
0
        public ActionResult SearchImport()
        {
            try
            {
                var table = new StringBuilder();
                var datefrom = DateTime.ParseExact(Request["DateFrom"], "dd/MM/yyyy", null);
                var dateto = DateTime.ParseExact(Request["DateTo"], "dd/MM/yyyy", null);
                var iService = new ImportService();
                var pService = new ProviderService();
                var tService = new StockService();
                var imports = iService.GetExportByDate(datefrom, dateto);

                table.Append("<table id='table1' class='table1'>");
                table.Append("<thead>");
                table.Append("<tr>");
                table.Append("<th>Nhà cung cấp</th>");
                table.Append("<th>Ngày giờ</th>");
                table.Append("<th>Tên kho</th>");
                table.Append("</tr>");
                table.Append("</thead>");

                table.Append("<tbody>");
                foreach (var import in imports)
                {
                    var provider = pService.GetProviderById(import.ProviderId);
                    var stock = tService.GetStockById(import.StockId);
                    table.Append("<tr>");
                    table.AppendFormat("<td>{0}</td>", provider.Name);
                    table.AppendFormat("<td>{0}</td>", import.CreatedDate.ToShortDateString());
                    table.AppendFormat("<td>{0}</td>", stock.Name);
                    table.Append("</tr>");
                }

                table.Append("</tbody>");
                table.Append("</table>");

                return Json(new
                {
                    finish = true,
                    data = table.ToString()
                });
            }
            catch (Exception e)
            {

                return Json(new { finish = false, data = e.ToString() });

            }
        }
Пример #3
0
        public ActionResult SearchStorage()
        {
            try
            {
                var table = new StringBuilder();
                var sService = new StorageService();
                var pService = new ProductService();
                var tService = new StockService();
                var storages = sService.GetAllStorage().OrderBy(p => p.StockId).ThenBy(p => p.ProductId);

                table.Append("<table id='table1' class='table1'>");
                table.Append("<thead>");
                table.Append("<tr>");
                table.Append("<th>Sản phẩm</th>");
                table.Append("<th>Tên kho</th>");
                table.Append("<th>Số lượng kho</th>");
                table.Append("<th>Số lượng an toàn</th>");
                table.Append("</tr>");
                table.Append("</thead>");

                table.Append("<tbody>");
                foreach (var storage in storages)
                {
                    var product = pService.GetProductById(storage.ProductId);
                    var stock = tService.GetStockById(storage.StockId);
                    table.Append("<tr>");
                    table.AppendFormat("<td>{0}</td>", product.Name);
                    table.AppendFormat("<td>{0}</td>", stock.Name);
                    table.AppendFormat("<td>{0}</td>", storage.Quantity);
                    table.AppendFormat("<td>{0}</td>", product.SafeQuantity);
                    table.Append("</tr>");
                }

                table.Append("</tbody>");
                table.Append("</table>");

                return Json(new
                {
                    finish = true,
                    data = table.ToString()
                });
            }
            catch (Exception e)
            {

                return Json(new { finish = false, data = e.ToString() });

            }
        }