public int Update(error_quality_log obj) { int count = 0; try { count = PostgreHelper.UpdateSingleEntity <error_quality_log>(obj); return(count); } catch (Exception ex) { return(count); } }
public int Insert(error_quality_log obj) { try { string sql = "Insert into andon.error_quality_log(error_log_id,error_type_id,station_id,machine_code,defectives_count,quality_description,quality_reason,improve_plan,plan_date,responsible_person,remark,insert_time)" + "values({0},{1},{2},'{3}',{4},'{5}','{6}','{7}','{8}','{9}','{10}','{11}')"; sql = string.Format(sql, obj.error_log_id, obj.error_type_id, obj.station_id, obj.machine_code, obj.defectives_count, obj.quality_description, obj.quality_reason, obj.improve_plan, obj.plan_date, obj.responsible_person, obj.remark, obj.insert_time); int count = PostgreHelper.ExecuteNonQuery(sql); return(count); } catch (Exception ex) { throw ex; } }
public error_quality_log GetQualityLog(int LogId) { error_quality_log obj = new error_quality_log(); try { string sql = "select * from andon.error_quality_log where error_log_id='{0}'"; sql = string.Format(sql, LogId); obj = PostgreHelper.GetSingleEntity <error_quality_log>(sql); return(obj); } catch (Exception ex) { return(null); } }
public int Insert(error_quality_log obj) { int count = EQLS.Insert(obj); return(count); }
public error_quality_log GetQualityLog(int LogId) { error_quality_log obj = EQLS.GetQualityLog(LogId); return(obj); }
public int Update(error_quality_log obj) { int count = EQLS.Update(obj); return(count); }