public void hienthi() { Server_Client.Client cl = new Server_Client.Client(); this.client1 = cl.Connect(Luu.IP, Luu.Ports); tt = new TienTe("Select", 1, "a", "a", "a", "a", "a", 1000, "a", false, Common.Utilities.User.NhanVienID, Common.Utilities.User.TenDangNhap); clientstrem = cl.SerializeObj(this.client1, "TienTe", tt); TienTe[] tt1 = new TienTe[1]; tt1[0] = new TienTe(1, "a", "a", "a", "a", "a", 1000, "a", false); tt1 = (TienTe[])cl.DeserializeHepper1(clientstrem, tt1); if (tt1 == null) { Entities.TienTe [] a = new Entities.TienTe[0]; TT_Search = a; dataGridView1.DataSource = a; FixDataGridView(); toolStripStatus_Sua.Enabled = false; toolStripStatus_Xoa.Enabled = false; } else { TT_Search = tt1; dataGridView1.DataSource = tt1; FixDataGridView(); toolStripStatus_Sua.Enabled = true; toolStripStatus_Xoa.Enabled = true; } }
private void toolStripStatus_Xoa_Click(object sender, EventArgs e) { if (!frmDangNhap.User.Administrator && !CheckQuyen(this.Name, 3)) { MessageBox.Show("Bạn Không có quyền vào chức năng này."); return; } DialogResult dlgResult = MessageBox.Show("Bạn Có Chắc Chắn muốn Xóa không?", "Đồng ý?", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dlgResult == DialogResult.Yes) { try { bool ktdelete = false; int idcurent = int.Parse(dataGridView1.CurrentRow.Cells["TienTeID"].Value.ToString()); string maCurrent = dataGridView1.CurrentRow.Cells["MaTienTe"].Value.ToString(); hienthi(); for (int j = 0; j < TT_Search.Length; j++) { if (TT_Search[j].Deleted == false) { if (TT_Search[j].TienteID == idcurent) { ktdelete = true; break; } } } if (ktdelete == true) { try { if (new Check().CheckReference("TienTe", maCurrent)) { Server_Client.Client cl = new Server_Client.Client(); this.client1 = cl.Connect(Luu.IP, Luu.Ports); tt = new TienTe("Delete", idcurent, maCurrent, "", "", "", "", 0, "", false, Common.Utilities.User.NhanVienID, Common.Utilities.User.TenDangNhap); clientstrem = cl.SerializeObj(this.client1, "TienTe", tt); // MessageBox.Show("Xoa Thanh Cong..."); } else { MessageBox.Show("Tiền tệ này hiện đang có giao dịch - Không thể xóa", "Hệ thống cảnh báo"); } } catch { } } hienthi(); } catch (Exception ex) { MessageBox.Show("Lỗi Hệ Thống- Liên Hệ nhà Quản Trị"); } } }
public static void XoaTienTe(string maTienTe) { try { TienTe dao = new TienTe(); dao.XoaTienTe(maTienTe); } catch (SqlException ex) { throw ex; } }
public static void SuaTienTe(CTyGia tg) { try { TienTe dao = new TienTe(); dao.SuaTienTe(tg); } catch (SqlException ex) { throw ex; } }
public static DataTable LayTienTe() { try { TienTe dao = new TienTe(); DataTable table = dao.LoadTiGia(); return(table); } catch (SqlException ex) { throw ex; } }
public static bool KiemTraTienTe(string maTienTe) { try { TienTe dao = new TienTe(); DataTable table = dao.GetTienTe(maTienTe); if (table.Rows.Count > 0) { return(true); } } catch (Exception ex) { throw ex; } return(false); }
private void txtTimKiem_TextChanged(object sender, EventArgs e) { if (rdbTen.Checked == true) { if (TT_Search == null) { TienTe[] tt = new TienTe[0]; dataGridView1.DataSource = tt; FixDataGridView(); toolStripStatus_Sua.Enabled = false; toolStripStatus_Xoa.Enabled = false; } else if (TT_Search != null) { if (txtTimKiem.Text.Length == 0) { TienTe[] tt = new TienTe[0]; dataGridView1.DataSource = tt; FixDataGridView(); toolStripStatus_Sua.Enabled = false; toolStripStatus_Xoa.Enabled = false; } else { int tt1_search_count = 0; for (int i = 0; i < TT_Search.Length; i++) { int index = -1; index = TT_Search[i].TenTienTe.ToLower().IndexOf(txtTimKiem.Text.Trim().ToLower()); if (index >= 0) { tt1_search_count++; } } TienTe[] tt1_search = new TienTe[tt1_search_count]; tt1_search_count = 0; for (int i = 0; i < TT_Search.Length; i++) { int index = -1; index = TT_Search[i].TenTienTe.ToLower().IndexOf(txtTimKiem.Text.Trim().ToLower()); if (index >= 0) { tt1_search[tt1_search_count] = TT_Search[i]; tt1_search_count++; } } if (tt1_search_count == 0) { toolStripStatus_Sua.Enabled = false; toolStripStatus_Xoa.Enabled = false; } else { toolStripStatus_Sua.Enabled = true; toolStripStatus_Xoa.Enabled = true; } dataGridView1.DataSource = tt1_search; FixDataGridView(); } } } else if (rdbMa.Checked == true) { if (TT_Search == null) { TienTe[] tt = new TienTe[0]; dataGridView1.DataSource = tt; FixDataGridView(); toolStripStatus_Sua.Enabled = false; toolStripStatus_Xoa.Enabled = false; } else if (TT_Search != null) { if (txtTimKiem.Text.Length == 0) { TienTe[] tt = new TienTe[0]; dataGridView1.DataSource = tt; FixDataGridView(); toolStripStatus_Sua.Enabled = false; toolStripStatus_Xoa.Enabled = false; } else { int tt1_search_count = 0; for (int i = 0; i < TT_Search.Length; i++) { int index = -1; index = TT_Search[i].MaTienTe.ToLower().IndexOf(txtTimKiem.Text.Trim().ToLower()); if (index >= 0) { tt1_search_count++; } } TienTe[] tt1_search = new TienTe[tt1_search_count]; tt1_search_count = 0; for (int i = 0; i < TT_Search.Length; i++) { int index = -1; index = TT_Search[i].MaTienTe.ToLower().IndexOf(txtTimKiem.Text.Trim().ToLower()); if (index >= 0) { tt1_search[tt1_search_count] = TT_Search[i]; tt1_search_count++; } } if (tt1_search_count == 0) { toolStripStatus_Sua.Enabled = false; toolStripStatus_Xoa.Enabled = false; } else { toolStripStatus_Sua.Enabled = true; toolStripStatus_Xoa.Enabled = true; } dataGridView1.DataSource = tt1_search; FixDataGridView(); } } } }