| | |
| | | return GetObjectJson(ds); |
| | | } |
| | | |
| | | #region 工序流转卡(下达) |
| | | |
| | | /// <summary> |
| | | /// 返回工序流转卡(下达)列表 |
| | | ///参数:string sql。 |
| | |
| | | } |
| | | } |
| | | /// <summary> |
| | | /// 下达 |
| | | /// 工序流转卡下达 |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | [Route("LEMS/MES_Sc_ProcessExchangeIssue")] |
| | | [HttpGet] |
| | | public object MES_Sc_ProcessExchangeIssue(string HGroupID, string HSourceID, string HEntryId) { |
| | | public object MES_Sc_ProcessExchangeIssue(string HGroupID, string HSourceID, string HEntryId) |
| | | { |
| | | DataSet ds; |
| | | try |
| | | { |
| | |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 工序流转卡反下达 |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | [Route("LEMS/MES_Sc_ProcessExchangeCancelIssue")] |
| | | [HttpGet] |
| | | public object MES_Sc_ProcessExchangeCancelIssue(string HEntryId) |
| | | { |
| | | DataSet ds; |
| | | try |
| | | { |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | string sql = string.Empty; |
| | | //删除生产状态表临时表数据 |
| | | sql = string.Format(@" |
| | | delete from Sc_ICMOBillStatus_Tmp |
| | | where |
| | | cast(HSOURCEINTERID as varchar(20)) +'-'+ cast(HSOURCEENTRYID as varchar(20)) in |
| | | ( |
| | | select * from fn_Split('{0}',',') |
| | | )", HEntryId); |
| | | oCN.RunProc(sql); |
| | | //更改订单状态 |
| | | sql = string.Format(@" |
| | | update Sc_ProcessExchangeBillSub set |
| | | HGroupID=0, --班组 |
| | | HSourceID=0, --生产资源 |
| | | HIssue = 0 --下达状态 |
| | | where cast(HInterID as varchar(20)) +'-'+ cast(HEntryID as varchar(20)) in |
| | | ( |
| | | select * from fn_Split('{0}',',') |
| | | )", HEntryId); |
| | | oCN.RunProc(sql); |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "操作成功!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "异常!" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | #endregion |
| | | |
| | | /// <summary> |
| | | /// 返回工序出站汇报单列表 |
| | | ///参数:string sql。 |
| | | ///返回值:object。 |