/// <summary>
/// 将id全部替换为name
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public List <MachineInfoName> SelectAllName(MachineInfoName obj)
{
try
{
List <MachineInfoName> objList = new List <MachineInfoName>();
string sql = null;
if (obj.city_id > 0 && obj.plant_id <= 0 && string.IsNullOrEmpty(obj.unit_no) && obj.line_id <= 0 && obj.station_id <= 0)
{
//根据城市获取城市对应的所有厂别
sql = "SELECT a.plant_id,c.plant_name_en,c.plant_name_cn " +
" FROM fimp.machine_info a,fimp.city_info b, fimp.plant_info c " +
" where a.city_id=b.city_id and a.city_id={0} and a.plant_id=c.plant_id and b.city_id=c.city_id " +
" group by a.plant_id,c.plant_name_en,c.plant_name_cn " +
" order by a.plant_id";
sql = string.Format(sql, obj.city_id);
objList = PostgreHelper.GetEntityList <MachineInfoName>(sql);
return(objList);
}
else if (obj.city_id > 0 && obj.plant_id > 0 && string.IsNullOrEmpty(obj.unit_no) && obj.line_id <= 0 && obj.station_id <= 0)
{
//根据厂别获取厂别对应的所有制程
sql = " SELECT a.unit_no " +
" FROM fimp.machine_info a,fimp.city_info b, fimp.plant_info c " +
" where a.city_id=b.city_id and a.city_id={0} and a.plant_id=c.plant_id and b.city_id=c.city_id and a.plant_id={1} " +
" group by a.unit_no " +
" order by a.unit_no";
sql = string.Format(sql, obj.city_id, obj.plant_id);
objList = PostgreHelper.GetEntityList <MachineInfoName>(sql);
return(objList);
}
else if (obj.city_id > 0 && obj.plant_id > 0 && !string.IsNullOrEmpty(obj.unit_no) && obj.line_id <= 0 && obj.station_id <= 0)
{
//根据制程获取制程对应的所有线别
sql = " SELECT a.line_id,d.line_name_cn,d.line_name_en " +
" FROM fimp.machine_info a,fimp.city_info b, fimp.plant_info c, fimp.line_info d " +
" where a.city_id=b.city_id and a.city_id={0} and a.plant_id=c.plant_id and b.city_id=c.city_id and a.plant_id={1} and a.unit_no='{2}' and a.line_id=d.line_id " +
" group by a.line_id,d.line_name_cn,d.line_name_en " +
" order by line_id";
sql = string.Format(sql, obj.city_id, obj.plant_id, obj.unit_no);
objList = PostgreHelper.GetEntityList <MachineInfoName>(sql);
return(objList);
}
else if (obj.city_id > 0 && obj.plant_id > 0 && !string.IsNullOrEmpty(obj.unit_no) && obj.line_id > 0 && obj.station_id <= 0)
{
//根据线别获取线别对应的所有站位
sql = " SELECT a.station_id, e.station_name_cn, e.station_name_en " +
" FROM fimp.machine_info a,fimp.city_info b, fimp.plant_info c, fimp.line_info d, fimp.station_info e " +
" where a.city_id=b.city_id and a.city_id={0} and a.plant_id=c.plant_id and b.city_id=c.city_id and a.plant_id={1} and a.unit_no='{2}' and a.line_id=d.line_id and a.line_id={3} and c.plant_id=d.plant_id and d.unit_no=a.unit_no and e.station_id = a.station_id and e.unit_no=a.unit_no " +
" group by a.station_id, e.station_name_cn, e.station_name_en " +
" order by a.station_id";
sql = string.Format(sql, obj.city_id, obj.plant_id, obj.unit_no, obj.line_id);
objList = PostgreHelper.GetEntityList <MachineInfoName>(sql);
return(objList);
}
else if (obj.city_id > 0 && obj.plant_id > 0 && !string.IsNullOrEmpty(obj.unit_no) && obj.line_id > 0 && obj.station_id > 0)
{
//根据站位获取站位对应的所有机台
sql = " SELECT a.machine_code,a.machine_name_en,a.machine_name_tw,a.machine_name_cn " +
" FROM fimp.machine_info a,fimp.city_info b, fimp.plant_info c, fimp.line_info d, fimp.station_info e " +
" where a.city_id=b.city_id and a.city_id={0} and a.plant_id=c.plant_id and b.city_id=c.city_id and a.plant_id={1} and a.unit_no='{2}' and a.line_id=d.line_id and a.line_id={3} and c.plant_id=d.plant_id and d.unit_no=a.unit_no and a.station_id={4} and e.station_id = a.station_id and e.unit_no=a.unit_no " +
" group by a.machine_code,a.machine_name_en,a.machine_name_tw,a.machine_name_cn " +
" order by a.machine_code";
sql = string.Format(sql, obj.city_id, obj.plant_id, obj.unit_no, obj.line_id, obj.station_id);
objList = PostgreHelper.GetEntityList <MachineInfoName>(sql);
return(objList);
}
else if (obj.city_id <= 0 && obj.plant_id > 0 && string.IsNullOrEmpty(obj.unit_no) && obj.line_id <= 0 && obj.station_id <= 0)
{
sql = " SELECT a.city_id,b.city_name_en,b.city_name_cn FROM fimp.machine_info a, fimp.city_info b where a.city_id=b.city_id and a.plant_id={0} group by a.city_id,b.city_name_en,b.city_name_cn order by a.city_id ";
sql = string.Format(sql, obj.plant_id);
objList = PostgreHelper.GetEntityList <MachineInfoName>(sql);
return(objList);
}
else
{
sql = "SELECT a.city_id,b.city_name_en,b.city_name_cn FROM fimp.machine_info a, fimp.city_info b where a.city_id=b.city_id group by a.city_id,b.city_name_en,b.city_name_cn order by a.city_id ";
sql = string.Format(sql);
objList = PostgreHelper.GetEntityList <MachineInfoName>(sql);
return(objList);
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 获取站别信息,id全为name
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public List <MachineInfoName> SelectAllName(MachineInfoName obj)
{
List <MachineInfoName> objList = MIS.SelectAllName(obj);
return(objList);
}
