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