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; /*************************************************************************************************** * * 更新人:sitong.dong * 描述:台车零件收容数管理 * 修改时间:2022.06.22 * 修改日志:系统迭代升级 * **************************************************************************************************/ namespace Estsh.Core.Web.Controllers { public class CarrierPartManageController : BaseController { private ICarrierPartManageService service; public CarrierPartManageController(ICarrierPartManageService _service) { service = _service; } // // GET: /Menu/ public ActionResult Index() { return View(); } /// /// 获取菜单管理列表数据 /// /// /// /// /// /// public ActionResult getCarrierListByPage(string rackPart,string partPackage, 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(rackPart, partPackage, 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 rackPart = Request.Form["rackPart"].ToString(); String partPackage = Request.Form["partPackage"].ToString(); WmsRackPartPackage wmsRack = new WmsRackPartPackage(); wmsRack.RackPart = rackPart; wmsRack.PartPackage = partPackage; 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 editCarrierPartManage(String ruid) { if (!string.IsNullOrEmpty(ruid)) { Hashtable ht = this.service.getCarrierDetail(ruid); ViewData.Add("editType", "edit"); ViewData.Add("ruid", ht["ruid"]); ViewData.Add("rackPart", ht["rackPart"]); ViewData.Add("partPackage", ht["partPackage"]); ViewData.Add("factoryId", ht["factoryId"]); ViewData.Add("enabled", ht["enabled"]); } else { ViewData.Add("editType", "new"); } return View("EditCarrierPartManage"); } /// /// 导入台车号 /// /// 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 /// /// public ActionResult exportData(string rackPart, string partPackage,string enabled="Y") { List listHt = this.service.getExportList(rackPart, partPackage, enabled); var memoryStream = ExcelHelper.ToExcel(listHt); string dateTime = DateTime.Now.ToString("yyyyMMddHHmmss"); return File(memoryStream.ToArray(), "application/ms-excel", "台车零件收容数管理"+ dateTime + ".xls"); } /// /// 下载模板 /// /// public ActionResult downLoadExcel() { 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); } } }