Merge branch 'master' of http://101.37.171.70:10101/r/MES-WEB-API
| | |
| | | |
| | | long HWorkCenterID = list[0].HWorkCenterID; //å·¥ä½ä¸å¿ |
| | | |
| | | long HBadWHID = list[0].HBadWHID; //ä¸è¯ä»åº |
| | | long HWasterWHID = list[0].HWasterWHID; //æ¥åºä»åº |
| | | long HBadCountDevelopWHID = list[0].HBadCountDevelopWHID; //ç åä¸è¯åä»åº |
| | | long HWWBadWHID = list[0].HWWBadWHID; //å§å¤ä¸è¯ä»åº |
| | | long HWWWasterWHID = list[0].HWWWasterWHID; //å§å¤æ¥åºä»åº |
| | | long HWHID = list[0].HWHID; //è¯åä»åº |
| | | |
| | | |
| | | //夿æé |
| | | //if (!ClsPub.Security_Log("Gy_Process_Edit", 1, false, msg3)) |
| | |
| | | ",HTypeFlow,HTypeCount,HDeptNumber,HSNo" + |
| | | ",HLevel,HEndFlag,HStopflag,HRemark,HDeptID,HBarCodeForBase,HProcessID_K3,HBillSubType,HAutoTrunFlag" + |
| | | ",HFixPrice,HOverFixPrice,HProcMulID,HProcCheckNote" + |
| | | ",HUSEORGID,HWorkCenterID) " + |
| | | ",HUSEORGID,HWorkCenterID,HBadWHID,HWasterWHID,HBadCountDevelopWHID,HWWBadWHID,HWWWasterWHID,HWHID) " + |
| | | " Values('" + HNumber + "','" + HName + "','" + HHelpCode + "','" + HShortNumber + "'," + HParentID.ToString() + |
| | | "," + Convert.ToString(HTypeFlow ? 1 : 0) + "," + Convert.ToString(HTypeCount ? 1 : 0) + ",'" + HDeptNumber + "','" + HSNo.ToString() + |
| | | "'," + HLevel.ToString() + "," + Convert.ToString(HEndFlag ? 1 : 0) + "," + Convert.ToString(HStopflag ? 1 : 0) + ",'" + HRemark + "'," + HDeptID + |
| | | ",'" + HBarCode + "'," + HProcessID_K3 + ",'" +HBillSubType + "'," + Convert.ToString(HAutoTrunFlag ? 1 : 0) + |
| | | ",'" + HFixPrice.ToString() + "'," + HOverFixPrice.ToString() + "," + HProcMulID.ToString() + ",'" + HProcCheckNote.ToString() + "'" + |
| | | ","+ HUSEORGID + "," + HWorkCenterID + ")", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | ","+ HUSEORGID + "," + HWorkCenterID + "," + HBadWHID + "," + HWasterWHID + "," + HBadCountDevelopWHID + "," + HWWBadWHID + "," + HWWWasterWHID + "," + HWHID + ")", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | //ä¿®æ¹ä¸çº§ä¸ºéæ«çº§ä»£ç |
| | | oCN.RunProc("Update Gy_Process set HEndflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | oCN.Commit(); |
| | |
| | | ",HOverFixPrice= " + HOverFixPrice + |
| | | ",HProcMulID= " + HProcMulID + |
| | | ",HWorkCenterID= " + HWorkCenterID + |
| | | ",HBadWHID= " + HBadWHID + |
| | | ",HWasterWHID= " + HWasterWHID + |
| | | ",HBadCountDevelopWHID= " + HBadCountDevelopWHID + |
| | | ",HWWBadWHID= " + HWWBadWHID + |
| | | ",HWWWasterWHID= " + HWWWasterWHID + |
| | | ",HWHID= " + HWHID + |
| | | ",HProcCheckNote='" + HProcCheckNote + "' Where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | //ä¿®æ¹ä¸çº§ä¸ºéæ«çº§ä»£ç |
| | | oCN.RunProc("Update Gy_Process set HEndflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo); |
| | |
| | | using Newtonsoft.Json.Linq; |
| | | using Newtonsoft.Json; |
| | | using Newtonsoft.Json.Linq; |
| | | using Pub_Class; |
| | | using System; |
| | | using System.Collections; |
| | |
| | | { |
| | | try |
| | | { |
| | | List<object> columnNameList = new List<object>(); |
| | | //夿æ¯å¦ææ¥è¯¢æé |
| | | if (!DBUtility.ClsPub.Security_Log("MES_StationEntrustInBill_Query", 1, false, user)) |
| | | { |
| | |
| | | ds = oCN.RunProcReturn(sql, "h_v_MES_StationEntrustInBillList"); |
| | | } |
| | | |
| | | //æ·»å åå |
| | | foreach (DataColumn col in ds.Tables[0].Columns) |
| | | { |
| | | Type dataType = col.DataType; |
| | | string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}"; |
| | | columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//è·åå°DataColumnå对象çåå |
| | | } |
| | | |
| | | //if (ds.Tables[0].Rows.Count != 0 || ds != null) |
| | | //{ |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "Sucessï¼"; |
| | | objJsonResult.list = columnNameList; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | return objJsonResult; |
| | | //} |
| | |
| | | string HBarCode = list[0].HBarCode;//æ¡å½¢ç |
| | | string HAddr = ""; |
| | | string HBarCodeMaker = ""; |
| | | long HPRDOrgID = list[0].HPRDOrgID;//ç»ç»ID |
| | | if (HProcExchInterID <= 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | |
| | | ",HProcExchBillNo,HMaterID,HProcID,HICMOQty,HPlanQty,HStationInTime,HSourceID" + |
| | | ",HGroupID,HDeptID,HEmpID,HBarCode,HAddr,HBarCodeMaker,HBarCodeMakeDate" + |
| | | ",HSupID,HTaxRate,HQty,HPrice,HMoney,HPieceQty" + |
| | | ",HProcNo,HOrderProcNO,HWWWorkOrderBillNo,HWWWorkOrderInterID,HWWWorkOrderEntryID,HMainInterID" + |
| | | ",HProcNo,HOrderProcNO,HWWWorkOrderBillNo,HWWWorkOrderInterID,HWWWorkOrderEntryID,HMainInterID,HPRDOrgID" + |
| | | ") " + |
| | | " values('3792','3792'," + HInterID.ToString() + ",'" + HBillNo + "','" + HBillStatus.ToString() + "',getdate(),'" + HMaker + "',getdate()" + |
| | | ",'" + HYear.ToString() + "','" + HPeriod.ToString() + "','" + HRemark + "','" + HInnerBillNo + "'" + |
| | |
| | | ",'" + HProcExchBillNo + "'," + HMaterID + "," + HProcID + "," + HICMOQty + "," + HPlanQty + ",getdate()," + HSourceID + |
| | | "," + HGroupID + "," + HDeptID + "," + HEmpID + ",'" + HBarCode + "','" + HAddr + "','" + HBarCodeMaker + "',getdate()" + |
| | | "," + HSupID + "," + HTaxRate + "," + HQty + "," + HPrice + "," + HMoney + "," + HPieceQty + |
| | | ",'" + HProcNo + "','" + HOrderProcNO + "'" + ",'" + HWWWorkOrderBillNo + "'" + "," + HWWWorkOrderInterID + "" + "," + HWWWorkOrderEntryID + "," + HMainInterID + |
| | | ",'" + HProcNo + "','" + HOrderProcNO + "'" + ",'" + HWWWorkOrderBillNo + "'" + "," + HWWWorkOrderInterID + "" + "," + HWWWorkOrderEntryID + "," + HMainInterID + "," + HPRDOrgID + |
| | | ") "); |
| | | } |
| | | else if ("Modify".Equals(eventType)) |
| | |
| | | using Newtonsoft.Json.Linq; |
| | | using Newtonsoft.Json; |
| | | using Newtonsoft.Json.Linq; |
| | | using Pub_Class; |
| | | using System; |
| | | using System.Collections; |
| | |
| | | { |
| | | try |
| | | { |
| | | List<object> columnNameList = new List<object>(); |
| | | //夿æ¯å¦ææ¥è¯¢æé |
| | | if (!DBUtility.ClsPub.Security_Log("MES_StationEntrustOutBill_Query", 1, false, user)) |
| | | { |
| | |
| | | ds = oCN.RunProcReturn(sql, "h_v_MES_StationEntrustOutBillList"); |
| | | } |
| | | |
| | | //æ·»å åå |
| | | foreach (DataColumn col in ds.Tables[0].Columns) |
| | | { |
| | | Type dataType = col.DataType; |
| | | string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}"; |
| | | columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//è·åå°DataColumnå对象çåå |
| | | } |
| | | |
| | | |
| | | //if (ds.Tables[0].Rows.Count != 0 || ds != null) |
| | | //{ |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "Sucessï¼"; |
| | | objJsonResult.list = columnNameList; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | return objJsonResult; |
| | | //} |
| | |
| | | double HMainSourceInterID = 0; |
| | | string HMainSourceBillNo = ""; |
| | | string HMainSourceBillType = "3792"; |
| | | long HPRDOrgID = list[0].HPRDOrgID;//ç»ç»ID |
| | | if (HProcExchInterID <= 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | |
| | | ",HProcExchBillNo,HMaterID,HProcID,HICMOQty,HPlanQty,HStationOutTime,HSourceID" + |
| | | ",HGroupID,HDeptID,HEmpID,HBarCode,HAddr,HBarCodeMaker,HBarCodeMakeDate" + |
| | | ",HSupID,HTaxRate,HQty,HPrice,HMoney,HPrice_BHS,HMoney_BHS,HBadCount" + |
| | | ",HMainSourceInterID,HMainSourceBillNo,HMainSourceBillType,HProcNo,HOrderProcNO,HLastSubProc,HWWWorkOrderBillNo,HWWWorkOrderInterID,HWWWorkOrderEntryID,HMainInterID" + |
| | | ",HMainSourceInterID,HMainSourceBillNo,HMainSourceBillType,HProcNo,HOrderProcNO,HLastSubProc,HWWWorkOrderBillNo,HWWWorkOrderInterID,HWWWorkOrderEntryID,HMainInterID,HPRDOrgID" + |
| | | ") " + |
| | | " values('" + BillType + "','" + BillType + "'," + HInterID + ",'" + HBillNo + "'," + HBillStatus + ",getdate(),'" + HMaker + "',getdate()" + |
| | | "," + HYear + "," + HPeriod + ",'" + HRemark + "','" + HInnerBillNo + "','" + HSourceName + "'," + HPieceQty + "," + HWasterQty + "," + HPlanPieceQty + "," + HBadPNL + |
| | |
| | | ",'" + HProcExchBillNo + "'," + HMaterID + "," + HProcID + "," + HICMOQty + "," + HPlanQty + ",getdate()," + HSourceID + |
| | | "," + HGroupID + "," + HDeptID + "," + HEmpID + ",'" + HBarCode + "','" + HAddr + "','" + HBarCodeMaker + "',getdate()" + |
| | | "," + HSupID + "," + HTaxRate + "," + HQty + "," + HPrice + "," + HMoney + "," + HPrice_BHS + "," + HMoney_BHS + "," + HBadCount + |
| | | "," + HMainSourceInterID + ",'" + HMainSourceBillNo + "','" + HMainSourceBillType + "'," + HProcNo + ",'" + HOrderProcNO + "'," + Convert.ToString(HLastSubProc ? 1 : 0) + ",'" + HWWWorkOrderBillNo + "'," + HWWWorkOrderInterID + "," + HWWWorkOrderEntryID + "," + HMainInterID + |
| | | "," + HMainSourceInterID + ",'" + HMainSourceBillNo + "','" + HMainSourceBillType + "'," + HProcNo + ",'" + HOrderProcNO + "'," + Convert.ToString(HLastSubProc ? 1 : 0) + ",'" + HWWWorkOrderBillNo + "'," + HWWWorkOrderInterID + "," + HWWWorkOrderEntryID + "," + HMainInterID + "," + HPRDOrgID + |
| | | ") "); |
| | | } |
| | | else if ("Modify".Equals(eventType)) |
| | |
| | | using Newtonsoft.Json.Linq; |
| | | using Newtonsoft.Json; |
| | | using Newtonsoft.Json.Linq; |
| | | using Pub_Class; |
| | | using System; |
| | | using System.Collections; |
| | |
| | | string HSourceName = list[0].HSourceName;//çäº§èµæºåç§° |
| | | long HCenterID = list[0].HCenterID;//å·¥ä½ä¸å¿ID |
| | | string HOrderProcNO = list[0].HOrderProcNO;//订åè·è¸ªå· |
| | | long HPRDOrgID = list[0].HPRDOrgID;//ç»ç»ID |
| | | //忮宿´æ§å¤æ |
| | | if (HMaterID <= 0) |
| | | { |
| | |
| | | ",HProcExchBillNo,HMaterID,HProcID,HICMOQty,HPlanQty,HStationInTime,HSourceID" + |
| | | ",HGroupID,HDeptID,HEmpID,HBarCode,HAddr,HBarCodeMaker,HBarCodeMakeDate" + |
| | | ",HSupID,HQty,HPrice,HMoney,HPieceQty,HSourceName,HCenterID" + |
| | | ",HProcNo,HOrderProcNO,HMainInterID" + |
| | | ",HProcNo,HOrderProcNO,HMainInterID,HPRDOrgID" + |
| | | ") " + |
| | | " values('" + BillType + "','" + BillType + "'," + HInterID + ",'" + HBillNo + "'," + HBillStatus + ",getdate(),'" + HMaker + "',getdate()" + |
| | | "," + HYear + "," + HPeriod + ",'" + HRemark + "'" + |
| | |
| | | ",'" + HProcExchBillNo + "'," + HMaterID + "," + HProcID + "," + HICMOQty + "," + HPlanQty + ",getdate()," + HSourceID + |
| | | "," + HGroupID + "," + HDeptID + "," + HEmpID + ",'" + HBarCode + "','" + HAddr + "','" + HBarCodeMaker + "',getdate()" + |
| | | "," + HSupID + "," + HQty + "," + HPrice + "," + HMoney + "," + HPieceQty + ",'" + HSourceName + "'," + HCenterID + |
| | | ",'" + HProcNo + "','" + HOrderProcNO + "'," + HMainInterID + |
| | | ",'" + HProcNo + "','" + HOrderProcNO + "','" + HMainInterID + "'," + HPRDOrgID + |
| | | ") "); |
| | | } |
| | | else if ("Modify".Equals(eventType)) |
| | |
| | | { |
| | | try |
| | | { |
| | | List<object> columnNameList = new List<object>(); |
| | | //夿æ¯å¦ææ¥è¯¢æé |
| | | if (!DBUtility.ClsPub.Security_Log("Cj_StationInBill_Query", 1, false, user)) |
| | | { |
| | |
| | | ds = oCN.RunProcReturn(sql, "h_v_MES_StationInBillList"); |
| | | } |
| | | |
| | | //æ·»å åå |
| | | foreach (DataColumn col in ds.Tables[0].Columns) |
| | | { |
| | | Type dataType = col.DataType; |
| | | string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}"; |
| | | columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//è·åå°DataColumnå对象çåå |
| | | } |
| | | |
| | | //if (ds.Tables[0].Rows.Count != 0 || ds != null) |
| | | //{ |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "Sucessï¼"; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | objJsonResult.list = columnNameList; |
| | | return objJsonResult; |
| | | //} |
| | | //else |
| | |
| | | using Newtonsoft.Json.Linq; |
| | | using Newtonsoft.Json; |
| | | using Newtonsoft.Json.Linq; |
| | | using Pub_Class; |
| | | using System; |
| | | using System.Collections; |
| | |
| | | double HPriceRate = list[0].HPriceRate;//ç³»æ° |
| | | double HWorkTimes = list[0].HWorkTimes;//å·¥æ¶ |
| | | long HQCCheckID = list[0].HQCCheckID;//æ£éªåID |
| | | long HPRDOrgID = list[0].HPRDOrgID;//ç»ç»ID |
| | | //忮宿´æ§å¤æ |
| | | if (HProcExchInterID <= 0) |
| | | { |
| | |
| | | ",HGroupID,HDeptID,HEmpID,HBarCode,HAddr,HBarCodeMaker,HBarCodeMakeDate,HSourceID2,HSourceID3,HSourceID4,HSourceID5" + |
| | | ",HSupID,HQty,HPrice,HMoney,HBadCount,HCenterID,HProcNo,HOrderProcNO,HSourceNameList" + |
| | | ",HMainSourceInterID,HMainSourceBillNo,HMainSourceBillType,HLastSubProc" + |
| | | ",HEmpID2,HEmpID3,HEmpID4,HEmpID5,HDSQty,HChongQty,HPriceRate,HWorkTimes,HQCCheckID,HMainInterID" + |
| | | ",HEmpID2,HEmpID3,HEmpID4,HEmpID5,HDSQty,HChongQty,HPriceRate,HWorkTimes,HQCCheckID,HMainInterID,HPRDOrgID" + |
| | | ") " + |
| | | " values('" + BillType + "','" + HBillSubType + "'," + HInterID + ",'" + HBillNo + "'," + HBillStatus + ",getdate(),'" + HMaker + "',getdate(),'" + HMouldNum + "'" + |
| | | "," + HYear + "," + HPeriod + ",'" + HRemark + "','" + HSourceName + "'," + HPieceQty + "," + HWasterQty + "," + HPlanPieceQty + "," + HBadPNL + |
| | |
| | | "," + HGroupID + "," + HDeptID + "," + HEmpID + ",'" + HBarCode + "','" + HAddr + "','" + HBarCodeMaker + "',getdate()" + "," + HSourceID2 + "," + HSourceID3 + "," + HSourceID4 + "," + HSourceID5 + |
| | | "," + HSupID + "," + HQty + "," + HPrice + "," + HMoney + "," + HBadCount + "," + HCenterID + "," + HProcNo + ",'" + HOrderProcNO + "'" + ",'" + HSourceNameList + "'" + |
| | | "," + HMainSourceInterID + ",'" + HMainSourceBillNo + "','" + HMainSourceBillType + "'," + Convert.ToString(HLastSubProc ? 1 : 0) + |
| | | "," + HEmpID2 + "," + HEmpID3 + "," + HEmpID4 + "," + HEmpID5 + "," + HDSQty + "," + HChongQty + "," + HPriceRate + "," + HWorkTimes + "," + HQCCheckID + "," + HMainInterID + |
| | | "," + HEmpID2 + "," + HEmpID3 + "," + HEmpID4 + "," + HEmpID5 + "," + HDSQty + "," + HChongQty + "," + HPriceRate + "," + HWorkTimes + "," + HQCCheckID + "," + HMainInterID + "," + HPRDOrgID + |
| | | ") "); |
| | | } |
| | | else if ("Modify".Equals(eventType)) |
| | |
| | | { |
| | | try |
| | | { |
| | | List<object> columnNameList = new List<object>(); |
| | | //夿æ¯å¦ææ¥è¯¢æé |
| | | if (!DBUtility.ClsPub.Security_Log("Cj_StationOutBill_Query", 1, false, user)) |
| | | { |
| | |
| | | ds = oCN.RunProcReturn(sql, "h_v_MES_StationOutBillList"); |
| | | } |
| | | |
| | | //æ·»å åå |
| | | foreach (DataColumn col in ds.Tables[0].Columns) |
| | | { |
| | | Type dataType = col.DataType; |
| | | string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}"; |
| | | columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//è·åå°DataColumnå对象çåå |
| | | } |
| | | |
| | | //if (ds.Tables[0].Rows.Count != 0 || ds != null) |
| | | //{ |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "Sucessï¼"; |
| | | objJsonResult.list = columnNameList; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | return objJsonResult; |
| | | //} |
| | |
| | | { |
| | | return YqnQbService.DeleteProcess(hItemId); |
| | | } |
| | | /// <summary> |
| | | /// è·åä¸è¯ä»åº |
| | | /// </summary> |
| | | /// <param name="sWhere"></param> |
| | | /// <returns></returns> |
| | | [Route("api/newBill/getBadWHList")] |
| | | [HttpGet] |
| | | public ApiResult<DataSet> GetBadWHList(string sWhere) |
| | | { |
| | | return YqnQbService.GetBadWHList(sWhere); |
| | | } |
| | | /// <summary> |
| | | /// è·åæ¥åºä»åº |
| | | /// </summary> |
| | | /// <param name="sWhere"></param> |
| | | /// <returns></returns> |
| | | [Route("api/newBill/getWasterWHList")] |
| | | [HttpGet] |
| | | public ApiResult<DataSet> GetWasterWHList(string sWhere) |
| | | { |
| | | return YqnQbService.GetWasterWHList(sWhere); |
| | | } |
| | | /// <summary> |
| | | /// è·åç åä¸è¯åä»åº |
| | | /// </summary> |
| | | /// <param name="sWhere"></param> |
| | | /// <returns></returns> |
| | | [Route("api/newBill/getBadCountDevelopWHList")] |
| | | [HttpGet] |
| | | public ApiResult<DataSet> GetBadCountDevelopWHList(string sWhere) |
| | | { |
| | | return YqnQbService.GetBadCountDevelopWHList(sWhere); |
| | | } |
| | | /// <summary> |
| | | /// è·åå§å¤ä¸è¯ä»åº |
| | | /// </summary> |
| | | /// <param name="sWhere"></param> |
| | | /// <returns></returns> |
| | | [Route("api/newBill/getWWBadWHList")] |
| | | [HttpGet] |
| | | public ApiResult<DataSet> GetWWBadWHList(string sWhere) |
| | | { |
| | | return YqnQbService.GetWWBadWHList(sWhere); |
| | | } |
| | | /// <summary> |
| | | /// è·åå§å¤æ¥åºä»åº |
| | | /// </summary> |
| | | /// <param name="sWhere"></param> |
| | | /// <returns></returns> |
| | | [Route("api/newBill/getWWWasterWHList")] |
| | | [HttpGet] |
| | | public ApiResult<DataSet> GetWWWasterWHList(string sWhere) |
| | | { |
| | | return YqnQbService.GetWWWasterWHList(sWhere); |
| | | } |
| | | /// <summary> |
| | | /// è·åè¯åä»åº |
| | | /// </summary> |
| | | /// <param name="sWhere"></param> |
| | | /// <returns></returns> |
| | | [Route("api/newBill/getWHList")] |
| | | [HttpGet] |
| | | public ApiResult<DataSet> GetWHList(string sWhere) |
| | | { |
| | | return YqnQbService.GetWHList(sWhere); |
| | | } |
| | | } |
| | | } |
| | |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | /// <summary> |
| | | /// è·åæµæ°´å·å表 |
| | | /// </summary> |
| | | /// <param name="HInterID"></param> |
| | | /// <returns></returns> |
| | | [Route("Web/GetProcNoList")] |
| | | [HttpGet] |
| | | public object GetProcNoList(int HInterID,string sWhere) |
| | | { |
| | | List<object> columnNameList = new List<object>(); |
| | | try |
| | | { |
| | | ds = oCN.RunProcReturn("exec h_p_Sc_ProcNoList '" + HInterID + "','" + sWhere + "'", "h_p_Sc_ProcNoList"); |
| | | |
| | | 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 = e.Message.ToString(); |
| | | objJsonResult.data = null; |
| | | objJsonResult.list = columnNameList; |
| | | } |
| | | return objJsonResult; |
| | | } |
| | | |
| | | } |
| | | |
| | | } |
| | |
| | | public long HProcPlanEntryID { get; set; } |
| | | public string eventType { get; set; } |
| | | public long HMainInterID { get; set; } |
| | | |
| | | public long HPRDOrgID { get; set; } |
| | | } |
| | | } |
| | |
| | | public string HBarCodeForBase { get; set; } |
| | | |
| | | public long HWorkCenterID { get; set; } |
| | | public long HBadWHID { get; set; } |
| | | public long HWasterWHID { get; set; } |
| | | public long HBadCountDevelopWHID { get; set; } |
| | | public long HWWBadWHID { get; set; } |
| | | public long HWWWasterWHID { get; set; } |
| | | public long HWHID { get; set; } |
| | | } |
| | | } |
| | |
| | | return new ApiResult<DataSet> { code = 1, msg = "æ¥è¯¢æå", data = dataSet }; |
| | | } |
| | | /// <summary> |
| | | /// è·åä¸è¯ä»åºå表 |
| | | /// </summary> |
| | | /// <param name="sWhere"></param> |
| | | /// <returns></returns> |
| | | public static ApiResult<DataSet> GetBadWHList(string sWhere) |
| | | { |
| | | var dataSet = GetBadWH(sWhere); |
| | | if (dataSet == null || dataSet.Tables[0].Rows.Count == 0) |
| | | return new ApiResult<DataSet> { code = -1, msg = "æªæ¥è¯¢å°ä¸è¯ä»åº" }; |
| | | return new ApiResult<DataSet> { code = 1, msg = "æ¥è¯¢æå", data = dataSet }; |
| | | } |
| | | /// <summary> |
| | | /// è·åæ¥åºä»åºå表 |
| | | /// </summary> |
| | | /// <param name="sWhere"></param> |
| | | /// <returns></returns> |
| | | public static ApiResult<DataSet> GetWasterWHList(string sWhere) |
| | | { |
| | | var dataSet = GetWasterWH(sWhere); |
| | | if (dataSet == null || dataSet.Tables[0].Rows.Count == 0) |
| | | return new ApiResult<DataSet> { code = -1, msg = "æªæ¥è¯¢å°æ¥åºä»åº" }; |
| | | return new ApiResult<DataSet> { code = 1, msg = "æ¥è¯¢æå", data = dataSet }; |
| | | } |
| | | /// <summary> |
| | | /// è·åç åä¸è¯åä»åºå表 |
| | | /// </summary> |
| | | /// <param name="sWhere"></param> |
| | | /// <returns></returns> |
| | | public static ApiResult<DataSet> GetBadCountDevelopWHList(string sWhere) |
| | | { |
| | | var dataSet = GetBadCountDevelopWH(sWhere); |
| | | if (dataSet == null || dataSet.Tables[0].Rows.Count == 0) |
| | | return new ApiResult<DataSet> { code = -1, msg = "æªæ¥è¯¢å°ç åä¸è¯åä»åº" }; |
| | | return new ApiResult<DataSet> { code = 1, msg = "æ¥è¯¢æå", data = dataSet }; |
| | | } |
| | | /// <summary> |
| | | /// è·åå§å¤ä¸è¯ä»åºå表 |
| | | /// </summary> |
| | | /// <param name="sWhere"></param> |
| | | /// <returns></returns> |
| | | public static ApiResult<DataSet> GetWWBadWHList(string sWhere) |
| | | { |
| | | var dataSet = GetWWBadWH(sWhere); |
| | | if (dataSet == null || dataSet.Tables[0].Rows.Count == 0) |
| | | return new ApiResult<DataSet> { code = -1, msg = "æªæ¥è¯¢å°å§å¤ä¸è¯ä»åº" }; |
| | | return new ApiResult<DataSet> { code = 1, msg = "æ¥è¯¢æå", data = dataSet }; |
| | | } |
| | | /// <summary> |
| | | /// è·åå§å¤æ¥åºä»åºå表 |
| | | /// </summary> |
| | | /// <param name="sWhere"></param> |
| | | /// <returns></returns> |
| | | public static ApiResult<DataSet> GetWWWasterWHList(string sWhere) |
| | | { |
| | | var dataSet = GetWWWasterWH(sWhere); |
| | | if (dataSet == null || dataSet.Tables[0].Rows.Count == 0) |
| | | return new ApiResult<DataSet> { code = -1, msg = "æªæ¥è¯¢å°å§å¤æ¥åºä»åº" }; |
| | | return new ApiResult<DataSet> { code = 1, msg = "æ¥è¯¢æå", data = dataSet }; |
| | | } |
| | | /// <summary> |
| | | /// è·åè¯åä»åºå表 |
| | | /// </summary> |
| | | /// <param name="sWhere"></param> |
| | | /// <returns></returns> |
| | | public static ApiResult<DataSet> GetWHList(string sWhere) |
| | | { |
| | | var dataSet = GetWH(sWhere); |
| | | if (dataSet == null || dataSet.Tables[0].Rows.Count == 0) |
| | | return new ApiResult<DataSet> { code = -1, msg = "æªæ¥è¯¢å°è¯åä»åº" }; |
| | | return new ApiResult<DataSet> { code = 1, msg = "æ¥è¯¢æå", data = dataSet }; |
| | | } |
| | | /// <summary> |
| | | /// è·åæµè½¬å¡å表 |
| | | /// </summary> |
| | | /// <param name="sWhere"></param> |
| | |
| | | if (list?.Count == 0) |
| | | return new ApiResult<List<M_Process>> { code = -1, msg = "æ¥è¯¢ä¸ºç©º" }; |
| | | return new ApiResult<List<M_Process>> { code = 0, msg = "æ¥è¯¢æå", data = list, count = pageCount }; |
| | | } |
| | | } |
| | | /// <summary> |
| | | /// å é¤ä¸æ¡å·¥åº |
| | | /// </summary> |
| | |
| | | var dataSet = oCN.RunProcReturn(sql, "h_v_MES_StationOutBillList"); |
| | | return dataSet; |
| | | } |
| | | public static DataSet GetBadWH(string sWhere) |
| | | { |
| | | var sql = "Select * from h_v_Sc_GetBadWH Where 1=1 " + sWhere; |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | var dataSet = oCN.RunProcReturn(sql, "h_v_Sc_GetBadWH"); |
| | | return dataSet; |
| | | } |
| | | public static DataSet GetWasterWH(string sWhere) |
| | | { |
| | | var sql = "Select * from h_v_Sc_GetWasterWH Where 1=1 " + sWhere; |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | var dataSet = oCN.RunProcReturn(sql, "h_v_Sc_GetWasterWH"); |
| | | return dataSet; |
| | | } |
| | | public static DataSet GetBadCountDevelopWH(string sWhere) |
| | | { |
| | | var sql = "Select * from h_v_Sc_GetBadCountDevelopWH Where 1=1 " + sWhere; |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | var dataSet = oCN.RunProcReturn(sql, "h_v_Sc_GetBadCountDevelopWH"); |
| | | return dataSet; |
| | | } |
| | | public static DataSet GetWWBadWH(string sWhere) |
| | | { |
| | | var sql = "Select * from h_v_Sc_GetWWBadWH Where 1=1 " + sWhere; |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | var dataSet = oCN.RunProcReturn(sql, "h_v_Sc_GetWWBadWH"); |
| | | return dataSet; |
| | | } |
| | | public static DataSet GetWWWasterWH(string sWhere) |
| | | { |
| | | var sql = "Select * from h_v_Sc_GetWWWasterWH Where 1=1 " + sWhere; |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | var dataSet = oCN.RunProcReturn(sql, "h_v_Sc_GetWWWasterWH"); |
| | | return dataSet; |
| | | } |
| | | public static DataSet GetWH(string sWhere) |
| | | { |
| | | var sql = "Select * from h_v_Sc_GetWH Where 1=1 " + sWhere; |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | var dataSet = oCN.RunProcReturn(sql, "h_v_Sc_GetWH"); |
| | | return dataSet; |
| | | } |
| | | public static DataSet GetStationInBill(string strWhere) |
| | | { |
| | | var sql = "Select top 5000 * from h_v_MES_StationInBillList Where 1=1 " + strWhere; |
| | |
| | | <IISExpressUseClassicPipelineMode /> |
| | | <UseGlobalApplicationHostFile /> |
| | | <ProjectView>ShowAllFiles</ProjectView> |
| | | <Controller_SelectedScaffolderID>ApiControllerEmptyScaffolder</Controller_SelectedScaffolderID> |
| | | <Controller_SelectedScaffolderCategoryPath>root/Common/Web API</Controller_SelectedScaffolderCategoryPath> |
| | | <Controller_SelectedScaffolderID>MvcControllerEmptyScaffolder</Controller_SelectedScaffolderID> |
| | | <Controller_SelectedScaffolderCategoryPath>root/Common/MVC/Controller</Controller_SelectedScaffolderCategoryPath> |
| | | </PropertyGroup> |
| | | <ProjectExtensions> |
| | | <VisualStudio> |