| | |
| | | } |
| | | } |
| | | |
| | | |
| | | /// <summary> |
| | | /// 获取班次列表 |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | [Route("Web/GetGy_ShiftsList_Json")] |
| | | [HttpGet] |
| | | public object GetGy_ShiftsList_Json(string Shifts) |
| | | { |
| | | sWhere = " 禁用标记!='Y'"; |
| | | if (Shifts != "") |
| | | { |
| | | sWhere = " Where 禁用标记!='Y' and ( 班次代码 like '%" + Shifts + "%' or 班次名称 like '%" + Shifts + "%' ) "; |
| | | } |
| | | else |
| | | { |
| | | sWhere = " Where 禁用标记!='Y' "; |
| | | } |
| | | try |
| | | { |
| | | string sql = $"Select * from h_v_Gy_ShiftsList {sWhere} Order by 班次代码"; |
| | | ds = oCN.RunProcReturn(sql, "h_v_Gy_ShiftsList"); |
| | | if (ds == null || ds.Tables[0].Rows.Count <= 0) |
| | | { |
| | | objjson.code = "0"; |
| | | objjson.count = 0; |
| | | objjson.Message = "获取失败" + DBUtility.ClsPub.sErrInfo; |
| | | objjson.data = null; |
| | | return objjson; |
| | | } |
| | | else |
| | | { |
| | | objjson.code = "0"; |
| | | objjson.count = 1; |
| | | objjson.Message = "获取成功!"; |
| | | objjson.data = ds.Tables[0]; |
| | | return objjson; |
| | | } |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | |
| | | objjson.code = "0"; |
| | | objjson.count = 0; |
| | | objjson.Message = "获取失败" + ex.ToString(); |
| | | objjson.data = null; |
| | | return objjson; |
| | | } |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 获取异常反馈类型列表 |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | [Route("Web/GetGy_ErrMsgBackTypeList_Json")] |
| | | [HttpGet] |
| | | public object GetGy_ErrMsgBackTypeList_Json(string ErrMsg) |
| | | { |
| | | sWhere = " 禁用标志 ='否'"; |
| | | if (ErrMsg != "") |
| | | { |
| | | sWhere = " Where 禁用标志 ='否' and ( 异常反馈类型代码 like '%" + ErrMsg + "%' or 异常反馈类型名称 like '%" + ErrMsg + "%' ) "; |
| | | } |
| | | else |
| | | { |
| | | sWhere = " Where 禁用标志 ='否' "; |
| | | } |
| | | try |
| | | { |
| | | string sql = $"Select * from h_v_Gy_ErrMsgBackType {sWhere} Order by 异常反馈类型代码"; |
| | | ds = oCN.RunProcReturn(sql, "h_v_Gy_ErrMsgBackType"); |
| | | if (ds == null || ds.Tables[0].Rows.Count <= 0) |
| | | { |
| | | objjson.code = "0"; |
| | | objjson.count = 0; |
| | | objjson.Message = "获取失败" + DBUtility.ClsPub.sErrInfo; |
| | | objjson.data = null; |
| | | return objjson; |
| | | } |
| | | else |
| | | { |
| | | objjson.code = "0"; |
| | | objjson.count = 1; |
| | | objjson.Message = "获取成功!"; |
| | | objjson.data = ds.Tables[0]; |
| | | return objjson; |
| | | } |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | |
| | | objjson.code = "0"; |
| | | objjson.count = 0; |
| | | objjson.Message = "获取失败" + ex.ToString(); |
| | | objjson.data = null; |
| | | return objjson; |
| | | } |
| | | } |
| | | |
| | | |
| | | /// <summary> |
| | | /// 获取班组列表 |
| | | ///参数:string sql。 |
| | |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 根据物料+工序获取检验方案 |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | [Route("Web/GetCheckItemID")] |
| | | [HttpGet] |
| | | public object GetCheckItemID(string HName,string HProName) |
| | | { |
| | | try |
| | | { |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | ds = oCN.RunProcReturn("select top 1 * from h_v_Gy_QCCheckProjectList_Main where 物料名称='"+HName+ "' and 工序名称='" + HProName + "' order by 日期 desc ", "h_v_Gy_QCCheckProjectList_Main"); |
| | | if (ds == null || ds.Tables[0].Rows.Count <= 0) |
| | | { |
| | | objjson.code = "0"; |
| | | objjson.count = 0; |
| | | objjson.Message = "获取失败" + DBUtility.ClsPub.sErrInfo; |
| | | objjson.data = null; |
| | | return objjson; |
| | | } |
| | | else |
| | | { |
| | | objjson.code = "1"; |
| | | objjson.count = 1; |
| | | objjson.Message = "获取成功!"; |
| | | objjson.data = ds.Tables[0]; |
| | | return objjson; |
| | | } |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | objjson.code = "0"; |
| | | objjson.count = 0; |
| | | objjson.Message = "获取失败" + ex.ToString(); |
| | | objjson.data = null; |
| | | return objjson; |
| | | } |
| | | } |
| | | |
| | | |
| | | /// <summary> |
| | | /// 根据检验方案主内码获取检验项目 |
| | | /// </summary> |
| | | /// <returns></returns> |