private void gvRolls_PopupMenuShowing(object sender, DevExpress.XtraGrid.Views.Grid.PopupMenuShowingEventArgs e)
{
if (e.MenuType == DevExpress.XtraGrid.Views.Grid.GridMenuType.Row)
{
if (e.HitInfo.InRow && e.HitInfo.RowInfo != null)
{
DevExpress.XtraGrid.Views.Grid.GridView gv = (DevExpress.XtraGrid.Views.Grid.GridView)sender;
dynamic obj = null;
object itm = gv.GetRow(gv.FocusedRowHandle);
DevExpress.XtraGrid.Menu.GridViewMenu menu = e.Menu as DevExpress.XtraGrid.Menu.GridViewMenu;
menu.Items.Clear();
DevExpress.Utils.Menu.DXMenuItem mgr = new DevExpress.Utils.Menu.DXMenuItem();
mgr.Caption = $"Delete";
mgr.Click += delegate(object o, EventArgs args)
{
gv.DeleteSelectedRows();
ReCalcs();
};
menu.Items.Add(mgr);
}
}
}
private void toolStripMenuItemDel_Click(object sender, EventArgs e)
{
if (CurrentgridView == null)
{
return;
}
CurrentgridView.DeleteSelectedRows();
SaveToFile();
}
void gridControl1_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.F4)
{
GridControl gcMain = sender as GridControl;
DevExpress.XtraGrid.Views.Grid.GridView gvMain = gridControl1.Views[0] as DevExpress.XtraGrid.Views.Grid.GridView;
gvMain.DeleteSelectedRows();
}
}
/// <summary>
/// 删除选中的行
/// </summary>
/// <param name="gridview"></param>
/// <returns></returns>
public static bool DelSelectedRows(this DevExpress.XtraGrid.Views.Grid.GridView gridview)
{
bool r = false;
if (UserMessages.ShowQuestionBox("要删除选中的行么?"))
{
gridview.DeleteSelectedRows();
r = true;
}
return(r);
}
public static void grid_remove(DevExpress.XtraGrid.Views.Grid.GridView gvGrid)
{
try
{
int[] aList = gvGrid.GetSelectedRows();
for (int i = 0; i < aList.Length; i++)
{
gvGrid.DeleteSelectedRows();
}
}
catch (Exception erro)
{
Alert.erro("Erro ao realizar a remoção \n " + erro.Message);
}
}
private void ValidMtID(DataColumn colMT, string value)
{
string fieldName = colMT.ColumnName;
foreach (CDTGridLookUpEdit tmp in _glist)
{
if (tmp.Properties.Buttons[0].Tag != null)
{
if ((tmp.Properties.Buttons[0].Tag as DataRow)["QueryInsertDt"].ToString() == string.Empty)
{
continue;
}
if (!this.isRefreshed)
{
this.Refresh(this, new EventArgs());
this.isRefreshed = true;
}
if (fieldName.ToLower() == (tmp.Properties.Buttons[0].Tag as DataRow)["FieldName"].ToString().ToLower())
{
try
{
string query = (tmp.Properties.Buttons[0].Tag as DataRow)["QueryInsertDt"].ToString();
//xoa cac dong da nhap
DevExpress.XtraGrid.Views.Grid.GridView gvMain = gc.MainView as DevExpress.XtraGrid.Views.Grid.GridView;
if (colMT.Table.TableName == "MT29" && fieldName == "MT2AID") //Piriou
{
gvMain.SelectAll();
gvMain.DeleteSelectedRows();
//gvMain.ClearSelection();
_data.LstDrCurrentDetails.Clear();
}
if (value == string.Empty)
{
continue;
}
DataTable dtTable;
query = query.Replace("@" + fieldName, value);
dtTable = _data.DbData.GetDataTable(query);
//Xác định khóa ngoại
DataRow[] RelaRow = _data.DsStruct.Tables[1].Select("refTable='" + _data.DrTableMaster["TableName"].ToString() + "'");
string RelaCol = _data.DrTableMaster["Pk"].ToString();
if (RelaRow.Length > 0)
{
RelaCol = RelaRow[0]["FieldName"].ToString();
}
for (int i = 0; i < dtTable.Rows.Count; i++)
{
DataRow drdt = dtTable.Rows[i];
DataRow drNew = _data.DsData.Tables[1].NewRow();
drNew[RelaCol] = _data.DrCurrentMaster[_data.DrTableMaster["Pk"].ToString()];
gvMain.RefreshData();
//int j = gvMain.DataRowCount;
foreach (DataColumn col in dtTable.Columns)
{
if (_data.DsData.Tables[1].Columns.Contains(col.ColumnName))
{
drNew[col.ColumnName] = drdt[col.ColumnName];
if (gvMain.Columns[col.ColumnName] == null)
{
continue;
}
{
GridColumn g = gvMain.Columns[col.ColumnName];
CDTRepGridLookup r = g.ColumnEdit as CDTRepGridLookup;
if (r == null)
{
continue;
}
BindingSource bs = r.DataSource as BindingSource;
if (!r.Data.FullData)
{
r.Data.GetData();
bs.DataSource = r.Data.DsData.Tables[0];
r.DataSource = bs;
}
//DataTable tbRep = bs.DataSource as DataTable;
//int index = r.GetIndexByKeyValue(drdt[g.FieldName]);
//if (index == -1) continue;
//DataRow RowSelected = tbRep.Rows[index];
//if (RowSelected != null)
//{
// //_data.SetValuesFromListDt(drNew, g.FieldName, drdt[g.FieldName].ToString(), RowSelected);
//}
}
}
}
_data.DsData.Tables[1].Rows.Add(drNew);
//_data.DsData.Tables[1].Rows.Add(_data.LstDrCurrentDetails[_data.LstDrCurrentDetails.Count - 1]);
}
// gvMain.AddNewRow();
//if (colMT.Table.TableName == "MTLSX" && fieldName == "MT35ID") //Bến Thành
//{
// foreach (DataRow m in _data.LstDrCurrentDetails)
// {
// if (m["MT35ID"].ToString() != value)
// {
// m["MT35ID"] = DBNull.Value;
// m["DT35ID"] = DBNull.Value;
// m.EndEdit();
// }
// }
//}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
}
}
private void ValidMtID(DataColumn colMT, string value)
{
string fieldName = colMT.ColumnName;
foreach (CDTGridLookUpEdit tmp in _glist)
{
if (tmp.Properties.Buttons[0].Tag != null)
{
if ((tmp.Properties.Buttons[0].Tag as DataRow)["QueryInsertDt"].ToString() == string.Empty)
{
continue;
}
if (!this.isRefreshed)
{
this.Refresh(this, new EventArgs());
this.isRefreshed = true;
}
if (fieldName.ToLower() == (tmp.Properties.Buttons[0].Tag as DataRow)["FieldName"].ToString().ToLower())
{
try
{
string query = (tmp.Properties.Buttons[0].Tag as DataRow)["QueryInsertDt"].ToString();
//xoa cac dong da nhap
DevExpress.XtraGrid.Views.Grid.GridView gvMain = gc.MainView as DevExpress.XtraGrid.Views.Grid.GridView;
if (colMT.Table.TableName == "MT29" && fieldName == "MT2AID") //Piriou
{
gvMain.SelectAll();
gvMain.DeleteSelectedRows();
//gvMain.ClearSelection();
_data.LstDrCurrentDetails.Clear();
}
//gvMain.SelectAll();
//gvMain.DeleteSelectedRows();
////gvMain.ClearSelection();
//_data.LstDrCurrentDetails.Clear();
//string fieldName = e.Column.ColumnName;
if (value == string.Empty)
{
continue;
}
DataTable dtTable;
query = query.Replace("@" + fieldName, value);
dtTable = _data.DbData.GetDataTable(query);
for (int i = 0; i < dtTable.Rows.Count; i++)
{
DataRow drdt = dtTable.Rows[i];
gvMain.AddNewRow();
int j = gvMain.DataRowCount;
foreach (DataColumn col in dtTable.Columns)
{
if (_data.DsData.Tables[1].Columns.Contains(col.ColumnName))
{
_data.LstDrCurrentDetails[_data.LstDrCurrentDetails.Count - 1][col.ColumnName] = drdt[col.ColumnName];
if (gvMain.Columns[col.ColumnName] == null)
{
continue;
}
{
GridColumn g = gvMain.Columns[col.ColumnName];
CDTRepGridLookup r = g.ColumnEdit as CDTRepGridLookup;
if (r == null)
{
continue;
}
BindingSource bs = r.DataSource as BindingSource;
if (!r.Data.FullData)
{
r.Data.GetData();
bs.DataSource = r.Data.DsData.Tables[0];
r.DataSource = bs;
}
DataTable tbRep = bs.DataSource as DataTable;
int index = r.GetIndexByKeyValue(drdt[g.FieldName]);
if (index == -1)
{
continue;
}
DataRow RowSelected = tbRep.Rows[index];
if (RowSelected != null)
{
_data.SetValuesFromListDt(_data.LstDrCurrentDetails[j], g.FieldName, drdt[g.FieldName].ToString(), RowSelected);
}
}
}
}
_data.DsData.Tables[1].Rows.Add(_data.LstDrCurrentDetails[_data.LstDrCurrentDetails.Count - 1]);
}
// gvMain.AddNewRow();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
}
}
