| | |
| | | return TJson.toJson(mes); |
| | | } |
| | | #endregion |
| | | |
| | | |
| | | #region[生产进度报表] |
| | | /// <summary> |
| | | /// 生产进度报表 |
| | | /// </summary> |
| | | /// <param name="status">工单状态</param> |
| | | /// <param name="wocode">工单编号</param> |
| | | /// <param name="routecode">工艺路线编码</param> |
| | | /// <param name="routename">工艺路线名称</param> |
| | | /// <param name="partcode">产品编码</param> |
| | | /// <param name="partname">产品名称</param> |
| | | /// <param name="partspec">规格型号</param> |
| | | /// <param name="lm_date">单据日期</param> |
| | | /// <param name="page">页码</param> |
| | | /// <param name="rows">每页显示条数</param> |
| | | /// <param name="prop">排序字段</param> |
| | | /// <param name="order">排序规则</param> |
| | | /// <returns></returns> |
| | | [Route(template: "ProductionScheduleReportSearch")] |
| | | [HttpGet] |
| | | public HttpResponseMessage ProductionScheduleReportSearch(int page, int rows, string prop, string order, string status = null, string wocode = null, string routecode = null, string routename = null, string partcode = null, string partname = null, string partspec = null, string lm_date = null) |
| | | { |
| | | string opendate = ""; //开始时间 |
| | | string closedate = ""; //结束时间 |
| | | if (lm_date != "" && lm_date != null) |
| | | { |
| | | opendate = lm_date.Split('~')[0].ToString(); |
| | | closedate = lm_date.Split('~')[1].ToString(); |
| | | } |
| | | int startNum = rows * (page - 1) + 1; //起始记录rowNum |
| | | int endNum = rows * page; //结束记录 rowNum |
| | | mes = ReportManagerBLL.ProductionScheduleReportSearch(status, wocode, routecode, routename, partcode, partname, partspec, opendate, closedate, startNum, endNum, prop, order); |
| | | return TJson.toJson(mes); |
| | | } |
| | | #endregion |
| | | |
| | | #region[生产进度报表导出] |
| | | /// <summary> |
| | | /// 生产进度报表导出 |
| | | /// </summary> |
| | | /// <param name="status">工单状态</param> |
| | | /// <param name="wocode">工单编号</param> |
| | | /// <param name="routecode">工艺路线编码</param> |
| | | /// <param name="routename">工艺路线名称</param> |
| | | /// <param name="partcode">产品编码</param> |
| | | /// <param name="partname">产品名称</param> |
| | | /// <param name="partspec">规格型号</param> |
| | | /// <param name="lm_date">单据日期</param> |
| | | /// <returns></returns> |
| | | [Route(template: "ProductionScheduleReportExcelSearch")] |
| | | [HttpGet] |
| | | public HttpResponseMessage ProductionScheduleReportExcelSearch(string status = null, string wocode = null, string routecode = null, string routename = null, string partcode = null, string partname = null, string partspec = null, string lm_date = null) |
| | | { |
| | | string opendate = ""; //开始时间 |
| | | string closedate = ""; //结束时间 |
| | | if (lm_date != "" && lm_date != null) |
| | | { |
| | | opendate = lm_date.Split('~')[0].ToString(); |
| | | closedate = lm_date.Split('~')[1].ToString(); |
| | | } |
| | | mes = ReportManagerBLL.ProductionScheduleReportExcelSearch(status, wocode, routecode, routename, partcode, partname, partspec, opendate, closedate); |
| | | return TJson.toJson(mes); |
| | | } |
| | | #endregion |
| | | } |
| | | } |