private void btnLast_Click(object sender, EventArgs e)
{
m_Position = m_Reccount - 1; // Đi đến mẩu tin cuối cùng
ButtonGroupEventArgs e1 = new ButtonGroupEventArgs();
OnDisplay(e1);
}
private void btnExtra2_Click(object sender, EventArgs e)
{
ButtonGroupEventArgs e1 = new ButtonGroupEventArgs();
OnExtra2Click(e1);
OnDisplay(e1);
}
private void btnPrev_Click(object sender, EventArgs e)
{
m_Position--; // Trở về mẩu tin trước
ButtonGroupEventArgs e1 = new ButtonGroupEventArgs();
OnDisplay(e1);
}
private void btnNext_Click(object sender, EventArgs e)
{
m_Position++; // Sang mẩu tin kế tiếp
ButtonGroupEventArgs e1 = new ButtonGroupEventArgs();
OnDisplay(e1);
}
private void btgNhomLenh_Display(object sender, ButtonGroupEventArgs e)
{
if (btgNhomLenh.Reccount > 0)
{
dgvLoaiSanPham.CurrentCell = dgvLoaiSanPham.Rows[btgNhomLenh.Position].Cells[0];
}
}
private void btnFirst_Click(object sender, EventArgs e)
{
m_Position = 0; // Về mẩu tin đầu tiên
ButtonGroupEventArgs e1 = new ButtonGroupEventArgs();
OnDisplay(e1); // Bẫy chương trình xử lý biến cố (nếu có)
}
private void btgNhomLenh_SaveClick(object sender, ButtonGroupEventArgs e)
{
if (btgNhomLenh.Mode == 1)
{ // Lưu lúc thêm
String SQL = "Insert into NhaXuatBan(MSNXB,TenNXB) values('" + m_MsNXB
+ "',N'" + dsNhaXuatBan.Tables[m_Table].Rows[btgNhomLenh.Position]["TenNXB"].ToString() + "')";
// MessageBox.Show(SQL);
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
SqlCommand cmd = new SqlCommand(SQL, conn);
cmd.ExecuteNonQuery();
LoadData();
DinhViLai(m_MsNXB);
}
else
{ // Lưu lúc sửa
String SQL = "update NhaXuatBan set TenNXB=N'"
+ dsNhaXuatBan.Tables[m_Table].Rows[btgNhomLenh.Position]["TenNXB"].ToString()
+ "' where MSNXB='" + m_MsNXB.Trim() + "'";
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
SqlCommand cmd = new SqlCommand(SQL, conn);
cmd.ExecuteNonQuery();
}
}
private void btgNhomLenh_ExtraClick(object sender, ButtonGroupEventArgs e)
{
frmHinhBia frm = new frmHinhBia();
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
frm.txtMSSach.Text = dsSach.Tables[m_Table].Rows[btgNhomLenh.Position]["MSSach"].ToString().Trim();
frm.txtNhanDeSach.Text =
dsSach.Tables[m_Table].Rows[btgNhomLenh.Position]["NhanDeSach"].ToString().Trim();
frm.txtMSNXB.Text =
dsSach.Tables[m_Table].Rows[btgNhomLenh.Position]["MSNXB"].ToString().Trim();
frm.txtNamXB.Text = dsSach.Tables[m_Table].Rows[btgNhomLenh.Position]["NamXB"].ToString().Trim();
frm.txtSoTrang.Text = dsSach.Tables[m_Table].Rows[btgNhomLenh.Position]["SoTrang"].ToString();
if (!dsSach.Tables[m_Table].Rows[btgNhomLenh.Position]["HinhBia"].Equals(System.DBNull.Value))
{
MemoryStream ms =
new MemoryStream((byte[])(dsSach.Tables[m_Table].Rows[btgNhomLenh.Position]["HinhBia"]));
frm.pbHinhBia.Image = Image.FromStream(ms);
}
if (frm.ShowDialog() == DialogResult.OK)
{
LoadData();
DinhViLai(m_MsSach);
}
}
private void btgNhomLenh_SaveClick(object sender, ButtonGroupEventArgs e)
{
if (btgNhomLenh.Mode == 1)
{
m_MsTacGia = dsSachTacGia.Tables[m_Table].Rows[btgNhomLenh.Position]["MSTacGia"].ToString();
String SQL = "Insert into SachTacGia(MSSach,MSTacGia) values('" + m_MsSach + "','" + m_MsTacGia + "')";
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
SqlCommand cmd = new SqlCommand(SQL, conn);
cmd.ExecuteNonQuery();
LoadData();
DinhViLai(m_MsTacGia);
}
else
{
String SQL = "delete SachTacGia where "
+ "MSSach='" + m_MsSach + "' and MSTacGia='" + OldSachTacGia[0] + "'";
// MessageBox.Show(SQL);
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
SqlCommand cmd = new SqlCommand(SQL, conn);
cmd.ExecuteNonQuery();
m_MsTacGia = dsSachTacGia.Tables[m_Table].Rows[btgNhomLenh.Position]["MSTacGia"].ToString();
SQL = "Insert into SachTacGia(MSSach,MSTacGia) values('" + m_MsSach + "','" + m_MsTacGia + "')";
// MessageBox.Show(SQL);
cmd = new SqlCommand(SQL, conn);
cmd.ExecuteNonQuery();
LoadData();
DinhViLai(m_MsTacGia);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
ButtonGroupEventArgs e1 = new ButtonGroupEventArgs();
if (m_Mode == 1)
{ // Lưu lúc thêm
if (OnCanSave(e1))
{ // Lưu được lúc thêm
OnSaveClick(e1);
m_Mode = 0; // Bình thường
OnDeactivateRow(m_Position);
EnableButton(true);
}
else
{
MessageBox.Show("Không thể lưu lúc thêm", ParentForm.Text);
}
}
else
{ // Lưu lúc sửa
if (OnCanSave(e1))
{ // Lưu được lúc sửa
OnSaveClick(e1);
m_Mode = 0; // Bình thường
OnDeactivateRow(m_Position);
EnableButton(true);
}
else
{
MessageBox.Show("Không thể lưu lúc sửa", ParentForm.Text);
}
}
}
private bool btgNhomLenh_CanSave(object sender, ButtonGroupEventArgs e)
{
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
m_MsTacGia =
dsSachTacGia.Tables[m_Table].Rows[btgNhomLenh.Position]["MSTacGia"].ToString().Trim();
if (btgNhomLenh.Mode == 1)
{
if (m_MsSach.Trim() != "" && m_MsTacGia.Trim() != "")
{
String SQL = "select count(*) from SachTacGia where MSSach='" + m_MsSach.Trim()
+ "' and MSTacGia='" + m_MsTacGia.Trim() + "'";
SqlCommand cmd = new SqlCommand(SQL, conn);
int So = (int)cmd.ExecuteScalar();
return(So == 0);
}
}
else
{
if (m_MsSach.Trim() != "" && m_MsTacGia.Trim() != "")
{
String SQL = "select count(*) from SachTacGia where MSSach='" + m_MsSach.Trim()
+ "' and MSTacGia='" + m_MsTacGia.Trim() + "' and MSTacGia<>'" + OldSachTacGia[0] + "'";
SqlCommand cmd = new SqlCommand(SQL, conn);
return(((int)cmd.ExecuteScalar()) == 0);
}
}
return(false); // Không thể lưu được
}
private void btgNhomLenh_AddClick(object sender, ButtonGroupEventArgs e)
{
// MessageBox.Show("c " + btgNhomLenh.Reccount);
BUSLoaiSanPham.Instance.AddRows(dgvLoaiSanPham);
btgNhomLenh.Position = btgNhomLenh.Reccount++;
//MessageBox.Show("m " + btgNhomLenh.Position);
dgvLoaiSanPham.CurrentCell = dgvLoaiSanPham.Rows[btgNhomLenh.Position].Cells[1];
}
private void btgNhomLenh_EditClick(object sender, ButtonGroupEventArgs e)
{
OldNhaXuatBan = new String[2]; // Dùng cho trường hợp phục hồi
for (int i = 0; i < 2; i++)
{
OldNhaXuatBan[i] = dsNhaXuatBan.Tables[m_Table].Rows[btgNhomLenh.Position][i].ToString();
}
}
private void btgNhomLenh_EditClick(object sender, ButtonGroupEventArgs e)
{
OldLoaiSanPham = new String[2];
for (int i = 0; i < 2; i++)
{
OldLoaiSanPham[i] = dgvLoaiSanPham.Rows[btgNhomLenh.Position].Cells[i].Value.ToString();
}
}
private void btgNhomLenh_EditClick(object sender, ButtonGroupEventArgs e)
{
OldSachTacGia = new String[4]; // Dùng cho trường hợp phục hồi (không kể cột MSSach)
for (int i = 0; i < 4; i++)
{
OldSachTacGia[i] = dsSachTacGia.Tables[m_Table].Rows[btgNhomLenh.Position][i].ToString();
}
}
private void btnEdit_Click(object sender, EventArgs e)
{
m_Mode = 2; // Đang sửa
ButtonGroupEventArgs e1 = new ButtonGroupEventArgs();
OnActivateRow(m_Position); // Có thể dưới dạng tham số khác
OnEditClick(e1);
EnableButton(false);
}
private void OnCancelClick(ButtonGroupEventArgs e)
{
ButtonGroupEventHandler handler = CancelClick;
if (handler != null)
{
handler(this, e);
}
}
private void btgNhomLenh_Display(object sender, ButtonGroupEventArgs e)
{
if (btgNhomLenh.Reccount > 0)
{
dgvNhanVien.CurrentCell = dgvNhanVien.Rows[btgNhomLenh.Position].Cells[0];
m_TenKH = dgvNhanVien.Rows[btgNhomLenh.Position].Cells[1].ToString();
LoadAnh();
}
}
private void OnDeleteClick(ButtonGroupEventArgs e)
{
ButtonGroupEventHandler handler = DeleteClick;
if (handler != null)
{
handler(this, e);
}
}
private void OnExtra2Click(ButtonGroupEventArgs e)
{
ButtonGroupEventHandler handler = Extra2Click;
if (handler != null)
{
handler(this, e);
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
m_Mode = 1; // Đang thêm
ButtonGroupEventArgs e1 = new ButtonGroupEventArgs();
OnAddClick(e1);
OnActivateRow(m_Position); // Có thể dưới dạng tham số khác
EnableButton(false);
}
private void OnDisplay(ButtonGroupEventArgs e) // On + Tên_biến_cố
{
ButtonGroupEventHandler handler = Display; // Có khả năng Display là null
if (handler != null)
{
handler(this, e); // Thực thi chương trình xử lý biến cố
}
EnableButton(true);
}
private void btgNhomLenh_EditClick(object sender, ButtonGroupEventArgs e)
{
isEdit = true;
OldHangHoa = new String[2];
for (int i = 0; i < 2; i++)
{
OldHangHoa[i] = dgvSanPham.Rows[btgNhomLenh.Position].Cells[i].Value.ToString();
}
btgNhomLenh.Extra2Enabled = false;
}
private void btgNhomLenh_EditClick(object sender, ButtonGroupEventArgs e)
{
isEdit = true;
OldNhanVien = new String[2];
for (int i = 0; i < 2; i++)
{
OldNhanVien[i] = dgvNhanVien.Rows[btgNhomLenh.Position].Cells[i].Value.ToString();
}
btgNhomLenh.Extra2Enabled = false;
LoadDuLieu();
}
private void btgNhomLenh_RadTimClick(object sender, ButtonGroupEventArgs e)
{
if (btgNhomLenh.ModeTimKiem == 1)
{
btgNhomLenh.ListTimKiem = BUSKhachHang.Instance.ListTimTheoTen();
}
else
{
btgNhomLenh.ListTimKiem = BUSKhachHang.Instance.ListTimTheoMa();
}
}
private void btgNhomLenh_AddClick(object sender, ButtonGroupEventArgs e)
{
DataGridViewComboBoxCell comboBoxCell = new DataGridViewComboBoxCell();
BUSKhachHang.Instance.AddRows(dgvNhanVien, comboBoxCell);
btgNhomLenh.Position = btgNhomLenh.Reccount++;
//MessageBox.Show("m " + btgNhomLenh.Position);
dgvNhanVien.CurrentCell = dgvNhanVien.Rows[btgNhomLenh.Position].Cells[1];
btgNhomLenh.Extra2Enabled = false;
dgvNhanVien[7, btgNhomLenh.Position] = comboBoxCell;
}
private bool OnCanDelete(ButtonGroupEventArgs e)
{
ButtonGroupCanDoDelegate func = CanDelete;
if (func != null)
{
return(CanDelete(this, e));
}
else
{
return(true);
}
}
private void btgNhomLenh_CancelClick(object sender, ButtonGroupEventArgs e)
{
if (btgNhomLenh.Mode == 1)
{
}
else
{
for (int i = 0; i < 4; i++)
{
dsTacGia.Tables[m_Table].Rows[btgNhomLenh.Position][i] = OldTacGia[i];
}
}
}
private bool btgNhomLenh_CanDelete(object sender, ButtonGroupEventArgs e)
{
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
m_MsSach = dsSach.Tables[m_Table].Rows[btgNhomLenh.Position]["MSSach"].ToString().Trim();
String SQL = "select count(*) from SachTacGia where MSSach='" + m_MsSach.Trim() + "'";
SqlCommand cmd = new SqlCommand(SQL, conn);
int So = (int)cmd.ExecuteScalar();
return(So == 0);
}
private void btgNhomLenh_CancelClick(object sender, ButtonGroupEventArgs e)
{
if (btgNhomLenh.Mode == 1) //trang thai 1: huy luc thêm
{
BUSLoaiSanPham.Instance.XoaRow(dgvLoaiSanPham);
dgvLoaiSanPham.CurrentCell = dgvLoaiSanPham.Rows[btgNhomLenh.Position].Cells[0];
}
else //trạng thái khác 1: hủy lúc sửa
{
for (int i = 0; i < 2; i++)
{
dgvLoaiSanPham.Rows[btgNhomLenh.Position].Cells[i].Value = OldLoaiSanPham[i];
}
}
}
