public DataSet SelectAll() { SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@Mode", "View"); return(objDBBridge.ExecuteDataSet(_spName, param)); }
public DataSet SelectByEmployee() { SqlParameter[] param = new SqlParameter[3]; param[0] = new SqlParameter("@Mode", "ViewByEmployee"); param[1] = new SqlParameter("@EmployeeId", _employeeId); param[2] = new SqlParameter("@JobType", _jobType); return(objDBBridge.ExecuteDataSet(_spname, param)); }