private void frmDonSanXuat_Avery_Load(object sender, EventArgs e)
{
tbl = donSanXuatAveryCtr.DonSanXuatAD_NhanVien_XacNhanNull(nvObj.Tennhanvien);
//var db = new MyDBContextDataContext();
//var lst = db.DonSanXuatAD_NhanVien_XacNhanNull(nvObj.Tennhanvien);
gridControl1.DataSource = tbl;
gcDonSanXuat.DataSource = dsxCtr.LoadData();
sCDLabel1.Hide();
sCDLabel1.DataBindings.Clear();
sCDLabel1.DataBindings.Add("text", gcDonSanXuat.DataSource, "SCD");
OrderDate.DateTime = DateTime.Now;
}
//public frmDonSanXuat(string manhanvien, string tennhanvien, string taikhoan, string matkhau, string ngaysinh,
// string gioitinh, string diachi, string dienthoai, string bophan, string chucvu, string tinhtrang, string ghichu)
//{
// InitializeComponent();
// nvObj.Manhanvien = manhanvien;
// nvObj.Tennhanvien = tennhanvien;
// nvObj.Taikhoan = taikhoan;
// nvObj.Matkhau = matkhau;
// nvObj.Ngaysinh = ngaysinh;
// nvObj.Gioitinh = gioitinh;
// nvObj.Diachi = diachi;
// nvObj.Dienthoai = dienthoai;
// nvObj.Bophan = bophan;
// nvObj.Chucvu = chucvu;
// nvObj.Tinhtrang = tinhtrang;
// nvObj.Ghichu = ghichu;
// //dsxCtrl.broker();
// //var ss = new SqlClientPermission(System.Security.Permissions.PermissionState.Unrestricted);
// //ss.Demand();
// //SqlDependency.Stop(m_connect);
// //SqlDependency.Start(m_connect);
// //con = new SqlConnection(m_connect);
//}
//public void Form1_OnNewHome()
//{
// var i = (ISynchronizeInvoke)this;
// if (i.InvokeRequired)//tab
// {
// var dd = new NewHome(Form1_OnNewHome);
// i.BeginInvoke(dd, null);
// return;
// }
// LoadData();
//}
////Ham load data
//private void LoadData()
//{
// try
// {
// var dt = new DataTable();
// if (con.State == ConnectionState.Closed)
// {
// con.Open();
// }
// var caulenh = "DonSanXuat_TienTe_QuanLyDonHang_View";
// var cmd = new SqlCommand(caulenh, con);
// cmd.CommandType = CommandType.StoredProcedure;
// cmd.Notification = null;
// var de = new SqlDependency(cmd);
// de.OnChange += de_OnChange;
// dt.Load(cmd.ExecuteReader(CommandBehavior.CloseConnection));
// gcDonSanXuat.DataSource = dt;
// sCDLabel1.DataBindings.Clear();
// sCDLabel1.DataBindings.Add("text", dt, "SCD");
// sCDLabel1.Hide();
// }
// catch (Exception e)
// {
// Console.WriteLine(e);
// throw;
// }
//}
//public void de_OnChange(object sender, SqlNotificationEventArgs e)
//{
// var de = sender as SqlDependency;
// if (de != null) de.OnChange -= de_OnChange;
// if (OnNewHome != null)
// {
// OnNewHome();// }
//}
private void frmDonSanXuat_Load(object sender, EventArgs e)
{
//CurrentThread.CurrentCulture = new Globalization.CultureInfo("vi");
//CurrentThread.CurrentUICulture = new Globalization.CultureInfo("vi");
//OnNewHome += dsxCtrl.Form1_OnNewHome;//tab
//load data vao datagrid
overlayLoading.StartLoading(gcDonSanXuat);
gcDonSanXuat.DataSource = dsxCtrl.LoadData();
sCDLabel1.DataBindings.Clear();
sCDLabel1.DataBindings.Add("text", gcDonSanXuat.DataSource, "SCD");
sCDLabel1.Hide();
overlayLoading.EndLoading();
//Thread.CurrentThread.CurrentCulture = new Globalization.CultureInfo("vi");
//Thread.CurrentThread.CurrentUICulture = new Globalization.CultureInfo("vi");
}
