public SalaryVO GetByIDAndBranchID(int id, int branchId) { SalaryVO vo = new SalaryVO(); DataTable dt = Select("ID=" + id + " AND BranchID=" + branchId); if (dt.Rows.Count > 0) vo = b.ConvertObj(dt.Rows[0], new SalaryVO()) as SalaryVO; return vo; }
public int Insert(SalaryVO vo) { int lastInsertId = 0; try { lastInsertId = b.Insert("Salary", b.ConvertColName(vo), b.ConvertValueList(vo)); } catch (SqlException ex) { throw ex; } return lastInsertId; }
public int UpdateByRank(SalaryVO vo) { int ID = 0; try { b.Update("Salary", vo.Rank.ToString(), b.ConvertColName(vo), b.ConvertValueList(vo)); ID = vo.Id; } catch (SqlException ex) { throw ex; } return ID; }
public int Create(SalaryVO vo) { int id; if (!dao.isExist(vo.Id.ToString())) { id = dao.Insert(vo); } else { id = dao.Update(vo); } return(id); }