public SquadForm(DbConnect postgreConnect, DataSet globalDS, int squadID = -1)
{
InitializeComponent();
cbColumn = new DataGridViewCheckBoxColumn();
cbColumn.HeaderText = "Является сотрудником отряда";
cbColumn.DataPropertyName = "is_in_squad";
cbColumn.FillWeight = 40;
cbColumn.ReadOnly = false;
dataSet1 = globalDS;
postgreConnection = postgreConnect;
squadSelectBS.DataSource = dataSet1.Tables["squad"];
listBox1.DataSource = dataSet1.Tables["squad"];
listBox1.DisplayMember = "name";
listBox1.ValueMember = "id";
initEnd = true;
if (listBox1.SelectedValue != null)
ChangeSelectedSquad(int.Parse(listBox1.SelectedValue.ToString()));
else
DeactivateAllButtons();
SetButtonPermissions();
if (squadID != -1)
listBox1.SelectedValue = squadID;
bindingNavigator2.BindingSource = selectionsDataBS;
bindingNavigator1.BindingSource = employeesAddBS;
dataGridView1.DataSource = selectionsDataBS;
}
public void LoadListaVariaveis(List<MaquinaInequacoesServiceReference.Variavel> variaveis)
{
dataGridView3.AutoGenerateColumns = false;
dataGridView3.DataSource = variaveis;
DataGridViewCheckBoxColumn chk = new DataGridViewCheckBoxColumn();
chk.HeaderText = "X";
chk.Name = "chkVariaveis";
dataGridView3.Columns.Add(chk);
//dataGridView3.Columns.Add(CreateComboBoxOrdem());
DataGridViewColumn column = new DataGridViewTextBoxColumn();
column.DataPropertyName = "Nome";
column.Name = "Variavel";
dataGridView3.Columns.Add(column);
/*
DataGridViewComboBoxColumn cmb = new DataGridViewComboBoxColumn();
cmb.HeaderText = "Ordem";
cmb.Name = "cmbOrdem";
cmb.MaxDropDownItems = 100;
for (int i = 0; i < 100; i++)
{
cmb.Items.Add(i);
}
dataGridView3.Columns.Add(cmb);
foreach (DataGridViewRow row in dataGridView3.Rows)
{
row.Cells[chk.Name].Value = false;
//(row.Cells[cmb.Name] as DataGridViewComboBoxCell).Value = 0;
}
*/
}
public DataGridView agregarBotones(DataGridView dataGridView, String tipo)
{
if (tipo == "SELECCIONAR")
{
DataGridViewCheckBoxColumn ColumnaSeleccionar = new DataGridViewCheckBoxColumn();
ColumnaSeleccionar.HeaderText = "SEL";
ColumnaSeleccionar.Name = "SELECCIONAR";
ColumnaSeleccionar.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
ColumnaSeleccionar.FlatStyle = FlatStyle.Standard;
ColumnaSeleccionar.DisplayIndex = dataGridView.Columns.Count;
ColumnaSeleccionar.CellTemplate.Style.BackColor = Color.Honeydew;
ColumnaSeleccionar.Width = 80;
if (dataGridView.Columns["SELECCIONAR"] == null)
{
dataGridView.Columns.Add(ColumnaSeleccionar);
}
else
{
dataGridView.Columns.Remove(dataGridView.Columns["Seleccionar"]);
dataGridView.Columns.Add(ColumnaSeleccionar);
}
}
return dataGridView;
}
private void CreateDataGridViewCell(DataGridView dataGridView, string[] rows, string[] columns, bool readOnly)
{
dataGridView.Columns.Clear();
dataGridView.Rows.Clear();
DataGridViewColumnCollection matrixColumns = dataGridView.Columns;
matrixColumns.Add("nullColumn", "");
for (int j = 0; j < columns.Length; j++)
{
DataGridViewCheckBoxColumn checkColumn = new DataGridViewCheckBoxColumn();
checkColumn.Name = "testColumn";
checkColumn.HeaderText = columns[j];
checkColumn.TrueValue = true;
checkColumn.FalseValue = false;
checkColumn.FillWeight = 10;
checkColumn.ReadOnly = readOnly;
checkColumn.AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
matrixColumns.Add(checkColumn);
}
DataGridViewRowCollection matrixRows = dataGridView.Rows;
for (int i = 0; i < rows.Length; i++)
{
matrixRows.Add(rows[i]);
}
dataGridView.Columns[0].Frozen = true;
dataGridView.Columns[0].ReadOnly = true;
dataGridView.Columns[0].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCellsExceptHeader;
}
private void frm_SelectStudent_Load(object sender, EventArgs e)
{
ob = new class_Application();
s = "select user_id,user_name from user_access";
ds = ob.fill_data_set(s);
DataGridViewCheckBoxColumn chk = new DataGridViewCheckBoxColumn();
dataGridView1.Columns.Add("user_id", "USER ID");
dataGridView1.Columns.Add("user_name", "USER NAME");
dataGridView1.Columns.Add(chk);
dataGridView1.Columns[2].HeaderText = "SELECT";
dataGridView1.Columns[2].Name = "select";
dataGridView1.RowHeadersVisible = false;
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dataGridView1.Columns[0].SortMode = DataGridViewColumnSortMode.Programmatic;
dataGridView1.Columns[1].SortMode = DataGridViewColumnSortMode.Programmatic;
dataGridView1.Columns[2].SortMode = DataGridViewColumnSortMode.Programmatic;
dataGridView1.Rows.Add(ds.Tables[0].Rows.Count);
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{ dataGridView1.Rows[i].Cells["user_id"].Value = ds.Tables[0].Rows[i]["user_id"];
dataGridView1.Rows[i].Cells["user_name"].Value = ds.Tables[0].Rows[i]["user_name"];
}
}
public static DataGridViewColumn CreateColumn( DataGridViewColumnType columnType, String columnName, String columnText)
{
DataGridViewColumn col = null;
switch (columnType)
{
case DataGridViewColumnType.MULTICOMBOBOX:
col = new DataGridViewMultiColumnComboBoxColumn();
break;
case DataGridViewColumnType.COMBOBOX:
col = new DataGridViewComboBoxColumn();
break;
case DataGridViewColumnType.TIME:
col = new DataGridViewTimeColumn();
break;
case DataGridViewColumnType.DATE:
col = new DataGridViewDateTimeColumn();
break;
case DataGridViewColumnType.CHECKBOX:
col = new DataGridViewCheckBoxColumn();
break;
case DataGridViewColumnType.NUMBER:
default:
col = new DataGridViewTextBoxColumn();
break;
}
col.DataPropertyName = columnName;
col.Name = columnName;
col.HeaderText = columnText;
return col;
}
private void BuildDataGridViewStructure()
{
dgvList.AllowUserToAddRows = false;
dgvList.MultiSelect = false;
dgvList.AllowUserToResizeRows = false;
dgvList.ReadOnly = true;
dgvList.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
dgvList.AutoGenerateColumns = false;
DataGridViewTextBoxColumn id = new DataGridViewTextBoxColumn();
id.DisplayIndex = 0;
id.Name = "Id";
id.ReadOnly = true;
id.HeaderText = "Id";
id.DataPropertyName = "Id";
DataGridViewTextBoxColumn name = new DataGridViewTextBoxColumn();
name.DisplayIndex = 1;
name.Name = "Name";
name.ReadOnly = true;
name.HeaderText = "Name";
name.DataPropertyName = "Name";
DataGridViewCheckBoxColumn enabled = new DataGridViewCheckBoxColumn();
enabled.DisplayIndex = 2;
enabled.Name = "Enabled";
enabled.ReadOnly = true;
enabled.HeaderText = "Enabled";
enabled.DataPropertyName = "Enabled";
dgvList.Columns.AddRange(id, name, enabled);
}
/*
public CheckedListBox ()
{
colString = new NSString("CheckedListBox");
}
*/
public override void SetupColumn ()
{
column = new DataGridViewCheckBoxColumn(colString);
column.DataCell.Editable = false;
tableView.AddColumn(column);
}
private void button1_Click(object sender, EventArgs e)
{
//NavigateDirs nav = new NavigateDirs();
nav.WalkDirectoryTree(di, FileTypes.FileExtensions.mp3);
MusicFiles mList = nav.MusicFileList;
BindingSource bindingSource = new BindingSource();
foreach (MusicFile f in mList)
{
bindingSource.Add(f);
}
songGrid.AutoSize = true;
songGrid.AutoResizeColumns();
//Add checkbox Column
DataGridViewColumn column = new DataGridViewCheckBoxColumn();
column.DataPropertyName = "Copy";
column.Name = "Copy Song";
songGrid.Columns.Add(column);
songGrid.Columns["songFormat"].Visible = false;
songGrid.Columns["songLocation"].Visible = false;
songGrid.DataSource = bindingSource;
}
public DtrForm()
{
InitializeComponent();
this.CenterToScreen();
this.O_processCaller= new ProcessCaller(/*this*/);
this.O_paramReader = new ParamReader();
this.O_paramReader.readKbDatabase();
this.dataGridView1.MultiSelect = true;
this.dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
this.dataGridView1.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.AllCells;
this.dataGridView1.DefaultCellStyle.WrapMode = DataGridViewTriState.True;
DataGridViewTextBoxColumn explainColumn = new DataGridViewTextBoxColumn();
explainColumn.HeaderText = "Info";
//explainColumn.ReadOnly = true;
explainColumn.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
explainColumn.FillWeight = 75;
this.dataGridView1.Columns.Add(explainColumn);
this.dataGridView1.Rows.Add("First Line" + "\n" + "AAAA");
DataGridViewCheckBoxColumn chkToFix = new DataGridViewCheckBoxColumn();
chkToFix.HeaderText = "Fix ?";
chkToFix.Name = "chk";
chkToFix.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
chkToFix.FillWeight = 5;
chkToFix.ReadOnly = false;
this.dataGridView1.Columns.Insert(0, chkToFix);
this.dataGridView1.Rows[0].Cells[0].Value = true;
}
private DataSet numMarca; //usado en funcion TModelos
#endregion Fields
#region Constructors
public BuscarPedidos()
{
InitializeComponent();
EN.ENPedidos enPedido = new EN.ENPedidos();
DataSet dsMarc = new DataSet();
dsMarc = enPedido.ObtenerListaMarcas();
numMarca = new DataSet();
numMarca = dsMarc;
DataGridViewButtonColumn buttons = new DataGridViewButtonColumn();
{
buttons.HeaderText = "Editar"; //texto de la columna
buttons.Text = "Editar"; //texto de cada boton, sale al introducir texto
buttons.UseColumnTextForButtonValue = true;
buttons.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
buttons.FlatStyle = FlatStyle.Standard;
buttons.CellTemplate.Style.BackColor = Color.Honeydew;
buttons.DisplayIndex = 0;
}
DataGridViewCheckBoxColumn boton = new DataGridViewCheckBoxColumn();
{
boton.HeaderText = "Eliminar";//texto de la columna
boton.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; //tamaño
boton.DisplayIndex = 0; //indice que ocupara en la tabla
}
TDataGridViewPedidos.Columns.Add(boton);
TDataGridViewPedidos.Columns.Add(buttons);
}
private DataGridViewCheckBoxColumn CheckboxColumn(string columnName, string headerText)
{
DataGridViewCheckBoxColumn comboColumn = new DataGridViewCheckBoxColumn();
comboColumn.Name = columnName;
comboColumn.HeaderText = headerText;
return comboColumn;
}
public void AddCols()
{
DgWorkers.AutoGenerateColumns = false;
var col1 = new DataGridViewTextBoxColumn();
var col2 = new DataGridViewTextBoxColumn();
var col3 = new DataGridViewTextBoxColumn();
var col4 = new DataGridViewCheckBoxColumn();
col1.HeaderText = "מספר עובד";
col1.DataPropertyName = "ID";
col1.Name = "WorkerNumber";
DgWorkers.Columns.Add(col1);
col2.HeaderText = "שם פרטי";
col2.DataPropertyName = "FirstName";
col2.Name = "FirstName";
DgWorkers.Columns.Add(col2);
col3.HeaderText = "שם משפחה";
col3.DataPropertyName = "LastName";
col3.Name = "LastName";
DgWorkers.Columns.Add(col3);
col4.HeaderText = "פעיל";
col4.DataPropertyName = "Active";
col4.Name = "Active";
DgWorkers.Columns.Add(col4);
}
public ItemsGridView()
{
//
//
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle1 = new System.Windows.Forms.DataGridViewCellStyle();
this.AutoGenerateColumns = false;
Items_id = new DataGridViewTextBoxColumn();
Items_name = new System.Windows.Forms.DataGridViewTextBoxColumn();
Items_receipt_id = new System.Windows.Forms.DataGridViewTextBoxColumn();
Items_price = new System.Windows.Forms.DataGridViewTextBoxColumn();
Items_isReturn = new System.Windows.Forms.DataGridViewCheckBoxColumn();
Items_tag_printed = new System.Windows.Forms.DataGridViewCheckBoxColumn();
Items_receipt_date = new System.Windows.Forms.DataGridViewTextBoxColumn();
Items_volume = new System.Windows.Forms.DataGridViewTextBoxColumn();
Items_boxid = new System.Windows.Forms.DataGridViewTextBoxColumn();
Items_comment = new System.Windows.Forms.DataGridViewTextBoxColumn();
Items_sell_price = new System.Windows.Forms.DataGridViewTextBoxColumn();
Items_sell_date = new System.Windows.Forms.DataGridViewTextBoxColumn();
dataGridViewCellStyle1.Font = new System.Drawing.Font("Meiryo UI", 9.75F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(128)));
this.CellBeginEdit += new DataGridViewCellCancelEventHandler(ItemsGridView_CellBeginEdit);
this.CellEndEdit += new DataGridViewCellEventHandler(ItemsGridView_CellEndEdit);
this.RowLeave += new DataGridViewCellEventHandler(ItemsGridView_RowLeave);
this.RowEnter += new DataGridViewCellEventHandler(ItemsGridView_RowEnter);
this.Leave += new EventHandler(ItemsGridView_Leave);
this.UserDeletingRow += new DataGridViewRowCancelEventHandler(ItemsGridView_UserDeletingRow);
this.UserDeletedRow += new DataGridViewRowEventHandler(ItemsGridView_UserDeletedRow);
}
internal NewSportsFestivalGUI(NewSportsFestivalController controller)
{
InitializeComponent();
this.StyleManager = metroStyleManager;
DataGridViewCheckBoxColumn checkboxColumn = new DataGridViewCheckBoxColumn();
checkboxColumn.HeaderText = "";
checkboxColumn.Name = competitionGridColumn0Name;
checkboxColumn.Width = 50;
DataGridViewTextBoxColumn competitionIdColumn = new DataGridViewTextBoxColumn();
competitionIdColumn.HeaderText = "Wettkampf-ID";
competitionIdColumn.Name = competitionGridColumn1Name;
competitionIdColumn.Visible = false;
DataGridViewTextBoxColumn competitionNameColumn = new DataGridViewTextBoxColumn();
competitionNameColumn.HeaderText = "Wettkampf";
competitionNameColumn.Name = competitionGridColumn2Name;
competitionNameColumn.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
competitionNameColumn.ReadOnly = true;
competitionGrid.Columns.Add(checkboxColumn);
competitionGrid.Columns.Add(competitionIdColumn);
competitionGrid.Columns.Add(competitionNameColumn);
}
private DataSet numProvincia; // usado en funcion TComboBoxCiudades_Click
#endregion Fields
#region Constructors
public GestionPersonalBuscar()
{
InitializeComponent();
DataGridViewButtonColumn buttons = new DataGridViewButtonColumn();
{
buttons.HeaderText = "Editar"; //texto de la columna
buttons.Text = "Editar"; //texto de cada boton, sale al introducir texto
buttons.UseColumnTextForButtonValue = true;
buttons.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
buttons.FlatStyle = FlatStyle.Standard;
buttons.CellTemplate.Style.BackColor = Color.Honeydew;
buttons.DisplayIndex = 0;
}
DataGridViewCheckBoxColumn boton = new DataGridViewCheckBoxColumn();
{
boton.HeaderText = "Eliminar";//texto de la columna
boton.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; //tamaño
boton.DisplayIndex = 0; //indice que ocupara en la tabla
}
TDataGridViewPersonal.Columns.Add(boton);
TDataGridViewPersonal.Columns.Add(buttons);
}
public void CargarTabla()
{
// Format DataGridView
this.dataGridView1.AllowUserToAddRows = false;
this.dataGridView1.BackgroundColor = this.BackColor;
this.dataGridView1.RowHeadersWidth = 75;
String [] Semana = {"Lunes",
"Martes",
"Miercoles",
"Jueves",
"Viernes",
"Sabado"
};
// Add columns to DataGridView
foreach (String item in Semana)
{
DataGridViewCheckBoxColumn checkColumn = new DataGridViewCheckBoxColumn();
checkColumn.Name = "Columna_" + item;
checkColumn.HeaderText = item;
checkColumn.Width = 75;
checkColumn.ReadOnly = true;
checkColumn.FillWeight = 10; //if the datagridview is resized (on form resize) the checkbox won't take up too much; value is relative to the other columns' fill values
dataGridView1.Columns.Add(checkColumn);
}
// Add rows to DataGridView
for (int i = 7; i <= 32; i++)
{
TimeSpan t = TimeSpan.FromSeconds(25200 + ((i - 7)* 1800));
dataGridView1.Rows.Add();
dataGridView1.Rows[i - 7].HeaderCell.Value = t.ToString().Substring(0, 5) ;
}
// Sabados no se trabaja hasta las 10
for (int i = 0; i < 6; i++)
{
DataGridViewTextBoxCell TextBoxCell = new DataGridViewTextBoxCell();
dataGridView1[5, i] = TextBoxCell;
dataGridView1[5, i].Value = "";
dataGridView1[5, i].Style.BackColor = Color.Black;
dataGridView1[5, i].ReadOnly = true;
}
// Sabados no se trabaja desde las 5
for (int i = 16; i <= 25; i++)
{
DataGridViewTextBoxCell TextBoxCell = new DataGridViewTextBoxCell();
dataGridView1[5, i] = TextBoxCell;
dataGridView1[5, i].Value = "";
dataGridView1[5, i].Style.BackColor = Color.Black;
dataGridView1[5, i].ReadOnly = true;
}
}
private void CreateCell(string[] rows, string[] columns)
{
DataGridViewColumnCollection matrixColumns = matrixDataGridView.Columns;
matrixColumns.Add("nullColumn", "Traceability Matrix");
for (int j = 0; j < columns.Length; j++)
{
DataGridViewCheckBoxColumn checkColumn = new DataGridViewCheckBoxColumn();
checkColumn.Name = "testColumn";
checkColumn.HeaderText = columns[j];
checkColumn.TrueValue = true;
checkColumn.FalseValue = false;
checkColumn.FillWeight = 10;
matrixColumns.Add(checkColumn);
}
DataGridViewRowCollection matrixRows = matrixDataGridView.Rows;
for (int i = 0; i < rows.Length; i++)
{
matrixRows.Add(rows[i]);
}
matrixDataGridView.Columns[0].Frozen = true;
matrixDataGridView.Columns[0].ReadOnly = true;
bool flag = false;
for (int i = 0; i < rows.Length; i++)
{
for (int j = 0; j < columns.Length; j++)
{
DataGridViewCheckBoxCell chk = (DataGridViewCheckBoxCell)matrixDataGridView.Rows[i].Cells[1 + j];
chk.Selected = flag;
flag = !flag;
}
}
}
private bool TryWriteFileIntoTable(StreamReader reader)
{
document = OrderFileParser.ParseOrderFile(reader, out prologue, out epilogue);
if (document.Count == 0)
return false;
tableOrder.Clear();
foreach (PaymentRecord record in document)
{
tableOrder.Rows.Add(record.documentDate.ToString("dd.MM.yyyy"), record.documentNumber,
record.correspondentCode, record.correspondentAccount, record.ratingCredit);
}
gridOrder.DataSource = null;
gridOrder.Columns.Clear();
gridOrder.DataSource = tableOrder;
gridOrder.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
DataGridViewCheckBoxColumn column;
foreach (DataGridViewColumn c in gridOrder.Columns)
c.ReadOnly = true;
foreach (String filial in OrderFileGenerator.filialNames)
{
column = new DataGridViewCheckBoxColumn();
column.HeaderText = filial;
column.Name = filial;
column.HeaderCell.Style.ForeColor = Color.SlateBlue;
column.HeaderCell.Style.Font = new Font(gridOrder.Font, FontStyle.Bold);
gridOrder.Columns.Add(column);
}
return true;
}
//onload fill datagrid
private void adviserForm_Load(object sender, EventArgs e)
{
DataGridViewColumn column = new DataGridViewTextBoxColumn();
// Initialize and add a check box column.
column = new DataGridViewImageColumn();
// column.Image
column.DataPropertyName = "pictureArrByte";
column.Width = 80;
column.Name = "picture";
column.ReadOnly = false;
dataGridView.Columns.Add(column);
column = new DataGridViewTextBoxColumn();
column.DataPropertyName = "playerId";
column.Name = "Id";
dataGridView.Columns.Add(column);
column = new DataGridViewTextBoxColumn();
column.DataPropertyName = "firstName";
column.Name = "First Name";
dataGridView.Columns.Add(column);
column = new DataGridViewTextBoxColumn();
column.DataPropertyName = "lastName";
column.Name = "Last Name";
dataGridView.Columns.Add(column);
// Initialize and add a check box column.
DataGridViewCheckBoxColumn columnCheckBox = new DataGridViewCheckBoxColumn();
columnCheckBox.DataPropertyName = "Action";
columnCheckBox.Name = "Action";
columnCheckBox.ReadOnly = false;
dataGridView.Columns.Add(columnCheckBox);
//Fill data to form
Players[] list = server.getAdvisors(playerId);
dataGridView.AutoGenerateColumns = false;
dataGridView.AutoSize = false;
foreach (Players player in list)
{
if (player.pictureArrByte != null)
{
Rectangle compressionRectangle = new Rectangle(60, 60,
player.pictureArrByte.Width / 2, player.pictureArrByte.Height / 2);
using (Graphics g = Graphics.FromImage(player.pictureArrByte))
g.DrawImage(player.pictureArrByte, compressionRectangle);
}
}
dataGridView.DataSource = list;
//set the heigt for picture colum
foreach (DataGridViewRow row in dataGridView.Rows)
{
row.Height = 75;
}
}
public FrmInscripcion()
{
InitializeComponent();
ConfigureForm();
dataGridView1.AutoGenerateColumns = false;
dataGridView1.AutoSize = true;
dataGridView1.DataSource = bindingSource1;
DataGridViewColumn column = new DataGridViewTextBoxColumn();
column.DataPropertyName = "NOMBRE";
column.Name = "NOMBRE";
dataGridView1.Columns.Add(column);
column = new DataGridViewCheckBoxColumn();
column.DataPropertyName = "CARRERA";
column.Name = "CARRERA";
dataGridView1.Columns.Add(column);
column = new DataGridViewCheckBoxColumn();
column.DataPropertyName = "NIVEL";
column.Name = "NIVEL";
dataGridView1.Columns.Add(column);
DataGridViewButtonColumn column2 = new DataGridViewButtonColumn();
column2.DataPropertyName = "INSCRIBIR";
column2.Name = "INSCRIBIR";
column2.HeaderText = "INSCRIBIR";
column2.ToolTipText = "INSCRIBIR";
dataGridView1.Columns.Add(column2);
}
private void SetupDataGridViewColumns()
{
using (var col = new DataGridViewTextBoxColumn())
{
col.DataPropertyName = "Name";
col.HeaderText = "Name";
dgvNameEntries.Columns.Add(col);
col.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
}
using (var col = new DataGridViewComboBoxColumn())
{
col.DataPropertyName = "NamePosition";
col.HeaderText = "Name Position";
col.DataSource = Enum.GetValues(typeof(NamePosition));
col.AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
dgvNameEntries.Columns.Add(col);
}
using (var col = new DataGridViewCheckBoxColumn())
{
col.DataPropertyName = "IsFemale";
col.HeaderText = "Is Female";
col.FalseValue = false;
col.TrueValue = true;
col.AutoSizeMode = DataGridViewAutoSizeColumnMode.ColumnHeader;
dgvNameEntries.Columns.Add(col);
}
}
//--selected index change exant for the test name combobox-->
private void comboBox2_SelectedIndexChanged(object sender, EventArgs e)
{
DataRowView dr=(DataRowView)comboBox2.SelectedItem;
test_code=Convert.ToString(dr["test_code"]);
dataGridView1.Columns.Clear();
DataGridViewCheckBoxColumn ob1 = new DataGridViewCheckBoxColumn();
dataGridView1.Columns.Add("sub_code", "SUBJECT CODE");
dataGridView1.Columns.Add("sub_name", "SUBJECT NAME");
dataGridView1.Columns.Add(ob1);
dataGridView1.Columns[2].HeaderText = "QUESTION PRESENT";
dataGridView1.Columns[2].Name = "is_present";
dataGridView1.RowHeadersVisible = false;
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dataGridView1.Columns[0].SortMode = DataGridViewColumnSortMode.Programmatic;
dataGridView1.Columns[1].SortMode = DataGridViewColumnSortMode.Programmatic;
dataGridView1.Columns[2].ReadOnly = true;
s = "select sub_code,sub_name from subject_master where exam_code='" + exam_code + "'";
DataSet ds = ob.fill_data_set(s);
dataGridView1.Rows.Add(ds.Tables[0].Rows.Count);
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{ dataGridView1.Rows[i].Cells["sub_code"].Value = ds.Tables[0].Rows[i]["sub_code"];
dataGridView1.Rows[i].Cells["sub_name"].Value = ds.Tables[0].Rows[i]["sub_name"];
s = null;
s = "select iif ( count(*),1,0) from questions_master where exam_code='" + exam_code + "' and test_code='" + test_code + "' and sub_code='" + Convert.ToString(ds.Tables[0].Rows[i]["sub_code"]) + "';";
dataGridView1.Rows[i].Cells["is_present"].Value = Convert.ToInt32(ob.execute_scalar(s));
}
}
private void init()
{
this.dgv = new DataGridView();
this.dgv.Dock = DockStyle.Fill;
this.dgv.BorderStyle = BorderStyle.None;
this.dgv.BackgroundColor = SystemColors.Window;
this.dgv.Font = PluginBase.Settings.DefaultFont;
this.dgv.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.AutoSize;
this.dgv.ColumnHeadersBorderStyle = DataGridViewHeaderBorderStyle.None;
this.dgv.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
this.dgv.CellBorderStyle = DataGridViewCellBorderStyle.Single;
this.dgv.EnableHeadersVisualStyles = true;
this.dgv.RowHeadersVisible = false;
DataGridViewCellStyle viewStyle = new DataGridViewCellStyle();
viewStyle.Padding = new Padding(1);
this.dgv.ColumnHeadersDefaultCellStyle = viewStyle;
this.ColumnBreakPointEnable = new DataGridViewCheckBoxColumn();
this.ColumnBreakPointFilePath = new DataGridViewTextBoxColumn();
this.ColumnBreakPointFileName = new DataGridViewTextBoxColumn();
this.ColumnBreakPointLine = new DataGridViewTextBoxColumn();
this.ColumnBreakPointExp = new DataGridViewTextBoxColumn();
this.ColumnBreakPointEnable.HeaderText = TextHelper.GetString("Label.Enable");
this.ColumnBreakPointEnable.Name = "Enable";
this.ColumnBreakPointEnable.AutoSizeMode = DataGridViewAutoSizeColumnMode.None;
this.ColumnBreakPointEnable.Width = 70;
this.ColumnBreakPointFilePath.HeaderText = TextHelper.GetString("Label.Path");
this.ColumnBreakPointFilePath.Name = "FilePath";
this.ColumnBreakPointFilePath.ReadOnly = true;
this.ColumnBreakPointFileName.HeaderText = TextHelper.GetString("Label.File");
this.ColumnBreakPointFileName.Name = "FileName";
this.ColumnBreakPointFileName.ReadOnly = true;
this.ColumnBreakPointLine.HeaderText = TextHelper.GetString("Label.Line");
this.ColumnBreakPointLine.Name = "Line";
this.ColumnBreakPointLine.ReadOnly = true;
this.ColumnBreakPointExp.HeaderText = TextHelper.GetString("Label.Exp");
this.ColumnBreakPointExp.Name = "Exp";
this.dgv.AllowUserToAddRows = false;
this.dgv.Columns.AddRange(new System.Windows.Forms.DataGridViewColumn[] {
this.ColumnBreakPointEnable,
this.ColumnBreakPointFilePath,
this.ColumnBreakPointFileName,
this.ColumnBreakPointLine,
this.ColumnBreakPointExp});
defaultColor = dgv.Rows[dgv.Rows.Add()].DefaultCellStyle.BackColor;
dgv.Rows.Clear();
this.dgv.CellEndEdit += new DataGridViewCellEventHandler(dgv_CellEndEdit);
this.dgv.CellMouseUp += new DataGridViewCellMouseEventHandler(dgv_CellMouseUp);
this.dgv.CellDoubleClick += new DataGridViewCellEventHandler(dgv_CellDoubleClick);
}
private void initDataGrid() {
DataGridViewCheckBoxColumn enableColumn = new DataGridViewCheckBoxColumn();
enableColumn.Name = "Enable";
enableColumn.HeaderText = Resources.Enable;
enableColumn.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
enableColumn.MinimumWidth = 50;
DataGridViewTextBoxColumn behaviorFileColumn = new DataGridViewTextBoxColumn();
behaviorFileColumn.Name = "BehaviorFilename";
behaviorFileColumn.HeaderText = Resources.BehaviorFilename;
behaviorFileColumn.ReadOnly = true;
behaviorFileColumn.MinimumWidth = 180;
DataGridViewTextBoxColumn nodeTypeColumn = new DataGridViewTextBoxColumn();
nodeTypeColumn.Name = "NodeType";
nodeTypeColumn.HeaderText = Resources.NodeType;
nodeTypeColumn.ReadOnly = true;
nodeTypeColumn.MinimumWidth = 120;
DataGridViewTextBoxColumn nodeIdColumn = new DataGridViewTextBoxColumn();
nodeIdColumn.Name = "NodeId";
nodeIdColumn.HeaderText = Resources.NodeId;
nodeIdColumn.ReadOnly = true;
nodeIdColumn.MinimumWidth = 100;
DataGridViewTextBoxColumn actionNameColumn = new DataGridViewTextBoxColumn();
actionNameColumn.Name = "ActionName";
actionNameColumn.HeaderText = Resources.ActionName;
actionNameColumn.ReadOnly = true;
actionNameColumn.MinimumWidth = 100;
DataGridViewComboBoxColumn actionResultColumn = new DataGridViewComboBoxColumn();
actionResultColumn.Name = "ActionResult";
actionResultColumn.HeaderText = Resources.ActionResult;
actionResultColumn.MinimumWidth = 100;
actionResultColumn.Items.Add(DebugDataPool.Action.kResultAll);
actionResultColumn.Items.Add(DebugDataPool.Action.kResultSuccess);
actionResultColumn.Items.Add(DebugDataPool.Action.kResultFailure);
DataGridViewTextBoxColumn hitCountColumn = new DataGridViewTextBoxColumn();
hitCountColumn.Name = "HitCount";
hitCountColumn.HeaderText = Resources.HitCount;
hitCountColumn.MinimumWidth = 100;
DataGridViewTextBoxColumn dummyColumn = new DataGridViewTextBoxColumn();
dummyColumn.Name = "Dummy";
dummyColumn.HeaderText = "";
dummyColumn.ReadOnly = true;
dummyColumn.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dataGridView.Columns.Add(enableColumn);
dataGridView.Columns.Add(behaviorFileColumn);
dataGridView.Columns.Add(nodeTypeColumn);
dataGridView.Columns.Add(nodeIdColumn);
dataGridView.Columns.Add(actionNameColumn);
dataGridView.Columns.Add(actionResultColumn);
dataGridView.Columns.Add(hitCountColumn);
dataGridView.Columns.Add(dummyColumn);
}
public void crearGrilla()
{
dgAmbulatorios.Columns.Clear();
dgAmbulatorios.AutoGenerateColumns = false;
dgAmbulatorios.RowHeadersVisible = false;
DataGridViewCheckBoxColumn clm_checkbox = new DataGridViewCheckBoxColumn();
clm_checkbox.Width = 50;
clm_checkbox.ReadOnly = false;
clm_checkbox.DataPropertyName = "Existe";
clm_checkbox.HeaderText = "";
dgAmbulatorios.Columns.Add(clm_checkbox);
DataGridViewTextBoxColumn clm_Medico = new DataGridViewTextBoxColumn();
clm_Medico.Width = 260;
clm_Medico.ReadOnly = true;
clm_Medico.DataPropertyName = "Planilla_medico_secundario_nombre";
clm_Medico.HeaderText = "Profesional";
dgAmbulatorios.Columns.Add(clm_Medico);
DataGridViewTextBoxColumn clm_Beneficio = new DataGridViewTextBoxColumn();
clm_Beneficio.Width = 160;
clm_Beneficio.ReadOnly = true;
clm_Beneficio.DataPropertyName = "Planilla_beneficio";
clm_Beneficio.HeaderText = "Beneficio";
dgAmbulatorios.Columns.Add(clm_Beneficio);
DataGridViewTextBoxColumn clm_Practica = new DataGridViewTextBoxColumn();
clm_Practica.Width = 120;
clm_Practica.ReadOnly = true;
clm_Practica.DataPropertyName = "Planilla_practica";
clm_Practica.HeaderText = "Práctica";
dgAmbulatorios.Columns.Add(clm_Practica);
DataGridViewTextBoxColumn clm_Fecha = new DataGridViewTextBoxColumn();
clm_Fecha.Width = 100;
clm_Fecha.ReadOnly = true;
clm_Fecha.DataPropertyName = "Planilla_fecha";
clm_Fecha.HeaderText = "Fecha";
dgAmbulatorios.Columns.Add(clm_Fecha);
DataGridViewTextBoxColumn clm_Hora = new DataGridViewTextBoxColumn();
clm_Hora.Width = 80;
clm_Hora.ReadOnly = true;
clm_Hora.DataPropertyName = "Planilla_hora";
clm_Hora.HeaderText = "Hora";
dgAmbulatorios.Columns.Add(clm_Hora);
dgAmbulatorios.DataSource = unaPlanilla.tablaPlanilla;
dgAmbulatorios.AllowUserToAddRows = false;
DataGridViewCellStyle miestilo = new DataGridViewCellStyle();
miestilo.Font = new Font("Franklin Gothic Book", 11);
dgAmbulatorios.EnableHeadersVisualStyles = false;
dgAmbulatorios.ColumnHeadersDefaultCellStyle = miestilo;
dgAmbulatorios.ColumnHeadersDefaultCellStyle.ForeColor = Color.DarkCyan;
dgAmbulatorios.ColumnHeadersDefaultCellStyle.BackColor = Color.Gainsboro;
}
public TagQuantForm()
{
InitializeComponent();
this.Text = "Tag Quant v" + Assembly.GetExecutingAssembly().GetName().Version.ToString();
dataGridView2.AutoGenerateColumns = false;
dataGridView2.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
DataGridViewCheckBoxColumn useColumn = new DataGridViewCheckBoxColumn();
useColumn.DataPropertyName = "IsUsed";
useColumn.HeaderText = "Use";
useColumn.Frozen = true;
useColumn.ContextMenuStrip = new ContextMenuStrip();
useColumn.ContextMenuStrip.Items.Add("Select All").Click += CheckBoxColumnSelectAll;
useColumn.ContextMenuStrip.Items.Add("Deselect All").Click += CheckBoxColumnDeselectAll;
dataGridView2.Columns.Add(useColumn);
DataGridViewTextBoxColumn nameColumn = new DataGridViewTextBoxColumn();
nameColumn.DataPropertyName = "TagName";
nameColumn.HeaderText = "Tag";
nameColumn.Frozen = true;
nameColumn.ReadOnly = true;
dataGridView2.Columns.Add(nameColumn);
DataGridViewTextBoxColumn sampleColumn = new DataGridViewTextBoxColumn();
sampleColumn.DataPropertyName = "SampleName";
sampleColumn.HeaderText = "Sample Name";
dataGridView2.Columns.Add(sampleColumn);
DataGridViewTextBoxColumn mzColumn = new DataGridViewTextBoxColumn();
mzColumn.DataPropertyName = "MassCAD";
mzColumn.HeaderText = "m/z (CAD)";
dataGridView2.Columns.Add(mzColumn);
DataGridViewTextBoxColumn m2Column = new DataGridViewTextBoxColumn();
m2Column.DataPropertyName = "M2";
m2Column.HeaderText = "-2";
dataGridView2.Columns.Add(m2Column);
DataGridViewTextBoxColumn m1Column = new DataGridViewTextBoxColumn();
m1Column.DataPropertyName = "M1";
m1Column.HeaderText = "-1";
dataGridView2.Columns.Add(m1Column);
DataGridViewTextBoxColumn p1Column = new DataGridViewTextBoxColumn();
p1Column.DataPropertyName = "P1";
p1Column.HeaderText = "+1";
dataGridView2.Columns.Add(p1Column);
DataGridViewTextBoxColumn p2Column = new DataGridViewTextBoxColumn();
p2Column.DataPropertyName = "P2";
p2Column.HeaderText = "+2";
dataGridView2.Columns.Add(p2Column);
radioButton2.Checked = true;
//allTags = new BindingList<TagInformation>(tmtTags);
dataGridView2.DataSource = allTags;
}
public ArrayList UpdateSearchResult(StructuredQueue oQueues)
{
ArrayList arrayTemp = new ArrayList();
DataGridViewCheckBoxColumn column = new DataGridViewCheckBoxColumn();
{
column.AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
column.FlatStyle = FlatStyle.Standard; column.ThreeState = true;
column.CellTemplate = new DataGridViewCheckBoxCell();
column.CellTemplate.Style.BackColor = Color.Beige;
}
try
{
Object[] cellValues = null;
foreach (QueueInfos Messages in oQueues.Message)
{
Application.DoEvents();
bool InfoFlag = false;
if ((chkqueuname.Checked) && (Regex.IsMatch(oQueues.sQueueName, txtSearch.Text.ToString(),RegexOptions.IgnoreCase)))
InfoFlag = true;
if ((chkLabel.Checked) && (Regex.IsMatch(Messages.Label, txtSearch.Text.ToString(), RegexOptions.IgnoreCase)))
InfoFlag = true;
if ((chkBody.Checked) && (Regex.IsMatch(Messages.Body, txtSearch.Text.ToString(), RegexOptions.IgnoreCase)))
InfoFlag = true;
if (Messages.Transact == 2)
Messages.Transaction = "True";
else if (Messages.Transact == 3)
Messages.Transaction = "False";
else if (Messages.Transact == 1)
Messages.Transaction = "Remote";
Messages.Path = oQueues.sPath;
Messages.QueueName = oQueues.sQueueName;
if (InfoFlag)
{
cellValues = new Object[]
{false,
(Convert.ToInt32(dgSearchresult.Rows.Count) +1) ,
Messages.Path,
Messages.QueueName,
Messages.Label,
Messages.Body,
Messages.Priority,
Messages.ID,
Messages.Transaction,
Messages.SentTime
};
dgSearchresult.Rows.Add(cellValues);
arrayTemp.Add(Messages);
}
}
}
catch { }
return arrayTemp;
}
public static DataGridViewCheckBoxColumn ReturnDataGridCBColumn(string name)
{
DataGridViewCheckBoxColumn column = new DataGridViewCheckBoxColumn();
column.Name = name;
column.HeaderText = name;
column.DataPropertyName = name;
return column;
}
public JpegViewer(string[] _jpgFiles, string jpgFile = "")
{
InitializeComponent();
this.WindowState = FormWindowState.Maximized;//Maximize form
#region initialize dgv
//Add ImageColumn
DataGridViewImageColumn imgColumn = new DataGridViewImageColumn();
imgColumn.Name = "Image";
imgColumn.ImageLayout = DataGridViewImageCellLayout.Zoom;//イメージを縦横の比率を維持して拡大、縮小表示する
imgColumn.Description = "イメージ"; //イメージの説明。セルをクリップボードにコピーした時に使用される
dgv.Columns.Add(imgColumn);//DataGridViewに追加する
dgv.Columns["Image"].Width = 120;
dgv.RowTemplate.Height = 90;
//Add CheckBoxColumn
DataGridViewCheckBoxColumn cbColumn = new DataGridViewCheckBoxColumn();
cbColumn.Name = "cbColumn";
dgv.Columns.Add(cbColumn);
cbColumn.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
//Add TextBoxColumn
DataGridViewTextBoxColumn tbColumn = new DataGridViewTextBoxColumn();
tbColumn.Name = "tbColumn";
tbColumn.ReadOnly = true;
dgv.Columns.Add(tbColumn);
tbColumn.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dgv.RowHeadersVisible = false;//Make selector invisible
dgv.ColumnHeadersVisible = false;//Make column header invisible
dgv.AllowUserToAddRows = false;
dgv.AllowUserToResizeColumns = false;
dgv.AllowUserToResizeRows = false;
#endregion
#region dgv image procedure
jpgFiles.AddRange(_jpgFiles);
jpgFiles.Sort();
for (int i = 0; i < jpgFiles.Count; i++)
{
try
{
dgv.Rows.Add();
dgv["Image", i].Value = new Bitmap(jpgFiles[i].ToString());
}
catch (ArgumentOutOfRangeException)
{ MessageBox.Show("[ArgumentOutOfRangeException]" + Properties.Resources.HasOccurred, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); }
}
#endregion
#region pictureBox
pbMain.SizeMode = PictureBoxSizeMode.Zoom;
selectedJpgFile = jpgFile;
#endregion
}
//---function for filling up the datagridview-->
public void fill_grid()
{
row = 0;
textBox2.Text = null;
checkBox1.Checked = false;
checkBox2.Checked = false;
class_Application.flag = 1;
ds = new DataSet();
dataGridView1.Columns.Clear();
dataGridView1.Rows.Clear();
dataGridView1.Columns.Add("Examcode", "Exam Code");
dataGridView1.Columns.Add("ExamName", "Exam Name");
DataGridViewCheckBoxColumn chk = new DataGridViewCheckBoxColumn();
dataGridView1.Columns.Add(chk);
dataGridView1.Columns[2].Name = "Skip";
dataGridView1.Columns[2].HeaderText = "SKIP";
DataGridViewCheckBoxColumn chk2 = new DataGridViewCheckBoxColumn();
dataGridView1.Columns.Add(chk2);
dataGridView1.Columns[3].Name = "Negetive";
dataGridView1.Columns[3].HeaderText = "NEGETIVE";
s = null;
s = "select exam_code,exam_name,can_skip,negetive_marking from exam_master;";
//--loadingthe datagrid view with the dataset--->
ds = ob.fill_data_set(s);
int i = 0;
if (ds.Tables[0].Rows.Count > 0)
{
dataGridView1.Rows.Add(ds.Tables[0].Rows.Count);
foreach (DataRow dr in ds.Tables[0].Rows)
{
dataGridView1.Rows[i].Cells["ExamCode"].Value = dr["exam_code"];
dataGridView1.Rows[i].Cells["ExamName"].Value = dr["exam_name"];
dataGridView1.Rows[i].Cells["Skip"].Value = Convert.ToInt32(dr["can_skip"]);
dataGridView1.Rows[i].Cells["Negetive"].Value = Convert.ToInt32(dr["negetive_marking"]);
i++;
}
}
//---assigning the default cell fill type property for the datagridveiw1--->
dataGridView1.RowHeadersVisible = false;
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dataGridView1.Columns[0].SortMode = DataGridViewColumnSortMode.Programmatic;
dataGridView1.Columns[1].SortMode = DataGridViewColumnSortMode.Programmatic;
dataGridView1.Columns[2].SortMode = DataGridViewColumnSortMode.Programmatic;
dataGridView1.Columns[3].SortMode = DataGridViewColumnSortMode.Programmatic;
dataGridView1.Columns[0].ReadOnly = true;
dataGridView1.Columns[1].ReadOnly = true;
dataGridView1.Columns[2].ReadOnly = true;
dataGridView1.Columns[3].ReadOnly = true;
}
public void CheckBoxTest()
{
SWF.DataGridViewCheckBoxColumn column = new SWF.DataGridViewCheckBoxColumn();
column.HeaderText = "CheckBox Column";
SWF.DataGridViewCheckBoxCell cell = new SWF.DataGridViewCheckBoxCell();
cell.Value = false;
SWF.DataGridViewCheckBoxCell cell1 = new SWF.DataGridViewCheckBoxCell();
cell1.Value = false;
ColumnCellTest(column, cell, false, cell1);
}
private void buttonX1_Click(object sender, EventArgs e)
{
buttonX2.Enabled = false;
if (string.IsNullOrEmpty(textBoxX1.Text))
{
MessageBox.Show("关键词不能为空");
return;
}
this.dataGridViewX1.Columns.Clear();
var db1 = new Model1();
cnkis = db1.Cnkis.Where(o => o.Category == comboBoxEx1.Text && o.KeyWord.Contains(textBoxX1.Text)).ToList();
if (cnkis == null || cnkis.Count == 0)
{
MessageBox.Show("没找到记录");
dataGridViewX1.DataSource = new DataTable();
return;
}
System.Windows.Forms.DataGridViewCheckBoxColumn Column1;
Column1 = new System.Windows.Forms.DataGridViewCheckBoxColumn();
Column1.HeaderText = "选择";
Column1.Name = "Select";
this.dataGridViewX1.Columns.Add(Column1);
var searchedDataTable = standardTable.Clone();
foreach (var dataitem in cnkis.Select(o => new
{
o.Title,
o.Author,
o.JournalName,
o.PublishDate,
o.DownloadedCount
}).ToList())
{
var newrow = searchedDataTable.NewRow();
newrow["篇名"] = dataitem.Title;
newrow["作者"] = dataitem.Author;
newrow["刊名"] = dataitem.JournalName;
newrow["年期"] = dataitem.PublishDate;
newrow["下载数"] = dataitem.DownloadedCount;
searchedDataTable.Rows.Add(newrow);
}
dataGridViewX1.DataSource = searchedDataTable;
buttonX2.Enabled = searchedDataTable.Rows.Count > 0;
}
private void loadPage()
{
CrossThreadUtility.InvokeControlAction <DataGridView>(dg, dataGrid =>
{
var m_pagedCandidates = m_filteredPositions.Skip(m_CurrentPage * Properties.Settings.Default.PageSize)
.Take(Properties.Settings.Default.PageSize);
m_mainGridBindingSource = new BindingSource();
m_mainGridBindingSource.DataSource = new List <Position>(m_pagedCandidates);
dataGrid.Columns.Clear();
dataGrid.DataSource = m_mainGridBindingSource;
if (m_filteredPositions.Count() > 0 && dataGrid.Columns.Count > 0)
{
dataGrid.Columns[0].Visible = false;
dataGrid.Columns[10].Visible = false;
dataGrid.Columns[11].Visible = false;
}
if (m_openMode == FormOpenMode.SearchAndSelect)
{
dataGrid.ReadOnly = false;
for (int i = 0; i < dataGrid.ColumnCount; i++)
{
dataGrid.Columns[i].ReadOnly = true;
}
var col = new System.Windows.Forms.DataGridViewCheckBoxColumn();
col.Width = 30;
col.Frozen = true;
col.DividerWidth = 3;
col.MinimumWidth = 30;
col.ReadOnly = false;
dataGrid.Columns.Insert(0, col);
}
else
{
dataGrid.ReadOnly = true;
}
});
// Show Status
CrossThreadUtility.InvokeControlAction <Label>(lblStatus, label => label.Text = (m_CurrentPage + (m_TotalRecords > 0 ? 1 : 0)).ToString() + " / " + m_TotalPages.ToString());
CrossThreadUtility.InvokeControlAction <Panel>(panelWait, panel => panel.Visible = false);
}
} //LoadMissingDivs()
private void dateTimePicker1_ValueChanged(object sender, EventArgs e)
{
// Local Variables
String mySql;
String myDate;
//dg_Dividends.Rows.Clear();
dg_Dividends.Update();
myDate = dateTimePicker1.Value.ToString("dd-MMM-yyyy");
mySql = "Select BBG_Ticker, Div_Adjusted as [DPS $], Div_Crncy as Currency, Franking, ExDate as [Ex Date], PayableDate as [Payable Date], ID_BB_UNIQUE, 'N' as Changed, ExDate as [Orig_ExDate], CapitalReturn, WithholdingTaxRate as [Withholding Tax Rate]"+
"From Dividends "+
"Where ExDate >= '" + myDate + "' " +
"Order by ExDate, BBG_Ticker ";
dt_Dividends = SystemLibrary.SQLSelectToDataTable(mySql);
dg_Dividends.DataSource = dt_Dividends;
ParentForm1.SetFormatColumn(dg_Dividends, @"DPS $", Color.Empty, Color.LightCyan, "N8", "0");
ParentForm1.SetFormatColumn(dg_Dividends, "Franking", Color.Empty, Color.Empty, "0.0%", "0");
ParentForm1.SetFormatColumn(dg_Dividends, "Withholding Tax Rate", Color.Empty, Color.Empty, "0.000%", "0.000%");
dg_Dividends.Columns["BBG_Ticker"].HeaderText = "Ticker";
dg_Dividends.Columns["Ex Date"].DefaultCellStyle.Format = "dd-MMM-yy"; // M = dd-Mon, D = Short Date/Time, F = Long Date/Time
dg_Dividends.Columns["Ex Date"].DefaultCellStyle.ForeColor = Color.Blue;
dg_Dividends.Columns["Payable Date"].DefaultCellStyle.Format = "dd-MMM-yy"; // M = dd-Mon, D = Short Date/Time, F = Long Date/Time
dg_Dividends.Columns["CapitalReturn"].Visible = false;
if (!dg_Dividends.Columns.Contains("IsCapitalReturn"))
{
System.Windows.Forms.DataGridViewCheckBoxColumn IsCapitalReturn = new System.Windows.Forms.DataGridViewCheckBoxColumn();
IsCapitalReturn.DataPropertyName = "CapitalReturn";
IsCapitalReturn.FalseValue = "N";
IsCapitalReturn.HeaderText = "IsCapitalReturn";
IsCapitalReturn.Name = "IsCapitalReturn";
IsCapitalReturn.Resizable = System.Windows.Forms.DataGridViewTriState.True;
IsCapitalReturn.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.Automatic;
IsCapitalReturn.TrueValue = "Y";
IsCapitalReturn.Width = 67;
dg_Dividends.Columns.Add(IsCapitalReturn);
}
dg_Dividends.Columns["DPS $"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
dg_Dividends.Columns["Changed"].Visible = false;
dg_Dividends.Columns["Orig_ExDate"].Visible = false;
} //dateTimePicker1_ValueChanged()
} //ForwardDividends_FormClosed()
private void LoadMissingDivs()
{
// Local Variables
String mySql = "Exec sp_LoadMissingDivs";
dt_Prime_Divs = SystemLibrary.SQLSelectToDataTable(mySql);
tb_TotalAmount.Text = SystemLibrary.ToDecimal(dt_Prime_Divs.Compute("Sum(Amount)", "")).ToString("$#,###.00");
if (dt_Prime_Divs.Rows.Count > 0)
{
// Force the Prime file to be reprocessed to see if this clears the problem.
// As this takes a few seconds, better to call mySQL twice on occasions where there are problems, rather than each time we enter divs screen
DataRow[] dr = dt_Prime_Divs.Select("CustodianName='Merrill Lynch'");
if (dr.Length > 0)
{
SystemLibrary.SQLExecute("Exec sp_ML_Process_File '', 'ML_E239' ");
}
dr = dt_Prime_Divs.Select("CustodianName='SCOTIA'");
if (dr.Length > 0)
{
SystemLibrary.SQLExecute("Exec sp_Scotia_Process_File '', 'SCOTIA_CASHSTMNT'");
SystemLibrary.SQLExecute("Exec sp_Scotia_Process_File '', 'SCOTIA_ACCTHIST'");
}
dt_Prime_Divs = SystemLibrary.SQLSelectToDataTable(mySql);
}
dg_MissingDivs.DataSource = dt_Prime_Divs;
if (dt_Prime_Divs.Rows.Count == 0)
{
splitContainer1.Panel2.Enabled = false;
splitContainer1.IsSplitterFixed = true;
lb_MissingDivs.Visible = false;
dg_MissingDivs.Visible = false;
bt_Reconcile.Visible = false;
lb_TotalAmount.Visible = false;
tb_TotalAmount.Visible = false;
lb_Amount.Visible = false;
tb_Amount.Visible = false;
this.Height = splitContainer1.Top + splitContainer1.Panel1.Height + 50;
splitContainer1.SplitterDistance = splitContainer1.Height;
/*
* this.Height = lb_MissingDivs.Top;
* dg_Dividends.Height = this.Height - dg_Dividends.Top - 50;
*/
}
else
{
for (int i = 0; i < dg_MissingDivs.Columns.Count; i++)
{
dg_MissingDivs.Columns[i].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
}
dg_MissingDivs.Columns["FundID"].Visible = false;
dg_MissingDivs.Columns["Ex Date"].DefaultCellStyle.Format = "dd-MMM-yyyy";
dg_MissingDivs.Columns["Payable Date"].DefaultCellStyle.Format = "dd-MMM-yyyy";
dg_MissingDivs.Columns["GPB_Transaction_ID"].Visible = false;
ParentForm1.SetFormatColumn(dg_MissingDivs, "Quantity", Color.Empty, Color.Empty, "N0", "0");
ParentForm1.SetFormatColumn(dg_MissingDivs, "Amount", Color.Empty, Color.Empty, "N4", "0");
dg_MissingDivs.Columns["Quantity"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
dg_MissingDivs.Columns["Amount"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
// Loop over the Rows
for (Int32 i = 0; i < dg_MissingDivs.Rows.Count; i++) // Last row in dg_ReportPosition is a blank row
{
if (dg_MissingDivs["BBG_Ticker", i].Value != null)
{
ParentForm1.SetColumn(dg_MissingDivs, "Quantity", i);
ParentForm1.SetColumn(dg_MissingDivs, "Amount", i);
}
}
dg_MissingDivs.Columns["Reconcilled"].Visible = false;
if (!dg_MissingDivs.Columns.Contains("IsReconcilled"))
{
System.Windows.Forms.DataGridViewCheckBoxColumn IsReconcilled = new System.Windows.Forms.DataGridViewCheckBoxColumn();
IsReconcilled.DataPropertyName = "Reconcilled";
IsReconcilled.FalseValue = "N";
IsReconcilled.HeaderText = "Reconcilled";
IsReconcilled.Name = "IsReconcilled";
IsReconcilled.Resizable = System.Windows.Forms.DataGridViewTriState.True;
IsReconcilled.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.Automatic;
IsReconcilled.TrueValue = "Y";
IsReconcilled.Width = 67;
dg_MissingDivs.Columns.Insert(0, IsReconcilled);
}
}
} //LoadMissingDivs()
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
protected override void InitializeComponent()
{
this.GbxCustomerList = new System.Windows.Forms.GroupBox();
this.CupttsUers = new CustomControlLib.CUserPageTurnToolStrip();
this.DgvCustomer = new System.Windows.Forms.DataGridView();
this.Column1 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.Column2 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.Column3 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.Column4 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.Column12 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.Column13 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.Column5 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.Column6 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.Column11 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.Column7 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.Column9 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.Column8 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.Column10 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.CheckBoxS = new System.Windows.Forms.DataGridViewCheckBoxColumn();
this.CbSelectAllSound = new System.Windows.Forms.CheckBox();
this.dataGridViewCellStyle1 = new System.Windows.Forms.DataGridViewCellStyle();
this.GbxCustomerFind = new System.Windows.Forms.GroupBox();
this.CboCustomerData = new System.Windows.Forms.ComboBox();
this.BtnCustomerFind = new System.Windows.Forms.Button();
this.BtnCustomerDelete = new System.Windows.Forms.Button();
this.BtnCustomerAdd = new System.Windows.Forms.Button();
this.BtnCustomerModify = new System.Windows.Forms.Button();
this.CTxtCustomerData = new CustomControlLib.CUserTextButton();
this.CboCustomerCondition = new System.Windows.Forms.ComboBox();
this.LblCustomerData = new System.Windows.Forms.Label();
this.LblCustomerCondition = new System.Windows.Forms.Label();
this.BtnBatchModify = new System.Windows.Forms.Button();
this.SuspendLayout();
this.GbxCustomerList.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.DgvCustomer)).BeginInit();
this.GbxCustomerFind.SuspendLayout();
//
// tabPage1
//
this.BackColor = System.Drawing.SystemColors.Control;
this.Controls.Add(this.GbxCustomerList);
this.Controls.Add(this.GbxCustomerFind);
this.Location = new System.Drawing.Point(4, 26);
this.Margin = new System.Windows.Forms.Padding(4);
this.Name = "tabPage1";
this.Padding = new System.Windows.Forms.Padding(4);
this.Size = new System.Drawing.Size(841, 487);
this.TabIndex = 0;
this.Text = "车主管理";
//
// GbxCustomerList
//
this.GbxCustomerList.Controls.Add(this.BtnBatchModify);
this.GbxCustomerList.Controls.Add(this.CbSelectAllSound);
this.GbxCustomerList.Controls.Add(this.CupttsUers);
this.GbxCustomerList.Controls.Add(this.DgvCustomer);
this.GbxCustomerList.Location = new System.Drawing.Point(0, 140);
this.GbxCustomerList.Margin = new System.Windows.Forms.Padding(4);
this.GbxCustomerList.Name = "GbxCustomerList";
this.GbxCustomerList.Padding = new System.Windows.Forms.Padding(4);
this.GbxCustomerList.Size = new System.Drawing.Size(837, 347);
this.GbxCustomerList.TabIndex = 1;
this.GbxCustomerList.TabStop = false;
this.GbxCustomerList.Text = "车主列表";
//
// BtnSaveSound
//
this.BtnBatchModify.Location = new System.Drawing.Point(100, 20);
this.BtnBatchModify.Margin = new System.Windows.Forms.Padding(4);
this.BtnBatchModify.Name = "BtnBatchModify";
this.BtnBatchModify.Size = new System.Drawing.Size(100, 30);
this.BtnBatchModify.TabIndex = 9;
this.BtnBatchModify.Text = "批量修改";
this.BtnBatchModify.UseVisualStyleBackColor = true;
this.BtnBatchModify.Click += new System.EventHandler(this.BtnBatchModify_Click);
//
// CupttsUers
//
this.CupttsUers.Dock = System.Windows.Forms.DockStyle.Bottom;
this.CupttsUers.Font = new System.Drawing.Font("微软雅黑", 12F);
this.CupttsUers.Location = new System.Drawing.Point(4, 354);
this.CupttsUers.Name = "CupttsUers";
this.CupttsUers.RenderMode = System.Windows.Forms.ToolStripRenderMode.System;
this.CupttsUers.Size = new System.Drawing.Size(829, 33);
this.CupttsUers.TabIndex = 8;
this.CupttsUers.Tag = this.DgvCustomer;
this.CupttsUers.Text = "CupttsUers";
//
// DgvCustomer
//
this.DgvCustomer.AllowUserToAddRows = false;
this.DgvCustomer.AllowUserToResizeRows = false;
this.DgvCustomer.AutoSizeColumnsMode = System.Windows.Forms.DataGridViewAutoSizeColumnsMode.Fill;
this.DgvCustomer.AutoGenerateColumns = false;
this.DgvCustomer.Columns.AddRange(new System.Windows.Forms.DataGridViewColumn[] {
this.Column1,
this.Column2,
this.Column3,
this.Column4,
this.Column5,
this.Column6,
this.Column7,
this.Column9,
this.Column8,
this.Column10,
this.Column11,
this.Column12,
this.Column13,
this.CheckBoxS
});
this.DgvCustomer.Location = new System.Drawing.Point(3, 60);
this.DgvCustomer.Name = "DgvCustomer";
this.DgvCustomer.RowHeadersVisible = false;
this.DgvCustomer.SelectionMode = System.Windows.Forms.DataGridViewSelectionMode.FullRowSelect;
this.DgvCustomer.Size = new System.Drawing.Size(829, 270);
this.DgvCustomer.TabIndex = 0;
this.DgvCustomer.CellDoubleClick += new System.Windows.Forms.DataGridViewCellEventHandler(base.DgvCustomer_CellDoubleClick);
this.DgvCustomer.CellFormatting += new System.Windows.Forms.DataGridViewCellFormattingEventHandler(base.DgvCustomer_CellFormatting);
this.DgvCustomer.DataSourceChanged += new EventHandler(this.CupttsUers.UpdateLayout);
//
// Column1
//
this.Column1.DataPropertyName = "strName";
//this.Column1.FillWeight = 72.63921F;
this.Column1.HeaderText = "姓名";
this.Column1.Name = "Column1";
this.Column1.ReadOnly = true;
//
// Column2
//
this.Column2.DataPropertyName = "strICCardID";
//this.Column2.FillWeight = 79.48557F;
this.Column2.HeaderText = "用户卡号";
this.Column2.Name = "Column2";
this.Column2.ReadOnly = true;
//
// Column3
//
this.Column3.DataPropertyName = "nICCardStatus";
//this.Column3.FillWeight = 85.48165F;
this.Column3.HeaderText = "卡状态";
this.Column3.Name = "Column3";
this.Column3.ReadOnly = true;
//
// Column4
//
this.Column4.DataPropertyName = "nICCardType";
//this.Column4.FillWeight = 90.6097F;
this.Column4.HeaderText = "卡类型";
this.Column4.Name = "Column4";
this.Column4.ReadOnly = true;
//
// Column12
//
this.Column12.DataPropertyName = "dtStartTime";
this.Column12.FillWeight = 210.6097F;
dataGridViewCellStyle1.Format = "yyyy-MM-dd HH:mm:ss";
this.Column12.DefaultCellStyle = dataGridViewCellStyle1;
this.Column12.HeaderText = "起始日期";
this.Column12.Name = "Column2";
this.Column12.ReadOnly = true;
//
// Column13
//
this.Column13.DataPropertyName = "dtDeadLine";
this.Column13.FillWeight = 210.6097F;
this.Column13.DefaultCellStyle = dataGridViewCellStyle1;
this.Column13.HeaderText = "截止日期";
this.Column13.Name = "Column3";
this.Column13.ReadOnly = true;
//
// Column5
//
this.Column5.DataPropertyName = "nWareHouse";
//this.Column5.FillWeight = 95.23381F;
this.Column5.HeaderText = "库区";
this.Column5.Name = "Column5";
this.Column5.ReadOnly = true;
//
// Column6
//
this.Column6.DataPropertyName = "strCarPOSN";
//this.Column6.FillWeight = 99.75758F;
this.Column6.HeaderText = "分配车位";
this.Column6.Name = "Column6";
this.Column6.ReadOnly = true;
//
// Column11
//
this.Column11.DataPropertyName = "nPriorityID";
//this.Column11.FillWeight = 99.75758F;
this.Column11.HeaderText = "优先级";
this.Column11.Name = "Column11";
this.Column11.ReadOnly = true;
//
// Column7
//
this.Column7.DataPropertyName = "strTelphone";
//this.Column7.FillWeight = 104.7255F;
this.Column7.HeaderText = "住宅电话";
this.Column7.Name = "Column7";
this.Column7.ReadOnly = true;
//
// Column9
//
this.Column9.DataPropertyName = "strMobile";
//this.Column9.FillWeight = 111.502F;
this.Column9.HeaderText = "移动电话";
this.Column9.Name = "Column9";
this.Column9.ReadOnly = true;
//
// Column8
//
this.Column8.DataPropertyName = "strLicPlteNbr";
//this.Column8.FillWeight = 121.858F;
this.Column8.HeaderText = "车牌号";
this.Column8.Name = "Column8";
this.Column8.ReadOnly = true;
//
// Column10
//
this.Column10.DataPropertyName = "strAddress";
//this.Column10.FillWeight = 138.7068F;
this.Column10.HeaderText = "住址";
this.Column10.Name = "Column10";
this.Column10.ReadOnly = true;
//
// CheckBoxS
//
//this.CheckBoxS.DataPropertyName = "soundishand";
//this.CheckBoxS.FillWeight = 46.08193F;
this.CheckBoxS.HeaderText = "选择";
this.CheckBoxS.Name = "CheckBoxS";
this.CheckBoxS.Resizable = System.Windows.Forms.DataGridViewTriState.True;
this.CheckBoxS.TrueValue = true;
this.CheckBoxS.FalseValue = false;
//
// CbSelectAllSound
//
this.CbSelectAllSound.AutoSize = true;
this.CbSelectAllSound.Location = new System.Drawing.Point(900, 25);
this.CbSelectAllSound.Margin = new System.Windows.Forms.Padding(4);
this.CbSelectAllSound.Name = "CbSelectAllSound";
this.CbSelectAllSound.Size = new System.Drawing.Size(30, 20);
this.CbSelectAllSound.TabIndex = 10;
this.CbSelectAllSound.Text = "全选";
this.CbSelectAllSound.UseVisualStyleBackColor = true;
this.CbSelectAllSound.CheckedChanged += new System.EventHandler(this.CbSelectAllSound_CheckedChanged);
//
// GbxCustomerFind
//
this.GbxCustomerFind.Controls.Add(this.CboCustomerData);
this.GbxCustomerFind.Controls.Add(this.BtnCustomerFind);
this.GbxCustomerFind.Controls.Add(this.BtnCustomerDelete);
this.GbxCustomerFind.Controls.Add(this.BtnCustomerAdd);
this.GbxCustomerFind.Controls.Add(this.BtnCustomerModify);
this.GbxCustomerFind.Controls.Add(this.CTxtCustomerData);
this.GbxCustomerFind.Controls.Add(this.CboCustomerCondition);
this.GbxCustomerFind.Controls.Add(this.LblCustomerData);
this.GbxCustomerFind.Controls.Add(this.LblCustomerCondition);
this.GbxCustomerFind.Location = new System.Drawing.Point(0, 11);
this.GbxCustomerFind.Margin = new System.Windows.Forms.Padding(4);
this.GbxCustomerFind.Name = "GbxCustomerFind";
this.GbxCustomerFind.Padding = new System.Windows.Forms.Padding(4);
this.GbxCustomerFind.Size = new System.Drawing.Size(837, 120);
this.GbxCustomerFind.TabIndex = 0;
this.GbxCustomerFind.TabStop = false;
this.GbxCustomerFind.Text = "车主查询";
//
// CboCustomerData
//
this.CboCustomerData.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;
this.CboCustomerData.FlatStyle = System.Windows.Forms.FlatStyle.Popup;
this.CboCustomerData.FormattingEnabled = true;
this.CboCustomerData.Location = new System.Drawing.Point(150, 81);
this.CboCustomerData.Name = "CboCustomerData";
this.CboCustomerData.Size = new System.Drawing.Size(240, 24);
this.CboCustomerData.TabIndex = 8;
this.CboCustomerData.Visible = false;
//
// BtnCustomerFind
//
this.BtnCustomerFind.Location = new System.Drawing.Point(524, 35);
this.BtnCustomerFind.Margin = new System.Windows.Forms.Padding(4);
this.BtnCustomerFind.Name = "BtnCustomerFind";
this.BtnCustomerFind.Size = new System.Drawing.Size(100, 31);
this.BtnCustomerFind.TabIndex = 7;
this.BtnCustomerFind.Text = "查询";
this.BtnCustomerFind.UseVisualStyleBackColor = true;
this.BtnCustomerFind.Click += new System.EventHandler(this.BtnCustomerFind_Click);
//
// BtnCustomerClose
//
this.BtnCustomerDelete.Location = new System.Drawing.Point(689, 81);
this.BtnCustomerDelete.Margin = new System.Windows.Forms.Padding(4);
this.BtnCustomerDelete.Name = "BtnCustomerClose";
this.BtnCustomerDelete.Size = new System.Drawing.Size(100, 31);
this.BtnCustomerDelete.TabIndex = 6;
this.BtnCustomerDelete.Text = "删除";
this.BtnCustomerDelete.UseVisualStyleBackColor = true;
this.BtnCustomerDelete.Click += new System.EventHandler(this.BtnCustomerDelete_Click);
//
// BtnCustomerAdd
//
this.BtnCustomerAdd.Location = new System.Drawing.Point(524, 81);
this.BtnCustomerAdd.Margin = new System.Windows.Forms.Padding(4);
this.BtnCustomerAdd.Name = "BtnCustomerAdd";
this.BtnCustomerAdd.Size = new System.Drawing.Size(100, 31);
this.BtnCustomerAdd.TabIndex = 5;
this.BtnCustomerAdd.Text = "添加";
this.BtnCustomerAdd.UseVisualStyleBackColor = true;
this.BtnCustomerAdd.Click += new System.EventHandler(this.BtnCustomerAdd_Click);
//
// BtnCustomerModify
//
this.BtnCustomerModify.Location = new System.Drawing.Point(689, 35);
this.BtnCustomerModify.Margin = new System.Windows.Forms.Padding(4);
this.BtnCustomerModify.Name = "BtnCustomerModify";
this.BtnCustomerModify.Size = new System.Drawing.Size(100, 31);
this.BtnCustomerModify.TabIndex = 4;
this.BtnCustomerModify.Text = "修改";
this.BtnCustomerModify.UseVisualStyleBackColor = true;
this.BtnCustomerModify.Click += new System.EventHandler(this.BtnCustomerModify_Click);
//
// CTxtCustomerData
//
this.CTxtCustomerData.Enabled = false;
this.CTxtCustomerData.EnabledButton = false;
this.CTxtCustomerData.EnmTxtType = CustomControlLib.EnmTxtBoxType.Init;
this.CTxtCustomerData.ImageButton = null;
this.CTxtCustomerData.Location = new System.Drawing.Point(150, 81);
this.CTxtCustomerData.Margin = new System.Windows.Forms.Padding(4);
this.CTxtCustomerData.Name = "CTxtCustomerData";
this.CTxtCustomerData.Size = new System.Drawing.Size(240, 26);
this.CTxtCustomerData.TabIndex = 3;
//this.CTxtCustomerData.CallbackTextButtonEvent += BtnCloseClick
//
// CboCustomerCondition
//
this.CboCustomerCondition.FormattingEnabled = true;
this.CboCustomerCondition.Items.AddRange(new object[] {
"用户卡号",
"库区",
"卡类型",
"卡状态",
//"分配车位",
"姓名",
"移动电话",
"车牌号",
"所有"
});
this.CboCustomerCondition.Location = new System.Drawing.Point(150, 35);
this.CboCustomerCondition.Margin = new System.Windows.Forms.Padding(4);
this.CboCustomerCondition.Name = "CboCustomerCondition";
this.CboCustomerCondition.Size = new System.Drawing.Size(240, 24);
this.CboCustomerCondition.TabIndex = 2;
this.CboCustomerCondition.Text = "所有";
this.CboCustomerCondition.SelectedIndexChanged += new EventHandler(CboCustomerCondition_SelectedIndexChanged);
this.CboCustomerCondition.DropDownStyle = ComboBoxStyle.DropDownList;
this.CboCustomerCondition.FlatStyle = FlatStyle.Popup;
//
// LblCustomerData
//
this.LblCustomerData.Location = new System.Drawing.Point(3, 81);
this.LblCustomerData.Margin = new System.Windows.Forms.Padding(4, 0, 4, 0);
this.LblCustomerData.Name = "label2";
this.LblCustomerData.RightToLeft = System.Windows.Forms.RightToLeft.Yes;
this.LblCustomerData.Size = new System.Drawing.Size(147, 27);
this.LblCustomerData.TabIndex = 1;
this.LblCustomerData.Text = "查询数据";
//
// LblCustomerCondition
//
this.LblCustomerCondition.Location = new System.Drawing.Point(3, 35);
this.LblCustomerCondition.Margin = new System.Windows.Forms.Padding(4, 0, 4, 0);
this.LblCustomerCondition.Name = "label1";
this.LblCustomerCondition.RightToLeft = System.Windows.Forms.RightToLeft.Yes;
this.LblCustomerCondition.Size = new System.Drawing.Size(147, 27);
this.LblCustomerCondition.TabIndex = 0;
this.LblCustomerCondition.Text = "查询条件";
this.ResumeLayout(false);
this.GbxCustomerList.ResumeLayout(false);
this.GbxCustomerList.PerformLayout();
((System.ComponentModel.ISupportInitialize)(this.DgvCustomer)).EndInit();
this.GbxCustomerFind.ResumeLayout(false);
this.GbxCustomerFind.PerformLayout();
this.ResumeLayout(false);
}
private void SetParaToDepartmentUI(ref DataGridView dataGridView, Object obj)
{
dataGridView.Rows.Clear();
if (dataGridView.Equals(editDepartmentDataGridView) == true)
{
if (((ArrayList)obj).Count > 0)
{
dataGridView.Rows.Add(((ArrayList)obj).Count);
for (int i = 0; i < ((ArrayList)obj).Count; i++)
{
dataGridView.Rows[i].SetValues(((ArrayList)obj)[i]);
}
}
}
else if (dataGridView.Equals(accountTypeDataGridView) == true)
{
if (((AccountTypeTable)obj).Count > 0)
{
dataGridView.Rows.Add(((AccountTypeTable)obj).Count);
int idx = 0;
foreach (string accountName in ((AccountTypeTable)obj).Keys)
{
dataGridView.Rows[idx].SetValues(accountName, ((AccountTypeTable)obj)[accountName]);
idx++;
}
}
}
else if (dataGridView.Equals(accessFunctionDataGridView) == true)
{
if (((AccessFunctionTable)obj).Count > 0)
{
dataGridView.Rows.Add(((AccessFunctionTable)obj).Count);
for (int idx = 0; idx < ((AccessFunctionTable)obj).Count; idx++)
{
dataGridView.Rows[idx].SetValues(((AccessFunction)((AccessFunctionTable)obj)[idx]).AccessFunctionName);
}
}
}
else if (dataGridView.Equals(userAccountDataGridView) == true)
{
dataGridView.Rows.Clear();
if (((ArrayList)obj).Count > 0)
{
dataGridView.Rows.Add(((ArrayList)obj).Count);
for (int idx = 0; idx < ((ArrayList)obj).Count; idx++)
{
dataGridView.Rows[idx].SetValues(idx + 1, ((UserAccount)((ArrayList)obj)[idx]).LoginID,
((UserAccount)((ArrayList)obj)[idx]).Department,
((UserAccount)((ArrayList)obj)[idx]).UserName,
((UserAccount)((ArrayList)obj)[idx]).AccountType.GetFirstAccountTypeName(),
((UserAccount)((ArrayList)obj)[idx]).Description);
}
dataGridView_Sorted(userAccountDataGridView, null);
}
}
else if (dataGridView.Equals(functionAccessDataGridView) == true)
{
if (((AccessFunctionTable)obj).Count > 0)
{
System.Windows.Forms.DataGridViewColumn[] dataGridColumn = new System.Windows.Forms.DataGridViewColumn[accountTypeTable.Count];
AccountTypeTable accountTypeTableTemp = new AccountTypeTable();
foreach (string strAccount in accountTypeTable.Keys)
{
accountTypeTableTemp.AddType(strAccount, (int)(accountTypeTable[strAccount]));
}
int iColumnIdx = 0;
for (int i = 100; i >= 0; i--)
{
foreach (string strAccount in accountTypeTableTemp.Keys)
{
if (((int)accountTypeTableTemp[strAccount]) == i)
{
accountTypeTableTemp.Remove(strAccount);
System.Windows.Forms.DataGridViewCheckBoxColumn column = new System.Windows.Forms.DataGridViewCheckBoxColumn();
column.HeaderText = strAccount;
column.Name = "AccessFuncColumn" + i;
column.Width = 100;
column.ReadOnly = true;
dataGridColumn[iColumnIdx] = column;
iColumnIdx++;
//避免重複印出
foreach (DataGridViewColumn ExistColumn in this.functionAccessDataGridView.Columns)
{
if (ExistColumn.HeaderText == strAccount)
{
this.functionAccessDataGridView.Columns.Remove(ExistColumn);
break;
}
}
break;
}
}
}
this.functionAccessDataGridView.Columns.AddRange(dataGridColumn);
dataGridView.Rows.Add(((AccessFunctionTable)obj).Count);
for (int idx = 0; idx < ((AccessFunctionTable)obj).Count; idx++)
{
dataGridView.Rows[idx].SetValues(idx + 1, ((AccessFunction)((AccessFunctionTable)obj)[idx]).AccessFunctionName);
foreach (string strAccount in ((AccessFunction)accessFunctionTable[idx]).AccountType.Keys)
{
for (int columnIdx = 2; columnIdx < functionAccessDataGridView.ColumnCount; columnIdx++)
{
if (strAccount.Equals(functionAccessDataGridView.Columns[columnIdx].HeaderText))
{
functionAccessDataGridView.Rows[idx].Cells[columnIdx].Value = true;
}
//functionAccessDataGridView.Rows[idx].Cells[columnIdx].ReadOnly = strAccount.Equals(functionAccessDataGridView.Columns[columnIdx].HeaderText);
}
}
}
}
}
}
private void InitializeComponent()
{
this.components = new System.ComponentModel.Container();
this.dataGridView1 = new System.Windows.Forms.DataGridView();
this.RowCol = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.NameCol = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.TypeCol = new System.Windows.Forms.DataGridViewComboBoxColumn();
this.ArchiveCol = new System.Windows.Forms.DataGridViewCheckBoxColumn();
this.RetriggerCol = new System.Windows.Forms.DataGridViewComboBoxColumn();
this.PrintCol = new System.Windows.Forms.DataGridViewCheckBoxColumn();
this.IDCol = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.ReadOnlyCol = new DataGridViewCheckBoxColumn();
this.contextMenuStrip1 = new System.Windows.Forms.ContextMenuStrip(this.components);
this.deleteToolStripMenuItem = new System.Windows.Forms.ToolStripMenuItem();
this.addToolStripMenuItem = new System.Windows.Forms.ToolStripMenuItem();
this.copyToolStripMenuItem = new System.Windows.Forms.ToolStripMenuItem();
this.pasteToolStripMenuItem = new System.Windows.Forms.ToolStripMenuItem();
this.panelTabPage = new System.Windows.Forms.Panel();
((System.ComponentModel.ISupportInitialize)(this.dataGridView1)).BeginInit();
this.SuspendLayout();
//
// dataGridView1
//
this.dataGridView1.AllowUserToAddRows = false;
this.dataGridView1.AllowUserToDeleteRows = false;
this.dataGridView1.AllowUserToResizeRows = false;
this.dataGridView1.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
this.dataGridView1.Columns.AddRange(new System.Windows.Forms.DataGridViewColumn[] {
this.RowCol,
this.NameCol,
this.TypeCol,
this.ArchiveCol,
this.RetriggerCol,
this.PrintCol,
this.IDCol,
this.ReadOnlyCol
});
//this.dataGridView1.ContextMenuStrip = this.contextMenuStrip1;
this.dataGridView1.Dock = System.Windows.Forms.DockStyle.Fill;
this.dataGridView1.Location = new System.Drawing.Point(3, 3);
this.dataGridView1.RowHeadersVisible = false;
this.dataGridView1.MultiSelect = false;
this.dataGridView1.Name = "dataGridView1";
this.dataGridView1.Size = new System.Drawing.Size(563, 150);
this.dataGridView1.TabIndex = 0;
this.dataGridView1.CellBeginEdit += new System.Windows.Forms.DataGridViewCellCancelEventHandler(this.dataGridView1_CellBeginEdit);
this.dataGridView1.CellValueChanged += new System.Windows.Forms.DataGridViewCellEventHandler(this.dataGridView1_CellValueChanged);
this.dataGridView1.ColumnWidthChanged += new System.Windows.Forms.DataGridViewColumnEventHandler(this.dataGridView1_ColumnWidthChanged);
this.dataGridView1.CellMouseUp += new DataGridViewCellMouseEventHandler(this.dataGridView1_CellMouseUp);
this.dataGridView1.RowsAdded += new System.Windows.Forms.DataGridViewRowsAddedEventHandler(this.dataGridView1_RowsAdded);
//
// RowCol
//
this.RowCol.HeaderText = "Row";
this.RowCol.Name = "RowCol";
//
// NameCol
//
this.NameCol.HeaderText = "Name";
this.NameCol.Name = "NameCol";
//
// TypeCol
//
this.TypeCol.HeaderText = "Type";
this.TypeCol.Items.AddRange(new object[] {
"Event",
"Self Acknowledge",
"Acknowledge on Set",
"Acknowledge on Set/Reset"
});
this.TypeCol.Name = "TypeCol";
//
// ArchiveCol
//
this.ArchiveCol.HeaderText = "Archive";
this.ArchiveCol.Name = "ArchiveCol";
//
// RetriggerCol
//
this.RetriggerCol.HeaderText = "Retrigger";
this.RetriggerCol.Items.AddRange(new object[] {
"No",
"1 Minute",
"10 Minute",
"1 Hour"
});
this.RetriggerCol.Name = "RetriggerCol";
this.RetriggerCol.Resizable = System.Windows.Forms.DataGridViewTriState.True;
//
// PrintCol
//
this.PrintCol.HeaderText = "Print";
this.PrintCol.Name = "PrintCol";
//
// IDCol
//
this.IDCol.HeaderText = "ID";
this.IDCol.Name = "IDCol";
//
// ReadOnlyCol
//
this.ReadOnlyCol.HeaderText = "ReadOnly";
this.ReadOnlyCol.Name = "ReadOnlyCol";
//
// contextMenuStrip1
//
this.contextMenuStrip1.Items.AddRange(new System.Windows.Forms.ToolStripItem[] {
this.deleteToolStripMenuItem,
this.addToolStripMenuItem,
this.copyToolStripMenuItem,
this.pasteToolStripMenuItem
});
this.contextMenuStrip1.Name = "contextMenuStrip1";
this.contextMenuStrip1.Size = new System.Drawing.Size(102, 26);
//
// delteToolStripMenuItem
//
this.deleteToolStripMenuItem.Name = "deleteToolStripMenuItem";
this.deleteToolStripMenuItem.Size = new System.Drawing.Size(101, 22);
this.deleteToolStripMenuItem.Text = "Delete";
this.deleteToolStripMenuItem.Click += new System.EventHandler(this.deleteToolStripMenuItem_Click);
//
// addToolStripMenuItem
//
this.addToolStripMenuItem.Name = "addToolStripMenuItem";
this.addToolStripMenuItem.Size = new System.Drawing.Size(101, 22);
this.addToolStripMenuItem.Text = "Add";
this.addToolStripMenuItem.Click += new System.EventHandler(this.addToolStripMenuItem_Click);
//
// copyToolStripMenuItem
//
this.copyToolStripMenuItem.Name = "copyToolStripMenuItem";
this.copyToolStripMenuItem.Size = new System.Drawing.Size(101, 22);
this.copyToolStripMenuItem.Text = "Copy";
this.copyToolStripMenuItem.Click += new System.EventHandler(this.copyToolStripMenuItem_Click);
//
// pasteToolStripMenuItem
//
this.pasteToolStripMenuItem.Name = "pasteToolStripMenuItem";
this.pasteToolStripMenuItem.Size = new System.Drawing.Size(101, 22);
this.pasteToolStripMenuItem.Text = "Paste";
this.pasteToolStripMenuItem.Click += new System.EventHandler(this.pasteToolStripMenuItem_Click);
//
// panelTabPage
//
this.panelTabPage.AutoScroll = true;
this.panelTabPage.BackColor = System.Drawing.SystemColors.ActiveCaption;
this.panelTabPage.Controls.Add(this.dataGridView1);
this.panelTabPage.Dock = System.Windows.Forms.DockStyle.Fill;
this.panelTabPage.Location = new System.Drawing.Point(0, 0);
this.panelTabPage.Name = "panelTabPage";
this.panelTabPage.Size = new System.Drawing.Size(550, 187);
this.panelTabPage.TabIndex = 0;
//
// TabGridPageControl
//
this.Controls.Add(this.panelTabPage);
((System.ComponentModel.ISupportInitialize)(this.dataGridView1)).EndInit();
this.ResumeLayout(false);
}
//慶忠版本
public int LoadUI(string iniFilePath, CCIOMonitorUnitControl.IOType ioType)
{
string SectionName, KeyName;
SuspendLayout();
nowioType = ioType;
IniFile iniFile = new IniFile(iniFilePath);
IniFile iniIOLogListFile = new IniFile(IOLogListINIPath);
int dioNumber = iniFile.GetInt32("Info", (ioType == IOType.DI_TYPE) ? "DITotal" : "DOTotal", 0);
IoLogCheckBoxUsable = iniFile.GetInt16("Info", "IoLogCheckBoxUsable", 1);
tabPage = new System.Windows.Forms.TabPage[(dioNumber % _DISPLAY_IO_NUM_PER_PAGE_) == 0 ? dioNumber / _DISPLAY_IO_NUM_PER_PAGE_ : dioNumber / _DISPLAY_IO_NUM_PER_PAGE_ + 1];
diLEDLabel = new System.Windows.Forms.Label[dioNumber];
diNameLabel = new System.Windows.Forms.Label[dioNumber];
//////////////////////////////////////////////////////////////////////////
ioDataGridView = new System.Windows.Forms.DataGridView[(dioNumber % _DISPLAY_IO_NUM_PER_PAGE_) == 0 ? dioNumber / _DISPLAY_IO_NUM_PER_PAGE_ : dioNumber / _DISPLAY_IO_NUM_PER_PAGE_ + 1];
IdxTest = new System.Windows.Forms.DataGridViewTextBoxColumn[(dioNumber % _DISPLAY_IO_NUM_PER_PAGE_) == 0 ? dioNumber / _DISPLAY_IO_NUM_PER_PAGE_ : dioNumber / _DISPLAY_IO_NUM_PER_PAGE_ + 1, 4];
CheckStatus = new System.Windows.Forms.DataGridViewCheckBoxColumn[(dioNumber % _DISPLAY_IO_NUM_PER_PAGE_) == 0 ? dioNumber / _DISPLAY_IO_NUM_PER_PAGE_ : dioNumber / _DISPLAY_IO_NUM_PER_PAGE_ + 1, 4];
IoStatus = new System.Windows.Forms.DataGridViewButtonColumn[(dioNumber % _DISPLAY_IO_NUM_PER_PAGE_) == 0 ? dioNumber / _DISPLAY_IO_NUM_PER_PAGE_ : dioNumber / _DISPLAY_IO_NUM_PER_PAGE_ + 1, 4];
DescriptionTest = new System.Windows.Forms.DataGridViewTextBoxColumn[(dioNumber % _DISPLAY_IO_NUM_PER_PAGE_) == 0 ? dioNumber / _DISPLAY_IO_NUM_PER_PAGE_ : dioNumber / _DISPLAY_IO_NUM_PER_PAGE_ + 1, 4];
//////////////////////////////////////////////////////////////////////////
tabControlEX.Controls.Clear();
for (int tabIdx = 0; tabIdx < tabPage.Length; tabIdx++)
{
//
// 建立TabPage
//
tabPage[tabIdx] = new Dotnetrix.Controls.TabPageEX();
tabPage[tabIdx].Location = new System.Drawing.Point(4, 21);
tabPage[tabIdx].Name = "sampleTabPage";
tabPage[tabIdx].Padding = new System.Windows.Forms.Padding(3);
tabPage[tabIdx].Size = new System.Drawing.Size(368, 434);
tabPage[tabIdx].TabIndex = 0;
tabPage[tabIdx].Text = string.Format("{0}~{1}", tabIdx * _DISPLAY_IO_NUM_PER_PAGE_, (tabIdx + 1) * _DISPLAY_IO_NUM_PER_PAGE_ - 1);
tabPage[tabIdx].UseVisualStyleBackColor = true;
tabControlEX.Controls.Add(tabPage[tabIdx]);
for (int i = 0; i < 4; i++)
{
//////////////////////////////////////////////
// Idx
//
IdxTest[tabIdx, i] = new System.Windows.Forms.DataGridViewTextBoxColumn();
IdxTest[tabIdx, i].HeaderText = "Idx";
IdxTest[tabIdx, i].Name = "Column1";
IdxTest[tabIdx, i].ReadOnly = true;
IdxTest[tabIdx, i].Width = 30;//26
//////////////////////////////////////////////
//
// Log Check Box
//
CheckStatus[tabIdx, i] = new System.Windows.Forms.DataGridViewCheckBoxColumn();
CheckStatus[tabIdx, i].FlatStyle = System.Windows.Forms.FlatStyle.Popup;
CheckStatus[tabIdx, i].HeaderText = "Pass";
CheckStatus[tabIdx, i].Name = "Pass";
CheckStatus[tabIdx, i].Width = 25;//20
CheckStatus[tabIdx, i].ReadOnly = false;
CheckStatus[tabIdx, i].FalseValue = false;
CheckStatus[tabIdx, i].TrueValue = true;
//////////////////////////////////////////////
//
// Status
//
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle2 = new System.Windows.Forms.DataGridViewCellStyle();
IoStatus[tabIdx, i] = new System.Windows.Forms.DataGridViewButtonColumn();
dataGridViewCellStyle2.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;
dataGridViewCellStyle2.BackColor = System.Drawing.Color.Lime;
dataGridViewCellStyle2.SelectionBackColor = System.Drawing.Color.Transparent;
IoStatus[tabIdx, i].DefaultCellStyle = dataGridViewCellStyle2;
IoStatus[tabIdx, i].FlatStyle = System.Windows.Forms.FlatStyle.Popup;
IoStatus[tabIdx, i].HeaderText = "Status";
IoStatus[tabIdx, i].Name = "Status";
IoStatus[tabIdx, i].ReadOnly = true;
IoStatus[tabIdx, i].Width = 25;//20
/////////////////////////////////////////////////////////////////////////
//
// Description
//
DescriptionTest[tabIdx, i] = new System.Windows.Forms.DataGridViewTextBoxColumn();
//DescriptionTest[tabIdx, i].AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.Fill;
DescriptionTest[tabIdx, i].HeaderText = "Description";
DescriptionTest[tabIdx, i].Name = "Description";
DescriptionTest[tabIdx, i].ReadOnly = true;
DescriptionTest[tabIdx, i].Width = 194;//180
}
//
// sampleDataGridView
//
ioDataGridView[tabIdx] = new System.Windows.Forms.DataGridView();
tabPage[tabIdx].Controls.Add(ioDataGridView[tabIdx]);
ioDataGridView[tabIdx].AllowUserToAddRows = false;
ioDataGridView[tabIdx].AllowUserToDeleteRows = false;
ioDataGridView[tabIdx].AllowUserToResizeColumns = false;
ioDataGridView[tabIdx].AllowUserToResizeRows = false;
//ioDataGridView[tabIdx].AutoSizeRowsMode = System.Windows.Forms.DataGridViewAutoSizeRowsMode.DisplayedCells;
//ioDataGridView[tabIdx].ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
ioDataGridView[tabIdx].ColumnHeadersVisible = false;
ioDataGridView[tabIdx].Columns.AddRange(new System.Windows.Forms.DataGridViewColumn[] {
IdxTest[tabIdx, 0],
CheckStatus[tabIdx, 0],
IoStatus[tabIdx, 0],
DescriptionTest[tabIdx, 0],
IdxTest[tabIdx, 1],
CheckStatus[tabIdx, 1],
IoStatus[tabIdx, 1],
DescriptionTest[tabIdx, 1],
IdxTest[tabIdx, 2],
CheckStatus[tabIdx, 2],
IoStatus[tabIdx, 2],
DescriptionTest[tabIdx, 2],
IdxTest[tabIdx, 3],
CheckStatus[tabIdx, 3],
IoStatus[tabIdx, 3],
DescriptionTest[tabIdx, 3]
});
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle3 = new System.Windows.Forms.DataGridViewCellStyle();
dataGridViewCellStyle3.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleLeft;
dataGridViewCellStyle3.BackColor = System.Drawing.SystemColors.Window;
dataGridViewCellStyle3.Font = new System.Drawing.Font("Arial", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
dataGridViewCellStyle3.ForeColor = System.Drawing.SystemColors.ControlText;
dataGridViewCellStyle3.SelectionBackColor = System.Drawing.SystemColors.Highlight;
dataGridViewCellStyle3.SelectionForeColor = System.Drawing.SystemColors.HighlightText;
dataGridViewCellStyle3.WrapMode = System.Windows.Forms.DataGridViewTriState.False;
ioDataGridView[tabIdx].DefaultCellStyle = dataGridViewCellStyle3;
//ioDataGridView[tabIdx].Dock = System.Windows.Forms.DockStyle.Fill;
ioDataGridView[tabIdx].EditMode = System.Windows.Forms.DataGridViewEditMode.EditProgrammatically;
ioDataGridView[tabIdx].Location = sampleDataGridView.Location;
ioDataGridView[tabIdx].MultiSelect = false;
ioDataGridView[tabIdx].Name = "sampleDataGridView";
//ioDataGridView[tabIdx].ReadOnly = true;
ioDataGridView[tabIdx].RowHeadersVisible = false;
ioDataGridView[tabIdx].RowHeadersWidthSizeMode = System.Windows.Forms.DataGridViewRowHeadersWidthSizeMode.DisableResizing;
ioDataGridView[tabIdx].SelectionMode = System.Windows.Forms.DataGridViewSelectionMode.RowHeaderSelect;
ioDataGridView[tabIdx].ScrollBars = System.Windows.Forms.ScrollBars.None;
ioDataGridView[tabIdx].Size = sampleDataGridView.Size;
ioDataGridView[tabIdx].TabIndex = 15;
ioDataGridView[tabIdx].Rows.Add(_DISPLAY_IO_NUM_PER_COLUMN_);
foreach (DataGridViewRow de in ioDataGridView[tabIdx].Rows)
{
de.Height = 25;//19
}
string ioName;
int iColumnIdx = 0;
int iRowIdx = 0;
for (int ioIdx = 0; ioIdx < _DISPLAY_IO_NUM_PER_PAGE_; ioIdx++)
{
//ioName = string.Format("{0}. ", ioIdx + _DISPLAY_IO_NUM_PER_PAGE_ * tabIdx) + iniFile.GetString((ioType == IOType.DI_TYPE) ? "DIName" : "DOName", string.Format("{0:D4}", ioIdx + _DISPLAY_IO_NUM_PER_PAGE_ * tabIdx), "");
ioName = iniFile.GetString((ioType == IOType.DI_TYPE) ? "DIName" : "DOName", string.Format("{0:D4}", ioIdx + _DISPLAY_IO_NUM_PER_PAGE_ * tabIdx), "");
if (ioIdx != 0 && ioIdx % _DISPLAY_IO_NUM_PER_COLUMN_ == 0)
{
iColumnIdx++;
iRowIdx = 0;
}
ioDataGridView[tabIdx].Rows[iRowIdx].Cells[0 + 4 * iColumnIdx].Value = string.Format("{0}", ioIdx + _DISPLAY_IO_NUM_PER_PAGE_ * tabIdx);
ioDataGridView[tabIdx].Rows[iRowIdx].Cells[0 + 4 * iColumnIdx].Style.BackColor = Color.Black;
ioDataGridView[tabIdx].Rows[iRowIdx].Cells[0 + 4 * iColumnIdx].Style.ForeColor = Color.White;
ioDataGridView[tabIdx].Rows[iRowIdx].Cells[1 + 4 * iColumnIdx].Style.BackColor = Color.Black;
ioDataGridView[tabIdx].Rows[iRowIdx].Cells[1 + 4 * iColumnIdx].Style.ForeColor = Color.White;
ioDataGridView[tabIdx].Rows[iRowIdx].Cells[1 + 4 * iColumnIdx].Value = false;
ioDataGridView[tabIdx].Rows[iRowIdx].Cells[2 + 4 * iColumnIdx].Style.BackColor = Color.Red;
ioDataGridView[tabIdx].Rows[iRowIdx].Cells[3 + 4 * iColumnIdx].Value = ioName;
ioDataGridView[tabIdx].Rows[iRowIdx].Cells[3 + 4 * iColumnIdx].Style.ForeColor = Color.White;
ioDataGridView[tabIdx].Rows[iRowIdx].Cells[3 + 4 * iColumnIdx].Style.BackColor = Color.Gray;
//Load IO Log Check List
SectionName = (nowioType == IOType.DI_TYPE) ? "DI Check List" : "DO Check List";
KeyName = ((nowioType == IOType.DI_TYPE) ? "DI" : "DO") + (string)ioDataGridView[tabIdx].Rows[iRowIdx].Cells[0 + 4 * iColumnIdx].Value;
ioDataGridView[tabIdx].Rows[iRowIdx].Cells[1 + 4 * iColumnIdx].Value = iniIOLogListFile.GetInt32(SectionName, KeyName, 1) == 1;
iRowIdx++;
}
tabPageNumber++;
}
for (int i = 0; i < tabPageNumber; i++)
{
ioDataGridView[i].CellClick += new System.Windows.Forms.DataGridViewCellEventHandler(IoLogDataGridView_CellContentClick);
}
ResumeLayout();
return(0);
}
private DataGridView NewLightView()
{
DataGridView LightView = new System.Windows.Forms.DataGridView();
LightView.CellClick += new DataGridViewCellEventHandler(lightView_CellClick);
#region Colums
DataGridViewTextBoxColumn lid = new System.Windows.Forms.DataGridViewTextBoxColumn();
DataGridViewTextBoxColumn lRoom = new System.Windows.Forms.DataGridViewTextBoxColumn();
DataGridViewTextBoxColumn lLoc = new System.Windows.Forms.DataGridViewTextBoxColumn();
DataGridViewTextBoxColumn lModel = new System.Windows.Forms.DataGridViewTextBoxColumn();
DataGridViewTextBoxColumn lMake = new System.Windows.Forms.DataGridViewTextBoxColumn();
DataGridViewTextBoxColumn lHeads = new System.Windows.Forms.DataGridViewTextBoxColumn();
DataGridViewTextBoxColumn lPow = new System.Windows.Forms.DataGridViewTextBoxColumn();
DataGridViewTextBoxColumn lVolts = new System.Windows.Forms.DataGridViewTextBoxColumn();
DataGridViewCheckBoxColumn lReqServ = new System.Windows.Forms.DataGridViewCheckBoxColumn();
DataGridViewTextBoxColumn lSerial = new System.Windows.Forms.DataGridViewTextBoxColumn();
DataGridViewTextBoxColumn lBarCode = new System.Windows.Forms.DataGridViewTextBoxColumn();
DataGridViewTextBoxColumn lManDate = new System.Windows.Forms.DataGridViewTextBoxColumn();
DataGridViewButtonColumn lDel = new DataGridViewButtonColumn();
lid.HeaderText = "ID";
lid.Name = "lid";
lid.Visible = false;
lLoc.HeaderText = "Location";
lLoc.Name = "lLoc";
lLoc.Width = 80;
lModel.HeaderText = "Model";
lModel.Name = "lModel";
lModel.Width = 80;
lMake.HeaderText = "Make";
lMake.Name = "lMake";
lMake.Width = 60;
lHeads.HeaderText = "Heads";
lHeads.Name = "lHeads";
lHeads.Width = 60;
lPow.HeaderText = "Watts";
lPow.Name = "lPow";
lPow.Width = 60;
lVolts.HeaderText = "Volts";
lVolts.Name = "lVolts";
lVolts.Width = 60;
lReqServ.HeaderText = "Service";
lReqServ.Name = "lReqServ";
lReqServ.Width = 60;
lSerial.HeaderText = "Serial";
lSerial.Name = "lSerial";
lSerial.Width = 150;
lRoom.HeaderText = "Room";
lRoom.Name = "lRoom";
lRoom.Visible = false;
lRoom.Width = 60;
lBarCode.HeaderText = "Bar Code";
lBarCode.Name = "Bar Code";
lBarCode.Width = 80;
lManDate.HeaderText = "Manufacturing Date";
lManDate.Name = "lManDate";
lManDate.Width = 150;
lDel.HeaderText = "Delete";
lDel.Name = "lDel";
lDel.Width = 40;
#endregion
LightView.AllowUserToAddRows = false;
LightView.AllowUserToDeleteRows = false;
LightView.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
LightView.Columns.AddRange(new System.Windows.Forms.DataGridViewColumn[] {
lid,
lLoc,
lModel,
lMake,
lHeads,
lPow,
lVolts,
lReqServ,
lSerial,
lRoom,
lBarCode,
lManDate,
lDel
});
LightView.Location = new System.Drawing.Point(5, 220);
LightView.Name = "LightView";
LightView.Size = new System.Drawing.Size(AddItemButton.Location.X - LightView.Location.X - 10, 150);
LightView.TabIndex = 66;
LightView.Visible = false;
return(LightView);
}
