private void BorrarFilasSeleccionadas(DevExpress.XtraGrid.Views.Grid.GridView view)
{
if (view == null || view.SelectedRowsCount == 0)
{
return;
}
DataRow[] rows = new DataRow[view.SelectedRowsCount];
for (int i = 0; i < view.SelectedRowsCount; i++)
{
rows[i] = view.GetDataRow(view.GetSelectedRows()[i]);
}
view.BeginSort();
try
{
foreach (DataRow row in rows)
{
row.Delete();
}
}
finally
{
view.EndSort();
}
}
private void DeleteSelectedRows(DevExpress.XtraGrid.Views.Grid.GridView view)
{
//Start : added on 26/05/2014
int iNoSku = Convert.ToInt32(lblTotNoOfSKU.Text);
int iNoOfSetOf = Convert.ToInt32(lblTotSetOf.Text);
decimal dTotQty = Convert.ToDecimal(lblTotQty.Text);
//End : added on 26/05/2014
if (view == null || view.SelectedRowsCount == 0)
{
return;
}
DataRow[] rows = new DataRow[view.SelectedRowsCount];
for (int i = 0; i < view.SelectedRowsCount; i++)
{
rows[i] = view.GetDataRow(view.GetSelectedRows()[i]);
}
view.BeginSort();
try
{
//Start : added on 26/05/2014
foreach (DataRow dr in rows)
{
iNoSku = iNoSku - 1;
iNoOfSetOf = iNoOfSetOf - Convert.ToInt32(dr[1]);
dTotQty = dTotQty - Convert.ToDecimal(dr[2]);
}
lblTotNoOfSKU.Text = Convert.ToString(iNoSku);
lblTotSetOf.Text = Convert.ToString(iNoOfSetOf);
lblTotQty.Text = Convert.ToString(dTotQty);
foreach (DataRow rn in rows)
{
foreach (DataRow row in dtSku.Rows)
{
if (Convert.ToString(row["SkuNumber"]) == Convert.ToString(rn[0]))
{
row.Delete();
break;
}
}
}
dtSku.AcceptChanges();
//End : added on 26/05/2014
}
finally
{
view.EndSort();
}
}
private void DeleteFocusedRows(DevExpress.XtraGrid.Views.Grid.GridView view)
{
if (view.RowCount > 0 && view.IsValidRowHandle(view.FocusedRowHandle) && !view.IsNewItemRow(view.FocusedRowHandle))
{
view.BeginSort();
try
{
view.DeleteRow(view.FocusedRowHandle);
}
catch (Exception)
{
}
view.EndSort();
}
}
//Sắp xếp theo thứ tự tăng/giảm dần gridview
public static void SapXepLaiGridView(DevExpress.XtraGrid.Views.Grid.GridView gv, string tenCotCanSapXep, bool Tang_True_Giam_False)
{
gv.BeginSort();
try
{
gv.ClearSorting();
if (Tang_True_Giam_False)
{
gv.Columns[tenCotCanSapXep].SortOrder = DevExpress.Data.ColumnSortOrder.Ascending;
}
else
{
gv.Columns[tenCotCanSapXep].SortOrder = DevExpress.Data.ColumnSortOrder.Descending;
}
}
finally
{
gv.EndSort();
}
}
private void EditGridRow(DevExpress.XtraGrid.Views.Grid.GridView view)
{
if (view == null || view.SelectedRowsCount == 0)
{
return;
}
DataRow[] rows = new DataRow[view.SelectedRowsCount];
for (int i = 0; i < view.SelectedRowsCount; i++)
{
rows[i] = view.GetDataRow(view.GetSelectedRows()[i]);
}
view.BeginSort();
try
{
foreach (DataRow rn in rows)
{
dtpDate.Text = Convert.ToDateTime(rn[0]).ToShortDateString();
txtExistCust.Text = Convert.ToString(rn[1]);
txtNewCust.Text = Convert.ToString(rn[2]);
txtHNICust.Text = Convert.ToString(rn[3]);
txtExistCust.Tag = Convert.ToInt32(rn[4]);
bIsEdit = false;
dtpDate.Enabled = false;
txtExistCust.Enabled = false;
txtNewCust.Enabled = false;
txtHNICust.Enabled = false;
}
}
finally
{
view.EndSort();
}
}
public static void ConfigGridView(DevExpress.XtraGrid.Views.Grid.GridView gridView, string[] bestFitColumns = null, string[] invisibleColumns = null, bool readOnly = false, string[] readOnlyColumns = null, bool allowGroup = false, string[] groupColumns = null, bool merge = false, string[] mergeColumns = null, bool allowFilter = true, bool allowSort = true)
{
gridView.OptionsCustomization.AllowFilter = allowFilter;
gridView.OptionsCustomization.AllowSort = allowSort;
//AutoSizeColumn
//gridView.BestFitColumns();
if (bestFitColumns != null)
{
foreach (var column in bestFitColumns)
{
gridView.Columns[column].BestFit();
}
}
//Visible column
if (invisibleColumns != null)
{
foreach (var column in invisibleColumns)
{
gridView.Columns[column].Visible = false;
}
}
//Readonly
gridView.OptionsBehavior.ReadOnly = readOnly;
if (!readOnly && readOnlyColumns != null)
{
foreach (var column in readOnlyColumns)
{
gridView.Columns[column].OptionsColumn.ReadOnly = true;
}
}
//group column
gridView.OptionsCustomization.AllowGroup = allowGroup;
if (groupColumns != null)
{
gridView.BeginSort();
try
{
gridView.ClearGrouping();
int index = 0;
foreach (var column in groupColumns)
{
gridView.Columns[column].GroupIndex = index++;
}
}
finally
{
gridView.EndSort();
}
}
//merge column
gridView.OptionsView.AllowCellMerge = merge;
if (mergeColumns != null)
{
for (int i = 0; i < gridView.Columns.Count; i++)
{
gridView.Columns[i].OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.False;
}
foreach (var column in mergeColumns)
{
gridView.Columns[column].OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.True;
}
}
ReconfigGridView(gridView);
}
