| | |
|---|
| | | } |
|---|
| | | return objJsonResult; |
|---|
| | | } |
|---|
| | | // 工序流转卡返工信息 |
|---|
| | | [Route("Sc_ProcessExchangeBill/GetProcessExchangeBillSub_Back")] |
|---|
| | | [HttpGet] |
|---|
| | | public object GetProcessExchangeBillSub_Back(string HInterID) |
|---|
| | | { |
|---|
| | | DataSet ds; |
|---|
| | | try |
|---|
| | | { |
|---|
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
|---|
| | | string sql = string.Format(@"SELECT ISNULL(HSourceInterID, 0) AS HSourceInterID,ISNULL(HSourceEntryID, 0) AS HSourceEntryID,ISNULL(HSourceBillNo, '') AS HSourceBillNo, |
|---|
| | | ISNULL(HSourceBillType, '') AS HSourceBillType,ISNULL(HProcExchInterID, 0) AS HProcExchInterID,ISNULL(HProcExchEntryID, 0) AS HProcExchEntryID, |
|---|
| | | ISNULL(HProcExchBillNo, '') AS HProcExchBillNo,ISNULL(HICMOInterID, 0) AS HICMOInterID,ISNULL(HICMOEntryID, 0) AS HICMOEntryID, |
|---|
| | | ISNULL(HICMOBillNo, '') AS HICMOBillNo,ISNULL(HStationOutInterID, 0) AS HStationOutInterID,ISNULL(HStationOutBillNo, '') AS HStationOutBillNo |
|---|
| | | FROM Sc_ProcessExchangeBillSub_HRelationBack where HInterID=" + HInterID + " order by HEntryID "); |
|---|
| | | |
|---|
| | | ds = oCN.RunProcReturn(sql, "Sc_ProcessExchangeBillSub_HRelationBack"); |
|---|
| | | |
|---|
| | | objJsonResult.code = "0"; |
|---|
| | | objJsonResult.count = 1; |
|---|
| | | objJsonResult.Message = "[0000-1-037]获取信息成功！"; |
|---|
| | | objJsonResult.data = ds.Tables[0]; |
|---|
| | | } |
|---|
| | | catch (Exception e) |
|---|
| | | { |
|---|
| | | objJsonResult.code = "0"; |
|---|
| | | objJsonResult.count = 0; |
|---|
| | | objJsonResult.Message = "[0000-1-045]没有返回任何记录！" + e.ToString(); |
|---|
| | | objJsonResult.data = null; |
|---|
| | | } |
|---|
| | | return objJsonResult; |
|---|
| | | } |
|---|
| | | #endregion |
|---|
| | | |
|---|
| | | #region [工序流转卡删除功能] |
|---|
