| | |
| | | public string HCustomerName { get; set; } |
| | | public string HProductName { get; set; } |
| | | public string HOtherSearch { get; set; } |
| | | public string HEmpName { get; set; } |
| | | public string sWheres { get; set; } |
| | | } |
| | | [Route("MaterOutEntryReport/SC_DayRkReport")] |
| | | [HttpGet] |
| | |
| | | DayRkReport DayRkReportList = JsonConvert.DeserializeObject<DayRkReport>(sWhere); |
| | | |
| | | string sql = $"exec h_p_Gy_DayRkReport '{DayRkReportList.HBeginDate}','{DayRkReportList.HEndDate}','{DayRkReportList.HMaterNumber}'" + |
| | | $",'{DayRkReportList.HProductName}','{DayRkReportList.HCustomerName}','{DayRkReportList.HOtherSearch}'"; |
| | | $",'{DayRkReportList.HProductName}','{DayRkReportList.HCustomerName}','{DayRkReportList.HOtherSearch}','{DayRkReportList.HEmpName}','{DayRkReportList.sWheres}'"; |
| | | //string sql = $"exec h_p_Gy_DayRkReport '{DayRkReportList.HBeginDate}','{DayRkReportList.HEndDate}','{DayRkReportList.HMaterNumber}'" + |
| | | // $",'{DayRkReportList.HProductName}','{DayRkReportList.HCustomerName}'"; |
| | | |