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);
}
