/// <summary>
/// 置底
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void RepositoryItemButtonEdit4_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
{
DataTable dtPostgreSql = gcSetting.DataSource as DataTable;
GridView gridView1 = this.gcSetting.MainView as GridView;
int bottom = dtPostgreSql.Rows.Count - 1;
if (gridView1.SelectedRowsCount >= 1)
{
int[] index = new int[gridView1.SelectedRowsCount];
int[] rows = gridView1.GetSelectedRows();
int j = 0;
if (rows[rows.Length - 1] <= gridView1.RowCount - 2)
{
for (int i = rows[rows.Length - 1]; i > rows[0] - 1; i--)
{
object[] ot = dtPostgreSql.Rows[i].ItemArray;
DataRow dr = dtPostgreSql.Rows[i];
dtPostgreSql.Rows.Remove(dr);
DataRow drs = dtPostgreSql.NewRow();
drs.ItemArray = ot;
dtPostgreSql.Rows.InsertAt(drs, bottom - j);
index[j] = bottom - j;
j++;
}
gridView1.SelectRows(index[0], index[index.Length - 1]);
dtPostgreSql.AcceptChanges();
}
else
{
KzxMessageBox.Show("已到最后一条记录不能继续下移");
}
}
}
/// <summary>
/// 上移
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void RepositoryItemButtonEdit1_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
{
DataTable dtPostgreSql = gcSetting.DataSource as DataTable;
GridView gridView1 = this.gcSetting.MainView as GridView;
if (gridView1.SelectedRowsCount < 1)
{
KzxMessageBox.Show("未选中任何行");
return;
}
if (gridView1.SelectedRowsCount == 1)
{
int selectIndex = this.gridView1.GetDataSourceRowIndex(this.gridView1.FocusedRowHandle);
if (selectIndex - 1 >= 0)
{
object[] ot = dtPostgreSql.Rows[selectIndex].ItemArray;
DataRow dr = dtPostgreSql.Rows[selectIndex];
dtPostgreSql.Rows.Remove(dr);
DataRow drs = dtPostgreSql.NewRow();
drs.ItemArray = ot;
dtPostgreSql.Rows.InsertAt(drs, selectIndex - 1);
dtPostgreSql.AcceptChanges();
}
else
{
KzxMessageBox.Show("已到第一行不能继续上移");
}
gridView1.FocusedRowHandle = selectIndex - 1;
}
}
/// <summary>
/// 置顶
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void RepositoryItemButtonEdit3_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
{
DataTable dtPostgreSql = gcSetting.DataSource as DataTable;
GridView gridView1 = this.gcSetting.MainView as GridView;
if (gridView1.SelectedRowsCount == 1)
{
int top = this.gridView1.GetDataSourceRowIndex(this.gridView1.FocusedRowHandle);
DataRow drOne = this.gridView1.GetDataRow(top);
dtPostgreSql.Rows.InsertAt(dtPostgreSql.NewRow(), 0);
dtPostgreSql.Rows[0].ItemArray = drOne.ItemArray;
drOne.Delete(); //删除原来的数据行(该行所在父表中删除)
dtPostgreSql.AcceptChanges(); //提交表所有的更改
gridView1.MoveFirst();
}
if (gridView1.SelectedRowsCount > 1)
{
int[] index = new int[gridView1.SelectedRowsCount];
int[] rows = gridView1.GetSelectedRows();
int j = 0;
if (rows[0] - 1 >= 0)
{
for (int i = rows[0]; i < rows[rows.Length - 1] + 1; i++)
{
object[] ot = dtPostgreSql.Rows[i].ItemArray;
DataRow dr = dtPostgreSql.Rows[i];
dtPostgreSql.Rows.Remove(dr);
DataRow drs = dtPostgreSql.NewRow();
drs.ItemArray = ot;
dtPostgreSql.Rows.InsertAt(drs, j);
index[j] = j;
j++;
}
gridView1.SelectRows(index[0], index[index.Length - 1]);
dtPostgreSql.AcceptChanges();
}
else
{
KzxMessageBox.Show("已到第一行不能继续上移");
}
}
}
/// <summary>
/// 弹窗提示测试
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void sbtnOverrideShow_Click(object sender, EventArgs e)
{
KzxMessageBox.Show("this is a test!");
KzxMessageBox.Show("This is a test!", MessageBoxButtons.OKCancel, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1);
}
