protected void Luuhinhvaodatabase(string hinh_nv, string ma_nv) { NHANVIENBusiness hinhnv = new NHANVIENBusiness(); Hinh_NHANVIEN n_v = new Hinh_NHANVIEN(); n_v.manv = ma_nv; n_v.hinh = hinh_nv; hinhnv.Update_hinh(n_v); }
protected void List_Nhanvien(string mnv) { try { NHANVIENBusiness nhanvien = new NHANVIENBusiness(); DataTable tbl = nhanvien.DetailsByField("manv", mnv); manhanvien.Text = tbl.Rows[0]["manv"].ToString(); hovaten.Text = tbl.Rows[0]["tennv"].ToString(); noisinh.Text = tbl.Rows[0]["noisinh"].ToString(); choohientai.Text = tbl.Rows[0]["noiohientai"].ToString(); ngaysinh.Text = tbl.Rows[0]["ngaysinh"].ToString().Substring(0, 10); CMND.Text = tbl.Rows[0]["socmnd"].ToString(); noisinh.Text = tbl.Rows[0]["noisinh"].ToString(); dienthoai.Text = tbl.Rows[0]["sodt"].ToString(); hdldso.Text = tbl.Rows[0]["sohd"].ToString(); donvi.SelectedIndex = donvi.Items.IndexOf(donvi.Items.FindByValue(tbl.Rows[0]["donviid"].ToString())); machuyenmon.SelectedIndex = machuyenmon.Items.IndexOf(machuyenmon.Items.FindByValue(tbl.Rows[0]["cmid"].ToString())); maphong.SelectedIndex = maphong.Items.IndexOf(maphong.Items.FindByValue(tbl.Rows[0]["phongid"].ToString())); machucvu.SelectedIndex = machucvu.Items.IndexOf(machucvu.Items.FindByValue(tbl.Rows[0]["cvid"].ToString())); dantoc.SelectedIndex = dantoc.Items.IndexOf(dantoc.Items.FindByValue(tbl.Rows[0]["dantoc"].ToString())); tongiao.SelectedIndex = tongiao.Items.IndexOf(tongiao.Items.FindByValue(tbl.Rows[0]["tongiao"].ToString())); loaihd.SelectedIndex = loaihd.Items.IndexOf(loaihd.Items.FindByValue(tbl.Rows[0]["loaihd"].ToString())); gioitinh.SelectedIndex = gioitinh.Items.IndexOf(gioitinh.Items.FindByValue(tbl.Rows[0]["gioitinh"].ToString())); giadinh.SelectedIndex = giadinh.Items.IndexOf(giadinh.Items.FindByValue(tbl.Rows[0]["giadinh"].ToString())); if (tbl.Rows[0]["hinh"] == DBNull.Value) { hinhnhanvien.ImageUrl = "/Images/noimage.png"; } else { if (File.Exists(Server.MapPath("/Images/" + tbl.Rows[0]["hinh"].ToString())) == true) { hinhnhanvien.ImageUrl = "/Images/" + tbl.Rows[0]["hinh"].ToString(); } else { hinhnhanvien.ImageUrl = "/Images/noimage.png"; } } ngayhd.Text = tbl.Rows[0]["ngayhd"].ToString().Substring(0, 10); ngaybd.Text = tbl.Rows[0]["ngaybd"].ToString().Substring(0, 10); } catch { } }
protected void them_Click(object sender, EventArgs e) { try { NHANVIENBusiness nv = new NHANVIENBusiness(); NHANVIEN n_v = new NHANVIEN(); DataNHANVIEN dtnv = new DataNHANVIEN(); DataTable dtsl = dtnv.DataGetListNHANVIEN(); int sl = dtsl.Rows.Count + 1; manhanvien.Text = Taomanv(donvi.SelectedValue, maphong.Text, sl); n_v.manv = manhanvien.Text; n_v.honv = hovaten.Text; n_v.bacluong = float.Parse(bacluong.SelectedValue.ToString()); n_v.bhxh = ""; n_v.cmid = decimal.Parse(machuyenmon.SelectedValue); n_v.cvid = decimal.Parse(machucvu.SelectedValue); n_v.dantoc = decimal.Parse(dantoc.SelectedValue); n_v.donviid = decimal.Parse(donvi.SelectedValue); n_v.email = ""; n_v.giadinh = decimal.Parse(giadinh.SelectedValue); n_v.gioitinh = decimal.Parse(gioitinh.SelectedValue); n_v.honv = hovaten.Text; n_v.loaihd = decimal.Parse(loaihd.SelectedValue); n_v.ngaybd = DateTime.Parse(ngaybd.Text); n_v.ngayct = DateTime.Parse(ngaybd.Text); n_v.ngayhd = DateTime.Parse(ngayhd.Text); n_v.ngaykt = System.DateTime.Now; n_v.ngaysinh = DateTime.Parse(ngaysinh.Text); n_v.noiohientai = choohientai.Text; n_v.noisinh = noisinh.Text; n_v.phongid = decimal.Parse(maphong.SelectedValue); n_v.socmnd = CMND.Text; n_v.sodt = dienthoai.Text; n_v.sohd = hdldso.Text; n_v.tdid = decimal.Parse(matrinhdo.SelectedValue); n_v.tennv = hovaten.Text; n_v.tongiao = decimal.Parse(tongiao.SelectedValue); nv.Insert(n_v); Luuhinhvaodatabase(loadhinh.FileName, manhanvien.Text); } catch { } }
protected void Page_Load(object sender, EventArgs e) { Form.Action = Request.RawUrl; if (!IsPostBack) { NHANVIENBusiness nhanvien = new NHANVIENBusiness(); DataTable ds_nhanvien = nhanvien.GetList(); danhsachnhanvien.DataSource = ds_nhanvien; danhsachnhanvien.DataBind(); // ------------------------- Load_Phong(); Load_chucvu(); Load_trinhdo(); Load_chuyenmon(); Load_dantoc(); Load_tongiao(); Load_bacluong(); Load_loaihd(); Load_gioitinh(); Load_donvi(); } }