/// <summary> /// 查询单笔数据,通过id或者machine_code /// </summary> /// <param name="id"></param> /// <returns></returns> public MachineInfo SelectSingleById(int id = 0) { try { MachineInfo obj = new MachineInfo(); string sql = null; if (id > 0) { sql = "SELECT * FROM fimp.machine_info where machine_id={0} order by area_id,city_id,plant_id,unit_no,line_id"; sql = string.Format(sql, id); obj = PostgreHelper.GetSingleEntity <MachineInfo>(sql); } return(obj); } catch (Exception ex) { throw ex; } }
/// <summary> /// 查询单笔数据,通过id或者machine_code /// </summary> /// <param name="id"></param> /// <returns></returns> public MachineInfo SelectSingle(int id = 0, string machine_code = null) { try { MachineInfo obj = new MachineInfo(); string sql = null; if (id > 0) { sql = "SELECT * FROM fimp.machine_info where machine_id={0} order by area_id,city_id,plant_id,unit_no,line_id"; sql = string.Format(sql, id); } else if (!string.IsNullOrEmpty(machine_code)) { sql = "SELECT * FROM fimp.machine_info where machine_code='{0}' order by area_id,city_id,plant_id,unit_no,line_id"; sql = string.Format(sql, machine_code); } obj = PostgreHelper.GetSingleEntity <MachineInfo>(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 List <MachineInfo> SelectAll(MachineInfo obj, string unit_no = null) { try { List <MachineInfo> objList = new List <MachineInfo>(); string sql = null; if (string.IsNullOrEmpty(unit_no) && obj == null) { sql = "SELECT * FROM fimp.machine_info order by area_id,city_id,plant_id,unit_no,line_id"; sql = string.Format(sql, unit_no); } else if (!string.IsNullOrEmpty(unit_no)) { sql = "SELECT mqtt_no,machine_id,area_id,city_id,plant_id,unit_no,line_id,machine_code,machine_name_en,machine_name_tw,machine_name_cn,status_no,station_id,set_up FROM fimp.machine_info where unit_no='{0}' order by area_id,city_id,plant_id,unit_no,line_id"; sql = string.Format(sql, unit_no); } else { if (obj != null) { if (obj.area_id > 0 && obj.city_id <= 0 && obj.plant_id <= 0 && string.IsNullOrEmpty(obj.unit_no) && obj.line_id <= 0) { sql = "SELECT mqtt_no,machine_id,area_id,city_id,plant_id,unit_no,line_id,machine_code,machine_name_en,machine_name_tw,machine_name_cn,status_no,station_id,set_up FROM fimp.machine_info where area_id={0} order by area_id,city_id,plant_id,unit_no,line_id"; sql = string.Format(sql, obj.area_id); } else if (obj.area_id > 0 && obj.city_id > 0 && obj.plant_id <= 0 && string.IsNullOrEmpty(obj.unit_no) && obj.line_id <= 0) { sql = "SELECT mqtt_no,machine_id,area_id,city_id,plant_id,unit_no,line_id,machine_code,machine_name_en,machine_name_tw,machine_name_cn,status_no,station_id,set_up FROM fimp.machine_info where area_id={0} and city_id={1} order by area_id,city_id,plant_id,unit_no,line_id"; sql = string.Format(sql, obj.area_id, obj.city_id); } else if (obj.area_id > 0 && obj.city_id > 0 && obj.plant_id > 0 && string.IsNullOrEmpty(obj.unit_no) && obj.line_id <= 0) { sql = "SELECT mqtt_no,machine_id,area_id,city_id,plant_id,unit_no,line_id,machine_code,machine_name_en,machine_name_tw,machine_name_cn,status_no,station_id,set_up FROM fimp.machine_info where area_id={0} and city_id={1} and plant_id={2} order by area_id,city_id,plant_id,unit_no,line_id"; sql = string.Format(sql, obj.area_id, obj.city_id, obj.plant_id); } else if (obj.area_id > 0 && obj.city_id > 0 && obj.plant_id > 0 && !string.IsNullOrEmpty(obj.unit_no) && obj.line_id <= 0) { sql = "SELECT mqtt_no,machine_id,area_id,city_id,plant_id,unit_no,line_id,machine_code,machine_name_en,machine_name_tw,machine_name_cn,status_no,station_id,set_up FROM fimp.machine_info where area_id={0} and city_id={1} and plant_id={2} and unit_no='{3}' order by area_id,city_id,plant_id,unit_no,line_id"; sql = string.Format(sql, obj.area_id, obj.city_id, obj.plant_id, obj.unit_no); } else if (obj.area_id > 0 && obj.city_id > 0 && obj.plant_id > 0 && !string.IsNullOrEmpty(obj.unit_no) && obj.line_id > 0) { sql = "SELECT mqtt_no,machine_id,area_id,city_id,plant_id,unit_no,line_id,machine_code,machine_name_en,machine_name_tw,machine_name_cn,status_no,station_id,set_up FROM fimp.machine_info where area_id={0} and city_id={1} and plant_id={2} and unit_no='{3}' and line_id={4} order by area_id,city_id,plant_id,unit_no,line_id"; sql = string.Format(sql, obj.area_id, obj.city_id, obj.plant_id, obj.unit_no, obj.line_id); } else { sql = "SELECT mqtt_no,machine_id,area_id,city_id,plant_id,unit_no,line_id,machine_code,machine_name_en,machine_name_tw,machine_name_cn,status_no,station_id,set_up FROM fimp.machine_info order by area_id,city_id,plant_id,unit_no,line_id"; } } else { sql = "SELECT mqtt_no,machine_id,area_id,city_id,plant_id,unit_no,line_id,machine_code,machine_name_en,machine_name_tw,machine_name_cn,status_no,station_id,set_up FROM fimp.machine_info order by area_id,city_id,plant_id,unit_no,line_id"; } } objList = PostgreHelper.GetEntityList <MachineInfo>(sql); return(objList); } catch (Exception ex) { throw ex; } }
/// <summary> /// 更新站别信息 /// </summary> /// <param name="obj"></param> /// <returns></returns> public int Update(MachineInfo obj) { int count = MIS.Update(obj); return(count); }
/// <summary> /// 插入站别信息数据 /// </summary> /// <param name="obj"></param> /// <returns></returns> public int Insert(MachineInfo obj, int machine_id = 0) { int count = MIS.Insert(obj, machine_id); return(count); }
/// <summary> /// 获取站别信息 /// </summary> /// <param name="obj"></param> /// <returns></returns> public List <MachineInfo> SelectAll(MachineInfo obj, string unit_no = null) { List <MachineInfo> objList = MIS.SelectAll(obj, unit_no); return(objList); }