private void comboBox1_SelectionChangeCommitted(object sender, EventArgs e) { string id = comboBox1.Text; staffDTO p = NhanVien.Ins.getNV(id); lbName.Text = p.Hoten; }
public List <staffDTO> getListDTO() { string query = "SELECT * FROM NHANVIEN WHERE ACTIVE = 1"; DataTable rs = Provider.Ins.ExcuteQuery(query); List <staffDTO> ls = new List <staffDTO>(); staffDTO p; for (int i = 0; i < rs.Rows.Count; i++) { p = new staffDTO(); p.Id = rs.Rows[i][0].ToString(); p.Hoten = rs.Rows[i][1].ToString(); p.Gtinh = rs.Rows[i][2].ToString(); p.Ngsinh = (DateTime)rs.Rows[i][3]; p.Dchi = rs.Rows[i][4].ToString(); p.Cmnd = rs.Rows[i][5].ToString(); p.Trangthai = (bool)rs.Rows[i][6]; p.Vitri = rs.Rows[i][7].ToString(); p.ImgStr = rs.Rows[i][8].ToString(); p.Sdt = rs.Rows[i][9].ToString(); ls.Add(p); } return(ls); }
public ThemNhanVien() { InitializeComponent(); PathImg = ""; ImgStrDefault = Convert.ToBase64String(NhanVien.Ins.converImgToByte(@"..\..\images\user.png")); staff = new staffDTO(); txtID.Text = NhanVien.Ins.getMaNVnext(); }
public SuaNhanVien(string id) { InitializeComponent(); PathImg = ""; staff = NhanVien.Ins.getNV(id); ImgStrDefault = staff.ImgStr; BindingData(); }
public AccControl(string id) { InitializeComponent(); if (id.Contains("NV") == true) { p = NhanVien.Ins.getNV(id); acc = Account.Ins.getAccount(id); } }
private void button1_Click(object sender, EventArgs e) { SuaNhanVien form = new SuaNhanVien(lbID.Text); form.ShowDialog(); staffDTO p = NhanVien.Ins.getNV(lbID.Text); lbName.Text = p.Hoten; lbPhone.Text = p.Sdt; lbSex.Text = p.Gtinh; lbCHUC.Text = p.Vitri; pictureBox1.Image = NhanVien.Ins.ByteToImg(p.ImgStr); }
public accForm(string id) { InitializeComponent(); if (id.Contains("NV") == true) { p = NhanVien.Ins.getNV(id); acc = Account.Ins.getAccount(id); } else { pK = KHACHHANG.Ins.getKH(id); accK = ACCOUNTKHACHHANG.Ins.getAccDTO(id); } }
public staffDTO getNV(string id) { string query = "select * from NHANVIEN where ID = @ID "; DataTable rs = DAL.Provider.Ins.ExcuteQuery(query, new object[] { id }); if (rs.Rows.Count == 0) { return(null); } staffDTO res = new staffDTO(); res.Id = rs.Rows[0][0].ToString(); res.Hoten = rs.Rows[0][1].ToString(); res.Gtinh = rs.Rows[0][2].ToString(); res.Ngsinh = (DateTime)rs.Rows[0][3]; res.Dchi = rs.Rows[0][4].ToString(); res.Cmnd = rs.Rows[0][5].ToString(); res.Trangthai = (bool)rs.Rows[0][6]; res.Vitri = rs.Rows[0][7].ToString(); res.ImgStr = rs.Rows[0][8].ToString(); res.Sdt = rs.Rows[0][9].ToString(); return(res); }