private void barButtonItem4_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) // redo { if (Program.indexLogGVDK < Program.logGVDK.Count - 1) { Program.indexLogGVDK++; DataLogGVDK logGvdk = Program.logGVDK[Program.indexLogGVDK]; if (logGvdk.Action.Equals("I")) { SqlCommand sqlcmd = new SqlCommand("SP_THEM_GVDK", Program.conn); sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.Add("@MAGV", logGvdk.Sau.MaGV); sqlcmd.Parameters.Add("@MAMH", logGvdk.Sau.MaMH); sqlcmd.Parameters.Add("@MALOP", logGvdk.Sau.MaLop); sqlcmd.Parameters.Add("@TRINHDO", logGvdk.Sau.TrinhDo); sqlcmd.Parameters.Add("@NGAYTHI", logGvdk.Sau.NgayThi); sqlcmd.Parameters.Add("@LAN", logGvdk.Sau.Lan); sqlcmd.Parameters.Add("@SOCAUTHI", logGvdk.Sau.SoCauThi); sqlcmd.Parameters.Add("@THOIGIAN", logGvdk.Sau.ThoiGian); MessageBox.Show(logGvdk.Action + logGvdk.Sau.MaMH + " " + logGvdk.Sau.MaLop + " " + logGvdk.Sau.Lan + "" + logGvdk.Sau.TrinhDo + logGvdk.Sau.NgayThi + logGvdk.Sau.SoCauThi + logGvdk.Sau.ThoiGian); int check = Program.execStoreProcedureWithReturnValue(sqlcmd); if (check == 1) { MessageBox.Show("Lỗi Khôi phục Insert"); } else { barButtonItem1.PerformClick(); } } if (logGvdk.Action.Equals("D")) { SqlCommand sqlcmd = new SqlCommand("SP_XOA_GVDK", Program.conn); sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.Add("@MAMH", logGvdk.Truoc.MaMH); sqlcmd.Parameters.Add("@MALOP", logGvdk.Truoc.MaLop); sqlcmd.Parameters.Add("@LAN", logGvdk.Truoc.Lan); int check = Program.execStoreProcedureWithReturnValue(sqlcmd); if (check == 1) { MessageBox.Show("Lỗi Khôi phục Insert"); } else { barButtonItem1.PerformClick(); } } if (logGvdk.Action.Equals("U")) { SqlCommand sqlcmd = new SqlCommand("SP_SUA_GVDK", Program.conn); sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.Add("@MAGV", logGvdk.Sau.MaGV); sqlcmd.Parameters.Add("@MAMH", logGvdk.Sau.MaMH); sqlcmd.Parameters.Add("@MALOP", logGvdk.Sau.MaLop); sqlcmd.Parameters.Add("@TRINHDO", logGvdk.Sau.TrinhDo); sqlcmd.Parameters.Add("@NGAYTHI", logGvdk.Sau.NgayThi); sqlcmd.Parameters.Add("@LAN", logGvdk.Sau.Lan); sqlcmd.Parameters.Add("@SOCAUTHI", logGvdk.Sau.SoCauThi); sqlcmd.Parameters.Add("@THOIGIAN", logGvdk.Sau.ThoiGian); int check = Program.execStoreProcedureWithReturnValue(sqlcmd); if (check == 1) { MessageBox.Show("Lỗi Khôi phục Insert"); } else { barButtonItem1.PerformClick(); } } } }
private void barButtonItem3_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { /* * Neu Insert thi delete * Nêu Update thi Update * Nếu Xóa Thì Insert * */ if (Program.indexLogGVDK >= 0) { DataLogGVDK logGvdk = Program.logGVDK[Program.indexLogGVDK]; if (logGvdk.Action.Equals("I")) { SqlCommand sqlcmd = new SqlCommand("SP_XOA_GVDK", Program.conn); sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.Add("@MAMH", logGvdk.Sau.MaMH); sqlcmd.Parameters.Add("@MALOP", logGvdk.Sau.MaLop); sqlcmd.Parameters.Add("@LAN", logGvdk.Sau.Lan); int check = Program.execStoreProcedureWithReturnValue(sqlcmd); if (check == 1) { MessageBox.Show("Lỗi Khôi phục Insert"); } else { barButtonItem1.PerformClick(); Program.indexLogGVDK--; } } if (logGvdk.Action.Equals("D")) { SqlCommand sqlcmd = new SqlCommand("SP_THEM_GVDK", Program.conn); sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.Add("@MAGV", logGvdk.Truoc.MaGV); sqlcmd.Parameters.Add("@MAMH", logGvdk.Truoc.MaMH); sqlcmd.Parameters.Add("@MALOP", logGvdk.Truoc.MaLop); sqlcmd.Parameters.Add("@TRINHDO", logGvdk.Truoc.TrinhDo); sqlcmd.Parameters.Add("@NGAYTHI", logGvdk.Truoc.NgayThi); sqlcmd.Parameters.Add("@LAN", logGvdk.Truoc.Lan); sqlcmd.Parameters.Add("@SOCAUTHI", logGvdk.Truoc.SoCauThi); sqlcmd.Parameters.Add("@THOIGIAN", logGvdk.Truoc.ThoiGian); int check = Program.execStoreProcedureWithReturnValue(sqlcmd); if (check == 1) { MessageBox.Show("Lỗi Khôi phục Insert"); } else { barButtonItem1.PerformClick(); Program.indexLogGVDK--; } } if (logGvdk.Action.Equals("U")) { SqlCommand sqlcmd = new SqlCommand("SP_SUA_GVDK", Program.conn); sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.Add("@MAGV", logGvdk.Truoc.MaGV); sqlcmd.Parameters.Add("@MAMH", logGvdk.Truoc.MaMH); sqlcmd.Parameters.Add("@MALOP", logGvdk.Truoc.MaLop); sqlcmd.Parameters.Add("@TRINHDO", logGvdk.Truoc.TrinhDo); sqlcmd.Parameters.Add("@NGAYTHI", logGvdk.Truoc.NgayThi); sqlcmd.Parameters.Add("@LAN", logGvdk.Truoc.Lan); sqlcmd.Parameters.Add("@SOCAUTHI", logGvdk.Truoc.SoCauThi); sqlcmd.Parameters.Add("@THOIGIAN", logGvdk.Truoc.ThoiGian); int check = Program.execStoreProcedureWithReturnValue(sqlcmd); if (check == 1) { MessageBox.Show("Lỗi Khôi phục Insert"); } else { barButtonItem1.PerformClick(); Program.indexLogGVDK--; } } } }