/// <summary> /// Chỗ này truyền vào tương tự hàm sửa.cũng theo khóa chính /// </summary> /// <param name="Ma"></param> /// <returns></returns> public HSSV LayHSSV(string Ma) { SqlParameter[] parm = new SqlParameter[] { new SqlParameter(PARM_MAHSSV, SqlDbType.NVarChar, 30) }; parm[0].Value = Ma; SqlDataReader d = DALHelper.ExecuteReader(DALHelper.ConnectionString, CommandType.StoredProcedure, "tblHSSV_Lay1", parm); HSSV hs = new HSSV(); if (d.Read()) { hs.MaHSSV = d[0].ToString(); hs.HoTen = d[1].ToString(); hs.MaLop = d[2].ToString(); hs.GioiTinh = bool.Parse(d[3].ToString()); hs.NgaySinh = DateTime.Parse(d[4].ToString()); hs.NoiSinh = d[5].ToString(); hs.QueQuan = d[6].ToString(); hs.NoiOHienNay = d[7].ToString(); hs.DienThoai = d[8].ToString(); hs.EMail = d[9].ToString(); hs.UrlPhoto = d[10].ToString(); hs.GhiChu = d[11].ToString(); hs.MatKhau = d[12].ToString(); hs.TrangThai = bool.Parse(d[13].ToString()); } return(hs); }
public List <HSSV> DSHSSV() { SqlDataReader d = DALHelper.ExecuteReader(DALHelper.ConnectionString, CommandType.StoredProcedure, "tblHSSV_DS", null);//chỗ này để ý cuối là null List <HSSV> mylist = new List <HSSV>(); while (d.Read()) { HSSV hs = new HSSV(); hs.MaHSSV = d[0].ToString(); hs.HoTen = d[1].ToString(); hs.MaLop = d[2].ToString(); hs.GioiTinh = bool.Parse(d[3].ToString()); hs.NgaySinh = DateTime.Parse(d[4].ToString()); hs.NoiSinh = d[5].ToString(); hs.QueQuan = d[6].ToString(); hs.NoiOHienNay = d[7].ToString(); hs.DienThoai = d[8].ToString(); hs.EMail = d[9].ToString(); hs.UrlPhoto = d[10].ToString(); hs.GhiChu = d[11].ToString(); hs.MatKhau = d[12].ToString(); hs.TrangThai = bool.Parse(d[13].ToString()); mylist.Add(hs); } d.Dispose(); return(mylist); }
protected void btnSave_Click(object sender, EventArgs e) { HSSV hssv = new HSSV(); hssv.HoTen = txtHoTen.Text; hssv.MaLop = txtMaLop.Text; hssv.GioiTinh = rdbNam.Checked; hssv.NgaySinh = DateTime.Parse(txtNgaySinh.Text); hssv.NoiSinh = txtNoiSinh.Text; hssv.QueQuan = txtQueQuan.Text; hssv.NoiOHienNay = txtNoiOHienNay.Text; hssv.DienThoai = txtDienThoai.Text; hssv.EMail = txtEMail.Text; hssv.GhiChu = txtGhiChu.Text; hssv.MatKhau = txtMatKhau.Text; hssv.TrangThai = rdHD.Checked; if (fileAnh.HasFile) { hssv.UrlPhoto = Up(fileAnh); } if (editType.Value == "add") { hssv.MaHSSV = txtMaHSSV.Text; int t = hssvbll.Them(hssv); LoadHSSV(); } else { hssv.MaHSSV = txtMaHSSV.Text; hssvbll.Sua(hssv); LoadHSSV(); EditState.Value = "hide"; } EditState.Value = "hide"; //if (fileAnh.HasFile) //{ // hssv.UrlPhoto = Up(fileAnh); //} //if (editType.Value == "add") //{ // hssv.MaHSSV = txtMaHSSV.Text; // int t = hssvbll.Them(hssv); // LoadHSSV(); //} //else //{ // hssv.MaHSSV = txtMaHSSV.Text; // hssvbll.Sua(hssv); // LoadHSSV(); // EditState.Value = "hide"; //} }
protected void grvHSSV_RowCommand(object sender, GridViewCommandEventArgs e) { GridViewRow gvr; try { gvr = (GridViewRow)(((LinkButton)e.CommandSource).NamingContainer); } catch { return; } int index = gvr.RowIndex; if (e.CommandName == "Sua") { HSSV hssv = new HSSV(); GridViewRow gvrow = grvHSSV.Rows[index]; txtMaHSSV.Enabled = false; txtMaHSSV.Text = HttpUtility.HtmlDecode(gvrow.Cells[0].Text).ToString(); hssv = hssvbll.LayHSSV(txtMaHSSV.Text); txtHoTen.Text = hssv.HoTen; txtMaLop.Text = hssv.MaLop; if (hssv.GioiTinh) { rdbNam.Checked = true; } else { rdbNu.Checked = true; } txtNgaySinh.Text = hssv.NgaySinh.ToShortDateString(); txtNoiSinh.Text = hssv.NoiSinh; txtQueQuan.Text = hssv.QueQuan; txtNoiOHienNay.Text = hssv.NoiOHienNay; txtDienThoai.Text = hssv.DienThoai; txtEMail.Text = hssv.EMail; txtGhiChu.Text = hssv.GhiChu; if (hssv.TrangThai) { rdHD.Checked = true; } else { rdKHD.Checked = true; } EditState.Value = "edit"; editType.Value = "edit"; } else if (e.CommandName == "Xoa") { GridViewRow gvrow = grvHSSV.Rows[index]; string id = HttpUtility.HtmlDecode(gvrow.Cells[0].Text).ToString(); idDelete.Value = id; EditState.Value = "delete"; } }
public int Sua(HSSV hs) { SqlParameter[] parm = new SqlParameter[] { new SqlParameter(PARM_MAHSSV, SqlDbType.NVarChar, 30), new SqlParameter(PARM_HOTEN, SqlDbType.NVarChar, 30), new SqlParameter(PARM_MALOP, SqlDbType.NVarChar, 30), new SqlParameter(PARM_GIOITINH, SqlDbType.Bit), new SqlParameter(PARM_NGAYSINH, SqlDbType.Date), new SqlParameter(PARM_NOISINH, SqlDbType.NVarChar, 100), new SqlParameter(PARM_QUEQUAN, SqlDbType.NVarChar, 100), new SqlParameter(PARM_NOIOHIENNAY, SqlDbType.NVarChar, 100), new SqlParameter(PARM_DIENTHOAI, SqlDbType.NVarChar, 30), new SqlParameter(PARM_EMAIL, SqlDbType.NVarChar, 30), new SqlParameter(PARM_URLPHOTO, SqlDbType.NVarChar, 150), new SqlParameter(PARM_GHICHU, SqlDbType.NVarChar, 1000), new SqlParameter(PARM_MATKHAU, SqlDbType.NVarChar, 30), new SqlParameter(PARM_TRANGTHAI, SqlDbType.Bit) }; parm[0].Value = hs.MaHSSV; parm[1].Value = hs.HoTen; parm[2].Value = hs.MaLop; parm[3].Value = hs.GioiTinh; parm[4].Value = hs.NgaySinh; parm[5].Value = hs.NoiSinh; parm[6].Value = hs.QueQuan; parm[7].Value = hs.NoiOHienNay; parm[8].Value = hs.DienThoai; parm[9].Value = hs.EMail; if (hs.UrlPhoto == "" || hs.UrlPhoto == null) { parm[10].Value = DBNull.Value; } else { parm[10].Value = hs.UrlPhoto; } if (hs.GhiChu == "" || hs.GhiChu == null) { parm[11].Value = DBNull.Value; } else { parm[11].Value = hs.GhiChu; } parm[12].Value = hs.MatKhau; parm[13].Value = hs.TrangThai; return(DALHelper.ExecuteNonQuery(DALHelper.ConnectionString, CommandType.StoredProcedure, "tblHSSV_Sua", parm)); }
public HSSV Login(string Ma, string pass) { SqlParameter[] parm = new SqlParameter[] { new SqlParameter(PARM_MAHSSV, SqlDbType.NVarChar, 30), new SqlParameter(PARM_MATKHAU, SqlDbType.NVarChar, 30) }; parm[0].Value = Ma; parm[1].Value = pass; SqlDataReader d = DALHelper.ExecuteReader(DALHelper.ConnectionString, CommandType.StoredProcedure, "tblHSSV_Login", parm); HSSV tt = new HSSV(); if (d.Read()) { tt.MaHSSV = d[0].ToString(); tt.HoTen = d[1].ToString(); tt.UrlPhoto = d[2].ToString(); } return(tt); }
public int Sua(HSSV hs) { return(hsdal.Sua(hs)); }
public int Them(HSSV hs) { return(hsdal.Them(hs)); }