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