예제 #1
0
        public bool XoaThongTinHocSinh(string MaHS)
        {
            string strDelete = "Delete  from HocSinh where MaHS='" + MaHS + "'";

            SqlParameter[] pars       = new SqlParameter[6];
            HocSinh        objHocSinh = new HocSinh();

            pars[0]       = new SqlParameter("@Ho", SqlDbType.NChar, 20);
            pars[0].Value = objHocSinh.Ho;

            pars[1]       = new SqlParameter("@Ten", SqlDbType.NChar, 20);
            pars[1].Value = objHocSinh.Ten;

            pars[2]       = new SqlParameter("@MaHS", SqlDbType.NVarChar, 5);
            pars[2].Value = objHocSinh.MaHS;

            pars[3]       = new SqlParameter("@MaLop", SqlDbType.NVarChar, 5);
            pars[3].Value = objHocSinh.MaLop;

            pars[4]       = new SqlParameter("@NgaySinh", SqlDbType.Date);
            pars[4].Value = objHocSinh.NgaySinh;

            pars[5]       = new SqlParameter("@GioiTinh", SqlDbType.NChar, 5);
            pars[5].Value = objHocSinh.GioiTinh;

            return(DataProvider.ThucHienChucNang(strDelete, pars));
        }
예제 #2
0
        public bool ThemMoiHocSinh(HocSinh objHocSinh)
        {
            string strInsert = "Insert into HocSinh(Ho,Ten,MaHS,MaLop,NgaySinh,GioiTinh) values(@Ho,@Ten,@MaHS,@MaLop,@NgaySinh,@GioiTinh)";

            SqlParameter[] pars = new SqlParameter[6];

            pars[0]       = new SqlParameter("@Ho", SqlDbType.NChar, 20);
            pars[0].Value = objHocSinh.Ho;

            pars[1]       = new SqlParameter("@Ten", SqlDbType.NChar, 20);
            pars[1].Value = objHocSinh.Ten;

            pars[2]       = new SqlParameter("@MaHS", SqlDbType.NVarChar, 5);
            pars[2].Value = objHocSinh.MaHS;

            pars[3]       = new SqlParameter("@MaLop", SqlDbType.NChar, 10);
            pars[3].Value = objHocSinh.MaLop;

            pars[4]       = new SqlParameter("@NgaySinh", SqlDbType.Date);
            pars[4].Value = objHocSinh.NgaySinh;

            pars[5]       = new SqlParameter("@GioiTinh", SqlDbType.NChar, 10);
            pars[5].Value = objHocSinh.GioiTinh;

            return(DataProvider.ThucHienChucNang(strInsert, pars));
        }
예제 #3
0
        public bool CapNhatThongTinHS(HocSinh objHocSinh)
        {
            string strUpdate = "Update HocSinh set Ho=@Ho,Ten=@Ten,MaHS=@MaHS,MaLop=@MaLop,NgaySinh=@NgaySinh,GioiTinh=@GioiTinh";

            SqlParameter[] pars = new SqlParameter[6];

            pars[0]       = new SqlParameter("@Ho", SqlDbType.NChar, 20);
            pars[0].Value = objHocSinh.Ho;

            pars[1]       = new SqlParameter("@Ten", SqlDbType.NChar, 20);
            pars[1].Value = objHocSinh.Ten;

            pars[2]       = new SqlParameter("@MaHS", SqlDbType.NVarChar, 5);
            pars[2].Value = objHocSinh.MaHS;

            pars[3]       = new SqlParameter("@MaLop", SqlDbType.NVarChar, 5);
            pars[3].Value = objHocSinh.MaLop;

            pars[4]       = new SqlParameter("@NgaySinh", SqlDbType.Date);
            pars[4].Value = objHocSinh.NgaySinh;

            pars[5]       = new SqlParameter("@GioiTinh", SqlDbType.NChar, 5);
            pars[5].Value = objHocSinh.GioiTinh;



            return(DataProvider.ThucHienChucNang(strUpdate, pars));;
        }
        private void btnThucHien_Click(object sender, EventArgs e)
        {
            bool    Insert     = true;
            HocSinh objHocSinh = new HocSinh();

            if (!string.IsNullOrEmpty(MaHS))
            {
                Insert = false;
            }
            objHocSinh.Ho       = txtHo.Text;
            objHocSinh.Ten      = txtTen.Text;
            objHocSinh.MaHS     = txtMaHS.Text;
            objHocSinh.NgaySinh = dtNgaySinh.Value;
            objHocSinh.MaLop    = txtMaLop.Text;
            string GioiTinh = "" + cbGioiTinh.SelectedItem;

            objHocSinh.GioiTinh = GioiTinh;
            bool ketQua = false;

            if (Insert)
            {
                ketQua = DataProvider.lstDanhSach.ThemMoiHocSinh(objHocSinh);
            }
            else
            {
                ketQua = DataProvider.lstDanhSach.CapNhatThongTinHS(objHocSinh);
            }
            if (ketQua)
            {
                MessageBox.Show("Thực hiện thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.None);
                this.Close();
            }
        }
        private void HienThiThongTinHocSinh()
        {
            LuuTruDanhSach service    = new LuuTruDanhSach();
            HocSinh        objHocSinh = service.HienThiThongTinHocSinhTheoMaHS(MaHS);

            if (objHocSinh != null)
            {
                txtHo.Text       = objHocSinh.Ho;
                txtTen.Text      = objHocSinh.Ten;
                txtMaHS.Text     = objHocSinh.MaHS;
                txtMaLop.Text    = objHocSinh.MaLop;
                dtNgaySinh.Value = objHocSinh.NgaySinh;

                cbGioiTinh.SelectedValue = objHocSinh.GioiTinh;
            }
        }
예제 #6
0
        public HocSinh HienThiThongTinHocSinhTheoMaHS(string MaHS)
        {
            string    str        = "Select * from HocSinh where MaHS='" + MaHS + "'";
            HocSinh   objHocSinh = null;
            DataTable dt         = DataProvider.LayDanhSach(str);

            if (dt.Rows.Count > 0)
            {
                objHocSinh      = new HocSinh();
                objHocSinh.Ho   = "" + dt.Rows[0]["Ho"];
                objHocSinh.Ten  = "" + dt.Rows[0]["Ten"];
                objHocSinh.MaHS = "" + dt.Rows[0]["MaHS"];
                DateTime ngay = DateTime.Today;
                DateTime.TryParse("" + dt.Rows[0]["NgaySinh"], out ngay);
                objHocSinh.NgaySinh = ngay;
                objHocSinh.GioiTinh = "" + dt.Rows[0]["GioiTinh"];
                objHocSinh.MaLop    = "" + dt.Rows[0]["MaLop"];
            }
            return(objHocSinh);
        }