public int checkmaKhoiHoc_ID(int makhoihoc) { SqlParameter[] parm = new SqlParameter[] { new SqlParameter(PARM_MAKHOIHOC, SqlDbType.Int) }; parm[0].Value = makhoihoc; return((int)DataAccessHelper.ExecuteScalar(DataAccessHelper.ConnectionString, CommandType.StoredProcedure, "tbl_KhoiHoc_Check", parm)); }
public int checkmaLoaiDiem_ID(int maloaidiem) { SqlParameter[] parm = new SqlParameter[] { new SqlParameter(PARM_MALOAIDIEM, SqlDbType.Int) }; parm[0].Value = maloaidiem; return((int)DataAccessHelper.ExecuteScalar(DataAccessHelper.ConnectionString, CommandType.StoredProcedure, "tbl_LoaiDiem_Check", parm)); }
public int checkmaGiaoVien_ID(int magiaovien) { SqlParameter[] parm = new SqlParameter[] { new SqlParameter(PARM_MAGIAOVIEN, SqlDbType.Int) }; parm[0].Value = magiaovien; return((int)DataAccessHelper.ExecuteScalar(DataAccessHelper.ConnectionString, CommandType.StoredProcedure, "tbl_GiaoVien_Check", parm)); }
public int checkmaDiem_ID(int mahocsinh) { SqlParameter[] parm = new SqlParameter[] { new SqlParameter(PARM_MAHOCSINH, SqlDbType.Int) }; parm[0].Value = mahocsinh; return((int)DataAccessHelper.ExecuteScalar(DataAccessHelper.ConnectionString, CommandType.StoredProcedure, "tbl_HocSinh_Check", parm)); }
public int getmaGiaoVien_Last() { return((int)DataAccessHelper.ExecuteScalar(DataAccessHelper.ConnectionString, CommandType.Text, "select top 1 magiaovien from tbl_GiaoVien order by magiaovien desc", null)); }
public int getmaLoaiDiem_Last() { return((int)DataAccessHelper.ExecuteScalar(DataAccessHelper.ConnectionString, CommandType.Text, "select top 1 maloaidiem from tbl_LoaiDiem order by maloaidiem desc", null)); }
public int getmaMonHoc_Last() { return((int)DataAccessHelper.ExecuteScalar(DataAccessHelper.ConnectionString, CommandType.Text, "select top 1 mamonhoc from tbl_MonHoc order by mamonhoc desc", null)); }
public int getmaDiem_Last() { return((int)DataAccessHelper.ExecuteScalar(DataAccessHelper.ConnectionString, CommandType.Text, "select top 1 Mahocsinh from tbl_HocSinh order by Mahocsinh desc", null)); }