/// <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);
}
