private void caidat() { if (kt() == false) { this.Visible = false; Form frm = new KPBT.Forms.frmXNBQ(); frm.ShowDialog(); } else { Settings1.Default.dc = "Dc"; Settings1.Default.Save(); this.Visible = false; Form frm = new frmmain(); frm.ShowDialog(); } }
private void Luu() { try { string sql = "Update ttdv Set dcdv=@dcdv,nlb=@nlb,nnhanhang=@nnhanhang,thukho=@thukho," + " ketoan=@ketoan,kttruong=@kttruong,ttdv=@ttdv,thuquy=@thuquy,MA=@MA,nkxtu=@nkxtu," + " nkxden=@nkxden,mqhns=@mqhns,diadanh=@diadanh,MASANG=@MASANG,MATOI=@MATOI,MUCHT=@MUCHT,Namhoc=@Namhoc"; OleDbCommand cmd = new OleDbCommand(); cmd.CommandText = sql; cmd.Parameters.Add("@dcdv", OleDbType.VarChar).Value = txtdcdv.Text; cmd.Parameters.Add("@nlb", OleDbType.VarChar).Value = txtnlb.Text; cmd.Parameters.Add("@nnhanhang", OleDbType.VarChar).Value = txtnnhanhang.Text; cmd.Parameters.Add("@thukho", OleDbType.VarChar).Value = txtthukho.Text; cmd.Parameters.Add("@ketoan", OleDbType.VarChar).Value = txtketoan.Text; cmd.Parameters.Add("@kttruong", OleDbType.VarChar).Value = txtkttruong.Text; cmd.Parameters.Add("@ttdv", OleDbType.VarChar).Value = txtttdv.Text; cmd.Parameters.Add("@thuquy", OleDbType.VarChar).Value = txtthuquy.Text; cmd.Parameters.Add("@MA", OleDbType.Double).Value = classdc.dungchung.kieudouble(txtMA.Text); cmd.Parameters.Add("@nkxtu", OleDbType.Date).Value = classdc.dungchung.thaydoi(Mtbnkxtu.Text); cmd.Parameters.Add("@nkxden", OleDbType.Date).Value = classdc.dungchung.thaydoi(Mtbnkxden.Text); cmd.Parameters.Add("@mqhns", OleDbType.VarChar).Value = txtmqhns.Text; cmd.Parameters.Add("@diadanh", OleDbType.VarChar).Value = txtdiadanh.Text; cmd.Parameters.Add("@MASANG", OleDbType.Double).Value = classdc.dungchung.kieudouble(txtMASANG.Text); cmd.Parameters.Add("@MATOI", OleDbType.Double).Value = classdc.dungchung.kieudouble(txtMATOI.Text); cmd.Parameters.Add("@MUCHT", OleDbType.Double).Value = classdc.dungchung.kieudouble(txtMUCHT.Text); cmd.Parameters.Add("@Namhoc", OleDbType.VarChar).Value = cboNamhoc.Text; Connect.LuuDL(cmd); thongtinketxuat.Default.diadanh = txtdiadanh.Text; thongtinketxuat.Default.Save(); thongtinketxuat.Default.nlb = txtnlb.Text; thongtinketxuat.Default.Save(); thongtinketxuat.Default.ttdv = txtttdv.Text; thongtinketxuat.Default.Save(); thongtinketxuat.Default.ptkt = txtketoan.Text; thongtinketxuat.Default.Save(); thongtinketxuat.Default.NTT = Mtbnkxtu.Text; thongtinketxuat.Default.Save(); thongtinketxuat.Default.NTD = Mtbnkxden.Text; thongtinketxuat.Default.Save(); thongtinketxuat.Default.thukho = txtthukho.Text; thongtinketxuat.Default.Save(); thongtinketxuat.Default.thuquy = txtthuquy.Text; thongtinketxuat.Default.Save(); thongtinketxuat.Default.namhoc = cboNamhoc.Text; thongtinketxuat.Default.Save(); Settings1.Default.mucan = txtMA.Text; Settings1.Default.Save(); Settings1.Default.mucansang = txtMASANG.Text; Settings1.Default.Save(); Settings1.Default.mucantoi = txtMATOI.Text; Settings1.Default.Save(); Settings1.Default.mucanht = txtMUCHT.Text; Settings1.Default.Save(); Settings1.Default.dc = "Dc"; Settings1.Default.Save(); MessageBox.Show("Bạn đã cập nhật thành công!", "Thông báo"); this.Visible = false; Form frm = new frmmain(); frm.ShowDialog(); this.Close(); } catch { MessageBox.Show("Lấy lại bảng hệ thống!", "Thống báo"); } }