| | |
| | | { |
| | | [RoutePrefix(prefix: "api/ReportManager")] |
| | | [ControllerGroup("报表管理", "在线接口")] |
| | | //[ChannelActionFilter] |
| | | [ChannelActionFilter] |
| | | public class ReportManagerController : ApiController |
| | | { |
| | | //定义全局信息返回变量 |
| | |
| | | /// <param name="groupcode">生产班组</param> |
| | | /// <param name="username">操作人员</param> |
| | | /// <param name="operdate">操作时间</param> |
| | | /// <param name="rejectstepcode">剔除工序(固定薪资工序不参与计算)</param> |
| | | /// <param name="page">页码</param> |
| | | /// <param name="rows">每页显示条数</param> |
| | | /// <param name="prop">排序字段</param> |
| | |
| | | /// <returns></returns> |
| | | [Route(template: "GroupSalaryReportSearch")] |
| | | [HttpGet] |
| | | public HttpResponseMessage GroupSalaryReportSearch(int page, int rows, string prop, string order,string compute, string wocode = null, string partcode = null, string partname = null, string partspec = null, string stepname = null, string groupcode = null, string username = null, string operdate = null) |
| | | public HttpResponseMessage GroupSalaryReportSearch(int page, int rows, string prop, string order,string compute, string wocode = null, string partcode = null, string partname = null, string partspec = null, string stepname = null, string groupcode = null, string username = null, string operdate = null,string rejectstepcode=null) |
| | | { |
| | | string operopendate = ""; //报工开始时间 |
| | | string operclosedate = ""; //报工结束时间 |
| | |
| | | } |
| | | int startNum = rows * (page - 1) + 1; //起始记录rowNum |
| | | int endNum = rows * page; //结束记录 rowNum |
| | | mes = ReportManagerBLL.GroupSalaryReportSearch(compute,wocode, partcode, partname, partspec, stepname, groupcode, username, operopendate, operclosedate, startNum, endNum, prop, order); |
| | | mes = ReportManagerBLL.GroupSalaryReportSearch(compute,wocode, partcode, partname, partspec, stepname, groupcode, username, operopendate, operclosedate, rejectstepcode, startNum, endNum, prop, order); |
| | | return TJson.toJson(mes); |
| | | } |
| | | #endregion |
| | |
| | | /// <param name="groupcode">生产班组</param> |
| | | /// <param name="username">操作人员</param> |
| | | /// <param name="operdate">操作时间</param> |
| | | /// <param name="rejectstepcode">剔除工序(固定薪资工序不参与计算)</param> |
| | | /// <returns></returns> |
| | | [Route(template: "GroupSalaryReportExcelSearch")] |
| | | [HttpGet] |
| | | public HttpResponseMessage GroupSalaryReportExcelSearch(string compute, string wocode = null, string partcode = null, string partname = null, string partspec = null, string stepname = null, string groupcode = null, string username = null, string operdate = null) |
| | | public HttpResponseMessage GroupSalaryReportExcelSearch(string compute, string wocode = null, string partcode = null, string partname = null, string partspec = null, string stepname = null, string groupcode = null, string username = null, string operdate = null,string rejectstepcode=null) |
| | | { |
| | | string operopendate = ""; //报工开始时间 |
| | | string operclosedate = ""; //报工结束时间 |
| | |
| | | operopendate = operdate.Split('~')[0].ToString(); |
| | | operclosedate = operdate.Split('~')[1].ToString(); |
| | | } |
| | | mes = ReportManagerBLL.GroupSalaryReportExcelSearch(compute,wocode, partcode, partname, partspec, stepname, groupcode, username, operopendate, operclosedate); |
| | | mes = ReportManagerBLL.GroupSalaryReportExcelSearch(compute,wocode, partcode, partname, partspec, stepname, groupcode, username, operopendate, operclosedate, rejectstepcode); |
| | | return TJson.toJson(mes); |
| | | } |
| | | #endregion |
| | |
| | | /// <param name="groupcode">生产班组</param> |
| | | /// <param name="reportname">报工人员</param> |
| | | /// <param name="reportdate">报工时间</param> |
| | | /// <param name = "rejectstepcode" > 剔除工序(固定薪资工序不参与计算) </param > |
| | | /// <param name="page">页码</param> |
| | | /// <param name="rows">每页显示条数</param> |
| | | /// <param name="prop">排序字段</param> |
| | |
| | | /// <returns></returns> |
| | | [Route(template: "PeopleSalaryReportSearch")] |
| | | [HttpGet] |
| | | public HttpResponseMessage PeopleSalaryReportSearch(int page, int rows, string prop, string order,string compute, string wocode = null, string partcode = null, string partname = null, string partspec = null, string stepname = null, string groupcode = null, string reportname = null, string reportdate = null) |
| | | public HttpResponseMessage PeopleSalaryReportSearch(int page, int rows, string prop, string order,string compute, string wocode = null, string partcode = null, string partname = null, string partspec = null, string stepname = null, string groupcode = null, string reportname = null, string reportdate = null,string rejectstepcode=null) |
| | | { |
| | | string reportopendate = ""; //报工开始时间 |
| | | string reportclosedate = ""; //报工结束时间 |
| | |
| | | } |
| | | int startNum = rows * (page - 1) + 1; //起始记录rowNum |
| | | int endNum = rows * page; //结束记录 rowNum |
| | | mes = ReportManagerBLL.PeopleSalaryReportSearch(compute,wocode, partcode, partname, partspec, stepname, groupcode, reportname, reportopendate, reportclosedate, startNum, endNum, prop, order); |
| | | mes = ReportManagerBLL.PeopleSalaryReportSearch(compute,wocode, partcode, partname, partspec, stepname, groupcode, reportname, reportopendate, reportclosedate, rejectstepcode, startNum, endNum, prop, order); |
| | | return TJson.toJson(mes); |
| | | } |
| | | #endregion |
| | |
| | | /// <param name="groupcode">生产班组</param> |
| | | /// <param name="reportname">报工人员</param> |
| | | /// <param name="reportdate">报工时间</param> |
| | | /// <param name = "rejectstepcode" > 剔除工序(固定薪资工序不参与计算) </param > |
| | | /// <returns></returns> |
| | | [Route(template: "PeopleSalaryReportExcelSearch")] |
| | | [HttpGet] |
| | | public HttpResponseMessage PeopleSalaryReportExcelSearch(string compute, string wocode = null, string partcode = null, string partname = null, string partspec = null, string stepname = null, string groupcode = null, string reportname = null, string reportdate = null) |
| | | public HttpResponseMessage PeopleSalaryReportExcelSearch(string compute, string wocode = null, string partcode = null, string partname = null, string partspec = null, string stepname = null, string groupcode = null, string reportname = null, string reportdate = null,string rejectstepcode=null) |
| | | { |
| | | string reportopendate = ""; //报工开始时间 |
| | | string reportclosedate = ""; //报工结束时间 |
| | |
| | | reportopendate = reportdate.Split('~')[0].ToString(); |
| | | reportclosedate = reportdate.Split('~')[1].ToString(); |
| | | } |
| | | mes = ReportManagerBLL.PeopleSalaryReportExcelSearch(compute,wocode, partcode, partname, partspec, stepname, groupcode, reportname, reportopendate, reportclosedate); |
| | | mes = ReportManagerBLL.PeopleSalaryReportExcelSearch(compute,wocode, partcode, partname, partspec, stepname, groupcode, reportname, reportopendate, reportclosedate, rejectstepcode); |
| | | return TJson.toJson(mes); |
| | | } |
| | | #endregion |
| | |
| | | return TJson.toJson(mes); |
| | | } |
| | | #endregion |
| | | |
| | | |
| | | |
| | | #region[物流检验记录查询] |
| | | /// <summary> |
| | | /// 物流检验记录查询 |
| | | /// </summary> |
| | | /// <param name="page">页码</param> |
| | | /// <param name="rows">每页显示数据条数</param> |
| | | /// <param name="prop">排序字段</param> |
| | | /// <param name="order">排序规则</param> |
| | | /// <param name="checktypecode">检验类型编码</param> |
| | | /// <param name="partcode">物料编码</param> |
| | | /// <param name="partname">物料名称</param> |
| | | /// <param name="partspec">规格型号</param> |
| | | /// <param name="labcode">条码编号</param> |
| | | /// <param name="customercode">往来单位编码</param> |
| | | /// <param name="batchno">批次条码</param> |
| | | /// <param name="checkuser">检验人员</param> |
| | | /// <param name="checkdate">检验时间</param> |
| | | /// <returns></returns> |
| | | [Route(template: "LogisticsCheckSearch")] |
| | | [HttpGet] |
| | | public HttpResponseMessage LogisticsCheckSearch(int page, int rows, string prop, string order, string checktypecode = null, string partcode = null, string partname = null, string partspec = null, string labcode = null,string customercode=null,string batchno=null,string checkuser=null,string checkdate=null) |
| | | { |
| | | string opencheckdate = ""; //响应开始时间 |
| | | string closecheckdate = ""; //响应结束时间 |
| | | if (checkdate != "" && checkdate != null) |
| | | { |
| | | opencheckdate = checkdate.Split('~')[0].ToString(); |
| | | closecheckdate = checkdate.Split('~')[1].ToString(); |
| | | } |
| | | int startNum = rows * (page - 1) + 1; //起始记录rowNum |
| | | int endNum = rows * page; //结束记录 rowNum |
| | | mes = ReportManagerBLL.LogisticsCheckSearch(checktypecode,partcode,partname,partspec,labcode,customercode,batchno,checkuser, opencheckdate, closecheckdate, startNum, endNum, prop, order); |
| | | return TJson.toJson(mes); |
| | | } |
| | | #endregion |
| | | |
| | | #region[物流检验,查看检验明细] |
| | | /// <summary> |
| | | /// 物流检验,查看检验明细 |
| | | /// </summary> |
| | | /// <param name="checkid">检验记录ID</param> |
| | | /// <returns></returns> |
| | | [Route(template: "LogisticsCheckSubSearch")] |
| | | [HttpGet] |
| | | public HttpResponseMessage LogisticsCheckSubSearch(string checkid) |
| | | { |
| | | mes = ReportManagerBLL.LogisticsCheckSubSearch(checkid); |
| | | return TJson.toJson(mes); |
| | | } |
| | | #endregion |
| | | } |
| | | } |