private void btnXoa_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (Program.conn.State == ConnectionState.Closed)
{
Program.conn.Open();
}
String strLenh = "dbo.SP_Ktra_DDH_co_CTDDH";
Program.sqlcmd = Program.conn.CreateCommand();
Program.sqlcmd.CommandType = CommandType.StoredProcedure;
Program.sqlcmd.CommandText = strLenh;
Program.sqlcmd.Parameters.Add("@MasoDDH", SqlDbType.NChar).Value = txtMaDDH.Text;
Program.sqlcmd.Parameters.Add("@Ret", SqlDbType.NChar).Direction = ParameterDirection.ReturnValue;
Program.sqlcmd.ExecuteNonQuery();
Program.conn.Close();
String Ret = Program.sqlcmd.Parameters["@Ret"].Value.ToString();
if (Ret != "0")
{
MessageBox.Show("Mã ĐƠN ĐẶT HÀNG đã có CTDDH!", "", MessageBoxButtons.OK);
txtMaDDH.Focus();
return;
}
if (MessageBox.Show("Bạn có thật sự muốn xóa DDH này ?? ", "Xác nhận",
MessageBoxButtons.OKCancel) == DialogResult.OK)
{
try
{
luaChon = XOA;
DDH ddh = new DDH(txtMaDDH.Text, dtNgay.Text, txtNhaCC.Text, cmbMANV.Text, cmbMAKHO.Text); //truyền các giá trị vô KHO
ObjectUndo ob = new ObjectUndo(luaChon, ddh);
st.Push(ob);
bdsDDH.RemoveCurrent();
this.dATHANGTableAdapter.Connection.ConnectionString = Program.connstr;
this.dATHANGTableAdapter.Update(this.dS.DATHANG);
this.nHANVIENTableAdapter.Connection.ConnectionString = Program.connstr;
this.nHANVIENTableAdapter.Update(this.dS.NHANVIEN);
this.kHOTableAdapter.Connection.ConnectionString = Program.connstr;
this.kHOTableAdapter.Update(this.dS.KHO);
updateButtonPhucHoi();
}
catch (Exception ex)
{
MessageBox.Show("Lỗi xóa Đơn Đặt Hàng. Bạn hãy xóa lại\n" + ex.Message, "", MessageBoxButtons.OK);
this.dATHANGTableAdapter.Fill(this.dS.DATHANG);
//bdsKho.Position = bdsKho.Find("MAKHO", makho);
return;
}
}
}
private void btnSua_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
groupBox1.Enabled = true;
btnThem.Enabled = btnXoa.Enabled = btnReLoad.Enabled = btnSua.Enabled = false;
btnGhi.Enabled = btnUndo.Enabled = btnThoat.Enabled = true;
luaChon = SUA;
DDH ddh = new DDH(txtMaDDH.Text, dtNgay.Text, txtNhaCC.Text, cmbMANV.Text, cmbMAKHO.Text); //truyền các giá trị vô KHO
ObjectUndo ob = new ObjectUndo(luaChon, ddh);
st.Push(ob);
updateButtonPhucHoi();
}
private void btnUndo_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (btnSua.Enabled == false || btnThem.Enabled == false)
{
this.bdsDDH.CancelEdit();
gcDatHang.Enabled = true;
groupBox1.Enabled = false;
btnThem.Enabled = btnSua.Enabled = btnXoa.Enabled = btnReLoad.Enabled = btnThoat.Enabled = true;
btnGhi.Enabled = btnSua.Enabled = false;
}
try
{
ObjectUndo ob = (ObjectUndo)st.Pop();
switch (ob.luaChon)
{
case THEM:
String lenh = (String)ob.obj;
MessageBox.Show("Khôi phục sau khi THÊM ");
Program.ExecSqlDataReader(lenh);
this.dATHANGTableAdapter.Fill(this.dS.DATHANG);
break;
case SUA:
MessageBox.Show("Khôi phục sau khi SỬA ");
DDH ddh = (DDH)ob.obj;
if (Program.conn.State == ConnectionState.Closed)
{
Program.conn.Open();
}
String strLenh = "dbo.SP_UndoSuaDDH";
Program.sqlcmd = Program.conn.CreateCommand();
Program.sqlcmd.CommandType = CommandType.StoredProcedure;
Program.sqlcmd.CommandText = strLenh;
Program.sqlcmd.Parameters.Add("@MasoDDH", SqlDbType.NChar).Value = ddh.MasoDDH;
Program.sqlcmd.Parameters.Add("@NGAY", SqlDbType.NVarChar).Value = ddh.Ngay;
Program.sqlcmd.Parameters.Add("@NhaCC", SqlDbType.NVarChar).Value = ddh.NhaCC;
Program.sqlcmd.Parameters.Add("@MANV", SqlDbType.NVarChar).Value = ddh.MaNV;
Program.sqlcmd.Parameters.Add("@MAKHO", SqlDbType.NVarChar).Value = ddh.MaKho;
Program.sqlcmd.Parameters.Add("@Ret", SqlDbType.NChar).Direction = ParameterDirection.ReturnValue;
Program.sqlcmd.ExecuteNonQuery();
Program.conn.Close();
String Ret = Program.sqlcmd.Parameters["@Ret"].Value.ToString();
if (Ret != "0")
{
MessageBox.Show("Khoi phuc khong thanh cong", "", MessageBoxButtons.OK);
}
else
{
MessageBox.Show("Khoi phuc thanh cong", "", MessageBoxButtons.OK);
}
break;
case XOA:
MessageBox.Show("Khôi phục sau khi XÓA ");
DDH ddh1 = (DDH)ob.obj;
if (Program.conn.State == ConnectionState.Closed)
{
Program.conn.Open();
}
String strLenh1 = "dbo.SP_UndoXoaDDH";
Program.sqlcmd = Program.conn.CreateCommand();
Program.sqlcmd.CommandType = CommandType.StoredProcedure;
Program.sqlcmd.CommandText = strLenh1;
Program.sqlcmd.Parameters.Add("@MasoDDH", SqlDbType.NChar).Value = ddh1.MasoDDH;
Program.sqlcmd.Parameters.Add("@NGAY", SqlDbType.NVarChar).Value = ddh1.Ngay;
Program.sqlcmd.Parameters.Add("@NhaCC", SqlDbType.NVarChar).Value = ddh1.NhaCC;
Program.sqlcmd.Parameters.Add("@MANV", SqlDbType.NVarChar).Value = ddh1.MaNV;
Program.sqlcmd.Parameters.Add("@MAKHO", SqlDbType.NVarChar).Value = ddh1.MaKho;
Program.sqlcmd.Parameters.Add("@Ret", SqlDbType.NChar).Direction = ParameterDirection.ReturnValue;
Program.sqlcmd.ExecuteNonQuery();
Program.conn.Close();
String Ret1 = Program.sqlcmd.Parameters["@Ret"].Value.ToString();
if (Ret1 != "0")
{
MessageBox.Show("Khoi phuc khong thanh cong", "", MessageBoxButtons.OK);
}
else
{
MessageBox.Show("Khoi phuc thanh cong", "", MessageBoxButtons.OK);
}
break;
}
bdsDDH.EndEdit();
bdsDDH.ResetCurrentItem();
this.dATHANGTableAdapter.Connection.ConnectionString = Program.connstr;
this.dATHANGTableAdapter.Update(this.dS.DATHANG);
updateButtonPhucHoi();
reload();
}
catch (Exception)
{
MessageBox.Show("Không có gì để UNDO", "THÔNG BÁO", MessageBoxButtons.OK);
}
}