using Estsh.Core.Controllers; using Estsh.Core.Model.ExcelModel; using Estsh.Core.Model.Result; using Estsh.Core.Models; using Estsh.Core.Services.IServices; using Estsh.Core.Util; using Microsoft.AspNetCore.Mvc; using System.Collections; namespace Estsh.Core.Web.Controllers { public class CarrierDateController : BaseController { private ICarrierDateService service; public CarrierDateController(ICarrierDateService _service) { service = _service; } // // GET: /Menu/ public ActionResult Index() { return View(); } /// /// 获取菜单管理列表数据 /// /// /// /// /// /// public ActionResult getCarrierListByPage(string rackNo, string cartonNo, string partNo, string partSpec, Pager pager, String direction, String sort, string enabled = "Y") { int factoryId = CurrentEmp.FactoryId; Hashtable result = new Hashtable(); result.Add("pager.pageNo", pager.pageNo); Hashtable dataHt = this.service.getCarrierListByPage(rackNo, cartonNo, partNo, partSpec, enabled, factoryId, pager, direction, sort); result.Add("rows", dataHt["dataList"]); result.Add("pager.totalRows", dataHt["totalCount"]); result.Add("sort", sort); result.Add("direction", direction); return Json(result); } /// /// 保存菜单数据 /// /// public ActionResult saveCarrier() { String editType = Request.Form["editType"].ToString(); String ruid = Request.Form["ruid"].ToString(); String rackNo = Request.Form["rackNo"].ToString(); WmsRack wmsRack = new WmsRack(); wmsRack.RackNo = rackNo; wmsRack.RackType = "10"; wmsRack.FactoryId = CurrentEmp.FactoryId; wmsRack.FactoryCode = CurrentEmp.FactoryCode; wmsRack.Enabled = "Y"; String message = ""; if (editType != null && editType.Trim().Equals("edit")) { wmsRack.UpdateUserId = CurrentEmp.EmpId; wmsRack.Ruid = Convert.ToInt32(ruid); if (this.service.updateCarrier(wmsRack) > 0) { message = "修改成功"; } else { message = "修改失败"; } } else { wmsRack.CreateUserId = CurrentEmp.EmpId; wmsRack.Guid = Guid.NewGuid().ToString(); if (this.service.saveCarrier(wmsRack) > 0) { message = "添加成功"; } else { message = "添加失败"; } } Hashtable result = new Hashtable(); result.Add("message", message); return Json(result); } /// /// 编辑菜单 /// /// /// public ActionResult editCarrierManage(String ruid) { if (!string.IsNullOrEmpty(ruid)) { Hashtable ht = this.service.getCarrierDetail(ruid); ViewData.Add("editType", "edit"); ViewData.Add("ruid", ht["ruid"]); ViewData.Add("rackNo", ht["rackNo"]); ViewData.Add("rackType", ht["rackType"]); ViewData.Add("factoryId", ht["factoryId"]); ViewData.Add("enabled", ht["enabled"]); } else { ViewData.Add("editType", "new"); } return View("EditCarrierManage"); } /// /// 导入台车号 /// /// public ActionResult carImport() { int factoryId = CurrentEmp.FactoryId; string factoryCode = CurrentEmp.FactoryCode; Hashtable result = new Hashtable(); IFormFile file = Request.Form.Files[0]; List data = ExcelHelper.GetList(file, 0); result = service.ImportExcel(data, factoryId, factoryCode, CurrentEmp.EmpId); return Json(result); } public ActionResult uploadFile() { return View("uploadFile"); } /// /// 导出数据到Excel /// BY NOAH /// carImport /// public ActionResult exportData(string rackNo, string enabled = "Y") { List listHt = this.service.getExportList(rackNo, enabled, CurrentEmp.FactoryId.ToString()); var memoryStream = ExcelHelper.ToExcel(listHt); string dateTime = DateTime.Now.ToString("yyyyMMddHHmmss"); return File(memoryStream.ToArray(), "application/ms-excel", "台车管理" + dateTime + ".xls"); } /// /// 下载模板 /// /// public ActionResult downLoadExcel(string rackPart, string partPackage, string enabled = "Y") { List listHt = new List();//导出空数据模板 var memoryStream = ExcelHelper.ToExcel(listHt); string dateTime = DateTime.Now.ToString("yyyyMMddHHmmss"); return File(memoryStream.ToArray(), "application/ms-excel", "台车管理" + dateTime + ".xls"); } /// /// 启用 /// /// /// public ActionResult onEnable(String ids) { int delCount = 0; try { delCount = this.service.EnableCarrier(ids); } catch (Exception e) { delCount = -1; } Hashtable result = new Hashtable(); result.Add("status", delCount); return Json(result); } /// /// 禁用 /// /// /// public ActionResult onDisable(String ids) { int delCount = 0; try { delCount = this.service.DisableCarrier(ids); } catch (Exception e) { delCount = -1; } Hashtable result = new Hashtable(); result.Add("status", delCount); return Json(result); } } }