| New file |
| | |
|---|
| | | using DBUtility; |
|---|
| | | using Newtonsoft.Json; |
|---|
| | | using Newtonsoft.Json.Linq; |
|---|
| | | using System; |
|---|
| | | using System.Collections.Generic; |
|---|
| | | using System.Data; |
|---|
| | | using System.Linq; |
|---|
| | | using System.Net; |
|---|
| | | using System.Net.Http; |
|---|
| | | using System.Web.Http; |
|---|
| | | using WebAPI.Models; |
|---|
| | | |
|---|
| | | namespace WebAPI.Controllers.CJGL |
|---|
| | | { |
|---|
| | | public class ProductionPlanReportController : ApiController |
|---|
| | | { |
|---|
| | | public DBUtility.ClsPub.Enum_BillStatus BillStatus; |
|---|
| | | private json objJsonResult = new json(); |
|---|
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
|---|
| | | DataSet ds; |
|---|
| | | |
|---|
| | | #region 投产计划报表 查询 |
|---|
| | | public class ProductionPlanReport |
|---|
| | | { |
|---|
| | | public int HOrgID; |
|---|
| | | public DateTime HBeginDate; |
|---|
| | | public DateTime HEndDate; |
|---|
| | | public string HICMOBillNo; |
|---|
| | | public string HWorkShopID; |
|---|
| | | public string HSeOrderBillNo; |
|---|
| | | public string HMaterNumber; |
|---|
| | | } |
|---|
| | | [Route("ProductionPlanReport/ProductionPlanReportList")] |
|---|
| | | [HttpGet] |
|---|
| | | public object ProductionPlanReportList(string sWhere) |
|---|
| | | { |
|---|
| | | try |
|---|
| | | { |
|---|
| | | //反序列化传递的值 |
|---|
| | | ProductionPlanReport com = JsonConvert.DeserializeObject<ProductionPlanReport>(sWhere.ToString()); |
|---|
| | | |
|---|
| | | ds = oCN.RunProcReturn($"exec h_p_Cj_ProductionPlanReportList {com.HOrgID},'{com.HBeginDate}','{com.HEndDate}'" + |
|---|
| | | $",'{com.HICMOBillNo}',{com.HWorkShopID},'{com.HSeOrderBillNo}','{com.HMaterNumber}'", "h_p_Cj_ProductionPlanReportList"); |
|---|
| | | |
|---|
| | | objJsonResult.code = "1"; |
|---|
| | | objJsonResult.count = 1; |
|---|
| | | objJsonResult.Message = "Sucess！"; |
|---|
| | | objJsonResult.data = ds.Tables[0]; |
|---|
| | | return objJsonResult; |
|---|
| | | } |
|---|
| | | catch (Exception e) |
|---|
| | | { |
|---|
| | | objJsonResult.code = "0"; |
|---|
| | | objJsonResult.count = 0; |
|---|
| | | objJsonResult.Message = "Exception！" + e.ToString(); |
|---|
| | | objJsonResult.data = null; |
|---|
| | | return objJsonResult; |
|---|
| | | } |
|---|
| | | } |
|---|
| | | #endregion |
|---|
| | | } |
|---|
| | | } |
|---|
