public IList <LopHoc> getAll(int PageNo, int PageSize, int Makhoihoc, int Siso, out int RecordCount) { SqlParameter[] parm = new SqlParameter[] { new SqlParameter("@PageIndex", SqlDbType.Int), new SqlParameter("@PageSize", SqlDbType.Int), new SqlParameter("@makhoihoc", SqlDbType.Int), new SqlParameter("@siso", SqlDbType.Int), }; parm[0].Value = PageNo; parm[1].Value = PageSize; parm[2].Value = Makhoihoc; parm[3].Value = Siso; RecordCount = 0; SqlDataReader dra = DataAccessHelper.ExecuteReader(DataAccessHelper.ConnectionString, CommandType.StoredProcedure, "tbl_LopHoc_Sel_All_Page", parm); IList <LopHoc> list = new List <LopHoc>(); while (dra.Read()) { RecordCount = int.Parse(dra["RecordCount"].ToString()); list.Add(new LopHoc( int.Parse(dra["malop"].ToString()), dra["tenlop"].ToString(), int.Parse(dra["makhoihoc"].ToString()), int.Parse(dra["magiaovien"].ToString()), int.Parse(dra["siso"].ToString()))); } dra.Dispose(); return(list); }
public IList <MonHoc> getAll(int Mamonhoc, string Tenmonhoc, int Sotiet, out int RecordCount) { SqlParameter[] parm = new SqlParameter[] { new SqlParameter("@mamochoc", SqlDbType.Int), new SqlParameter("@tenmonhoc", SqlDbType.NVarChar, 20), new SqlParameter("@sotiet", SqlDbType.Int), }; parm[0].Value = Mamonhoc; parm[1].Value = Tenmonhoc; parm[2].Value = Sotiet; RecordCount = 0; SqlDataReader dra = DataAccessHelper.ExecuteReader(DataAccessHelper.ConnectionString, CommandType.StoredProcedure, "tbl_MonHoc_Sel_All_Page", parm); IList <MonHoc> list = new List <MonHoc>(); while (dra.Read()) { RecordCount = int.Parse(dra["RecordCount"].ToString()); list.Add(new MonHoc( int.Parse(dra["mamonhoc"].ToString()), dra["tenmonhoc"].ToString(), int.Parse(dra["sotiet"].ToString()))); } dra.Dispose(); return(list); }
public Diem getmaDiem(int mabangdiem) { SqlParameter[] parm = new SqlParameter[] { new SqlParameter(PARM_MABANGDIEM, SqlDbType.Int) }; parm[0].Value = mabangdiem; Diem d = null; SqlDataReader dra = DataAccessHelper.ExecuteReader(DataAccessHelper.ConnectionString, CommandType.StoredProcedure, "tbl_Diem_Sel_ID", parm); if (dra.Read()) { d = new Diem( int.Parse(dra["mabangdiem"].ToString()), int.Parse(dra["malop"].ToString()), int.Parse(dra["mahocsinh"].ToString()), int.Parse(dra["kihoc"].ToString()), dra["namhoc"].ToString(), float.Parse(dra["diemtb"].ToString()), dra["hanhkiem"].ToString(), dra["hocluc"].ToString(), dra["danhhieu"].ToString(), int.Parse(dra["magiaovien"].ToString())); } dra.Dispose(); return(d); }
//public IList<HocSinh> getAll(int PageNo, int PageSize, string Tenhocsinh, string Quequan, out int RecordCount) //{ // SqlParameter[] parm = new SqlParameter[] // { // new SqlParameter("@PageIndex",SqlDbType.Int), // new SqlParameter("@PageSize",SqlDbType.Int), // new SqlParameter("@tenhocsinh",SqlDbType.NVarChar,20), // new SqlParameter("@quequan",SqlDbType.NVarChar,20), // }; // parm[0].Value = PageNo; // parm[1].Value = PageSize; // parm[2].Value = Tenhocsinh; // parm[3].Value = Quequan; // RecordCount = 0; // SqlDataReader dra = DataAccessHelper.ExecuteReader(DataAccessHelper.ConnectionString, CommandType.StoredProcedure, "tbl_HocSinh_Sell_All_Page", parm); // IList<HocSinh> list = new List<HocSinh>(); // while (dra.Read()) // { // RecordCount = int.Parse(dra["RecordCount"].ToString()); // list.Add(new HocSinh( // int.Parse(dra["mahocsinh"].ToString()), // int.Parse(dra["malop"].ToString()), // dra["tenhocsinh"].ToString(), // DateTime.Parse(dra["ngaysinh"].ToString()), // dra["gioitinh"].ToString(), // dra["quequan"].ToString(), // dra["sodienthoai"].ToString(), // dra["socmnd"].ToString())); // } // dra.Dispose(); // return list; //} public HocSinh getmaHocSinh(int mahocsinh) { SqlParameter[] parm = new SqlParameter[] { new SqlParameter(PARM_MAHOCSINH, SqlDbType.Int) }; parm[0].Value = mahocsinh; HocSinh hs = null; SqlDataReader dra = DataAccessHelper.ExecuteReader(DataAccessHelper.ConnectionString, CommandType.StoredProcedure, "tbl_HocSinh_Sel_ID", parm); if (dra.Read()) { hs = new HocSinh( int.Parse(dra["mahocsinh"].ToString()), int.Parse(dra["malop"].ToString()), dra["tenhocsinh"].ToString(), DateTime.Parse(dra["ngaysinh"].ToString()), dra["gioitinh"].ToString(), dra["quequan"].ToString(), dra["sodienthoai"].ToString(), dra["socmnd"].ToString()); } dra.Dispose(); return(hs); }
public IList <KhoiHoc> getAll() { SqlDataReader dra = DataAccessHelper.ExecuteReader(DataAccessHelper.ConnectionString, CommandType.StoredProcedure, "tbl_KhoiHoc_Sel_All", null); IList <KhoiHoc> list = new List <KhoiHoc>(); while (dra.Read()) { list.Add(new KhoiHoc( int.Parse(dra["makhoihoc"].ToString()), dra["tenkhoihoc"].ToString())); } dra.Dispose(); return(list); }
public IList <LoaiDiem> getAll() { SqlDataReader dra = DataAccessHelper.ExecuteReader(DataAccessHelper.ConnectionString, CommandType.StoredProcedure, "tbl_LoaiDiem_Sel_All", null); IList <LoaiDiem> list = new List <LoaiDiem>(); while (dra.Read()) { list.Add(new LoaiDiem( int.Parse(dra["maloaidiem"].ToString()), dra["tenloaidiem"].ToString(), int.Parse(dra["heso"].ToString()))); } dra.Dispose(); return(list); }
public KhoiHoc getmaKhoiHoc(int makhoihoc) { SqlParameter[] parm = new SqlParameter[] { new SqlParameter(PARM_MAKHOIHOC, SqlDbType.Int) }; parm[0].Value = makhoihoc; KhoiHoc cls = null; SqlDataReader dra = DataAccessHelper.ExecuteReader(DataAccessHelper.ConnectionString, CommandType.StoredProcedure, "tbl_KhoiHoc_Sel_ID", parm); if (dra.Read()) { cls = new KhoiHoc( int.Parse(dra["makhoihoc"].ToString()), dra["tenkhoihoc"].ToString()); } dra.Dispose(); return(cls); }
public IList <GiaoVien> getAll() { SqlDataReader dra = DataAccessHelper.ExecuteReader(DataAccessHelper.ConnectionString, CommandType.StoredProcedure, "tbl_GiaoVien_Sel_All", null); IList <GiaoVien> list = new List <GiaoVien>(); while (dra.Read()) { list.Add(new GiaoVien( int.Parse(dra["magiaovien"].ToString()), dra["tengiaovien"].ToString(), DateTime.Parse(dra["ngaysinh"].ToString()), dra["gioitinh"].ToString(), dra["quequan"].ToString(), dra["sodienthoai"].ToString(), dra["socmnd"].ToString())); } dra.Dispose(); return(list); }
public LoaiDiem getmaLoaiDiem(int maloaidiem) { SqlParameter[] parm = new SqlParameter[] { new SqlParameter(PARM_MALOAIDIEM, SqlDbType.Int) }; parm[0].Value = maloaidiem; LoaiDiem ld = null; SqlDataReader dra = DataAccessHelper.ExecuteReader(DataAccessHelper.ConnectionString, CommandType.StoredProcedure, "tbl_LoaiDiem_Sel_ID", parm); if (dra.Read()) { ld = new LoaiDiem( int.Parse(dra["maloaidiem"].ToString()), dra["tenloaidiem"].ToString(), int.Parse(dra["heso"].ToString())); } dra.Dispose(); return(ld); }
public MonHoc getmaMonHoc(int mamonhoc) { SqlParameter[] parm = new SqlParameter[] { new SqlParameter(PARM_MAMONHOC, SqlDbType.Int) }; parm[0].Value = mamonhoc; MonHoc l = null; SqlDataReader dra = DataAccessHelper.ExecuteReader(DataAccessHelper.ConnectionString, CommandType.StoredProcedure, "tbl_MonHoc_Sel_ID", parm); if (dra.Read()) { l = new MonHoc( int.Parse(dra["mamonhoc"].ToString()), dra["tenmonhoc"].ToString(), int.Parse(dra["sotiet"].ToString())); } dra.Dispose(); return(l); }
public IList <CTDiem> getAll() { SqlDataReader dra = DataAccessHelper.ExecuteReader(DataAccessHelper.ConnectionString, CommandType.StoredProcedure, "tbl_CTDiem_Sel_All", null); IList <CTDiem> list = new List <CTDiem>(); while (dra.Read()) { list.Add(new CTDiem( int.Parse(dra["mactdiem"].ToString()), int.Parse(dra["mabangdiem"].ToString()), int.Parse(dra["mahocsinh"].ToString()), int.Parse(dra["mamonhoc"].ToString()), int.Parse(dra["maloaidiem"].ToString()), int.Parse(dra["diem"].ToString()), float.Parse(dra["diemtb"].ToString()), int.Parse(dra["magiaovien"].ToString()))); } dra.Dispose(); return(list); }
public LopHoc getmaLopHoc(int malop) { SqlParameter[] parm = new SqlParameter[] { new SqlParameter(PARM_MALOP, SqlDbType.Int) }; parm[0].Value = malop; LopHoc l = null; SqlDataReader dra = DataAccessHelper.ExecuteReader(DataAccessHelper.ConnectionString, CommandType.StoredProcedure, "tbl_LopHoc_Sel_ID", parm); if (dra.Read()) { l = new LopHoc( int.Parse(dra["malop"].ToString()), dra["tenlop"].ToString(), int.Parse(dra["makhoihoc"].ToString()), int.Parse(dra["magiaovien"].ToString()), int.Parse(dra["siso"].ToString())); } dra.Dispose(); return(l); }
public IList <Diem> getAll(int PageNo, int PageSize, int Malop, int Kihoc, string Namhoc, out int RecordCount) { SqlParameter[] parm = new SqlParameter[] { new SqlParameter("@PageIndex", SqlDbType.Int), new SqlParameter("@PageSize", SqlDbType.Int), new SqlParameter("@malop", SqlDbType.Int), new SqlParameter("@kihoc", SqlDbType.Int), new SqlParameter("@namhoc", SqlDbType.NVarChar, 20), }; parm[0].Value = PageNo; parm[1].Value = PageSize; parm[2].Value = Malop; parm[3].Value = Kihoc; parm[3].Value = Namhoc; RecordCount = 0; SqlDataReader dra = DataAccessHelper.ExecuteReader(DataAccessHelper.ConnectionString, CommandType.StoredProcedure, "tbl_HocSinh_Sell_All_Page", parm); IList <Diem> list = new List <Diem>(); while (dra.Read()) { RecordCount = int.Parse(dra["RecordCount"].ToString()); list.Add(new Diem( int.Parse(dra["mabangdiem"].ToString()), int.Parse(dra["malop"].ToString()), int.Parse(dra["mahocsinh"].ToString()), int.Parse(dra["kihoc"].ToString()), dra["namhoc"].ToString(), float.Parse(dra["diemtb"].ToString()), dra["hanhkiem"].ToString(), dra["hocluc"].ToString(), dra["danhhieu"].ToString(), int.Parse(dra["magiaovien"].ToString()))); } dra.Dispose(); return(list); }
public IList <GiaoVien> getAll(int Magiaovien, string Tengiaovien, DateTime Ngaysinh, string Gioitinh, string Quequan, string Sodienthoai, string Socmnd, out int RecordCount) { SqlParameter[] parm = new SqlParameter[] { new SqlParameter("@magiaovien", SqlDbType.Int), new SqlParameter("@tengiaovien", SqlDbType.NVarChar, 20), new SqlParameter("@ngaysinh", SqlDbType.DateTime), new SqlParameter("@gioitinh", SqlDbType.NVarChar, 20), new SqlParameter("@quequan", SqlDbType.NVarChar, 20), new SqlParameter("@sodienthoai", SqlDbType.NVarChar, 20), new SqlParameter("@socmnd", SqlDbType.NVarChar, 20), }; parm[0].Value = Magiaovien; parm[1].Value = Tengiaovien; parm[2].Value = Ngaysinh; parm[3].Value = Gioitinh; parm[4].Value = Quequan; parm[5].Value = Sodienthoai; parm[6].Value = Socmnd; RecordCount = 0; SqlDataReader dra = DataAccessHelper.ExecuteReader(DataAccessHelper.ConnectionString, CommandType.StoredProcedure, "tbl_GiaoVien_Sel_All_Page", parm); IList <GiaoVien> list = new List <GiaoVien>(); while (dra.Read()) { RecordCount = int.Parse(dra["RecordCount"].ToString()); list.Add(new GiaoVien( int.Parse(dra["magiaovien"].ToString()), dra["tengiaovien"].ToString(), DateTime.Parse(dra["ngaysinh"].ToString()), dra["gioitinh"].ToString(), dra["quequan"].ToString(), dra["sodienthoai"].ToString(), dra["socmnd"].ToString())); } dra.Dispose(); return(list); }
public GiaoVien getmaGiaoVien(int magiaovien) { SqlParameter[] parm = new SqlParameter[] { new SqlParameter(PARM_MAGIAOVIEN, SqlDbType.Int) }; parm[0].Value = magiaovien; GiaoVien gv = null; SqlDataReader dra = DataAccessHelper.ExecuteReader(DataAccessHelper.ConnectionString, CommandType.StoredProcedure, "tbl_KhoiHoc_Sel_ID", parm); if (dra.Read()) { gv = new GiaoVien( int.Parse(dra["magiaovien"].ToString()), dra["tengiaovien"].ToString(), DateTime.Parse(dra["ngaysinh"].ToString()), dra["gioitinh"].ToString(), dra["quequan"].ToString(), dra["sodienthoai"].ToString(), dra["socmnd"].ToString()); } dra.Dispose(); return(gv); }
public Users checkAccount(string tenuser, string password) { SqlParameter[] parm = new SqlParameter[] { new SqlParameter(PARM_TENUSER, SqlDbType.NVarChar, 20), new SqlParameter(PARM_PASSWORD, SqlDbType.NVarChar, 20), }; parm[0].Value = tenuser; parm[1].Value = password; Users cls = null; SqlDataReader dra = DataAccessHelper.ExecuteReader(DataAccessHelper.ConnectionString, CommandType.StoredProcedure, "tbl_User_CheckAccount", parm); if (dra.Read()) { cls = new Users( int.Parse(dra["mauser"].ToString()), dra["tenuser"].ToString(), dra["passwword"].ToString(), dra["tenrole"].ToString(), dra["trangthai"].ToString()); } dra.Dispose(); return(cls); }