using Microsoft.AspNetCore.Http; using Microsoft.AspNetCore.Mvc; using Newtonsoft.Json.Linq; using System; using System.Collections.Generic; using System.Linq; using System.Threading.Tasks; using VueWebCoreApi.DLL.BLL; using VueWebCoreApi.Models; using VueWebCoreApi.Models.MouldVerify; using VueWebCoreApi.Tools; namespace VueWebCoreApi.Controllers { [ApiExplorerSettings(GroupName = "模具管理")] [ApiController] [Route("api/[controller]")] [ChannelActionFilter] public class MouldManagerController : Controller { //定义全局信息返回变量 ToMessage mes = new ToMessage(); RedisHelper redis = new RedisHelper(); #region[模具清单列表查询] /// /// 模具清单列表查询 /// /// 模具状态 /// 使用状态 /// 模具编码 /// 模具名称 /// 规格型号 /// 创建人员 /// 创建时间 /// 页码 /// 每页显示条数 /// 排序字段 /// 排序规则 /// [Route(template: "MouldMangerSearch")] [HttpGet] public JsonResult MouldMangerSearch(string mouldstaus = null, string onstate = null,string mouldcode=null,string mouldname=null,string mouldspec=null,string createuser=null,string createdate=null, int page = 0, int rows = 0, string prop = null, string order = null) { string opendate = ""; //开始时间 string closedate = ""; //结束时间 if (createdate != "" && createdate != null) { opendate = createdate.Split('~')[0].ToString(); closedate = createdate.Split('~')[1].ToString(); } int startNum = rows * (page - 1) + 1; //起始记录rowNum int endNum = rows * page; //结束记录 rowNum mes = MouldManagerBLL.MouldMangerSearch(mouldstaus, onstate, mouldcode, mouldname, mouldspec, createuser, opendate, closedate, startNum, endNum, prop, order); return Json(mes); } #endregion #region[模具清单新增编辑] /// /// 模具清单新增编辑 /// /// 提交数据对象 /// [Route(template: "AddUpdateMouldManger")] [HttpPost] public JsonResult AddUpdateMouldManger([FromBody] JObject obj) { var token = HttpContext.Request.Headers["Token"].ToString(); User us = JwtTools.Denocode(token.ToString()); string mouldcode = obj["mouldcode"].ToString(); //模具编码 string mouldname = obj["mouldname"].ToString(); //模具名称 string mouldspec = obj["mouldspec"].ToString(); //模具规格 string warehousecode = obj["warehousecode"].ToString(); //仓库编码 string location_code = obj["location_code"].ToString(); //库位编码 string surplife = obj["surplife"].ToString(); //预计寿命 string resilife = obj["resilife"].ToString(); //剩余寿命 string status = obj["status"].ToString(); //模具状态 string mouldpart = obj["mouldpart"].ToString(); //关联产品 string opertype = obj["opertype"].ToString(); //操作类型 mes = MouldManagerBLL.AddUpdateMouldManger(mouldcode, mouldname, mouldspec, warehousecode, location_code, surplife, resilife, status, mouldpart, opertype, us); return Json(mes); } #endregion #region[模具清单查看履历] /// /// 模具清单查看履历 /// /// 模具编码 /// 操作时间 /// 页码 /// 每页显示条数 /// 排序字段 /// 排序规则 /// [Route(template: "MoldResumeSearch")] [HttpGet] public JsonResult MoldResumeSearch(string mouldcode, string createdate = null, int page = 0, int rows = 0, string prop = null, string order = null) { string opendate = ""; //开始时间 string closedate = ""; //结束时间 if (createdate != "" && createdate != null) { opendate = createdate.Split('~')[0].ToString(); closedate = createdate.Split('~')[1].ToString(); } int startNum = rows * (page - 1) + 1; //起始记录rowNum int endNum = rows * page; //结束记录 rowNum mes = MouldManagerBLL.MoldResumeSearch(mouldcode,opendate, closedate, startNum, endNum, prop, order); return Json(mes); } #endregion #region[模具清单删除] /// /// 模具清单删除 /// /// 模具编码 /// [Route(template: "DeleteMouldManger")] [HttpPost] public JsonResult DeleteMouldManger(string mouldcode) { var token = HttpContext.Request.Headers["Token"].ToString(); User us = JwtTools.Denocode(token.ToString()); mes = MouldManagerBLL.DeleteMouldManger(mouldcode, us); return Json(mes); } #endregion #region[模具点检项列表查询] /// /// 模具点检项列表查询 /// /// 点检部位编码 /// 点检部位名称 /// 点检要求 /// 页码 /// 每页显示条数 /// 排序字段 /// 排序规则 /// [Route(template: "MouldCheckItemSearch")] [HttpGet] public JsonResult MouldCheckItemSearch(int page, int rows, string prop, string order, string checkitemcode = null, string checkitemname = null, string checkdescr = null) { int startNum = rows * (page - 1) + 1; //起始记录rowNum int endNum = rows * page; //结束记录 rowNum mes = MouldManagerBLL.MouldCheckItemSearch(checkitemcode, checkitemname, checkdescr, startNum, endNum, prop, order); return Json(mes); } #endregion #region[模具点检项新增编辑] /// /// 模具点检项新增编辑 /// /// 提交数据对象 /// [Route(template: "AddUpdateMouldCheckItem")] [HttpPost] public JsonResult AddUpdateMouldCheckItem([FromBody] JObject obj) { var token = HttpContext.Request.Headers["Token"].ToString(); User us = JwtTools.Denocode(token.ToString()); string checkitemid = obj["id"].ToString(); //模具点检项id(主键) string checkitemcode = obj["checkitemcode"].ToString(); //模具点检部位编码 string checkitemname = obj["checkitemname"].ToString(); //模具点检部位名称 string checkitemdescr = obj["checkitemdescr"].ToString(); //模具点检部位要求 string opertype = obj["opertype"].ToString(); //操作类型 mes = MouldManagerBLL.AddUpdateMouldCheckItem(checkitemid, checkitemcode, checkitemname, checkitemdescr, us, opertype); return Json(mes); } #endregion #region[模具点检项删除] /// /// 模具点检项删除 /// /// 模具点检项目(部位)编码 /// [Route(template: "DeleteMouldCheckItem")] [HttpPost] public JsonResult DeleteMouldCheckItem(string checkitemcode) { var token = HttpContext.Request.Headers["Token"].ToString(); User us = JwtTools.Denocode(token.ToString()); mes = MouldManagerBLL.DeleteMouldCheckItem(checkitemcode,us); return Json(mes); } #endregion #region[模具点检标准列表查询] /// /// 模具点检标准列表查询 /// /// 点检标准编码 /// 点检标准名称 /// 标准要求 /// 页码 /// 每页显示条数 /// 排序字段 /// 排序规则 /// [Route(template: "DeviceCheckStandArdSearch")] [HttpGet] public JsonResult DeviceCheckStandArdSearch(int page, int rows, string prop, string order, string checkstandcode = null, string checkstandname = null, string checkstandescr = null) { int startNum = rows * (page - 1) + 1; //起始记录rowNum int endNum = rows * page; //结束记录 rowNum mes = MouldManagerBLL.DeviceCheckStandArdSearch(checkstandcode, checkstandname, checkstandescr, startNum, endNum, prop, order); return Json(mes); } #endregion #region[模具点检标准编辑/查看获取数据] /// /// 模具点检标准编辑/查看获取数据 /// /// 模具点检标准编码 /// [Route(template: "ViewMouldCheckStanedSearch")] [HttpPost] public JsonResult ViewMouldCheckStanedSearch(string checkstand_code) { mes = MouldManagerBLL.ViewMouldCheckStanedSearch(checkstand_code); return Json(mes); } #endregion #region[模具点检标准新增编辑] /// /// 模具点检标准新增编辑 /// /// 操作类型 /// 提交数据 /// [Route(template: "AddUpdateMouldCheckStandArd")] [HttpPost] public JsonResult AddUpdateMouldCheckStandArd(string opertype, RoutEdit json) { var token = HttpContext.Request.Headers["Token"].ToString(); User us = JwtTools.Denocode(token.ToString()); mes = MouldManagerBLL.AddUpdateMouldCheckStandArd(opertype, json, us); return Json(mes); } #endregion #region[模具点检标准删除] /// /// 模具点检标准删除 /// /// 模具点检标准编码 /// [Route(template: "DeleteMouldCheckStaned")] [HttpPost] public JsonResult DeleteDeviceCheckStaned(string checkstand_code) { var token = HttpContext.Request.Headers["Token"].ToString(); User us = JwtTools.Denocode(token.ToString()); mes = MouldManagerBLL.DeleteMouldCheckStaned(checkstand_code,us); return Json(mes); } #endregion #region[模具点检标准关联模具查询] /// /// 模具点检标准关联模具查询 /// /// 模具点检标准编码 /// [Route(template: "CheckStanedAssociationMould")] [HttpGet] public JsonResult CheckStanedAssociationMould(string checkstand_code) { mes = MouldManagerBLL.CheckStanedAssociationMould(checkstand_code); return Json(mes); } #endregion #region [模具点检标准关联模具提交] /// /// 模具点检标准关联模具提交 /// /// 模具点检标准编码 /// 提交数据 /// [Route(template: "SaveCheckStanedAssociationMould")] [HttpPost] public JsonResult SaveCheckStanedAssociationMould(string checkstand_code, List json) { var token = HttpContext.Request.Headers["Token"].ToString(); User us = JwtTools.Denocode(token.ToString()); mes = MouldManagerBLL.SaveCheckStanedAssociationMould(checkstand_code, us, json); return Json(mes); } #endregion #region[模具保养项列表查询] /// /// 模具保养项列表查询 /// /// 保养部位编码 /// 保养部位名称 /// 保养要求 /// 页码 /// 每页显示条数 /// 排序字段 /// 排序规则 /// [Route(template: "MouldMaiItemSearch")] [HttpGet] public JsonResult MouldMaiItemSearch(int page, int rows, string prop, string order, string maiitemcode = null, string maiitemname = null, string maidescr = null) { int startNum = rows * (page - 1) + 1; //起始记录rowNum int endNum = rows * page; //结束记录 rowNum mes = MouldManagerBLL.MouldMaiItemSearch(maiitemcode, maiitemname, maidescr, startNum, endNum, prop, order); return Json(mes); } #endregion #region[模具保养项新增编辑] /// /// 模具保养项新增编辑 /// /// 提交数据对象 /// [Route(template: "AddUpdateMouldMaiItem")] [HttpPost] public JsonResult AddUpdateMouldMaiItem([FromBody] JObject obj) { var token = HttpContext.Request.Headers["Token"].ToString(); User us = JwtTools.Denocode(token.ToString()); string maiitemid = obj["id"].ToString(); //模具保养项id(主键) string maiitemcode = obj["maiitemcode"].ToString(); //模具点检部位编码 string maiitemname = obj["maiitemname"].ToString(); //模具点检部位名称 string maiitemdescr = obj["maiitemdescr"].ToString(); //模具点检部位要求 string opertype = obj["opertype"].ToString(); //操作类型 mes = MouldManagerBLL.AddUpdateMouldMaiItem(maiitemid, maiitemcode, maiitemname, maiitemdescr, us, opertype); return Json(mes); } #endregion #region[模具保养项删除] /// /// 模具保养项删除 /// /// 模具保养项目(部位)编码 /// [Route(template: "DeleteMouldMaiItem")] [HttpPost] public JsonResult DeleteMouldMaiItem(string maiitemcode) { var token = HttpContext.Request.Headers["Token"].ToString(); User us = JwtTools.Denocode(token.ToString()); mes = MouldManagerBLL.DeleteMouldMaiItem(maiitemcode, us); return Json(mes); } #endregion #region[模具保养标准列表查询] /// /// 模具保养标准列表查询 /// /// 保养标准编码 /// 保养标准名称 /// 保准要求 /// 页码 /// 每页显示条数 /// 排序字段 /// 排序规则 /// [Route(template: "MouldRepairStandArdSearch")] [HttpGet] public JsonResult MouldRepairStandArdSearch(int page, int rows, string prop, string order, string repairstandcode = null, string repairstandname = null, string repairstandescr = null) { int startNum = rows * (page - 1) + 1; //起始记录rowNum int endNum = rows * page; //结束记录 rowNum mes = MouldManagerBLL.MouldRepairStandArdSearch(repairstandcode, repairstandname, repairstandescr, startNum, endNum, prop, order); return Json(mes); } #endregion #region[模具保养标准编辑/查看获取数据] /// /// 模具保养标准编辑/查看获取数据 /// /// 模具保养标准编码 /// [Route(template: "ViewMouldRepairStanedSearch")] [HttpPost] public JsonResult ViewMouldRepairStanedSearch(string repairstand_code) { mes = MouldManagerBLL.ViewMouldRepairStanedSearch(repairstand_code); return Json(mes); } #endregion #region[模具保养标准新增编辑] /// /// 模具保养标准新增编辑 /// /// 操作类型 /// 提交数据 /// [Route(template: "AddUpdateMouldRepairStandArd")] [HttpPost] public JsonResult AddUpdateMouldRepairStandArd(string opertype, RoutEdit json) { var token = HttpContext.Request.Headers["Token"].ToString(); User us = JwtTools.Denocode(token.ToString()); mes = MouldManagerBLL.AddUpdateMouldRepairStandArd(opertype, json, us); return Json(mes); } #endregion #region[模具保养标准删除] /// /// 模具保养标准删除 /// /// 模具保养标准编码 /// [Route(template: "DeleteMouldRepairStaned")] [HttpPost] public JsonResult DeleteMouldRepairStaned(string repairstand_code) { var token = HttpContext.Request.Headers["Token"].ToString(); User us = JwtTools.Denocode(token.ToString()); mes = MouldManagerBLL.DeleteMouldRepairStaned(repairstand_code, us); return Json(mes); } #endregion #region[模具保养标准关联模具查询] /// /// 模具保养标准关联模具查询 /// /// 模具保养标准编码 /// [Route(template: "RepairStanedAssociationMould")] [HttpGet] public JsonResult RepairStanedAssociationMould(string repairstand_code) { mes = MouldManagerBLL.RepairStanedAssociationMould(repairstand_code); return Json(mes); } #endregion #region [模具保养标准关联模具提交] /// /// 模具保养标准关联模具提交 /// /// 模具保养标准编码 /// 提交数据 /// [Route(template: "SaveRepairStanedAssociationMould")] [HttpPost] public JsonResult SaveRepairStanedAssociationMould(string repairstand_code, List json) { var token = HttpContext.Request.Headers["Token"].ToString(); User us = JwtTools.Denocode(token.ToString()); mes = MouldManagerBLL.SaveRepairStanedAssociationMould(repairstand_code, us, json); return Json(mes); } #endregion #region[模具点检,扫描模具二维码] /// /// 模具点检,扫描模具二维码 /// /// 模具编码 /// [Route(template: "CheckScanMouldQrCodeData")] [HttpGet] public JsonResult CheckScanMouldQrCodeData(string mouldcode) { mes = MouldManagerBLL.CheckScanMouldQrCodeData(mouldcode); return Json(mes); } #endregion #region[模具点检,扫描模具二维码查找点检标准] /// /// 模具点检,扫描模具二维码查找点检标准 /// /// 模具编码 /// [Route(template: "CheckScanMouldTemp")] [HttpGet] public JsonResult CheckScanMouldTemp(string mouldcode) { mes = MouldManagerBLL.CheckScanMouldTemp(mouldcode); return Json(mes); } #endregion #region[模具点检,选择扫码模具、点检标准带出点检项] /// /// 模具点检,选择扫码模具、点检标准带出点检项 /// /// 模具编码 /// 点检标准编码 /// [Route(template: "SelectScanMouldQrCodeItem")] [HttpGet] public JsonResult SelectScanMouldQrCodeItem(string mouldcode, string checktempcode) { mes = MouldManagerBLL.SelectScanMouldQrCodeItem(mouldcode, checktempcode); return Json(mes); } #endregion #region[模具点检、提交保存] /// /// 模具点检、提交保存 /// /// 功能编码 /// 提交数据 /// [Route(template: "MouldCheckSave")] [HttpPost] public JsonResult MouldCheckSave(string menucode,AppDevicecCheck json) { var token = HttpContext.Request.Headers["Token"].ToString(); User us = JwtTools.Denocode(token.ToString()); mes = MouldManagerBLL.MouldCheckSave(menucode,us, json); return Json(mes); } #endregion #region[模具保养,扫描模具二维码] /// /// 模具保养,扫描模具二维码 /// /// 模具编码 /// [Route(template: "RepairScanMouldQrCodeData")] [HttpGet] public JsonResult RepairScanMouldQrCodeData(string mouldcode) { mes = MouldManagerBLL.RepairScanMouldQrCodeData(mouldcode); return Json(mes); } #endregion #region[模具保养,扫描模具二维码查找保养标准] /// /// 模具保养,扫描模具二维码查找保养标准 /// /// 模具编码 /// [Route(template: "RepairScanMouldTemp")] [HttpGet] public JsonResult RepairScanMouldTemp(string mouldcode) { mes = MouldManagerBLL.RepairScanMouldTemp(mouldcode); return Json(mes); } #endregion #region[模具保养,选择扫码模具列表带出保养项] /// /// 模具保养,选择扫码模具列表带出保养项 /// /// 模具编码 /// 保养标准编码 /// [Route(template: "RepairSelectScanMouldQrCodeItem")] [HttpGet] public JsonResult RepairSelectScanMouldQrCodeItem(string mouldcode, string repartempcode) { mes = MouldManagerBLL.RepairSelectScanMouldQrCodeItem(mouldcode, repartempcode); return Json(mes); } #endregion #region[模具保养,提交保存] /// /// 模具保养,提交保存 /// /// 功能编码 /// 提交数据 /// [Route(template: "MouldRepairSave")] [HttpPost] public JsonResult MouldRepairSave(string menucode, AppDevicecCheck json) { var token = HttpContext.Request.Headers["Token"].ToString(); User us = JwtTools.Denocode(token.ToString()); mes = MouldManagerBLL.MouldRepairSave(menucode, us, json); return Json(mes); } #endregion #region[模具信息查询,扫描模具二维码] /// /// 模具信息查询,扫描模具二维码 /// /// 模具编码 /// [Route(template: "ScanMouldQrCodeMessageData")] [HttpGet] public JsonResult ScanMouldQrCodeMessageData(string mouldcode) { mes = MouldManagerBLL.ScanMouldQrCodeMessageData(mouldcode); return Json(mes); } #endregion #region[模具信息查询明细] /// /// 模具信息查询明细 /// /// 模具编码 /// [Route(template: "ScanMouldQrCodeMessageSubData")] [HttpGet] public JsonResult ScanMouldQrCodeMessageSubData(string mouldcode) { mes = MouldManagerBLL.ScanMouldQrCodeMessageSubData(mouldcode); return Json(mes); } #endregion #region[模具维修申请,扫描模具二维码] /// /// 模具维修申请,扫描模具二维码 /// /// 模具编码 /// [Route(template: "MaintainScanMouldApplyQrCodeData")] [HttpGet] public JsonResult MaintainScanMouldApplyQrCodeData(string mouldcode) { mes = MouldManagerBLL.MaintainScanMouldApplyQrCodeData(mouldcode); return Json(mes); } #endregion #region[模具维修申请,提交保存] /// /// 模具维修申请,提交保存 /// /// 功能编号 /// 模具编码 /// 故障来源 /// 故障描述 /// [Route(template: "MaintainScanMouldApplySave")] [HttpPost] public JsonResult MaintainScanMouldApplySave([FromForm] string menucode, [FromForm] string mouldcode,[FromForm] string faultsourcecode,[FromForm] string faultdescr) { var token = HttpContext.Request.Headers["Token"].ToString(); User us = JwtTools.Denocode(token.ToString()); var files = Request.Form.Files; // 获取传输的文件列表 mes = MouldManagerBLL.MaintainScanMouldApplySave(menucode, mouldcode, faultsourcecode, faultdescr, us, files); mes.message = menucode; return Json(mes); } #endregion #region[模具待维修信息列表] /// /// 模具待维修信息列表 /// /// 模具编码 /// [Route(template: "RepairScanMouldQrCodeDataList")] [HttpGet] public JsonResult RepairScanMouldQrCodeDataList(string mouldcode) { mes = MouldManagerBLL.RepairScanMouldQrCodeDataList(mouldcode); return Json(mes); } #endregion #region[模具维修提交] /// /// 模具维修提交 /// /// 功能编号 /// 维修申请单号 /// 模具编码 /// 故障描述 /// 下机维修 /// 维修内容 /// [Route(template: "RepairScanMouldSave")] [HttpPost] public JsonResult RepairScanMouldSave([FromForm] string menucode, [FromForm] string docu_code, [FromForm] string mouldcode, [FromForm] string faultdescr, [FromForm] string is_stoprepair,[FromForm] string repaircontent) { var token = HttpContext.Request.Headers["Token"].ToString(); User us = JwtTools.Denocode(token.ToString()); var files = Request.Form.Files; // 获取传输的文件列表 mes = MouldManagerBLL.RepairScanMouldSave(menucode, docu_code, mouldcode, faultdescr, is_stoprepair, repaircontent, us, files); return Json(mes); } #endregion #region[模具维修待验证列表] /// /// 模具维修待验证列表 /// /// 模具编码 /// [Route(template: "RepairVerificationScanMouldData")] [HttpGet] public JsonResult RepairVerificationScanMouldData(string mouldcode) { mes = MouldManagerBLL.RepairVerificationScanMouldData(mouldcode); return Json(mes); } #endregion #region[模具维修待验证详情信息] /// /// 模具维修待验证详情信息 /// /// 维修单号 /// 模具编码 /// [Route(template: "RepairVerificationScanMouldDataSub")] [HttpGet] public JsonResult RepairVerificationScanMouldDataSub(string repair_code, string mouldcode) { mes = MouldManagerBLL.RepairVerificationScanMouldDataSub(repair_code, mouldcode); return Json(mes); } #endregion #region[模具维修验证提交] /// /// 模具维修验证提交 /// /// 提交数据 /// [Route(template: "RepairVerificationScanMouldSave")] [HttpPost] public JsonResult RepairVerificationScanMouldSave([FromBody] JObject obj) { var token = HttpContext.Request.Headers["Token"].ToString(); User us = JwtTools.Denocode(token.ToString()); string repairwo = obj["repairwo"].ToString(); //维修单号 string mouldcode = obj["mouldcode"].ToString(); //模具编码 string result = obj["result"].ToString(); //验证结果 string surp_life = obj["surp_life"].ToString(); //维修后剩余寿命 mes = MouldManagerBLL.RepairVerificationScanMouldSave(repairwo, mouldcode,result, surp_life,us); return Json(mes); } #endregion #region[模具上机,扫描模具编码] /// /// 模具上机,扫描模具编码 /// /// 模具编码 /// [Route(template: "MouldUpQrCodeData")] [HttpGet] public JsonResult MouldUpQrCodeData(string mouldcode) { mes = MouldManagerBLL.MouldUpQrCodeData(mouldcode); return Json(mes); } #endregion #region[模具上机,选择未上模设备] /// /// 模具上机,选择未上模设备 /// /// [Route(template: "MouldEqpPermissions")] [HttpGet] public JsonResult MouldEqpPermissions() { mes = MouldManagerBLL.MouldEqpPermissions(); return Json(mes); } #endregion #region[模具上机提交] /// /// 模具上机提交 /// /// 提交数据 /// [Route(template: "MouldUpSave")] [HttpPost] public JsonResult MouldUpSave([FromBody] JObject obj) { var token = HttpContext.Request.Headers["Token"].ToString(); User us = JwtTools.Denocode(token.ToString()); string mouldcode = obj["mouldcode"].ToString(); //模具编码 string eqp_code = obj["eqp_code"].ToString(); //设备编码 string description = obj["description"].ToString(); //上机描述 mes = MouldManagerBLL.MouldUpSave(mouldcode, eqp_code, description, us); return Json(mes); } #endregion #region[模具下机,扫描模具编码] /// /// 模具下机,扫描模具编码 /// /// 模具编码 /// [Route(template: "MouldDownQrCodeData")] [HttpGet] public JsonResult MouldDownQrCodeData(string mouldcode) { mes = MouldManagerBLL.MouldDownQrCodeData(mouldcode); return Json(mes); } #endregion #region[模具下机提交] /// /// 模具下机提交 /// /// 提交数据 /// [Route(template: "MouldDownSave")] [HttpPost] public JsonResult MouldDownSave([FromBody] JObject obj) { var token = HttpContext.Request.Headers["Token"].ToString(); User us = JwtTools.Denocode(token.ToString()); string mouldcode = obj["mouldcode"].ToString(); //模具编码 string eqp_code = obj["eqp_code"].ToString(); //设备编码 string usecount_life = obj["usecount_life"].ToString(); //本次使用寿命(次) string description = obj["description"].ToString(); //下机描述 mes = MouldManagerBLL.MouldDownSave(mouldcode, eqp_code, usecount_life, description, us); return Json(mes); } #endregion #region[模具外借,扫描模具编码] /// /// 模具外借,扫描模具编码 /// /// 模具编码 /// [Route(template: "MouldLendOutQrCodeData")] [HttpGet] public JsonResult MouldLendOutQrCodeData(string mouldcode) { mes = MouldManagerBLL.MouldLendOutQrCodeData(mouldcode); return Json(mes); } #endregion #region[模具外借提交] /// /// 模具外借提交 /// /// 提交数据 /// [Route(template: "MouldLendOutSave")] [HttpPost] public JsonResult MouldLendOutSave([FromBody] JObject obj) { var token = HttpContext.Request.Headers["Token"].ToString(); User us = JwtTools.Denocode(token.ToString()); string mouldcode = obj["mouldcode"].ToString(); //模具编码 string description = obj["description"].ToString(); //外借描述 mes = MouldManagerBLL.MouldLendOutSave(mouldcode, description, us); return Json(mes); } #endregion #region[模具归还,扫描模具编码] /// /// 模具归还,扫描模具编码 /// /// 模具编码 /// [Route(template: "MouldReturnQrCodeData")] [HttpGet] public JsonResult MouldReturnQrCodeData(string mouldcode) { mes = MouldManagerBLL.MouldReturnQrCodeData(mouldcode); return Json(mes); } #endregion #region[模具归还提交] /// /// 模具归还提交 /// /// 提交数据 /// [Route(template: "MouldReturnSave")] [HttpPost] public JsonResult MouldReturnSave([FromBody] JObject obj) { var token = HttpContext.Request.Headers["Token"].ToString(); User us = JwtTools.Denocode(token.ToString()); string mouldcode = obj["mouldcode"].ToString(); //模具编码 string description = obj["description"].ToString(); //归还描述 mes = MouldManagerBLL.MouldReturnSave(mouldcode, description, us); return Json(mes); } #endregion #region[模具入库,扫描模具编码] /// /// 模具入库,扫描模具编码 /// /// 模具编码 /// [Route(template: "MouldInWareHouseQrCodeData")] [HttpGet] public JsonResult MouldInWareHouseQrCodeData(string mouldcode) { mes = MouldManagerBLL.MouldInWareHouseQrCodeData(mouldcode); return Json(mes); } #endregion #region[模具入库提交] /// /// 模具入库提交 /// /// 提交数据 /// [Route(template: "MouldInWareHouseSave")] [HttpPost] public JsonResult MouldInWareHouseSave([FromBody] JObject obj) { var token = HttpContext.Request.Headers["Token"].ToString(); User us = JwtTools.Denocode(token.ToString()); string mouldcode = obj["mouldcode"].ToString(); //模具编码 string warehousecode = obj["warehousecode"].ToString(); //仓库编码 string locationcode = obj["locationcode"].ToString(); //库位编码 string description = obj["description"].ToString(); //入库描述 mes = MouldManagerBLL.MouldInWareHouseSave(mouldcode, warehousecode, locationcode, description, us); return Json(mes); } #endregion #region[模具出库,扫描模具编码] /// /// 模具出库,扫描模具编码 /// /// 模具编码 /// [Route(template: "MouldOutWareHouseQrCodeData")] [HttpGet] public JsonResult MouldOutWareHouseQrCodeData(string mouldcode) { mes = MouldManagerBLL.MouldOutWareHouseQrCodeData(mouldcode); return Json(mes); } #endregion #region[模具出库提交] /// /// 模具出库提交 /// /// 提交数据 /// [Route(template: "MouldOutWareHouseSave")] [HttpPost] public JsonResult MouldOutWareHouseSave([FromBody] JObject obj) { var token = HttpContext.Request.Headers["Token"].ToString(); User us = JwtTools.Denocode(token.ToString()); string mouldcode = obj["mouldcode"].ToString(); //模具编码 string warehousecode = obj["warehousecode"].ToString(); //仓库编码 string locationcode = obj["locationcode"].ToString(); //库位编码 string description = obj["description"].ToString(); //出库描述 mes = MouldManagerBLL.MouldOutWareHouseSave(mouldcode, warehousecode, locationcode, description, us); return Json(mes); } #endregion #region[模具点检记录查询] /// /// 模具点检记录查询 /// /// 模具编码 /// 模具名称 /// 规格型号 /// 点检标准编码 /// 点检标准名称 /// 点检人员 /// 点检时间 /// 点检结果 /// 页码 /// 每页显示条数 /// 排序字段 /// 排序规则 /// [Route(template: "MouldCheckTakeSearch")] [HttpGet] public JsonResult MouldCheckTakeSearch(int page, int rows, string prop, string order, string mouldcode = null, string mouldname = null, string mouldspec = null, string stanedcode = null,string stanedname=null, string checkuser = null, string checkdate = null,string checkrequest=null) { string checkopendate = ""; //点检开始时间 string checkclosedate = ""; //点检结束时间 if (checkdate != "" && checkdate != null) { checkopendate = checkdate.Split('~')[0].ToString(); checkclosedate = checkdate.Split('~')[1].ToString(); } int startNum = rows * (page - 1) + 1; //起始记录rowNum int endNum = rows * page; //结束记录 rowNum mes = MouldManagerBLL.MouldCheckTakeSearch(mouldcode, mouldname, mouldspec, stanedcode, stanedname, checkuser, checkopendate, checkclosedate, checkrequest, startNum, endNum, prop, order); return Json(mes); } #endregion #region[模具点检记录明细查询] /// /// 模具点检记录明细查询 /// /// 点检记录主id /// [Route(template: "MouldCheckSubTakeSearch")] [HttpGet] public JsonResult MouldCheckSubTakeSearch(string id) { mes = MouldManagerBLL.MouldCheckSubTakeSearch(id); return Json(mes); } #endregion #region[模具点检记录导出] /// /// 模具点检记录导出 /// /// 模具编码 /// 模具名称 /// 规格型号 /// 点检标准编码 /// 点检标准名称 /// 点检人员 /// 点检时间 /// 点检结果 /// [Route(template: "MouldCheckTakeOutExcel")] [HttpGet] public JsonResult MouldCheckTakeOutExcel(string mouldcode = null, string mouldname = null, string mouldspec = null, string stanedcode = null, string stanedname = null, string checkuser = null, string checkdate = null,string checkrequest=null) { string checkopendate = ""; //点检开始时间 string checkclosedate = ""; //点检结束时间 if (checkdate != "" && checkdate != null) { checkopendate = checkdate.Split('~')[0].ToString(); checkclosedate = checkdate.Split('~')[1].ToString(); } mes = MouldManagerBLL.MouldCheckTakeOutExcel(mouldcode, mouldname, mouldspec, stanedcode, stanedname, checkuser, checkopendate, checkclosedate, checkrequest); return Json(mes); } #endregion #region[模具保养记录查询] /// /// 模具保养记录查询 /// /// 模具编码 /// 模具名称 /// 规格型号 /// 保养标准编码 /// 保养标准名称 /// 保养人员 /// 保养时间 /// 保养结果 /// 页码 /// 每页显示条数 /// 排序字段 /// 排序规则 /// [Route(template: "MouldRepairTakeSearch")] [HttpGet] public JsonResult MouldRepairTakeSearch(int page, int rows, string prop, string order, string mouldcode = null, string mouldname = null, string mouldspec = null,string stanedcode=null, string stanedname = null, string repairuser = null, string repairdate = null, string repairresult = null) { string repairopendate = ""; //点检开始时间 string repairclosedate = ""; //点检结束时间 if (repairdate != "" && repairdate != null) { repairopendate = repairdate.Split('~')[0].ToString(); repairclosedate = repairdate.Split('~')[1].ToString(); } int startNum = rows * (page - 1) + 1; //起始记录rowNum int endNum = rows * page; //结束记录 rowNum mes = MouldManagerBLL.MouldRepairTakeSearch(mouldcode, mouldname, mouldspec, stanedcode,stanedname, repairuser, repairopendate, repairclosedate, repairresult, startNum, endNum, prop, order); return Json(mes); } #endregion #region[模具保养记录明细查询] /// /// 模具保养记录明细查询 /// /// 保养记录主表id /// [Route(template: "MouldRepairSubTakeSearch")] [HttpGet] public JsonResult MouldRepairSubTakeSearch(string id) { mes = MouldManagerBLL.MouldRepairSubTakeSearch(id); return Json(mes); } #endregion #region[模具保养记录导出] /// /// 模具保养记录导出 /// /// 模具编码 /// 模具名称 /// 规格型号 /// 保养标准编码 /// 保养标准名称 /// 保养人员 /// 保养时间 /// 保养结果 /// [Route(template: "MouldRepairTakeOutExcel")] [HttpGet] public JsonResult MouldRepairTakeOutExcel(string mouldcode = null, string mouldname = null, string mouldspec = null, string stanedcode = null, string stanedname = null, string repairuser = null, string repairdate = null, string repairresult = null) { string repairopendate = ""; //点检开始时间 string repairclosedate = ""; //点检结束时间 if (repairdate != "" && repairdate != null) { repairopendate = repairdate.Split('~')[0].ToString(); repairclosedate = repairdate.Split('~')[1].ToString(); } mes = MouldManagerBLL.MouldRepairTakeOutExcel(mouldcode, mouldname, mouldspec, stanedcode, stanedname, repairuser, repairopendate, repairclosedate, repairresult); return Json(mes); } #endregion #region[模具维修记录查询] /// /// 模具维修记录查询 /// /// 模具编码 /// 模具名称 /// 规格型号 /// 报修人员 /// 报修时间 /// 维修人员 /// 维修时间 /// 验证人员 /// 验证时间 /// 页码 /// 每页显示条数 /// 排序字段 /// 排序规则 /// [Route(template: "MouldUpdateSearch")] [HttpGet] public JsonResult MouldUpdateSearch(int page, int rows, string prop, string order, string mouldcode = null, string mouldname = null, string mouldspec = null, string reportuser = null, string reportdate = null, string repairuser = null, string repairdate = null, string vrifcatuser = null, string vrifcatdate = null) { string reportopendate = ""; //报修开始时间 string reportclosedate = ""; //报修结束时间 string repairopendate = ""; //维修开始时间 string repairclosedate = ""; //维修结束时间 string vrifcatopendate = ""; //维修验证开始时间 string vrifcatclosedate = ""; //维修验证结束时间 if (reportdate != "" && reportdate != null) { reportopendate = reportdate.Split('~')[0].ToString(); reportclosedate = reportdate.Split('~')[1].ToString(); } if (repairdate != "" && repairdate != null) { repairopendate = repairdate.Split('~')[0].ToString(); repairclosedate = repairdate.Split('~')[1].ToString(); } if (vrifcatdate != "" && vrifcatdate != null) { vrifcatopendate = vrifcatdate.Split('~')[0].ToString(); vrifcatclosedate = vrifcatdate.Split('~')[1].ToString(); } int startNum = rows * (page - 1) + 1; //起始记录rowNum int endNum = rows * page; //结束记录 rowNum mes = MouldManagerBLL.MouldUpdateSearch(mouldcode, mouldname, mouldspec, reportuser, repairuser, vrifcatuser, reportopendate, reportclosedate, repairopendate, repairclosedate, vrifcatopendate, vrifcatclosedate, startNum, endNum, prop, order); return Json(mes); } #endregion #region[模具维修记录明细查询] /// /// 模具维修记录明细查询 /// /// 模具维修单号 /// [Route(template: "MouldUpdateSubSearch")] [HttpGet] public JsonResult MouldUpdateSubSearch(string repair_code) { mes = MouldManagerBLL.MouldUpdateSubSearch(repair_code); return Json(mes); } #endregion #region[模具维修记录导出] /// /// 模具维修记录导出 /// /// 模具编码 /// 模具名称 /// 规格型号 /// 报修人员 /// 报修时间 /// 维修人员 /// 维修时间 /// 验证人员 /// 验证时间 /// [Route(template: "MouldUpdateOutExcel")] [HttpGet] public JsonResult MouldUpdateOutExcel(string mouldcode = null, string mouldname = null, string mouldspec = null, string reportuser = null, string reportdate = null, string repairuser = null, string repairdate = null, string vrifcatuser = null, string vrifcatdate = null) { string reportopendate = ""; //报修开始时间 string reportclosedate = ""; //报修结束时间 string repairopendate = ""; //维修开始时间 string repairclosedate = ""; //维修结束时间 string vrifcatopendate = ""; //维修验证开始时间 string vrifcatclosedate = ""; //维修验证结束时间 if (reportdate != "" && reportdate != null) { reportopendate = reportdate.Split('~')[0].ToString(); reportclosedate = reportdate.Split('~')[1].ToString(); } if (repairdate != "" && repairdate != null) { repairopendate = repairdate.Split('~')[0].ToString(); repairclosedate = repairdate.Split('~')[1].ToString(); } if (vrifcatdate != "" && vrifcatdate != null) { vrifcatopendate = vrifcatdate.Split('~')[0].ToString(); vrifcatclosedate = vrifcatdate.Split('~')[1].ToString(); } mes = MouldManagerBLL.MouldUpdateOutExcel(mouldcode, mouldname, mouldspec, reportuser, repairuser, vrifcatuser, reportopendate, reportclosedate, repairopendate, repairclosedate, vrifcatopendate, vrifcatclosedate); return Json(mes); } #endregion #region[模具上下机记录查询] /// /// 模具上下机记录查询 /// /// 模具编码 /// 模具名称 /// 规格型号 /// 操作类型(上机:UP 下机:DOWN) /// 设备编码 /// 操作人员 /// 操作时间 /// 页码 /// 每页显示条数 /// 排序字段 /// 排序规格 /// [Route(template: "MouldUpDownMachinesSearch")] [HttpGet] public JsonResult MouldUpDownMachinesSearch(int page, int rows, string prop, string order, string mouldcode = null, string mouldname = null, string mouldspec = null, string type = null,string devicecode=null,string operuser=null, string operdate = null) { string opendate = ""; //开始时间 string closedate = ""; //结束时间 if (operdate != "" && operdate != null) { opendate = operdate.Split('~')[0].ToString(); closedate = operdate.Split('~')[1].ToString(); } int startNum = rows * (page - 1) + 1; //起始记录rowNum int endNum = rows * page; //结束记录 rowNum mes = MouldManagerBLL.MouldUpDownMachinesSearch(mouldcode, mouldname, mouldspec,type,devicecode,operuser,opendate,closedate, startNum, endNum, prop, order); return Json(mes); } #endregion #region[模具上下机记导出] /// /// 模具上下机记导出 /// /// 模具编码 /// 模具名称 /// 规格型号 /// 操作类型(上机:UP 下机:DOWN) /// 设备编码 /// 操作人员 /// 操作时间 /// [Route(template: "MouldUpDownMachinesOutExcel")] [HttpGet] public JsonResult MouldUpDownMachinesOutExcel(string mouldcode = null, string mouldname = null, string mouldspec = null, string type = null, string devicecode = null, string operuser = null, string operdate = null) { string opendate = ""; //开始时间 string closedate = ""; //结束时间 if (operdate != "" && operdate != null) { opendate = operdate.Split('~')[0].ToString(); closedate = operdate.Split('~')[1].ToString(); } mes = MouldManagerBLL.MouldUpDownMachinesOutExcel(mouldcode, mouldname, mouldspec, type, devicecode, operuser, opendate, closedate); return Json(mes); } #endregion #region[模具借还记录查询] /// /// 模具借还记录查询 /// /// 模具编码 /// 模具名称 /// 规格型号 /// 操作类型 /// 操作人员 /// 操作时间 /// 页码 /// 每页显示条数 /// 排序字段 /// 排序规格 /// [Route(template: "MouldCirculateMachinesSearch")] [HttpGet] public JsonResult MouldCirculateMachinesSearch(int page, int rows, string prop, string order, string mouldcode = null, string mouldname = null, string mouldspec = null, string type = null, string operuser = null, string operdate = null) { string opendate = ""; //开始时间 string closedate = ""; //结束时间 if (operdate != "" && operdate != null) { opendate = operdate.Split('~')[0].ToString(); closedate = operdate.Split('~')[1].ToString(); } int startNum = rows * (page - 1) + 1; //起始记录rowNum int endNum = rows * page; //结束记录 rowNum mes = MouldManagerBLL.MouldCirculateMachinesSearch(mouldcode, mouldname, mouldspec, type, operuser, opendate, closedate, startNum, endNum, prop, order); return Json(mes); } #endregion #region[模具借还记录导出] /// /// 模具借还记录导出 /// /// 模具编码 /// 模具名称 /// 规格型号 /// 操作类型 /// 操作人员 /// 操作时间 /// [Route(template: "MouldCirculateMachinesOutExcel")] [HttpGet] public JsonResult MouldCirculateMachinesOutExcel(string mouldcode = null, string mouldname = null, string mouldspec = null, string type = null, string operuser = null, string operdate = null) { string opendate = ""; //开始时间 string closedate = ""; //结束时间 if (operdate != "" && operdate != null) { opendate = operdate.Split('~')[0].ToString(); closedate = operdate.Split('~')[1].ToString(); } mes = MouldManagerBLL.MouldCirculateMachinesOutExcel(mouldcode, mouldname, mouldspec, type, operuser, opendate, closedate); return Json(mes); } #endregion #region[模具出入库记录查询] /// /// 模具出入库记录查询 /// /// 模具编码 /// 模具名称 /// 规格型号 /// 操作类型(入库:IN 出库:OUT) /// 仓库编码 /// 库位编码 /// 操作人员 /// 操作时间 /// 页码 /// 每页显示条数 /// 排序字段 /// 排序规则 /// [Route(template: "MouldInOutMachinesSearch")] [HttpGet] public JsonResult MouldInOutMachinesSearch(int page, int rows, string prop, string order, string mouldcode = null, string mouldname = null, string mouldspec = null, string type = null,string warehousecode=null,string locationcode=null, string operuser = null, string operdate = null) { string opendate = ""; //开始时间 string closedate = ""; //结束时间 if (operdate != "" && operdate != null) { opendate = operdate.Split('~')[0].ToString(); closedate = operdate.Split('~')[1].ToString(); } int startNum = rows * (page - 1) + 1; //起始记录rowNum int endNum = rows * page; //结束记录 rowNum mes = MouldManagerBLL.MouldInOutMachinesSearch(mouldcode, mouldname, mouldspec, type, warehousecode,locationcode, operuser, opendate, closedate, startNum, endNum, prop, order); return Json(mes); } #endregion #region[模具出入库记录导出] /// /// 模具出入库记录导出 /// /// 模具编码 /// 模具名称 /// 规格型号 /// 操作类型(入库:IN 出库:OUT) /// 仓库编码 /// 库位编码 /// 操作人员 /// 操作时间 /// [Route(template: "MouldInOutMachinesOutExcel")] [HttpGet] public JsonResult MouldInOutMachinesOutExcel(string mouldcode = null, string mouldname = null, string mouldspec = null, string type = null, string warehousecode = null, string locationcode = null, string operuser = null, string operdate = null) { string opendate = ""; //开始时间 string closedate = ""; //结束时间 if (operdate != "" && operdate != null) { opendate = operdate.Split('~')[0].ToString(); closedate = operdate.Split('~')[1].ToString(); } mes = MouldManagerBLL.MouldInOutMachinesOutExcel(mouldcode, mouldname, mouldspec, type, warehousecode, locationcode, operuser, opendate, closedate); return Json(mes); } #endregion } }