/// <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); }