1

zrg

1 天以前 639ea7256f10697d19c19cc878e999bcb7b1e6a1

 WebAPI/Controllers/Sc_EmployeeSignInNoteBillController.cs

@@ -62,7 +62,7 @@


                objJsonResult.code = "1";
                objJsonResult.count = 1;
                objJsonResult.count = ds.Tables[0].Rows.Count;
                objJsonResult.Message = "Sucess！";
                objJsonResult.data = ds.Tables[0];
                objJsonResult.list = columnNameList;
@@ -424,8 +424,33 @@
                return objJsonResult;
            }
        }
        #endregion
        [Route("Sc_EmployeeSignInNoteBillController/Get_equipmentMes")]
        [HttpGet]
        public object Get_MouldMes(int HInterID, string HBarCode)
        {

            
            DataSet dss = oCN.RunProcReturn("select HInterID from Gy_EquipFileBillMain where HBarCode='"+ HBarCode + "'", "Gy_EquipFileBillMain");
            DataSet ds = oCN.RunProcReturn("exec h_p_SB_HEquipHMould_Query '" + dss.Tables[0].Rows[0]["HInterID"] + "'", "h_p_SB_HEquipHMould_Query");
            if (ds != null || ds.Tables.Count > 0)
            {
                objJsonResult.code = "1";
                objJsonResult.count = 1;
                objJsonResult.Message = "成功";
                objJsonResult.data = ds.Tables[0];
                return objJsonResult;

            }
            else
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "没有返回任何记录！";
                objJsonResult.data = null;
                return objJsonResult;
            }
        }
        #endregion

        #region  保存/编辑

@@ -603,5 +628,37 @@
            }
        }
        #endregion


        #region 出站单 查询当前机台的操作员、模具工、机修 （华舟）
        [Route("Sc_EmployeeSignInNoteBillController/Get_HSourceRoulsList")]
        [HttpGet]
        public object Get_HSourceRoulsList(int HSourceID)
        {
            try
            {
                List<object> columnNameList = new List<object>();


                ds = oCN.RunProcReturn("exec h_p_Cj_StationOutBill_Roules_HZ  '" + HSourceID + "'", "h_p_Cj_StationOutBill_Roules_HZ");

                objJsonResult.code = "1";
                objJsonResult.count = 1;
                objJsonResult.Message = "Sucess！";
                objJsonResult.data = ds;
                objJsonResult.list = null;
                return objJsonResult;
            }
            catch (Exception ex)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "没有返回任何记录！" + ex.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }
        #endregion

    }
}