/// <summary>
/// 执行插入人员信息方法
/// </summary>
/// <param name="obj"></param>
/// <returns>影响行数</returns>
public int Insert(machine_working_time obj)
{
try
{
string sql = "insert into fimp.machine_working_time(machine_id,plant_id,unit_no,line_id,station_id,part_num,standard_time )values({0},{1},'{2}',{3},{4},'{5}',{6})";
sql = string.Format(sql, obj.machine_id, obj.plant_id, obj.unit_no, obj.line_id, obj.station_id, obj.part_num, obj.standard_time);
int count = PostgreHelper.ExecuteNonQuery(sql);
return(count);
}
catch (Exception ex)
{
throw ex;
}
}
public machine_working_time SelectSingleID(int id)
{
try
{
machine_working_time obj = new machine_working_time();
string sql = "select * from fimp.machine_working_time where id={0}";
sql = string.Format(sql, id);
obj = PostgreHelper.GetSingleEntity <machine_working_time>(sql);
return(obj);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 更新信息
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public int Update(machine_working_time obj)
{
try
{
int count = 0;
string sql = "update fimp.machine_working_time set machine_id={0},plant_id={1},unit_no='{2}',line_id={3},station_id={4},part_num='{5}',standard_time={6} where id={7}";
sql = string.Format(sql, obj.machine_id, obj.plant_id, obj.unit_no, obj.line_id, obj.station_id, obj.part_num, obj.standard_time, obj.id);
count = PostgreHelper.ExecuteNonQuery(sql);
return(count);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 查询所有信息
/// </summary>
/// <param name="user_name">根据用户名查询，可为空</param>
/// <returns></returns>
public List <machine_working_time> SelectAll(machine_working_time obj, string unit_no = null)
{
try
{
List <machine_working_time> objList = new List <machine_working_time>();
string sql = null;
if (!string.IsNullOrEmpty(unit_no))
{
sql = "SELECT * FROM fimp.machine_working_time where unit_no='{0}' order by unit_no";
sql = string.Format(sql, unit_no);
}
else
{
if (obj.plant_id > 0 && string.IsNullOrEmpty(obj.unit_no) && obj.line_id <= 0)
{
sql = "SELECT * FROM fimp.machine_working_time where plant_id={0} order by plant_id";
sql = string.Format(sql, obj.plant_id);
}
else if (obj.plant_id > 0 && !string.IsNullOrEmpty(obj.unit_no) && obj.line_id <= 0)
{
sql = "SELECT * FROM fimp.machine_working_time where and plant_id={0} and unit_no='{1}' order by plant_id,unit_no";
sql = string.Format(sql, obj.plant_id, obj.unit_no);
}
else if (obj.plant_id > 0 && !string.IsNullOrEmpty(obj.unit_no) && obj.line_id > 0)
{
sql = "SELECT * FROM fimp.machine_working_time where plant_id={0} and unit_no='{1}' and line_id={2} order by plant_id,unit_no,line_id";
sql = string.Format(sql, obj.plant_id, obj.unit_no, obj.line_id);
}
else
{
sql = "SELECT * FROM fimp.machine_working_time order by id";
}
}
objList = PostgreHelper.GetEntityList <machine_working_time>(sql);
return(objList);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 根据机种和设备id或者站位id去查找
/// </summary>
/// <param name="MachineId"></param>
/// <param name="StationId"></param>
/// <returns></returns>
public machine_working_time SelectTime(string part_num, int MachineId = -1, int StationId = -1)
{
try
{
string sql;
machine_working_time obj = new machine_working_time();
if (MachineId > 0)
{
sql = string.Format("select * from fimp.machine_working_time where machine_id={0} and part_num={1}", MachineId, part_num);
}
else
{
sql = string.Format("select * from fimp.machine_working_time where station_id={0} and part_num={1}", StationId, part_num);
}
obj = PostgreHelper.GetSingleEntity <machine_working_time>(sql);
return(obj);
}
catch (Exception ex)
{
throw ex;
}
}
public int Update(machine_working_time obj)
{
int count = AIS.Update(obj);
return(count);
}
public int Insert(machine_working_time obj)
{
int count = AIS.Insert(obj);
return(count);
}
/// <summary>
/// 根据设备或者站位标识去查找
/// </summary>
/// <param name="MachineId"></param>
/// <param name="StationId"></param>
/// <returns></returns>
public machine_working_time SelectSingle(int MachineId = -1, int StationId = -1)
{
machine_working_time obj = AIS.SelectSingle(MachineId, StationId);
return(obj);
}
public machine_working_time SelectSingleID(int id)
{
machine_working_time obj = AIS.SelectSingleID(id);
return(obj);
}
public List <machine_working_time> SelectAll(machine_working_time obj, string unit_no = null)
{
List <machine_working_time> objList = AIS.SelectAll(obj, unit_no);
return(objList);
}