//查询单笔数据,通过名称 public line_info SelectSingleByName(string line_name) { string sql = "SELECT *FROM fimp.line_info where line_name_en='{0}'"; sql = string.Format(sql, line_name); return(PostgreHelper.GetSingleEntity <line_info>(sql)); }
/// <summary> /// 获取指定配置 /// </summary> /// <param name="system_tag_code">系统标签类型</param> /// <param name="unit_no">制程</param> /// <param name="line_id">线别,=-1则不启用</param> /// <returns>配置列表</returns> public error_config GetErrorConfigByCode(string system_tag_code, String unit_no, int line_id = -1) { error_config obj = new error_config(); string command = string.Empty; if (system_tag_code != null && line_id >= 0 && unit_no != null && unit_no.Length > 0) { command = string.Format("Select * from andon.error_config where system_tag_code='{0}' and unit_no='{1}' and line_id='{2}'", system_tag_code, unit_no, line_id); obj = PostgreHelper.GetSingleEntity <error_config>(command); if (obj == null)//查找不到,再向上一级查找 { command = string.Format("Select * from andon.error_config where system_tag_code='{0}' and unit_no='{1}'", system_tag_code, unit_no); } } else if (system_tag_code != null && unit_no != null && unit_no.Length > 0) { command = string.Format("Select * from andon.error_config where system_tag_code='{0}' and unit_no='{1}'", system_tag_code, unit_no); } if (command != string.Empty) { obj = PostgreHelper.GetSingleEntity <error_config>(command); return(obj); } return(null); }
/// <summary> /// 查询时间是否在休息时间列表中 /// </summary> /// <param name="time">时间</param> /// <returns></returns> public bool SelectCount(string time, string unit_no) { try { bool result = false; string sql = "select * from fimp.rest_time where start_time<='{0}' and end_time>='{1}' and unit_no='{2}' and state='A'"; sql = string.Format(sql, time, time, unit_no); rest_time obj = PostgreHelper.GetSingleEntity <rest_time>(sql); if (obj != null) { result = true; } else { result = false; } return(result); } catch (Exception ex) { throw ex; } }
public rest_time_row IsUpdate(string machine_code, string start_time, string end_time) { try { rest_time_row obj = new rest_time_row(); string sql = "select * from fimp.rest_time_row where machine_code='{0}' and start_time<='{1}' and end_time>='{2}'"; sql = string.Format(sql, machine_code, start_time, start_time); obj = PostgreHelper.GetSingleEntity <rest_time_row>(sql); if (obj != null) { } else { sql = "select * from fimp.rest_time_row where machine_code='{0}' and start_time<='{1}' and end_time>='{2}'"; sql = string.Format(sql, machine_code, end_time, end_time); obj = PostgreHelper.GetSingleEntity <rest_time_row>(sql); } return(obj); } catch (Exception ex) { throw ex; } }
public error_config_person SelectSingle(string class_no, int id) { try { error_config_person obj = new error_config_person(); string sql = null; if (!string.IsNullOrEmpty(class_no)) { sql = "select * from andon.error_config_person where class_no='{0}' order by class_no"; sql = string.Format(sql, class_no); } else { sql = "select * from andon.error_config_person where id={0} order by class_no"; sql = string.Format(sql, id); } obj = PostgreHelper.GetSingleEntity <error_config_person>(sql); return(obj); } catch (Exception ex) { throw ex; } }
/// <summary> /// 获取最后一笔数据 /// </summary> /// <param name="machine_code">设备编号</param> /// <param name="end_time">结束时间</param> /// <returns></returns> public CT SelectSingle(string machine_code, string date_time) { try { CT obj = new CT(); string comm = null; if (string.IsNullOrEmpty(date_time)) { comm = "select id,machine_code,station_id,pn,wo,start_time,end_time,value,tag_code from fimp.ct where machine_code='{0}' order by end_time desc limit 1"; comm = string.Format(comm, machine_code); } else { string end_time = Convert.ToDateTime(date_time).ToString("yyyy-MM-dd HH:mm:ss.999"); comm = "select id,machine_code,station_id,pn,wo,start_time,end_time,value,tag_code from fimp.ct where machine_code='{0}' and end_time>'{1}' order by end_time desc limit 1"; comm = string.Format(comm, machine_code, end_time); } obj = PostgreHelper.GetSingleEntity <CT>(comm); return(obj); } catch (Exception ex) { Console.WriteLine(ex.Message); } return(null); }
/// <summary> /// 根据id查询人员 /// </summary> /// <param name="Id">人员id</param> /// <returns></returns> public person GetPersonById(int Id) { string command = string.Format("Select * from fimp.Person where id='{0}'", Id); person Person = PostgreHelper.GetSingleEntity <person>(command); return(Person); }
/// <summary> /// 根据id查询人员 /// </summary> /// <param name="card_num">员工卡号</param> /// <returns></returns> public person GetPersonByCardId(string card_num) { string command = string.Format("Select * from fimp.Person where card_num='{0}'", card_num); person Person = PostgreHelper.GetSingleEntity <person>(command); return(Person); }
public Attendance SelectById(int id) { Attendance attItem = new Attendance(); string command = string.Format("Select * from fimp.attendance where id= {0}", id); attItem = PostgreHelper.GetSingleEntity <Attendance>(command); return(attItem); }
/// <summary> /// 根据id获取单个对象 /// </summary> /// <param name="id"></param> /// <returns></returns> public error_config GetErrorConfigById(int id) { string command = string.Empty; command = string.Format("Select * from andon.error_config where id='{0}'", id); return(PostgreHelper.GetSingleEntity <error_config>(command)); }
/// <summary> /// 根据code获取单个对象 /// </summary> /// <param name="code"></param> /// <returns></returns> public srp_inner_log GetInnerLogByCode(string code) { string command = string.Empty; command = string.Format("Select * from fimp.srp_inner_log where srp_code='{0}'", code); return(PostgreHelper.GetSingleEntity <srp_inner_log>(command)); }
public SystemConfigs Get(string config_code) { SystemConfigs obj = new SystemConfigs(); string sql = " select * from {0} where config_code='{1}' "; sql = string.Format(sql, SystemConfigs.TableName, config_code); obj = PostgreHelper.GetSingleEntity <SystemConfigs>(sql); return(obj); }
/// <summary> /// 加载指定的异常记录 /// </summary> /// <param name="MachineCode">设备编码</param> /// <returns></returns> public error_log GetErrorLogById(int id) { error_log logItem = new error_log(); string command = string.Format("Select * from andon.error_log where id='{0}'", id); logItem = PostgreHelper.GetSingleEntity <error_log>(command); return(logItem); }
/// <summary> /// 加载指定的异常记录 /// </summary> /// <param name="StationId">站位id</param> /// <returns></returns> public error_log GetUnAckLogByDeviceId(int device_id, string system_tag_code) { error_log obj = new error_log(); string command; command = "Select * from andon.error_log where station_id='{0}' and system_tag_code='{1}' and (release_time<='{2}' OR release_time is NULL) limit 1"; command = string.Format(command, device_id, system_tag_code, "2001-01-01 00:00:00"); obj = PostgreHelper.GetSingleEntity <error_log>(command); return(obj); }
public CT_Log SelectNewsLog(string machine_code, string ts) { try { string comm = "select * from fimp.ct_log where machine_code='{0}' order by insert_time desc limit 1"; CT_Log ctlog = PostgreHelper.GetSingleEntity <CT_Log>(comm); return(ctlog); } catch (Exception ex) { throw ex; } }
//查询单笔数据,通过厂区id public plant_info SelectSingle(int id) { try { plant_info obj = new plant_info(); string sql = "SELECT * FROM fimp.plant_info where plant_id='{0}' order by city_id,plant_id"; sql = string.Format(sql, id); obj = PostgreHelper.GetSingleEntity <plant_info>(sql); return(obj); } catch (Exception ex) { throw ex; } }
/// <summary> /// 根据ID查询,查询结果为一笔数据 /// </summary> /// <param name="id"></param> /// <returns></returns> public Company SelectSingleByName(string company_name, int company_type) { try { Company obj = new Company(); string sql = "select * from jinchen.company_info where company_name='{0}' and company_type={1} "; sql = string.Format(sql, company_name, company_type); obj = PostgreHelper.GetSingleEntity <Company>(sql); return(obj); } catch (Exception ex) { throw ex; } }
/// <summary> /// 根据ID查询,查询结果为一笔数据 /// </summary> /// <param name="id"></param> /// <returns></returns> public Company SelectSingle(int id) { try { Company obj = new Company(); string sql = "select * from jinchen.company_info where id={0}"; sql = string.Format(sql, id); obj = PostgreHelper.GetSingleEntity <Company>(sql); return(obj); } catch (Exception ex) { throw ex; } }
public area_info SelectSingleID(int area_id) { try { area_info obj = new area_info(); string sql = "select * from fimp.area_info where area_id={0}"; sql = string.Format(sql, area_id); obj = PostgreHelper.GetSingleEntity <area_info>(sql); return(obj); } catch (Exception ex) { throw ex; } }
public material_category SelectSingleID(int area_id) { try { material_category obj = new material_category(); string sql = "select * from fimp.material_category where id={0}"; sql = string.Format(sql, area_id); obj = PostgreHelper.GetSingleEntity <material_category>(sql); return(obj); } catch (Exception ex) { throw ex; } }
/// <summary> /// 查询单笔数 /// </summary> /// <param name="id">用户id</param> /// <returns></returns> public Contact SelectById(int id) { try { Contact obj = new Contact(); string sql = "select * from jinchen.customer_info where id={0}"; sql = string.Format(sql, id); obj = PostgreHelper.GetSingleEntity <Contact>(sql); return(obj); } catch (Exception ex) { throw ex; } }
/// <summary> /// 查询单笔数 /// </summary> /// <param user_name="user_user_name">用户名</param> /// <returns></returns> public person SelectSingle(string user_name) { try { person obj = new person(); string sql = "select * from fimp.person where user_name=N'{0}'"; sql = string.Format(sql, user_name); obj = PostgreHelper.GetSingleEntity <person>(sql); return(obj); } catch (Exception ex) { throw ex; } }
public rest_time SelectTime(string unit_no) { try { string sql = "select * from fimp.rest_time where unit_no={0}"; sql = string.Format(sql, unit_no); rest_time obj = new rest_time(); obj = PostgreHelper.GetSingleEntity <rest_time>(sql); return(obj); } catch (Exception ex) { throw ex; } }
/// <summary> /// 通过id返回视图里面的人员及部门对象 /// </summary> /// <param name="id"></param> /// <returns></returns> public PersonDept SelectPersonByID(int id) { try { PersonDept obj = new PersonDept(); string sql = "select * from fimp.person_dept_view where id={0}"; sql = string.Format(sql, id); obj = PostgreHelper.GetSingleEntity <PersonDept>(sql); return(obj); } catch (Exception ex) { throw ex; } }
public rest_time_row SelectSingle(string machine_code, string ts) { try { rest_time_row obj = new rest_time_row(); string sql = "select * from fimp.rest_time_row where machine_code='{0}' and start_time<='{1}' and end_time>='{2}'"; sql = string.Format(sql, machine_code, ts, ts); obj = PostgreHelper.GetSingleEntity <rest_time_row>(sql); return(obj); } catch (Exception ex) { throw ex; } }
public person SelectSingleByID(int id) { try { person obj = new person(); string sql = "select * from fimp.person where id={0}"; sql = string.Format(sql, id); obj = PostgreHelper.GetSingleEntity <person>(sql); return(obj); } catch (Exception ex) { throw ex; } }
//查询单笔数据 public city_info SelectSingle(int id) { try { city_info obj = new city_info(); string sql = "SELECT * FROM fimp.city_info where city_id={0} order by area_id,city_id"; sql = string.Format(sql, id); obj = PostgreHelper.GetSingleEntity <city_info>(sql); return(obj); } catch (Exception ex) { throw ex; } }
public client_config_info SelectSingle(string client_mac) { try { client_config_info obj = new client_config_info(); string sql = "select * from fimp.client_config_info where client_mac='{0}'"; sql = string.Format(sql, client_mac); obj = PostgreHelper.GetSingleEntity <client_config_info>(sql); return(obj); } catch (Exception ex) { throw ex; } }
/// <summary> /// 根据id_num 查询信息 /// </summary> /// <param user_name="user_name"></param> /// <returns></returns> public person Selectnum(string card_num) { try { person obj = new person(); string sql = "select * from fimp.person where card_num=N'{0}'"; sql = string.Format(sql, card_num); obj = PostgreHelper.GetSingleEntity <person>(sql); return(obj); } catch (Exception ex) { throw ex; } }
//查询所有material_request_info public material_request_info SelectById(int id) { try { material_request_info obj = new material_request_info(); string sql = "SELECT id, material_id,station_id,request_person_id,work_order,part_num,request_count,take_person_id,take_time,remark,createtime FROM fimp.material_request_info where id ={0}"; sql = string.Format(sql, id); obj = PostgreHelper.GetSingleEntity <material_request_info>(sql); return(obj); } catch (Exception ex) { throw ex; } }