private void ucHoaDonNhap_Load(object sender, EventArgs e)
{
String query = "select MAHDN from HOADONNHAP";
DataTable tbl = db.DocDuLieu(query);
cboMAHDN.DataSource = tbl;
cboMAHDN.DisplayMember = "MAHDN";
cboMAHDN.ValueMember = "MAHDN";
}
private void frmThemHDB_Load(object sender, EventArgs e)
{
String queryNV = "select TENNV from NHANVIEN";
DataTable tblNV = db.DocDuLieu(queryNV);
AutoCompleteStringCollection autoNV = new AutoCompleteStringCollection();
foreach (DataRow row in tblNV.Rows)
{
autoNV.Add(row["TENNV"].ToString());
}
txtnv.AutoCompleteSource = AutoCompleteSource.CustomSource;
txtnv.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
txtnv.AutoCompleteCustomSource = autoNV;
nmrsoluong.Enabled = false;
nmrgiamgia.Enabled = false;
DataTable tblLuu = db.DocDuLieu("Select * from HOADONBAN");
string str = "HDB" + DateTime.Now.Day.ToString() + DateTime.Now.Month.ToString() + DateTime.Now.Year.ToString();
txtmahdb.Text = td.SinhMaTuDong("HOADONBAN", str, "MAHDB");
}
