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;
 }
Пример #4
0
        public int Create(SalaryVO vo)
        {
            int id;

            if (!dao.isExist(vo.Id.ToString()))
            {
                id = dao.Insert(vo);
            }
            else
            {
                id = dao.Update(vo);
            }
            return(id);
        }