/// <summary> /// Metodo que realiza una bisqueda dentro de toda la informacion de un DataGridStyle, /// oculta las filas que no tienen ninguna coincidencia con un texto dado. /// </summary> /// <param name="dgv">DataGridStyle en el que se buscata</param> /// <param name="txbB">TextBox que contoene el texto que se debe buscar.</param> public void Buscar(DataGridStyle dgv, TextBox txbB) { int rows = dgv.RowCount; bool[] crows; crows = new bool[rows]; for (int i = 0; i < dgv.RowCount; i++) { crows[i] = false; } for (int i = 0; i < dgv.RowCount; i++) { for (int j = 0; j < dgv.ColumnCount; j++) { if (dgv[j, i].Value.ToString().ToLower().Contains(txbB.Text.ToLower())) { crows[i] = true; } } } for (int i = 0; i < dgv.RowCount; i++) { dgv.Rows[i].Visible = crows[i]; } }
/// <summary> /// 表格响应按键事件 /// </summary> private void Dg_PreviewKeyDown(object sender, KeyEventArgs e) { if (e.Key == Key.Enter) { int rowIndex = this.dg.SelectedIndex; DataGridCellInfo cellInfo = this.dg.CurrentCell; if (null != cellInfo && null != cellInfo.Column) { if (rowIndex == this.dg.Items.Count - 1 && cellInfo.Column.DisplayIndex == this.dg.Columns.Count - 1) { // 在最后一个单元格点击回车进入搜索框 e.Handled = true; this.dg.SelectedIndex = -1; this.ResetSearchBoxFocus(); } else if (rowIndex > -1 && cellInfo.Column.DisplayIndex == 0) { // 第一列,删除事件 e.Handled = true; this.ButtonDeleteItem_Click(null, null); // 焦点定位到 DataGridCell timeCell = DataGridStyle.GetCell(this.dg, this.dg.SelectedIndex, 2); if (timeCell != null) { this.dg.CurrentCell = new DataGridCellInfo(timeCell); this.dg.BeginEdit(); } } } } }
/// <summary> /// 下拉框关闭时恢复响应DataGrid的按键事件 /// </summary> private void ComboBox_DropDownClosed(object sender, EventArgs e) { // 恢复表格响应PreviewKeyDown事件 this.datagrid.Tag = null; // 进入往右的下一单元格 this.datagrid.Focus(); // 当前选中行的持续状态为0时,则焦点定位到搜索框中 if (this.cbCellNextColumnIndex == 11 && this.anesDrugEditorViewModel.SelectItem.DURATIVE_INDICATOR == 0) { this.ResetSearchBoxFocus(); } else { DataGridCell timeCell = DataGridStyle.GetCell(this.datagrid, this.datagrid.SelectedIndex, this.cbCellNextColumnIndex); if (timeCell != null) { this.datagrid.CurrentCell = new DataGridCellInfo(timeCell); this.datagrid.BeginEdit(); } } // 重新设置下数据 this.cbCellNextColumnIndex = -1; this.isDataGridPreviewMouseLeftButtonDown = false; }
/// <summary> /// 重置列表选中行 /// </summary> private void ResetDataGridSelected(int rowIndex) { // 设置选中行 if (this.datagrid.Items.Count > 0) { if (this.datagrid.Items.Count > rowIndex) { this.datagrid.SelectedIndex = rowIndex; } else if (this.datagrid.Items.Count == rowIndex) { this.datagrid.SelectedIndex = this.datagrid.Items.Count - 1; } // 焦点定位到开始时间 DataGridCell timeCell = DataGridStyle.GetCell(this.datagrid, this.datagrid.SelectedIndex, 2); if (timeCell != null) { this.datagrid.CurrentCell = new DataGridCellInfo(timeCell); this.datagrid.BeginEdit(); } } else { this.ResetSearchBoxFocus(); } }
/// <summary> /// 搜索框响应方向键 /// </summary> private void TxtBoxSearch_PreviewKeyDown(object sender, KeyEventArgs e) { if (e.Key == Key.Down && this.lvMed.Items.Count > 0) { // 往下进入字典列表 e.Handled = true; this.lvMed.Focus(); this.lvMed.SelectedIndex = 0; SelectorControlHelper.SetItemFocus(this.lvMed, this.lvMed.SelectedItem); } else if (e.Key == Key.Right && this.datagrid.Items.Count > 0) { // 往右进入表格 e.Handled = true; this.datagrid.Focus(); this.datagrid.SelectedIndex = 0; // 焦点定位到第一行的开始时间单元格 DataGridCell timeCell = DataGridStyle.GetCell(this.datagrid, 0, 2); if (timeCell != null) { this.datagrid.CurrentCell = new DataGridCellInfo(timeCell); this.datagrid.BeginEdit(); } } }
private void FrmTableTranse_Load(object sender, EventArgs e) { RetrieveData(); LoadInterfaceTrans(); DataGridStyle.GridDisplayStyle(dgv_task, true); Isloading = false; string sql = "select Table_Name from IF_Table_Infor where table_position = '0'"; AccessDBop.SQLSelect(sql, ref dtOurTableName); sql = "select Table_Name from IF_Table_Infor where table_position = '1'"; AccessDBop.SQLSelect(sql, ref dtTheirTableName); }
public override void Destroy() { sfGrid.AutoGeneratingColumn -= GridGenerateColumns; sfGrid.Dispose(); sfGrid = null; viewModel = null; defaultStyle = null; darkStyle = null; blueStyle = null; redStyle = null; greenStyle = null; }
private void c_conAdd_CheckedChanged(object sender, EventArgs e) { if ((!c_checkAdd.Checked) && (!c_checkUpdate.Checked) && (!c_checkDel.Checked)) { d_contition.Enabled = false; DataGridStyle.GridDisplayStyle(d_contition, true, false); } else { d_contition.Enabled = true; DataGridStyle.GridDisplayStyle(d_contition, true); } }
private void Report_Load(object sender, EventArgs e) { checkBoxDate.Checked = false; checkBoxDocName.Checked = false; checkBoxEName.Checked = false; dateTimePicker1.Enabled = false; comboBox_EmpName.Enabled = false; comboBoxDocName.Enabled = false; dateTimePicker1.Value = GetDateWithoutMilliseconds(DateTime.Now); FillEmployeesToCombo(); FillDocumentsToCombo(); ShowGridSignedList(); DataGridStyle.DataGridDesign(dataGridView); }
private void EditFormType_Load(object sender, EventArgs e) { try { label4.Left = 175; cb_CompareTable.Left = 259; DataGridStyle.GridDisplayStyle(dgv_columns, true); if (_TableName != "") { cb_DatabaseTable.Visible = false; label1.Visible = false; tb_TableName.Text = _TableName; tb_TableDesc.Text = _TableDesc; ucbTablePosition.Text = _TablePosition; ucbTablePosition.Enabled = false; } else { cb_DatabaseTable.Visible = true; label1.Visible = true; ucbTablePosition.Enabled = true; LoadPosition2ucbTablePosition(); } if (_TableType == "Z") { cb_CompareTable.Visible = false; cb_CompareTable.Enabled = false; label4.Visible = false; label4.Enabled = false; } else { cb_DatabaseTable.Visible = false; label1.Visible = false; cb_CompareTable.Visible = true; cb_CompareTable.Enabled = true; label4.Visible = true; label4.Enabled = true; } RetrieveData(); if (_TableType != "Z" && _TableName != "") { cb_CompareTable.Enabled = false; cb_CompareTable.Text = ((DataTable)cb_CompareTable.DataSource).Select("Table_Name = '" + _CompareTableName + "'")[0]["Table_desc"].ToString(); } Isload = false; } catch { } }
private void EndTime_PreviewKeyDown(object sender, KeyEventArgs e) { if (e.Key == Key.Enter) { // 往右进入表格 e.Handled = true; this.SignDataGrid.Focus(); this.SignDataGrid.SelectedIndex = 0; // 焦点定位到第一行的开始时间单元格 DataGridCell timeCell = DataGridStyle.GetCell(this.SignDataGrid, 0, 1); if (timeCell != null) { this.SignDataGrid.CurrentCell = new DataGridCellInfo(timeCell); this.SignDataGrid.BeginEdit(); } } }
public override Android.Views.View GetSampleContent (Android.Content.Context context) { sfGrid = new SfDataGrid (context); viewModel = new StylesViewModel (); sfGrid.ItemsSource = (viewModel.OrdersInfo); sfGrid.AutoGeneratingColumn += GridGenerateColumns; sfGrid.AlternatingRowColor = Color.Rgb (206, 206, 206); sfGrid.SelectionMode = SelectionMode.Single; sfGrid.GroupColumnDescriptions.Add (new GroupColumnDescription (){ ColumnName = "CustomerID" }); sfGrid.GridViewCreated += SfGrid_GridViewCreated; sfGrid.QueryRowHeight += SfGrid_QueryRowHeight; defaultStyle = new DataGridStyle (); darkStyle = new Dark (); blueStyle = new Blue (); redStyle = new Red (); greenStyle = new Green (); return sfGrid; }
public override Android.Views.View GetSampleContent(Android.Content.Context context) { sfGrid = new SfDataGrid(context); viewModel = new StylesViewModel(); sfGrid.ItemsSource = (viewModel.OrdersInfo); sfGrid.AutoGeneratingColumn += GridGenerateColumns; sfGrid.SelectionMode = SelectionMode.Single; sfGrid.GridViewCreated += SfGrid_GridViewCreated; sfGrid.QueryRowHeight += SfGrid_QueryRowHeight; sfGrid.VerticalOverScrollMode = VerticalOverScrollMode.None; sfGrid.Alpha = 1.0f; defaultStyle = new DataGridStyle(); darkStyle = new Dark(); blueStyle = new Blue(); redStyle = new Red(); greenStyle = new Green(); purpleStyle = new Purple(); return(sfGrid); }
public override Android.Views.View GetSampleContent(Android.Content.Context context) { sfGrid = new SfDataGrid(context); viewModel = new StylesViewModel(); sfGrid.ItemsSource = (viewModel.OrdersInfo); sfGrid.AutoGeneratingColumn += GridGenerateColumns; sfGrid.AlternatingRowColor = Color.Rgb(206, 206, 206); sfGrid.SelectionMode = SelectionMode.Single; sfGrid.GroupColumnDescriptions.Add(new GroupColumnDescription() { ColumnName = "CustomerID" }); sfGrid.GridViewCreated += SfGrid_GridViewCreated; sfGrid.QueryRowHeight += SfGrid_QueryRowHeight; defaultStyle = new DataGridStyle(); darkStyle = new Dark(); blueStyle = new Blue(); redStyle = new Red(); greenStyle = new Green(); return(sfGrid); }
private void ColumnTypeDefine_Load(object sender, EventArgs e) { DataGridStyle.GridDisplayStyle(dgv_columntype, true); string ls_types = (Project.DB_Type.ToLower().Equals("sql server")) ? "varchar,nvarchar,char,nchar,int,bigint,decimal,numeric,money,float,real,datetime,image" : (Project.DB_Type.ToLower().Equals("oracle")) ? "varchar2,nvarchar2,char,nchar,int,number,float,date" : "text,varchar,char,int,float,datetime,date,TIMESTAMP"; string ls_default = (Project.DB_Type.ToLower().Equals("sql server")) ? "50,50,10,10,,,10,10,10,,,," : (Project.DB_Type.ToLower().Equals("oracle")) ? "50,50,10,10,,10,," : ",50,10,4,4,8,3,4"; string[] lsa_types = ls_types.Split(','); string[] lsa_default = ls_default.Split(','); for (int i = 0; i < lsa_types.Length; i++) { dgv_columntype.Rows.Add(new object[] { lsa_types[i], lsa_default[i] }); } }
/// <summary> /// Llena un DataGridView, extrallendo los datos desde SQLServer /// </summary> /// <param name="origenTabla">Tabla origen que sera llenada</param> /// <param name="index">Indice de la categoria seleccionada</param> /// <returns>Tabla llena con datos.</returns> public DataGridStyle ObtenerTablaDocumentos(DataGridStyle origenTabla, int index) { documentoId.Clear(); origenTabla.Rows.Clear(); estado = Conexion.EjecutarConsulta("EXECUTE SP_DIG_OBTENER_DOCUMENTOS " + categoriaId[index]); if (estado.Estado) { //Llenar tabla while (estado.Resultado.HasRows && estado.Resultado.Read()) { origenTabla.Rows.Add(estado.Resultado.GetString(0), estado.Resultado.GetString(1), estado.Resultado.GetDateTime(2).ToString("dd/MM/yyyy HH:mm:ss"), estado.Resultado.GetBoolean(3)); documentoId.Add(estado.Resultado.GetInt32(4)); } estado.Resultado.Close(); //Bloquear Columnas no Editables origenTabla.Columns["NombreUsuario"].ReadOnly = true; origenTabla.Columns["FechaAlta"].ReadOnly = true; return(origenTabla); } return(null); }
private void FrmFieldTranse_Load(object sender, EventArgs e) { LoadData(); LoadInterfaceTrans(); DataGridStyle.GridDisplayStyle(dgv_Fields, true); }
private void RetrieveData() { string ls_sql = ""; DataTable ldt; //if (_TableType != "Z") //{ //绑定下拉框 ls_sql = "select Table_Name,Table_desc From IF_Table_infor" + " Where Table_Type = 'Z' "; ldt = new DataTable(); if (AccessDBop.SQLSelect(ls_sql, ref ldt)) { if (ldt.Rows.Count > 0) { cb_Ztable.DisplayMember = "Table_desc"; cb_Ztable.ValueMember = "Table_Name"; cb_Ztable.DataSource = ldt; cb_Ztable.SelectedIndex = -1; cb_Ztable.SelectedIndex = 0; } } if (_TableName == "") { ls_sql = "select Table_Name,Table_desc From IF_Table_infor" + " Where Table_Type = 'L'" + " and Table_Name not in " + " (select TableName from IF_Table_Compare)"; } else { ls_sql = "select Table_Name,Table_desc From IF_Table_infor" + " Where Table_Type = 'L'"; } ldt = new DataTable(); if (AccessDBop.SQLSelect(ls_sql, ref ldt)) { if (ldt.Rows.Count > 0) { cb_Ltable.DisplayMember = "Table_desc"; cb_Ltable.ValueMember = "Table_Name"; cb_Ltable.DataSource = ldt; cb_Ltable.SelectedIndex = -1; cb_Ltable.SelectedIndex = 0; } } //} //初始化datagird if (_TableName != "" && _TableName != null) { cb_Ltable.Enabled = false; cb_Ztable.Enabled = false; ls_sql = "SELECT TableName, CompareTableName,Rule_id, Rule_content, SQLString " + " FROM IF_Table_Compare Where TableName ='" + _TableName + "'"; ldt = new DataTable(); DataGridView dgv = new DataGridView(); if (AccessDBop.SQLSelect(ls_sql, ref ldt)) { if (ldt.Rows.Count > 0) { cb_Ltable.SelectedValue = ldt.Rows[0]["TableName"].ToString(); cb_Ztable.SelectedValue = ldt.Rows[0]["CompareTableName"].ToString(); switch (ldt.Rows[0]["Rule_id"].ToString()) { case "0": dgv = d_replace; r_replace.Checked = true; tb_Mode.SelectedIndex = 0; break; case "1": dgv = d_check; r_check.Checked = true; tb_Mode.SelectedIndex = 1; break; case "2": dgv = d_contition; r_contition.Checked = true; tb_Mode.SelectedIndex = 2; break; } } string ls_Rule_content = ldt.Rows[0]["Rule_content"].ToString(); string[] ls_contents = ls_Rule_content.Split(new string[] { "{seprator}" }, StringSplitOptions.None); string[] ls_rows = ls_contents[0].Split(new string[] { "{|}" }, StringSplitOptions.None); //初始化datagridview for (int i = 0; i < ls_rows.Length; i++) { string[] ls_value = ls_rows[i].Split(new string[] { "{,}" }, StringSplitOptions.None); dgv.Rows.Add(ls_value); } //若条件更新初始化增删改字段 string[] ls_conditionfileds = ls_contents[1].Split(new string[] { "," }, StringSplitOptions.None); if (r_contition.Checked) { t_conditionfield.Text = ls_conditionfileds[0]; t_addflag.Text = ls_conditionfileds[1]; t_updateflag.Text = ls_conditionfileds[2]; t_deleteflag.Text = ls_conditionfileds[3]; c_conAdd.Checked = (ls_conditionfileds[4] == "1" ? true : false); c_conUpdate.Checked = (ls_conditionfileds[5] == "1" ? true : false); c_conDel.Checked = (ls_conditionfileds[6] == "1" ? true : false); if ((!c_conAdd.Checked) && (!c_conUpdate.Checked) && (!c_conDel.Checked)) { d_contition.Enabled = false; DataGridStyle.GridDisplayStyle(d_contition, true, false); } else { d_contition.Enabled = true; DataGridStyle.GridDisplayStyle(d_contition, true); } } else if (r_check.Checked) { c_checkAdd.Checked = (ls_conditionfileds[0] == "1" ? true : false); c_checkUpdate.Checked = (ls_conditionfileds[1] == "1" ? true : false); c_checkDel.Checked = (ls_conditionfileds[2] == "1" ? true : false); if ((!c_checkAdd.Checked) && (!c_checkUpdate.Checked) && (!c_checkDel.Checked)) { d_check.Enabled = false; DataGridStyle.GridDisplayStyle(d_check, true, false); } else { d_check.Enabled = true; DataGridStyle.GridDisplayStyle(d_check, true); } } //初始化自定义语句 if (ls_contents[2] == "1") { r_enable.Checked = true; t_sql.Text = ls_contents[3]; } else { r_disable.Checked = true; } } } else { InitDataGrid(); tb_Mode.SelectedIndex = 1; c_checkAdd.Checked = false; c_checkDel.Checked = false; c_checkUpdate.Checked = false; } }
private void SetDataGridStyle() { DataGridStyle.GridDisplayStyle(d_check, true); DataGridStyle.GridDisplayStyle(d_contition, true); DataGridStyle.GridDisplayStyle(d_replace, true); }
public override void Destroy () { sfGrid.AutoGeneratingColumn -= GridGenerateColumns; sfGrid.Dispose (); sfGrid = null; viewModel = null; defaultStyle = null; darkStyle = null; blueStyle = null; redStyle = null; greenStyle = null; }
private void SelectUser_Load(object sender, EventArgs e) { DataGridStyle.GridDisplayStyle(dgv_tables, true); RetrieveUser(); }