private void btnPhucHoi_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (isDangThem)
{
capNhatBtnPhucHoi();
reload();
isDangThem = false;
}
bdsMonHoc.CancelEdit();
if (btnThem.Enabled == false || btnHieuChinh.Enabled == false)
{
bdsMonHoc.Position = vitri;
}
gcMonHoc.Enabled = true;
groupBox1.Enabled = false;
btnThem.Enabled = btnHieuChinh.Enabled = btnXoa.Enabled = btnThoat.Enabled = true;
btnGhi.Enabled = btnPhucHoi.Enabled = false;
if (st.Count == 0)
{
return;
}
UndoMonHoc objUndo = (UndoMonHoc)st.Pop();
Object obj = objUndo.getObj();
switch (objUndo.getType())
{
case THEM:
{
Program.ExecSqlDataReader(obj.ToString());
this.MonHocTableAdapter.Fill(this.dS.MONHOC);
capNhatBtnPhucHoi();
break;
}
case HIEU_CHINH:
{
if (Program.conn.State == ConnectionState.Closed)
{
Program.conn.Open();
}
MonHoc monHocHieuChinh = (MonHoc)obj;
String sqlHieuChinh = "exec sp_CapNhatMonHoc N'" + monHocHieuChinh.getMaMH() + "',N'" + monHocHieuChinh.getTenMH() + "'";
Program.ExecSqlDataTable(sqlHieuChinh);
//String strPhucHoiHieuChinh = "sp_CapNhatMonHoc";
//Program.sqlcmd = Program.conn.CreateCommand();
//Program.sqlcmd.CommandType = CommandType.StoredProcedure;
//Program.sqlcmd.CommandText = strPhucHoiHieuChinh;
//Program.sqlcmd.Parameters.Add("@MAMH", SqlDbType.Text).Value = monHocHieuChinh.getMaMH();
//Program.sqlcmd.Parameters.Add("@TENMH", SqlDbType.Text).Value = monHocHieuChinh.getTenMH();
//Program.sqlcmd.ExecuteNonQuery();
Program.conn.Close();
capNhatBtnPhucHoi();
reload();
break;
}
case XOA:
MonHoc monHocXoa = (MonHoc)obj;
if (Program.conn.State == ConnectionState.Closed)
{
Program.conn.Open();
}
string sql = "exec sp_ThemMonHoc N'" + monHocXoa.getMaMH() + "', N'" + monHocXoa.getTenMH() + "'";
Program.ExecSqlDataTable(sql);
//String strPhucHoiXoa = "sp_ThemMonHoc";
//Program.sqlcmd = Program.conn.CreateCommand();
//Program.sqlcmd.CommandType = CommandType.StoredProcedure;
//Program.sqlcmd.CommandText = strPhucHoiXoa;
//Program.sqlcmd.Parameters.Add("@MAMH", SqlDbType.Text).Value = monHocXoa.getMaMH();
//Program.sqlcmd.Parameters.Add("@TENMH", SqlDbType.Text).Value = monHocXoa.getTenMH();
//Program.sqlcmd.ExecuteNonQuery();
reload();
break;
}
}
