/// <summary> /// 更新站别信息 /// </summary> /// <param name="obj"></param> /// <returns></returns> public int Update(station_info obj) { try { int count = PostgreHelper.UpdateSingleEntity <station_info>(obj); return(count); } catch (Exception ex) { throw ex; } }
/// <summary> /// 插入站别信息数据 /// </summary> /// <param name="obj"></param> /// <returns></returns> public int Insert(station_info obj) { try { string sql = "Insert into fimp.station_info(station_name_en,station_name_cn,station_name_tw,type_no,status_no,unit_no,line_id)values('{0}','{1}','{2}','{3}','{4}','{5}',{6})"; sql = string.Format(sql, obj.station_name_en, obj.station_name_cn, obj.station_name_tw, obj.type_no, obj.status_no, obj.unit_no, obj.line_id); int count = PostgreHelper.ExecuteNonQuery(sql); return(count); } catch (Exception ex) { throw ex; } }
/// <summary> /// 查询单笔数据,通过id或station_code /// </summary> /// <param name="id"></param> /// <returns></returns> public station_info SelectSingle(int station_id = 0) { station_info obj = new station_info(); if (station_id > 0) { obj = SS.SelectSingle(station_id); } else { obj = null; } return(obj); }
/// <summary> /// 查询单笔数据,通过名称 /// </summary> /// <param name="id"></param> /// <returns></returns> public station_info SelectByStaionName(string station_name) { try { string sql = "select * from fimp.station_info where station_name_en={0}"; sql = string.Format(sql, station_name); station_info obj = new station_info(); obj = PostgreHelper.GetSingleEntity <station_info>(sql); return(obj); } catch (Exception ex) { throw ex; } }
/// <summary> /// 根据装置id获取配置信息 /// </summary> /// <returns></returns> public List <error_config> GetLogConfigList(string system_tag_code, int station_id = -1, string machine_code = "") { List <error_config> list = null; if (machine_code.Length > 0)//以machine_code查询 { MachineInfo machine = machineInfoManager.SelectSingle(-1, machine_code); if (machine != null) { list = errorConfigService.GetErrorConfig(system_tag_code, machine.unit_no, machine.line_id); } } else if (station_id > 0) { ///Station station = stationManager.SelectSingle(station_id); station_info station = stationManager.SelectSingle(station_id); if (station != null) { list = errorConfigService.GetErrorConfig(system_tag_code, station.unit_no, -1); } } return(list); }
/// <summary> /// 更新站别信息 /// </summary> /// <param name="obj"></param> /// <returns></returns> public int Update(station_info obj) { int count = SS.Update(obj); return(count); }
/// <summary> /// 插入站别信息数据 /// </summary> /// <param name="obj"></param> /// <returns></returns> public int Insert(station_info obj) { int count = SS.Insert(obj); return(count); }