public EmployeeActivityVO GetByID(int id) { EmployeeActivityVO vo = new EmployeeActivityVO(); DataTable dt = Select("ID=" + id + ""); if (dt.Rows.Count > 0) { vo = b.ConvertObj(dt.Rows[0], new EmployeeActivityVO()) as EmployeeActivityVO; } return(vo); }
public int Insert(EmployeeActivityVO vo) { int lastInsertId = 0; try { lastInsertId = b.Insert("Employee_Activity", b.ConvertColName(vo), b.ConvertValueList(vo)); } catch (SqlException ex) { throw ex; } return(lastInsertId); }
public int Update(EmployeeActivityVO vo) { int ID = 0; try { b.Update("Employee_Activity", vo.Id.ToString(), b.ConvertColName(vo), b.ConvertValueList(vo)); ID = vo.Id; } catch (SqlException ex) { throw ex; } return(ID); }