/// <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;
}
}
/// <summary>
/// 更新数据
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public int Update(rest_time obj)
{
try
{
string sql = "update fimp.rest_time set start_time='{0}',end_time='{1}',unit_no='{2}',state='{3}' where id={4}";
sql = string.Format(sql, obj.start_time, obj.end_time, obj.unit_no, obj.state, obj.id);
int count = PostgreHelper.ExecuteNonQuery(sql);
return(count);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 插入数据
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public int Insert(rest_time obj)
{
try
{
string sql = "Insert into fimp.rest_time(start_time,end_time,unit_no,state)values('{0}','{1}','{2}','{3}')";
sql = string.Format(sql, obj.start_time, obj.end_time, obj.unit_no, obj.state);
int count = PostgreHelper.ExecuteNonQuery(sql);
return(count);
}
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;
}
}
public rest_time SelectTime(string unit_no)
{
rest_time obj = RTS.SelectTime(unit_no);
return(obj);
}
public int Update(rest_time obj)
{
int count = RTS.Update(obj);
return(count);
}
public int Insert(rest_time obj)
{
int count = RTS.Insert(obj);
return(count);
}
public rest_time SelectSingle(int id)
{
rest_time obj = RTS.SelectSingle(id);
return(obj);
}