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