| | |
| | | { |
| | | string opendate = ""; //开始时间 |
| | | string closedate = ""; //结束时间 |
| | | if (createuser != "" && createuser != null) |
| | | if (createdate != "" && createdate != null) |
| | | { |
| | | opendate = createuser.Split('~')[0].ToString(); |
| | | closedate = createuser.Split('~')[1].ToString(); |
| | | opendate = createdate.Split('~')[0].ToString(); |
| | | closedate = createdate.Split('~')[1].ToString(); |
| | | } |
| | | int startNum = rows * (page - 1) + 1; //起始记录rowNum |
| | | int endNum = rows * page; //结束记录 rowNum |
| | |
| | | string mouldpart = obj["mouldpart"].ToString(); //关联产品 |
| | | string opertype = obj["opertype"].ToString(); //操作类型 |
| | | mes = MouldManagerBLL.AddUpdateMouldManger(mouldcode, mouldname, mouldspec, surplife, resilife, status, mouldpart, opertype, us); |
| | | return Json(mes); |
| | | } |
| | | #endregion |
| | | |
| | | #region[模具清单查看履历] |
| | | /// <summary> |
| | | /// 模具清单查看履历 |
| | | /// </summary> |
| | | /// <param name="mouldcode">模具编码</param> |
| | | /// <param name="createdate">操作时间</param> |
| | | /// <param name="page">页码</param> |
| | | /// <param name="rows">每页显示条数</param> |
| | | /// <param name="prop">排序字段</param> |
| | | /// <param name="order">排序规则</param> |
| | | /// <returns></returns> |
| | | [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 |
| | |
| | | User us = JwtTools.Denocode(token.ToString()); |
| | | var files = Request.Form.Files; // 获取传输的文件列表 |
| | | mes = MouldManagerBLL.MaintainScanMouldApplySave(menucode, mouldcode, faultsourcecode, faultdescr, us, files); |
| | | mes.Message = menucode; |
| | | mes.message = menucode; |
| | | return Json(mes); |
| | | } |
| | | #endregion |
| | |
| | | public JsonResult MouldUpQrCodeData(string mouldcode) |
| | | { |
| | | mes = MouldManagerBLL.MouldUpQrCodeData(mouldcode); |
| | | return Json(mes); |
| | | } |
| | | #endregion |
| | | |
| | | #region[模具上机,选择未上模设备] |
| | | /// <summary> |
| | | /// 模具上机,选择未上模设备 |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | [Route(template: "MouldEqpPermissions")] |
| | | [HttpGet] |
| | | public JsonResult MouldEqpPermissions() |
| | | { |
| | | mes = MouldManagerBLL.MouldEqpPermissions(); |
| | | return Json(mes); |
| | | } |
| | | #endregion |
| | |
| | | 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,description, us); |
| | | mes = MouldManagerBLL.MouldInWareHouseSave(mouldcode, warehousecode, locationcode, description, us); |
| | | return Json(mes); |
| | | } |
| | | #endregion |
| | |
| | | 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, description, us); |
| | | mes = MouldManagerBLL.MouldOutWareHouseSave(mouldcode, warehousecode, locationcode, description, us); |
| | | return Json(mes); |
| | | } |
| | | #endregion |
| | | |
| | | |
| | | #region[模具点检记录查询] |
| | | /// <summary> |
| | | /// 模具点检记录查询 |
| | | /// </summary> |
| | | /// <param name="mouldcode">模具编码</param> |
| | | /// <param name="mouldname">模具名称</param> |
| | | /// <param name="mouldspec">规格型号</param> |
| | | /// <param name="stanedcode">点检标准编码</param> |
| | | /// <param name="stanedname">点检标准名称</param> |
| | | /// <param name="checkuser">点检人员</param> |
| | | /// <param name="checkdate">点检时间</param> |
| | | /// <param name="checkrequest">点检结果</param> |
| | | /// <param name="page">页码</param> |
| | | /// <param name="rows">每页显示条数</param> |
| | | /// <param name="prop">排序字段</param> |
| | | /// <param name="order">排序规则</param> |
| | | /// <returns></returns> |
| | | [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[模具点检记录明细查询] |
| | | /// <summary> |
| | | /// 模具点检记录明细查询 |
| | | /// </summary> |
| | | /// <param name="id">点检记录主id</param> |
| | | /// <returns></returns> |
| | | [Route(template: "MouldCheckSubTakeSearch")] |
| | | [HttpGet] |
| | | public JsonResult MouldCheckSubTakeSearch(string id) |
| | | { |
| | | mes = MouldManagerBLL.MouldCheckSubTakeSearch(id); |
| | | return Json(mes); |
| | | } |
| | | #endregion |
| | | |
| | | #region[模具点检记录导出] |
| | | /// <summary> |
| | | /// 模具点检记录导出 |
| | | /// </summary> |
| | | /// <param name="mouldcode">模具编码</param> |
| | | /// <param name="mouldname">模具名称</param> |
| | | /// <param name="mouldspec">规格型号</param> |
| | | /// <param name="stanedcode">点检标准编码</param> |
| | | /// <param name="stanedname">点检标准名称</param> |
| | | /// <param name="checkuser">点检人员</param> |
| | | /// <param name="checkdate">点检时间</param> |
| | | /// <param name="checkrequest">点检结果</param> |
| | | /// <returns></returns> |
| | | [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[模具保养记录查询] |
| | | /// <summary> |
| | | /// 模具保养记录查询 |
| | | /// </summary> |
| | | /// <param name="mouldcode">模具编码</param> |
| | | /// <param name="mouldname">模具名称</param> |
| | | /// <param name="mouldspec">规格型号</param> |
| | | /// <param name="stanedcode">保养标准编码</param> |
| | | /// <param name="stanedname">保养标准名称</param> |
| | | /// <param name="repairuser">保养人员</param> |
| | | /// <param name="repairdate">保养时间</param> |
| | | /// <param name="repairresult">保养结果</param> |
| | | /// <param name="page">页码</param> |
| | | /// <param name="rows">每页显示条数</param> |
| | | /// <param name="prop">排序字段</param> |
| | | /// <param name="order">排序规则</param> |
| | | /// <returns></returns> |
| | | [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[模具保养记录明细查询] |
| | | /// <summary> |
| | | /// 模具保养记录明细查询 |
| | | /// </summary> |
| | | /// <param name="id">保养记录主表id</param> |
| | | /// <returns></returns> |
| | | [Route(template: "MouldRepairSubTakeSearch")] |
| | | [HttpGet] |
| | | public JsonResult MouldRepairSubTakeSearch(string id) |
| | | { |
| | | mes = MouldManagerBLL.MouldRepairSubTakeSearch(id); |
| | | return Json(mes); |
| | | } |
| | | #endregion |
| | | |
| | | #region[模具保养记录导出] |
| | | /// <summary> |
| | | /// 模具保养记录导出 |
| | | /// </summary> |
| | | /// <param name="mouldcode">模具编码</param> |
| | | /// <param name="mouldname">模具名称</param> |
| | | /// <param name="mouldspec">规格型号</param> |
| | | /// <param name="stanedcode">保养标准编码</param> |
| | | /// <param name="stanedname">保养标准名称</param> |
| | | /// <param name="repairuser">保养人员</param> |
| | | /// <param name="repairdate">保养时间</param> |
| | | /// <param name="repairresult">保养结果</param> |
| | | /// <returns></returns> |
| | | [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[模具维修记录查询] |
| | | /// <summary> |
| | | /// 模具维修记录查询 |
| | | /// </summary> |
| | | /// <param name="mouldcode">模具编码</param> |
| | | /// <param name="mouldname">模具名称</param> |
| | | /// <param name="mouldspec">规格型号</param> |
| | | /// <param name="reportuser">报修人员</param> |
| | | /// <param name="reportdate">报修时间</param> |
| | | /// <param name="repairuser">维修人员</param> |
| | | /// <param name="repairdate">维修时间</param> |
| | | /// <param name="vrifcatuser">验证人员</param> |
| | | /// <param name="vrifcatdate">验证时间</param> |
| | | /// <param name="page">页码</param> |
| | | /// <param name="rows">每页显示条数</param> |
| | | /// <param name="prop">排序字段</param> |
| | | /// <param name="order">排序规则</param> |
| | | /// <returns></returns> |
| | | [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[模具维修记录明细查询] |
| | | /// <summary> |
| | | /// 模具维修记录明细查询 |
| | | /// </summary> |
| | | /// <param name="repair_code">模具维修单号</param> |
| | | /// <returns></returns> |
| | | [Route(template: "MouldUpdateSubSearch")] |
| | | [HttpGet] |
| | | public JsonResult MouldUpdateSubSearch(string repair_code) |
| | | { |
| | | mes = MouldManagerBLL.MouldUpdateSubSearch(repair_code); |
| | | return Json(mes); |
| | | } |
| | | #endregion |
| | | |
| | | #region[模具维修记录导出] |
| | | /// <summary> |
| | | /// 模具维修记录导出 |
| | | /// </summary> |
| | | /// <param name="mouldcode">模具编码</param> |
| | | /// <param name="mouldname">模具名称</param> |
| | | /// <param name="mouldspec">规格型号</param> |
| | | /// <param name="reportuser">报修人员</param> |
| | | /// <param name="reportdate">报修时间</param> |
| | | /// <param name="repairuser">维修人员</param> |
| | | /// <param name="repairdate">维修时间</param> |
| | | /// <param name="vrifcatuser">验证人员</param> |
| | | /// <param name="vrifcatdate">验证时间</param> |
| | | /// <returns></returns> |
| | | [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[模具上下机记录查询] |
| | | /// <summary> |
| | | /// 模具上下机记录查询 |
| | | /// </summary> |
| | | /// <param name="mouldcode">模具编码</param> |
| | | /// <param name="mouldname">模具名称</param> |
| | | /// <param name="mouldspec">规格型号</param> |
| | | /// <param name="type">操作类型(上机:UP 下机:DOWN)</param> |
| | | /// <param name="devicecode">设备编码</param> |
| | | /// <param name="operuser">操作人员</param> |
| | | /// <param name="operdate">操作时间</param> |
| | | /// <param name="page">页码</param> |
| | | /// <param name="rows">每页显示条数</param> |
| | | /// <param name="prop">排序字段</param> |
| | | /// <param name="order">排序规格</param> |
| | | /// <returns></returns> |
| | | [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[模具上下机记导出] |
| | | /// <summary> |
| | | /// 模具上下机记导出 |
| | | /// </summary> |
| | | /// <param name="mouldcode">模具编码</param> |
| | | /// <param name="mouldname">模具名称</param> |
| | | /// <param name="mouldspec">规格型号</param> |
| | | /// <param name="type">操作类型(上机:UP 下机:DOWN)</param> |
| | | /// <param name="devicecode">设备编码</param> |
| | | /// <param name="operuser">操作人员</param> |
| | | /// <param name="operdate">操作时间</param> |
| | | /// <returns></returns> |
| | | [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[模具借还记录查询] |
| | | /// <summary> |
| | | /// 模具借还记录查询 |
| | | /// </summary> |
| | | /// <param name="mouldcode">模具编码</param> |
| | | /// <param name="mouldname">模具名称</param> |
| | | /// <param name="mouldspec">规格型号</param> |
| | | /// <param name="type">操作类型</param> |
| | | /// <param name="operuser">操作人员</param> |
| | | /// <param name="operdate">操作时间</param> |
| | | /// <param name="page">页码</param> |
| | | /// <param name="rows">每页显示条数</param> |
| | | /// <param name="prop">排序字段</param> |
| | | /// <param name="order">排序规格</param> |
| | | /// <returns></returns> |
| | | [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[模具借还记录导出] |
| | | /// <summary> |
| | | /// 模具借还记录导出 |
| | | /// </summary> |
| | | /// <param name="mouldcode">模具编码</param> |
| | | /// <param name="mouldname">模具名称</param> |
| | | /// <param name="mouldspec">规格型号</param> |
| | | /// <param name="type">操作类型</param> |
| | | /// <param name="operuser">操作人员</param> |
| | | /// <param name="operdate">操作时间</param> |
| | | /// <returns></returns> |
| | | [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[模具出入库记录查询] |
| | | /// <summary> |
| | | /// 模具出入库记录查询 |
| | | /// </summary> |
| | | /// <param name="mouldcode">模具编码</param> |
| | | /// <param name="mouldname">模具名称</param> |
| | | /// <param name="mouldspec">规格型号</param> |
| | | /// <param name="type">操作类型(入库:IN 出库:OUT)</param> |
| | | /// <param name="warehousecode">仓库编码</param> |
| | | /// <param name="locationcode">库位编码</param> |
| | | /// <param name="operuser">操作人员</param> |
| | | /// <param name="operdate">操作时间</param> |
| | | /// <param name="page">页码</param> |
| | | /// <param name="rows">每页显示条数</param> |
| | | /// <param name="prop">排序字段</param> |
| | | /// <param name="order">排序规则</param> |
| | | /// <returns></returns> |
| | | [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[模具出入库记录导出] |
| | | /// <summary> |
| | | /// 模具出入库记录导出 |
| | | /// </summary> |
| | | /// <param name="mouldcode">模具编码</param> |
| | | /// <param name="mouldname">模具名称</param> |
| | | /// <param name="mouldspec">规格型号</param> |
| | | /// <param name="type">操作类型(入库:IN 出库:OUT)</param> |
| | | /// <param name="warehousecode">仓库编码</param> |
| | | /// <param name="locationcode">库位编码</param> |
| | | /// <param name="operuser">操作人员</param> |
| | | /// <param name="operdate">操作时间</param> |
| | | /// <returns></returns> |
| | | [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 |
| | | |
| | | } |
| | | } |