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