public void execute()
{
// save lai data
data = ((DataRowView)binding.Current).Row.ItemArray;
// thuc thi delet
binding.RemoveCurrent(); // delete
}
private void btHuy_Click(object sender, EventArgs e)
{
if (bsMain.Current == null)
{
return;
}
_data.Cancel(drCurrent["MT62ID"].ToString());
bsMain.RemoveCurrent();
}
private void button3_Click(object sender, EventArgs e)
{
if (MessageBox.Show("هل تريد الحذف", "تحذير", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
OleDbCommandBuilder cb = new OleDbCommandBuilder(da);
bs.RemoveCurrent();
da.DeleteCommand = cb.GetDeleteCommand();
da.Update(ds, "mor");
}
}
/// <summary>
/// When moving to the next/previous item, check if there are changes, save them and then move to the next record
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void StudyDetails_MouseWheel(object sender, MouseEventArgs e)
{
bs.EndEdit();
if (IsEmptyRecord(CurrentStudy))
{
bs.RemoveCurrent();
return;
}
if (SaveRecord() == 1)
{
MessageBox.Show("Unable to save current record. Ensure all fields are filled.");
return;
}
if (e.Delta == -120)
{
MoveRecord(1);
}
else if (e.Delta == 120)
{
MoveRecord(-1);
}
}
private void ClearData()
{
int addedRow = gvOrderDetail.DataRowCount;
for (int i = 0; i < addedRow; i++)
{
_bdsCTDDH.RemoveCurrent();
}
txtOrderId.EditValue = null;
lkeDepot.EditValue = null;
cboNCC.SelectedIndex = -1;
}
private void supprimerToolStripMenuItem_Click(object sender, EventArgs e)
{
if (srcb.Current != null)
{
if (MessageBox.Show("Voulez-vous supprimer cette fonction?", "Cofirmation de suppression", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes)
{
try
{
DataRowView drv = (DataRowView)srcb.Current;
string res = CLIENT_APP_PARAM.gcws.DELETE_FONCTION(drv["CODE_FONCTION"].ToString());
if (res == "OK")
{
srcb.RemoveCurrent();
dt.AcceptChanges();
}
else
{
MessageBox.Show(res, "Erreur", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception er)
{
MessageBox.Show(er.Message, "Connexion serveur", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
}
// TODO finish
private void DeleteQuestion()
{
if (MessageBox.Show(CurrentQuestion.VarName + " will be deleted from " + CurrentSurvey.SurveyCode + ". \r\n Do you want to proceed?", "Confirm Delete", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
int nextID = bs.Position;
// backup comments
DBAction.BackupComments(CurrentQuestion.ID);
// delete question from database
DBAction.DeleteQuestion(CurrentQuestion.VarName.FullVarName, CurrentQuestion.SurveyCode);
// remove question from the list
CurrentSurvey.Questions.Remove(CurrentQuestion);
// remove current item from bindingsource
bs.RemoveCurrent();
// refresh comments
// delete varname if no more uses
Renumber = true;
}
else
{
return;
}
if (MessageBox.Show("Do you want to document this deletion? (Click 'No' if you already have)", "Document", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
}
else
{
}
}
/// <summary>
/// Remove the current row
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
/// <remarks></remarks>
private void RemoveCurrentCustomerButton_Click(object sender, EventArgs e)
{
if (_bsCustomers.DataSource == null)
{
MessageBox.Show("Please select some data");
return;
}
if (Question("Remove " + _bsCustomers.CurrentRow().CompanyName()))
{
if (!_dataOperations.RemoveCustomer(_bsCustomers.CurrentRow().Identifier()))
{
if (!_dataOperations.IsSuccessFul)
{
MessageBox.Show($"Failed to remove customer{Environment.NewLine}{_dataOperations.LastExceptionMessage}");
}
}
else
{
//
// Only remove row if removed successfully from the database table
//
_bsCustomers.RemoveCurrent();
}
}
}
private void removeSourceButton_Click(object sender, EventArgs e)
{
if (pathBindingSource.Current != null)
{
DialogResult result = MessageBox.Show("This will remove from Moving Pictures all movies retrieved from this import path, are you sure?", "Warning!", MessageBoxButtons.YesNo);
if (result == DialogResult.Yes)
{
// stop the importer
MovingPicturesCore.Importer.Stop();;
// remove the import path
((DBImportPath)pathBindingSource.Current).Delete();
pathBindingSource.RemoveCurrent();
// clean the database of the old movies using our progress bar popup
ProgressPopup progressPopup = new ProgressPopup(new WorkerDelegate(DatabaseMaintenanceManager.RemoveInvalidFiles));
DatabaseMaintenanceManager.MaintenanceProgress += new ProgressDelegate(progressPopup.Progress);
progressPopup.Owner = ParentForm;
progressPopup.Text = "Removing related movies...";
progressPopup.ShowDialog();
// restart the importer
MovingPicturesCore.Importer.RestartScanner();
}
}
}
void grid_KeyDown(object sender, KeyEventArgs e)
{
DataGridView grid = (DataGridView)sender;
if (e.Control && e.KeyCode.Equals(Keys.Enter))
{
if (openDetailEvent != null)
{
openDetailEvent();
}
}
else if (e.Control && e.KeyCode.Equals(Keys.Delete))
{
BindingSource bs = (BindingSource)grid.DataSource;
if (bs.Current != null)
{
//TODO
if (MessageBox.Show("Are you sure to delete " + bs.Current.ToString(), "Delete", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
{
bs.RemoveCurrent();
}
}
}
}
private void supprimerToolStripMenuItem_Click(object sender, EventArgs e)
{
if (srcb_fournisseur.Current != null)
{
if (MessageBox.Show("Voulez vous confirmer la suppression?", "Suppression", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
try
{
Application.DoEvents();
DataRowView drv = (DataRowView)srcb_fournisseur.Current;
//string res = CLIENT_APP_PARAM.GEST.P_FOURNISSEUR.DELETE_FOURNISSEUR(drv["CODE_FOURNISSEUR"].ToString());
string res = CLIENT_APP_PARAM.gcws.DELETE_FOURNISSEUR(drv["CODE_FOURNISSEUR"].ToString());
if (res == "OK")
{
MessageBox.Show("La suppression du fournisseur à été effectuée avec succes.", "Suppression du fournisseur" + drv["CODE_FOURNISSEUR"].ToString(), MessageBoxButtons.OK, MessageBoxIcon.Information);
srcb_fournisseur.RemoveCurrent();
tab_fournisseur.AcceptChanges();
}
else
{
MessageBox.Show(res, "Suppression du fournisseur" + drv["CODE_FOURNISSEUR"].ToString(), MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception er)
{
MessageBox.Show(er.Message, "Connexion serveur", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
}
private void TsbRuleDeleteClick(object sender, EventArgs e)
{
using (DeleteControlForm deleteControlForm = new DeleteControlForm())
{
deleteControlForm.Message = "Deseja apagar a regra selecionada?";
if (deleteControlForm.ShowDialog() == DialogResult.OK)
{
DataRowView currentRule = _bsRule.Current as DataRowView;
_bsRule.RemoveCurrent();
_bsRule.EndEdit();
if (deleteControlForm.checkBox1.Checked)
{
DataRow currentRl = _dsSecurity.Tables["Rule"].Rows.Find(currentRule["Name"]);
currentRl.Delete();
_dsSecurity.Tables["Rule"].AcceptChanges();
}
else
{
DataRow currentGrpRl = _dsSecurity.Tables["GrpRl"].Rows.Find(new object[] { currentRule["GroupName"], currentRule["Name"] });
currentGrpRl.Delete();
_dsSecurity.Tables["GrpRl"].AcceptChanges();
}
}
}
}
private void TsbGroupDeleteClick(object sender, EventArgs e)
{
using (DeleteControlForm deleteControlForm = new DeleteControlForm())
{
deleteControlForm.Message = "Deseja apagar o grupo selecionado?";
if (deleteControlForm.ShowDialog() == DialogResult.OK)
{
DataRowView currentGroup = _bsGroup.Current as DataRowView;
_bsGroup.RemoveCurrent();
_bsGroup.EndEdit();
if (deleteControlForm.checkBox1.Checked)
{
DataRow currentGrp = _dsSecurity.Tables["Group"].Rows.Find(currentGroup["Name"]);
currentGrp.Delete();
_dsSecurity.Tables["Group"].AcceptChanges();
}
else
{
DataRow currentUsrGrp = _dsSecurity.Tables["UsrGrp"].Rows.Find(new object[] { currentGroup["UserName"], currentGroup["Name"] });
currentUsrGrp.Delete();
_dsSecurity.Tables["UsrGrp"].AcceptChanges();
}
}
}
}
private void ButtonDeleteRowClick(object sender, EventArgs e)
{
if (_bindingSource.Current != null && _bindingSource.AllowRemove)
{
_bindingSource.RemoveCurrent();
}
}
public static bool Delete(IDbDataAdapter adapter, DataSet ds, BindingSource bds)
{
try
{
if (Mensagem.Pergunta(null, "Deseja realmente deletar o registro corrente?", DialogResult.No))
{
return(false);
}
bds.RemoveCurrent();
bds.EndEdit();
adapter.Update(ds);
ds.Clear();
adapter.Fill(ds);
bds.DataSource = ds;
bds.DataMember = ds.Tables[0].TableName;
Commit();
return(true);
}
catch (Exception ex)
{
Mensagem.Excecao(null, "Erro ao deletar o registro corrente.", ex);
RefreshData(adapter, ds, bds);
return(false);
}
}
public static void RemoveSelected(this BindingSource bindingSource)
{
if (bindingSource.HasValue())
{
bindingSource.RemoveCurrent();
}
}
private void gridView1_RowCellClick(object sender, DevExpress.XtraGrid.Views.Grid.RowCellClickEventArgs e)
{
if (e.Column.Name == "colSuppr" && bsPaiement.Current != null)
{
bsPaiement.RemoveCurrent();
}
}
private void btnSupp_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Voulez-vous Supprimer?", "Confirmation", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes)
{
bs.RemoveCurrent();
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (MessageBox.Show("คุณต้องการลบหรือไม่?", "ยืนยันการลบ", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
bs.RemoveCurrent();
//ds.Tables["ProductAreana"].Rows[num].Delete();
if (num < ds.Tables["Custormer"].Rows.Count - 1)
{
num++;
}
else
{
if (num != 0)
{
num--;
}
else
{
clearFrom();
}
}
String sql;
conn.Open();
sql = "DELETE FROM Custormer WHERE ID_Customer = '" + txtID.Text + "'";
comm.CommandText = sql;
comm.ExecuteNonQuery();
conn.Close();
}
}
private void btnXoaDong_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (bds.Count > 0)
{
bds.RemoveCurrent();
}
else
{
return;
}
//Console.WriteLine(bds.Count);
//Console.WriteLine(dt.Rows.Count);
//Console.WriteLine(gv_SINHVIENTHEM.DataRowCount);
//for (int i = 0; i < gv_SINHVIENTHEM.DataRowCount; i++)
//{
// DataRow row = dt.NewRow();
// foreach (GridColumn column in gv_SINHVIENTHEM.VisibleColumns)
// {
// row[column.FieldName] = gv_SINHVIENTHEM.GetRowCellValue(i, column);
// if (column.FieldName.Equals("PHAITHEM") && row[column.FieldName].ToString().Equals("") ||
// column.FieldName.Equals("NGHIHOCTHEM") && row[column.FieldName].ToString().Equals(""))
// {
// row[column.FieldName] = false;
// }
// gv_SINHVIENTHEM.FocusedColumn = gv_SINHVIENTHEM.VisibleColumns[9];
// Console.WriteLine(row[column.FieldName]);
// }
//}
}
public override void MergeID()
{
if (bdsDoiTuong.Count <= 0)
{
return;
}
drCurrent = ((DataRowView)bdsDoiTuong.Current).Row;
string strOldValue = (string)drCurrent["Ma_Dt"];
frmMergeID frm = new frmMergeID();
frm.Load("LIDOITUONG", "Ma_Dt", "Ten_Dt", strOldValue, "DoiTuong");
if (frm.isAccept)
{
string strNewValue = frm.strNewValue;
string strMsg = Element.sysLanguage == enuLanguageType.English ? "Are you sure to merge " + strOldValue + " to " + strNewValue + " ?" : "Bạn có muốn gộp mã " + strOldValue + " sang " + strNewValue + " không ?";
if (!Common.MsgYes_No(strMsg))
{
return;
}
if (DataTool.SQLMergeID("Ma_Dt", "LIDOITUONG", strOldValue, strNewValue))
{
bdsDoiTuong.RemoveCurrent();
bdsDoiTuong.Position = bdsDoiTuong.Find("MA_DT", strNewValue);
}
}
}
private void BTN_SUPPRIMER_Click(object sender, EventArgs e)
{
if (bs.Current != null)
{
if (MessageBox.Show("Etes vous sûres de supprimer cet article?", this.Text, MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes)
{
//CHM_GESTION_COMERCIALE.RESULT_QUERY res;
CHMGC.RESULT_QUERY res;
try
{
DataRowView drv = (DataRowView)bs.Current;
Application.DoEvents();
//res = CLIENT_APP_PARAM.GEST.P_ARTICLE.DELETE_ARTICLE(drv["CODE_ARTICLE"].ToString());
res = CLIENT_APP_PARAM.gcws.DELETE_ARTICLE(drv["CODE_ARTICLE"].ToString());
if (res.OK)
{
bs.RemoveCurrent();
dt.AcceptChanges();
}
else
{
MessageBox.Show(res.MESSAGE, "Attention", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception er)
{
MessageBox.Show(er.Message, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
}
void gridControl1_KeyUp(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.F8)
{
bs.RemoveCurrent();
}
}
//【二、当系统读取到条形码开始将商品加入购物车】
//1.如果购物车中没有该商品，在购物车中新建一栏加入
//2.如果购物车中该商品已经存在了，直接改变购物车中该商品的数量
private void TxtProductId_KeyDown(object sender, KeyEventArgs e)
{
//在键盘按下事件中，必须要判断按下的功能键是什么
//【1】按下回车进行商品编号的录入，进入商品添加功能
if (e.KeyCode == Keys.Enter)
{
BindProduct();
}
//【2】按上移动
else if (e.KeyCode == Keys.Up)
{
if (dgvProductList.RowCount == 0 || dgvProductList.RowCount == 1)
{
return;
}
bs.MovePrevious();
}
//【3】按下移动
else if (e.KeyCode == Keys.Down)
{
if (dgvProductList.RowCount == 0 || dgvProductList.RowCount == 1)
{
return;
}
bs.MoveNext();
}
//【4】按下Del键移除
else if (e.KeyCode == Keys.Delete)
{
if (dgvProductList.RowCount == 0)
{
return;
}
bs.RemoveCurrent();
//问题：1.数据表要刷新
//问题：2.更新序号
dgvProductList.DataSource = null;
dgvProductList.DataSource = bs;
}
//【5】按下的是A键开始结算
else if (e.KeyCode == Keys.A)
{
if (dgvProductList.RowCount == 0)
{
return;
}
else
{
Balance();
}
}
//【6】按下的是退出系统按键
else if (e.KeyCode == Keys.Escape)
{
if (MessageBox.Show("是否确认关闭系统", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes)
{
this.Close();
}
}
}
private void tsRemove_Click(object sender, EventArgs e)
{
if (bs.Count > 0)
{
bs.RemoveCurrent();
}
}
public override void MergeID()
{
if (bdsViTri.Count <= 0)
{
return;
}
drCurrent = ((DataRowView)bdsViTri.Current).Row;
string strOldValue = (string)drCurrent["MA_VITRI"];
Epoint.Lists.frmMergeID frm = new Epoint.Lists.frmMergeID();
frm.Load("HRVITRI", "MA_VITRI", "Ten_Km", strOldValue, "ViTri");
if (frm.isAccept)
{
string strNewValue = frm.strNewValue;
string strMsg = Element.sysLanguage == enuLanguageType.English ? "Do you want to merge " + strOldValue + " to " + strNewValue + " ?" : "Bạn có muốn gộp mã " + strOldValue + " sang " + strNewValue + " không ?";
if (!Common.MsgYes_No(strMsg))
{
return;
}
if (DataTool.SQLMergeID("MA_VITRI", "HRVITRI", strOldValue, strNewValue))
{
bdsViTri.RemoveCurrent();
bdsViTri.Position = bdsViTri.Find("MA_VITRI", strNewValue);
}
}
}
private void toolStripMenuItem1_Click(object sender, EventArgs e)
{
if (bs.Current != null)
{
if (MessageBox.Show("Voulez vous confirmer la supression ?", "Supression", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes)
{
//CHM_GESTION_COMERCIALE.RESULT_QUERY res;
CHMGC.RESULT_QUERY res;
try
{
DataRowView drv = (DataRowView)bs.Current;
Application.DoEvents();
//res = CLIENT_APP_PARAM.GEST.P_MAGAZIN.DELETE_MAGAZIN(drv["CODE_MAG"].ToString());
res = CLIENT_APP_PARAM.gcws.DELETE_MAGAZIN(drv["CODE_MAG"].ToString());
if (res.OK)
{
bs.RemoveCurrent();
dt.AcceptChanges();
}
else
{
MessageBox.Show(res.MESSAGE, "Attention", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception er)
{
MessageBox.Show(er.Message, "Connexion serveur", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
}
private void TsbDeleteClick(object sender, EventArgs e)
{
if (MessageBox.Show("Confirma?", "Atenção", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes)
{
_bsTagList.RemoveCurrent();
}
}
public override void MergeID()
{
if (bdsEmployee.Count <= 0)
{
return;
}
drCurrent = ((DataRowView)bdsEmployee.Current).Row;
string strOldValue = (string)drCurrent["Ma_CbNv"];
frmMergeID frm = new frmMergeID();
frm.Load("LINHANVIEN", "Ma_CbNv", "Ten_CbNv", strOldValue, "DMCBNV");
if (frm.isAccept)
{
string strNewValue = frm.strNewValue;
string strMsg = Element.sysLanguage == enuLanguageType.English ? "Do you want to merge " + strOldValue + " to " + strNewValue + " ?" : "Bạn có muốn gộp mã " + strOldValue + " sang " + strNewValue + " không ?";
if (!Common.MsgYes_No(strMsg))
{
return;
}
if (DataTool.SQLMergeID("Ma_CbNv", "LINHANVIEN", strOldValue, strNewValue))
{
bdsEmployee.RemoveCurrent();
bdsEmployee.Position = bdsEmployee.Find("Ma_CbNv", strNewValue);
}
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (dataBindingSource.Current != null)
{
dataBindingSource.RemoveCurrent();
}
}