private void SetColumns(DataGridViewColumnCollection columns) { DataGridViewColumn column; DataGridViewCellStyle style; // //Index // column = new DataGridViewTextBoxColumn(); columns.Add(column); column.DataPropertyName = "Id"; column.HeaderText = "Id"; column.Name = "plainClmRequestId"; column.Width = 40; // // clmRowIndex // column = new DataGridViewTextBoxColumn(); columns.Add(column); column.DataPropertyName = "ParentId"; column.HeaderText = "RequestId"; column.Name = "plainClmRequestId"; column.Width = 50; // //Request // column = new DataGridViewTextBoxColumn(); columns.Add(column); column.DataPropertyName = "Request"; column.HeaderText = "Request"; column.Name = "plainClmRequest"; column.Width = 150; // // Start // column = new DataGridViewTextBoxColumn(); columns.Add(column); style = new DataGridViewCellStyle(); style.Format = "MMM dd, HH:mm:ss.fff"; column.DataPropertyName = "StartDate"; column.DefaultCellStyle = style; column.HeaderText = "Start"; column.Name = "plainClmStart"; column.Width = 110; // // clmConnectId // column = new DataGridViewTextBoxColumn(); columns.Add(column); column.DataPropertyName = "ConnectId"; column.HeaderText = "ConnectId"; column.Name = "plainClmConnectId"; column.Width = 70; // // clmLoginId // column = new DataGridViewTextBoxColumn(); columns.Add(column); column.DataPropertyName = "LoginId"; column.HeaderText = "LoginId"; column.Name = "plainClmLoginId"; column.Width = 70; // // clmCallId // column = new DataGridViewTextBoxColumn(); columns.Add(column); column.DataPropertyName = "CallId"; column.HeaderText = "CallId"; column.Name = "plainClmCallId"; column.Width = 70; // // clmUserName // column = new DataGridViewTextBoxColumn(); columns.Add(column); column.DataPropertyName = "User"; column.HeaderText = "User"; column.Name = "plainClmUserName"; column.Width = 70; // // clmThreadName // column = new DataGridViewTextBoxColumn(); columns.Add(column); column.DataPropertyName = "Thread"; column.HeaderText = "Thread"; column.Name = "plainClmThreadName"; // // clmType // column = new DataGridViewTextBoxColumn(); columns.Add(column); column.DataPropertyName = "Type"; column.HeaderText = "Type"; column.Name = "plainClmType"; column.Width = 40; // // clmExecutionTime // column = new DataGridViewTextBoxColumn(); columns.Add(column); style = new DataGridViewCellStyle(); style.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight; column.DataPropertyName = "DbTime"; column.DefaultCellStyle = style; column.HeaderText = "DbTime(ms)"; column.Name = "plainClmDbTime"; column.Width = 80; // // clmRowAffected // column = new DataGridViewTextBoxColumn(); columns.Add(column); style = new DataGridViewCellStyle(); style.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight; column.DataPropertyName = "RowAffected"; column.DefaultCellStyle = style; column.HeaderText = "Affected rows"; column.Name = "plainClmRowAffected"; // // clmMethod // column = new DataGridViewTextBoxColumn(); columns.Add(column); column.DataPropertyName = "Method"; column.HeaderText = "Method"; column.Name = "plainClmMethod"; column.Width = 350; // // clmSchema // column = new DataGridViewTextBoxColumn(); columns.Add(column); column.DataPropertyName = "DbSchema"; column.HeaderText = "DbSchema"; column.Name = "plainClmSchema"; // // clmMessage // column = new DataGridViewTextBoxColumn(); columns.Add(column); column.DataPropertyName = "Message"; column.HeaderText = "Message"; column.Name = "plainClmMessage"; }
private void button3_Click(object sender, EventArgs e) { string className = this.comboBox1.Text; string startTime = this.dateTimePicker1.Value.ToString("yyyy-MM-dd"); string endTime = this.dateTimePicker2.Value.ToString("yyyy-MM-dd"); DataTable dt = studentInfoCtl.GetClassCheckInfo(className, startTime, endTime); //DataColumn dc = new DataColumn("序号", typeof(int)); //dt.Columns.Add(dc); this.dataGridView1.DataSource = dt; this.dataGridView1.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells); int headerW = this.dataGridView1.RowHeadersWidth; int columnsW = 0; DataGridViewColumnCollection columns = this.dataGridView1.Columns; if (columns.Count > 0) { for (int i = 0; i < columns.Count; i++) { columnsW += columns[i].Width; } if (columnsW + headerW < this.dataGridView1.Width) { int leftTotalWidht = this.dataGridView1.Width - columnsW - headerW; int eachColumnAddedWidth = leftTotalWidht / (columns.Count); for (int i = 0; i < columns.Count; i++) { columns[i].Width += eachColumnAddedWidth; } } } ///////////////////////////////////////////////////////////////////////////////////// double y = 0; for (int i = 0; i < dt.Rows.Count; i++) { DataRow dr = dt.Rows[i]; try { DateTime date = DateTime.Parse(dr["考勤时间"].ToString()); string rate = dr["出勤率"].ToString(); y = double.Parse(rate); ChartSeriesValue csv = new ChartSeriesValue(date, (decimal)y); this.chart1.Series.Values.Add(csv); if (i == 0) { this.chart1.XAxis.Scale.Minimum = date.AddDays(-0.5); } if (i == dt.Rows.Count - 1) { this.chart1.XAxis.Scale.Maximum = date.AddDays(0.5); } } catch (System.Exception ex) { } } ///////////////////////////////////////////////////////////////////////////////////// /* * barChart.Items.Clear(); * * Color clrGreen = Color.FromArgb(255, 82, 206, 60); * Color clrYellow = Color.FromArgb(255, 234, 234, 134); * Color clrRed = Color.FromArgb(255, 253, 95, 77); * double y = 0; * for (int i = 0; i < dt.Rows.Count; i++) * { * DataRow dr = dt.Rows[i]; * try * { * string date = dr["考勤时间"].ToString().Substring(0, 10); * string rate = dr["出勤率"].ToString(); * y = double.Parse(rate); * Color clrSelected = clrGreen; * if (y < 85) * { * clrSelected = clrYellow; * } * if (y < 60) * { * clrSelected = clrRed; * } * barChart.Add(rate + "%", y, (i + 1).ToString(), clrSelected); * //barChart.Add(rate + "%", y, (i + 1).ToString(), Color.FromArgb(255, 200, 255, 255)); * } * catch (System.Exception ex) * { * * } * * } * barChart.RedrawChart(); */ /* * GraphPane myPane = zgc.GraphPane; * * // Set the Titles * * myPane.Title.Text = "出勤率折线图"; * myPane.XAxis.Title.Text = "考勤时间"; * myPane.YAxis.Title.Text = "出勤率"; * * // Make up some data arrays based on the Sine function * * double x, y; * PointPairList list = new PointPairList(); * for (int i = 0; i < dt.Rows.Count; i++) * { * DataRow dr = dt.Rows[i]; * try * { * DateTime date = DateTime.Parse(dr["考勤时间"].ToString()); * x = (double)new XDate(date.Year, date.Month, date.Day); * y = double.Parse(dr["出勤率"].ToString()); * list.Add(x, y); * } * catch (System.Exception ex) * { * * } * * } * * // Generate a red curve with diamond * * // symbols, and "Porsche" in the legend * * LineItem myCurve = myPane.AddCurve("出勤率折线图", * list, Color.Red, SymbolType.Diamond); * * * // Tell ZedGraph to refigure the * * // axes since the data have changed * * zgc.AxisChange(); */ }
void helper_RequestCompleted_disposeList(object o) { //if (this.InvokeRequired) //{ // this.Invoke(new deleControlInvoke(updateDatagrid), o); //} deleControlInvoke dele = delegate(object oProductList) { string strProduct = (string)oProductList; Debug.WriteLine( string.Format("frmProductManage.helper_RequestCompleted_disposeList -> response = {0}" , strProduct)); Product u2 = fastJSON.JSON.Instance.ToObject <Product>(strProduct); object olist = fastJSON.JSON.Instance.ToObjectList(strProduct, typeof(List <Product>), typeof(Product)); DataTable dt = null; if (this.dataGridView1.DataSource == null) { dt = new DataTable(); dt.Columns.Add("产品编号", typeof(string)); dt.Columns.Add("产品名称", typeof(string)); dt.Columns.Add("生产日期", typeof(string)); dt.Columns.Add("产品类别", typeof(string)); dt.Columns.Add("产品备注信息", typeof(string)); } else { dt = (DataTable)dataGridView1.DataSource; } dt.Rows.Clear(); foreach (Product c in (List <Product>)olist) { dt.Rows.Add(new object[] { c.productID, c.productName, c.produceDate, c.productCategory, c.descript }); Debug.WriteLine(c.productID + " " + c.produceDate); } this.dataGridView1.DataSource = dt; this.dataGridView1.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells); int headerW = this.dataGridView1.RowHeadersWidth; int columnsW = 0; DataGridViewColumnCollection columns = this.dataGridView1.Columns; if (columns.Count > 0) { for (int i = 0; i < columns.Count; i++) { columnsW += columns[i].Width; } if (columnsW + headerW < this.dataGridView1.Width) { int leftTotalWidht = this.dataGridView1.Width - columnsW - headerW; int eachColumnAddedWidth = leftTotalWidht / (columns.Count); for (int i = 0; i < columns.Count; i++) { columns[i].Width += eachColumnAddedWidth; } } } }; this.Invoke(dele, o); }
private void InitializeColumns(DataGridViewColumnCollection columns) { columns.Clear(); DataGridViewColumn column; // // clmIndex // column = new DataGridViewTextBoxColumn(); columns.Add(column); column.DataPropertyName = "Id"; column.HeaderText = "Id"; column.Name = "clmIndex"; column.ReadOnly = true; column.Width = 35; column.ToolTipText = "Index"; // // clmFrec // column = new DataGridViewTextBoxColumn(); columns.Add(column); column.DataPropertyName = "Title"; column.HeaderText = "Frec"; column.Name = "clmFrec"; column.ReadOnly = true; column.Width = 166; column.ToolTipText = "Frec"; // // clmTime // column = new DataGridViewTextBoxColumn(); columns.Add(column); column.DataPropertyName = "TimeString"; column.HeaderText = "Start"; column.Name = "clmTime"; column.ReadOnly = true; column.Width = 75; column.ToolTipText = "Start time"; // // clmWait // column = new DataGridViewTextBoxColumn(); columns.Add(column); column.DataPropertyName = "ResponceWaitTime"; column.HeaderText = "Wait"; column.Name = "clmWait"; column.ReadOnly = true; column.Width = 60; column.ToolTipText = "Waiting time to responce"; // // clmTable // column = new DataGridViewTextBoxColumn(); columns.Add(column); column.DataPropertyName = "TableName"; column.HeaderText = "Table"; column.Name = "clmTable"; column.ReadOnly = true; column.Width = 120; column.ToolTipText = "Table name"; // // clmSession // column = new DataGridViewTextBoxColumn(); columns.Add(column); column.DataPropertyName = "SessionId"; column.HeaderText = "Session"; column.Name = "clmSession"; column.ReadOnly = true; column.Width = 130; column.ToolTipText = "Project session"; column.Visible = false; // // clmThread // column = new DataGridViewTextBoxColumn(); columns.Add(column); column.DataPropertyName = "Thread"; column.HeaderText = "Thread"; column.Name = "clmThread"; column.ReadOnly = true; column.Width = 45; column.ToolTipText = "Thread"; column.Visible = false; // // clmParseDuration // column = new DataGridViewTextBoxColumn(); columns.Add(column); column.DataPropertyName = "ParseDuration"; column.HeaderText = "Parse duration"; column.Name = "clmParseDuration"; column.ReadOnly = true; column.Width = 120; column.ToolTipText = "Frec parse duration"; column.Visible = false; // // clmServer // column = new DataGridViewTextBoxColumn(); columns.Add(column); column.DataPropertyName = "Server"; column.HeaderText = "Server"; column.Name = "clmServer"; column.ReadOnly = true; column.Width = 120; column.ToolTipText = "Server"; column.Visible = false; }
private void AbrePasta_Click(object sender, EventArgs e) { string valor = "0"; string dtemissao = ""; string hremissao = ""; string numerocupom = "0"; string id = ""; string chcanc = ""; System.DateTime varData; decimal varValor; int varNumeroCupom; string varId; string varChCanc; List <DadosCupom> lCupons = new List <DadosCupom>(); Hashtable hashtableCupons = new Hashtable(); //define as propriedades do controle //OpenFileDialog this.ofd1.Multiselect = true; this.ofd1.Title = "Selecionar pasta arquivos SAT"; ofd1.InitialDirectory = @"C:\"; //filtra para exibir somente arquivos de imagens ofd1.Filter = "Images (*.XML)|*.XML|" + "All files (*.*)|*.*"; ofd1.CheckFileExists = true; ofd1.CheckPathExists = true; ofd1.FilterIndex = 2; ofd1.RestoreDirectory = true; ofd1.ReadOnlyChecked = true; ofd1.ShowReadOnly = true; DialogResult dr = this.ofd1.ShowDialog(); if (dr == System.Windows.Forms.DialogResult.OK) { Pasta = Path.GetDirectoryName(ofd1.FileName); DirectoryInfo Dir = new DirectoryInfo(Pasta); FileInfo[] Files = Dir.GetFiles("*", SearchOption.AllDirectories).OrderBy(p => p.CreationTimeUtc).ToArray(); //Array.Sort(Files, (x, y) => Comparer<DateTime>.Default.Compare(x.CreationTime, y.CreationTime)); txtCaminhoXML.Text = Pasta.ToString(); // Le os arquivos selecionados foreach (FileInfo File in Files) { //txtArquivo.Text += arquivo; // cria um PictureBox try { XmlTextReader reader = new XmlTextReader(File.FullName); //ArrayList elementos = new ArrayList(); valor = "0"; dtemissao = ""; hremissao = ""; numerocupom = "0"; id = ""; chcanc = ""; varValor = 0; varNumeroCupom = 0; varId = ""; varChCanc = ""; while ((reader.Read())) { if (reader.NodeType == XmlNodeType.Element) { switch (reader.Name) { case "vCFe": valor = reader.ReadString(); break; case "dEmi": dtemissao = reader.ReadString(); break; case "hEmi": hremissao = reader.ReadString(); break; case "nCFe": numerocupom = reader.ReadString(); break; case "infCFe": id = reader.GetAttribute("Id"); chcanc = reader.GetAttribute("chCanc") ?? ""; break; } } } DateTimeFormatInfo usDtfi = new CultureInfo("pt-PT", false).DateTimeFormat; varData = Convert.ToDateTime(dtemissao.Substring(6, 2) + "/" + dtemissao.Substring(4, 2) + "/" + dtemissao.Substring(0, 4) + " " + hremissao.Substring(0, 2) + ":" + hremissao.Substring(2, 2) + ":" + hremissao.Substring(4, 2), usDtfi); varValor = Convert.ToDecimal(valor, new CultureInfo("en-US")); varNumeroCupom = Convert.ToInt32(numerocupom); varId = Convert.ToString(id); varChCanc = Convert.ToString(chcanc); //lCupons.Add(new DadosCupom(varNumeroCupom, varData, varValor, varId, varChCanc)); if (varChCanc.Length > 0) { if (hashtableCupons.ContainsKey(varChCanc)) { //hashtableCupons[varChCanc] = new DadosCupom(varNumeroCupom, varData, varValor, varId, varChCanc); ((DadosCupom)hashtableCupons[varChCanc]).chcanc = varId; } else { //hashtableCupons.Add(varId, new DadosCupom(varNumeroCupom, varData, varValor, varId, varChCanc)); hashtableCupons.Add(varId, new DadosCupom(0, varData, 0, varChCanc, varId)); } } else { if (hashtableCupons.ContainsKey(varId)) { ((DadosCupom)hashtableCupons[varId]).Numero = varNumeroCupom; ((DadosCupom)hashtableCupons[varId]).Data = varData; ((DadosCupom)hashtableCupons[varId]).Valor = varValor; } else { hashtableCupons.Add(varId, new DadosCupom(varNumeroCupom, varData, varValor, varId, varChCanc)); } } } catch (SecurityException ex) { // O usuário não possui permissão para ler arquivos MessageBox.Show("Erro de segurança Contate o administrador de segurança da rede.\n\n" + "Mensagem : " + ex.Message + "\n\n" + "Detalhes (enviar ao suporte):\n\n" + ex.StackTrace); } catch (Exception ex) { // Não pode carregar a imagem (problemas de permissão) MessageBox.Show(". Você pode não ter permissão para ler o arquivo , ou " + " ele pode estar corrompido.\n\nErro reportado : " + ex.Message); } } //LblTotal.Text = Convert.ToString(lCupons.Sum(item => item.Valor)); LblTotal.Text = "Total: " + Convert.ToString(DadosCupom.Soma(hashtableCupons)); List <DadosCupom> hashToList = new List <DadosCupom>(); foreach (DictionaryEntry de in hashtableCupons) { hashToList.Add((DadosCupom)de.Value); } //Teoricamente ordenar aqui //List<DadosCupom> SortedList = hashToList.OrderBy(o => o.Data).ToList(); SortedList = hashToList.OrderBy(o => o.Data).ToList(); var bindingList = new BindingList <DadosCupom>(SortedList); var source1 = new BindingSource(bindingList, null); dgvHashCupons.DataSource = source1; dgvHashCupons.AutoResizeColumns(); DataGridViewColumnCollection c = dgvHashCupons.Columns; c[0].HeaderText = "N. Cupom"; c[0].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; c[1].HeaderText = "Data hora"; c[1].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; c[2].HeaderText = "Valor"; c[2].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; c[3].HeaderText = "Chave de acesso"; c[3].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; c[4].HeaderText = "Chave de acesso cancelamento"; c[4].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; } }
private void View1_CellContentClick(object sender, DataGridViewCellEventArgs e) { if (!DataGridViewUtil.CheckPerrmisson(this, sender, e)) { return; } foreach (var cItem in curControlList) { DataGridViewColumnCollection ColumnsList = view.Columns; for (int i = 0; i < ColumnsList.Count; i++) { string controlName = "Delivery" + cItem.ToString(); DataGridViewLinkColumn curLink = (DataGridViewLinkColumn)view.Columns[controlName]; DataGridViewColumn curI = ColumnsList[i]; DataTable dt = (DataTable)curI.DataGridView.DataSource; int t = e.ColumnIndex; int p = curI.Index; if (curI.DataPropertyName == controlName && e.ColumnIndex == curI.Index) { if (e.RowIndex >= 0) { sendOutGoodDetailForm form = new sendOutGoodDetailForm(); DataRow item = dt.Rows[e.RowIndex]; GetPfInvoicingPara changePara = new GetPfInvoicingPara(); // ReflectionHelper.CopyProperty(this.pagePara, changePara); // string headList = this.view.MergeColumnNames[0]; //this.view.MergeColumnNames[] changePara.CostumeID = item["CostumeID"].ToString(); changePara.PfCustomerID = item["PfCustomerID" + cItem].ToString(); changePara.SizeName = item["SizeName"].ToString(); changePara.ColorName = item["ColorName"].ToString(); changePara.StartDate = new CJBasic.Date(this.dateTimePicker_Start.Value); changePara.EndDate = new CJBasic.Date(this.dateTimePicker_End.Value); form.ShowDialog(changePara); } } string controlName1 = "Retail" + cItem.ToString(); DataGridViewLinkColumn curLink1 = (DataGridViewLinkColumn)view.Columns[controlName1]; DataGridViewColumn curI1 = ColumnsList[i]; if (curI1.DataPropertyName == controlName1 && e.ColumnIndex == curI1.Index) { if (e.RowIndex >= 0) { CustomSaleGoodDetailForm form = new CustomSaleGoodDetailForm(); DataRow item = dt.Rows[e.RowIndex]; GetPfInvoicingPara changePara = new GetPfInvoicingPara(); // ReflectionHelper.CopyProperty(this.pagePara, changePara); changePara.CostumeID = item["CostumeID"].ToString(); changePara.PfCustomerID = item["PfCustomerID" + cItem].ToString(); changePara.SizeName = item["SizeName"].ToString(); changePara.ColorName = item["ColorName"].ToString(); changePara.StartDate = new CJBasic.Date(this.dateTimePicker_Start.Value); changePara.EndDate = new CJBasic.Date(this.dateTimePicker_End.Value); form.ShowDialog(changePara); } } /* string controlName2 = "PfCustomerStore" + cItem.ToString(); * DataGridViewLinkColumn curLink2 = (DataGridViewLinkColumn)view.Columns[controlName2]; * DataGridViewColumn curI2 = ColumnsList[i]; * if (curI1.DataPropertyName == controlName2 && e.ColumnIndex == curI2.Index) * { * * int j = 0; * }*/ } //if (e.ColumnIndex == curLink.Index) //{ //} //DataGridViewLinkColumn curLink1 = (DataGridViewLinkColumn)view.Columns[controlName]; //if (e.ColumnIndex == curLink1.Index) //{ //} //string controlName2 = "PfCustomerStore" + cItem.ToString(); //DataGridViewLinkColumn curLink2 = (DataGridViewLinkColumn)view.Columns[controlName]; //if (e.ColumnIndex == curLink2.Index) //{ //} } }
public HeaderCollection(DataGridViewColumnCollection cols) { _headerList = new List <HeaderItem>(); BindCollection = cols; _iniLock = false; }
/// <summary> /// Gets the data from the Data Grid and puts it back in the function. /// </summary> /// <param name="destination"> /// The <see cref="PFunction2D"/> object where /// the data will be stored if it succeeds validation. /// </param> /// <returns>True if the operation was successful, False otherwise.</returns> private bool DataGridToPointFunctionData(PFunction2D destination) { PFunction2D tempFunction = new PFunction2D(); // Check if bind was executed. Is it still needed? if (base.m_Project != null) { base.m_Project.ResetExpressionParser(); base.m_Project.CreateSymbols(); #if MONO // If it's running on Mono the event EditingControlShowing doesn't work, so // convert the decimal separators in the data grid before calculating the points. if (Engine.RunningOnMono) { fairmatDataGridViewPointData.ConvertDecimalSeparators(); } #endif DataGridViewRowCollection rows = fairmatDataGridViewPointData.Rows; DataGridViewColumnCollection columns = fairmatDataGridViewPointData.Columns; // Sets the sizes of the function. Additionally check if the row.Count is zero, // in that case it means there are no columns and rows and so must be handled // separately tempFunction.SetSizes(columns.Count, rows.Count > 0 ? rows.Count - 1 : 0); // First load the column headers values for (int x = columns.Count - 1; x >= 0; x--) { // DataGridView in case the header cell is edited to an empty string replaces // its value with DBNull (non existent value). // So, substitute the cell value explicitly with the empty string. if (columns[x].HeaderCell.Value is DBNull || columns[x].HeaderCell.Value == null) { columns[x].HeaderCell.Value = string.Empty; } try { tempFunction[x, -1] = RightValue.ConvertFrom(columns[x].HeaderText, true); } catch (Exception e) { MessageBox.Show("The string " + columns[x].HeaderText + " (column " + "position " + (x + 1) + ") is invalid due to: " + e.Message, DataExchange.ApplicationName); return(false); } } // Then the rows and the cells. for (int y = rows.Count - 2; y >= 0; y--) { // DataGridView in case the header cell is edited to an empty string replaces // its value with DBNull (non existent value). // So, substitute the cell value explicitly with the empty string. if (rows[y].HeaderCell.Value is DBNull || rows[y].HeaderCell.Value == null) { rows[y].HeaderCell.Value = string.Empty; } try { tempFunction[-1, y] = RightValue.ConvertFrom(rows[y].HeaderCell.Value, true); } catch (Exception e) { MessageBox.Show("The string " + rows[y].HeaderCell.Value + " (row " + "position " + (y + 1) + ") is invalid due to: " + e.Message, DataExchange.ApplicationName); return(false); } for (int x = 0; x < columns.Count; x++) { // DataGridView in case the cell is edited to an empty string replaces // its value with DBNull (non existent value). // So, substitute the cell value explicitly with the empty string. if (rows[y].Cells[x].Value is DBNull) { rows[y].Cells[x].Value = string.Empty; } try { tempFunction[x, y] = RightValue.ConvertFrom(rows[y].Cells[x].Value, true); } catch (Exception e) { MessageBox.Show("The string " + rows[y].Cells[x].Value + " (position " + (x + 1) + ", " + (y + 1) + ") " + "is invalid due to: " + e.Message, DataExchange.ApplicationName); return(false); } } } } try { // Save the information about the interpolation/extrapolation tempFunction.Interpolation = this.interpolationExtrapolationControlPF.GetInterpolationType(); tempFunction.LeastSquaresCoefficients = this.interpolationExtrapolationControlPF.LeastSquareCoefficients; tempFunction.Extrapolation = this.interpolationExtrapolationControlPF.GetExtrapolationType(); } catch (Exception e) { MessageBox.Show("The selected functionality is currently not usable: " + e.Message, DataExchange.ApplicationName); return(false); } tempFunction.CopyTo(destination); return(true); }
public ColumnCollection(DataGridViewColumnCollection columnCollection) { _base = columnCollection; }
void RefreshDataView() { string start = rfidCheck_CheckOn.GetFormatDateTimeString(this.dTPStart.Value); string end = rfidCheck_CheckOn.GetFormatDateTimeString(this.dTPEnd.Value); string bj = null; if (this.cmBbj.Text != null && this.cmBbj.Text.Trim() != "") { bj = cmBbj.Text; } string nj = null; if (this.cmBnj.Text != null && this.cmBnj.Text.Trim() != "") { nj = cmBnj.Text; } DataSet ds = rfidCheck_CheckOn.GetStatisticCheckInfoDataSet(start, end, nj, bj); if (null != ds) { this.dataGridView1.DataSource = ds.Tables[0]; } this.dataGridView1.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells); int headerW = this.dataGridView1.RowHeadersWidth; int columnsW = 0; DataGridViewColumnCollection columns = this.dataGridView1.Columns; for (int i = 0; i < columns.Count; i++) { columnsW += columns[i].Width; } if (columnsW + headerW < this.dataGridView1.Width) { int leftTotalWidht = this.dataGridView1.Width - columnsW - headerW; int eachColumnAddedWidth = leftTotalWidht / columns.Count; for (int i = 0; i < columns.Count; i++) { columns[i].Width += eachColumnAddedWidth; } } /* * * List<CheckPerson> records = rfidCheck_CheckOn.GetCheckedPersonList(this.dateTimePicker1.Value.ToShortDateString()); * //List<CheckPerson> records = rfidCheck_CheckOn.GetCheckedPersonList("2011/5/10 9:00:00"); * DataTable table = new DataTable("Records"); * DataColumn column; * DataRow row; * * // Create new DataColumn, set DataType, * // ColumnName and add to DataTable. * column = new DataColumn("学号"); * //column.Unique = true; * // Add the Column to the DataColumnCollection. * table.Columns.Add(column); * column = new DataColumn("姓名"); * // Add the Column to the DataColumnCollection. * table.Columns.Add(column); * column = new DataColumn("考勤时间"); * // Add the Column to the DataColumnCollection. * table.Columns.Add(column); * * for (int i = 0; i < records.Count; i++) * { * row = table.NewRow(); * CheckPerson cp = records[i]; * Person p = cp.person; * row["学号"] = p.id_num; * row["姓名"] = p.name; * row["考勤时间"] = cp.checkDate; * table.Rows.Add(row); * } * this.dataGridView1.DataSource = table; * * this.dataGridView1.Columns[0].Width = 80; * this.dataGridView1.Columns[1].Width = 80; * this.dataGridView1.Columns[2].Width = 120; */ }
/// <summary> /// Copies the selected cells into the clipboard. /// </summary> /// <param name="addErrorInfo">if set to <c>true</c> [add error information].</param> /// <param name="cutLength">if set to <c>true</c> [cut length].</param> /// <param name="alternatingRows">if set to <c>true</c> [alternating rows].</param> /// <param name="columns">The columns.</param> /// <param name="rows">The rows.</param> /// <param name="selectedCells">The selected cells.</param> /// <param name="cancellationToken">The cancellation token.</param> private void CopySelectedCellsIntoClipboard( bool addErrorInfo, bool cutLength, bool alternatingRows, [NotNull] DataGridViewColumnCollection columns, [NotNull] DataGridViewRowCollection rows, [NotNull] DataGridViewSelectedCellCollection selectedCells, CancellationToken cancellationToken) { var buffer = new StringBuilder(); var dataObject = new DataObject(); // If there are multiple cells Add a header and a neat HTML table var sbHtml = new StringBuilder(m_HtmlStyle.TableOpen); var leftCol = int.MaxValue; var rightCol = int.MinValue; var topRow = int.MaxValue; var bottomRow = int.MinValue; foreach (DataGridViewCell cell in selectedCells) { if (cell.OwningColumn.DisplayIndex < leftCol) { leftCol = cell.OwningColumn.DisplayIndex; } if (cell.OwningColumn.DisplayIndex > rightCol) { rightCol = cell.OwningColumn.DisplayIndex; } if (cell.RowIndex < topRow) { topRow = cell.RowIndex; } if (cell.RowIndex > bottomRow) { bottomRow = cell.RowIndex; } } var hasRowError = HasRowErrors(topRow, bottomRow + 1, rows); var visibleColumns = new List <int>(); sbHtml.Append(m_HtmlStyle.TROpenAlt); for (var col = leftCol; col <= rightCol; col++) { foreach (DataGridViewColumn diplayCol in columns) { if (diplayCol.DisplayIndex == col && diplayCol.Visible && diplayCol.HeaderText != ReaderConstants.cErrorField) { visibleColumns.Add(col); sbHtml.Append(HTMLStyle.AddTd(m_HtmlStyle.TH, diplayCol.HeaderText)); if (buffer.Length > 0) { buffer.Append('\t'); } buffer.Append(EscapeTab(diplayCol.HeaderText)); break; } } } if (hasRowError && addErrorInfo) { sbHtml.Append(HTMLStyle.AddTd(m_HtmlStyle.TH, c_ErrorInfo)); buffer.Append('\t'); buffer.Append(c_ErrorInfo); } sbHtml.AppendLine(m_HtmlStyle.TRClose); buffer.AppendLine(); var trAlternate = false; var lastRefresh = DateTime.Now; for (var row = topRow; row <= bottomRow; row++) { if (rows[row].IsNewRow) { continue; } if (cancellationToken.IsCancellationRequested) { return; } sbHtml.Append(trAlternate ? m_HtmlStyle.TROpenAlt : m_HtmlStyle.TROpen); if (alternatingRows) { trAlternate = !trAlternate; } var written = false; if (cancellationToken.IsCancellationRequested) { return; } for (var col = leftCol; col <= rightCol; col++) { if (!visibleColumns.Contains(col)) { continue; } foreach (DataGridViewCell cell in selectedCells) { if (cell.RowIndex != row) { continue; } if (cell.OwningColumn.DisplayIndex != col) { continue; } AddCell(cell, buffer, sbHtml, col > leftCol, addErrorInfo, cutLength, m_HtmlStyle); written = true; break; } if (written) { continue; } buffer.Append('\t'); sbHtml.Append(m_HtmlStyle.TDEmpty); } AppendRowError(buffer, sbHtml, rows[row].ErrorText, addErrorInfo && hasRowError, m_HtmlStyle); sbHtml.AppendLine(m_HtmlStyle.TRClose); buffer.AppendLine(); if (!((DateTime.Now - lastRefresh).TotalSeconds > 0.2)) { continue; } lastRefresh = DateTime.Now; Extensions.ProcessUIElements(); } sbHtml.AppendLine(m_HtmlStyle.TableClose); dataObject.SetData(DataFormats.Html, true, m_HtmlStyle.ConvertToHtmlFragment(sbHtml.ToString())); dataObject.SetData(DataFormats.Text, true, buffer.ToString()); dataObject.SetClipboard(); }
/// <summary> /// Copies all cells to the clipboard /// </summary> /// <param name="addErrorInfo">if set to <c>true</c> [add error information].</param> /// <param name="cutLength">if set to <c>true</c> [cut length].</param> /// <param name="alternatingRows">if set to <c>true</c> [alternating rows].</param> /// <param name="columns">The columns.</param> /// <param name="rows">The rows.</param> /// <param name="cancellationToken">The cancellation token.</param> private void CopyAllCellsIntoClipboard( bool addErrorInfo, bool cutLength, bool alternatingRows, [NotNull] DataGridViewColumnCollection columns, [NotNull] DataGridViewRowCollection rows, CancellationToken cancellationToken) { var buffer = new StringBuilder(); var sbHtml = new StringBuilder(m_HtmlStyle.TableOpen); sbHtml.Append(m_HtmlStyle.TROpenAlt); var first = true; var visibleColumns = new SortedDictionary <int, DataGridViewColumn>(); foreach (DataGridViewColumn c in columns) { // Do not include the error field it will be retrieved from the error collection with nice coloring if (c.Visible && c.HeaderText != ReaderConstants.cErrorField) { visibleColumns.Add(c.DisplayIndex, c); } } var hasRowError = HasRowErrors(0, rows.Count, rows); foreach (var col in visibleColumns.Values) { var headerText = col.HeaderText; sbHtml.Append(HTMLStyle.AddTd(m_HtmlStyle.TH, headerText)); if (!first) { buffer.Append('\t'); } else { first = false; } buffer.Append(EscapeTab(headerText)); } if (hasRowError && addErrorInfo) { sbHtml.Append(HTMLStyle.AddTd(m_HtmlStyle.TH, c_ErrorInfo)); buffer.Append('\t'); buffer.Append(c_ErrorInfo); } sbHtml.AppendLine(m_HtmlStyle.TRClose); buffer.AppendLine(); var trAlternate = false; var lastRefresh = DateTime.Now; for (var row = 0; row < rows.Count; row++) { if (rows[row].IsNewRow) { break; } sbHtml.Append(trAlternate ? m_HtmlStyle.TROpenAlt : m_HtmlStyle.TROpen); if (alternatingRows) { trAlternate = !trAlternate; } first = true; foreach (var col in visibleColumns.Values) { if (cancellationToken.IsCancellationRequested) { return; } var cell = rows[row].Cells[col.Index]; AddCell(cell, buffer, sbHtml, !first, addErrorInfo, cutLength, m_HtmlStyle); first = false; } AppendRowError(buffer, sbHtml, rows[row].ErrorText, addErrorInfo && hasRowError, m_HtmlStyle); sbHtml.AppendLine(m_HtmlStyle.TRClose); buffer.AppendLine(); if (!((DateTime.Now - lastRefresh).TotalSeconds > 0.2)) { continue; } lastRefresh = DateTime.Now; Extensions.ProcessUIElements(); } sbHtml.AppendLine(m_HtmlStyle.TableClose); var dataObject = new DataObject(); dataObject.SetData(DataFormats.Html, true, m_HtmlStyle.ConvertToHtmlFragment(sbHtml.ToString())); dataObject.SetData(DataFormats.Text, true, buffer.ToString()); dataObject.SetClipboard(); }
public ConditionsForm(DataGridViewColumnCollection columns) { InitializeComponent(); conditions = new List <Condition>(); Initialize(columns); }
public static bool ValidName(string name, DataGridViewColumnCollection columns, IContainer container, INameCreationService nameCreationService, DataGridViewColumnCollection liveColumns, bool allowDuplicateNameInLiveColumnCollection) { if (columns.Contains(name)) { return(false); } if (((container != null) && (container.Components[name] != null)) && ((!allowDuplicateNameInLiveColumnCollection || (liveColumns == null)) || !liveColumns.Contains(name))) { return(false); } return(((nameCreationService == null) || nameCreationService.IsValidName(name)) || ((allowDuplicateNameInLiveColumnCollection && (liveColumns != null)) && liveColumns.Contains(name))); }
public DisplayedColumns(DataGridViewColumnCollection columns) { InitializeComponent(); Columns = columns; }
public static bool ValidName(string name, DataGridViewColumnCollection columns, IContainer container, INameCreationService nameCreationService, DataGridViewColumnCollection liveColumns, bool allowDuplicateNameInLiveColumnCollection, out string errorString) { if (columns.Contains(name)) { errorString = "DataGridViewDuplicateColumnName " + name;// SR.GetString("DataGridViewDuplicateColumnName", new object[] { name }); return(false); } if (((container != null) && (container.Components[name] != null)) && ((!allowDuplicateNameInLiveColumnCollection || (liveColumns == null)) || !liveColumns.Contains(name))) { errorString = "DesignerHostDuplicateName " + name;//SR.GetString("DesignerHostDuplicateName", new object[] { name }); return(false); } if (((nameCreationService != null) && !nameCreationService.IsValidName(name)) && ((!allowDuplicateNameInLiveColumnCollection || (liveColumns == null)) || !liveColumns.Contains(name))) { errorString = "CodeDomDesignerLoaderInvalidIdentifier " + name; // SR.GetString("CodeDomDesignerLoaderInvalidIdentifier", new object[] { name }); return(false); } errorString = string.Empty; return(true); }
/// <summary> /// Наполнить колонки на основе типа. /// </summary> /// <param name="columns">Коллекция колонок</param> /// <param name="type">Тип, размеченный аттрибутами</param> public static void ParseAllPropsIntoColumns(DataGridViewColumnCollection columns, Type type) { PropertyInfo[] props = type.GetProperties(); ArrayList propsNames = new ArrayList(props.Length); foreach (PropertyInfo prop in props) { PropertyOrderAttribute att = (PropertyOrderAttribute)Attribute.GetCustomAttribute(prop, typeof(PropertyOrderAttribute)); if (att != null) { propsNames.Add(new PropertyOrderPair(prop.Name, att.Order)); } else { propsNames.Add(new PropertyOrderPair(prop.Name, 0)); } } propsNames.Sort(); DataGridViewCell cell = new DataGridViewTextBoxCell(); for (int i = 0; i < propsNames.Count; ++i) { PropertyInfo prop = type.GetProperty((propsNames[i] as PropertyOrderPair).Name); ColumnNameAttribute attName = (ColumnNameAttribute)Attribute.GetCustomAttribute(prop, typeof(ColumnNameAttribute)); if (attName != null) { DataGridViewColumn column = new DataGridViewColumn(); column.Name = attName.ColumnName; column.CellTemplate = cell; ColumnWidthAttribute attWidth = (ColumnWidthAttribute)Attribute.GetCustomAttribute(prop, typeof(ColumnWidthAttribute)); if (attWidth != null) { column.Width = attWidth.ColumnWidth; } else { column.Width = 100; } ColumnTextAttribute attText = (ColumnTextAttribute)Attribute.GetCustomAttribute(prop, typeof(ColumnTextAttribute)); if (attText != null) { column.HeaderText = attText.ColumnText; } else { column.HeaderText = attName.ColumnName; } if (prop.GetSetMethod() != null) { ReadOnlyAttribute attRO = (ReadOnlyAttribute)Attribute.GetCustomAttribute(prop, typeof(ReadOnlyAttribute)); if (attRO != null) { column.ReadOnly = attRO.IsReadOnly; } } ContentAlignmentAttribute attAl = (ContentAlignmentAttribute)Attribute.GetCustomAttribute(prop, typeof(ContentAlignmentAttribute)); if (attAl != null) { column.HeaderCell.Style.Alignment = (DataGridViewContentAlignment)(attAl.Alignment); } columns.Add(column); } } }
public override bool ReceiveDialogMessage(DialogMessage message) { if (customizer == null) { customizer = (Properties)base.CustomizationObject; reportStructure = (ReportStructure)customizer.Get("Generator"); } if (message == DialogMessage.Activated) { this.model = reportStructure.CreateAndFillReportModel(); this.resultDataSet = FillGrid(); if (this.resultDataSet != null) { this.grdQuery.DataSource = this.resultDataSet.Tables[0]; foreach (DataGridViewColumn dd in this.grdQuery.Columns) { DataGridViewColumnHeaderCheckBoxCell cb = new DataGridViewColumnHeaderCheckBoxCell(); cb.CheckBoxAlignment = HorizontalAlignment.Right; cb.Checked = true; dd.HeaderCell = cb; dd.SortMode = DataGridViewColumnSortMode.NotSortable; } this.grdQuery.AllowUserToOrderColumns = true; } base.EnableNext = true; base.EnableFinish = true; } else if (message == DialogMessage.Finish) { if (this.resultDataSet != null) { // check reordering of columns DataGridViewColumn[] displayCols; DataGridViewColumnCollection dc = this.grdQuery.Columns; displayCols = new DataGridViewColumn[dc.Count]; for (int i = 0; i < dc.Count; i++) { if (dc[i].Visible) { displayCols[dc[i].DisplayIndex] = dc[i]; } } // only checked columns are used in the report ReportItemCollection sourceItems = WizardHelper.DataItemsFromDataSet(this.resultDataSet); AvailableFieldsCollection abstractColumns = WizardHelper.AbstractColumnsFromDataSet(this.resultDataSet); ReportItemCollection destItems = new ReportItemCollection(); foreach (DataGridViewColumn cc in displayCols) { DataGridViewColumnHeaderCheckBoxCell hc = (DataGridViewColumnHeaderCheckBoxCell)cc.HeaderCell; if (hc.Checked) { BaseReportItem br = (BaseReportItem)sourceItems.Find(cc.HeaderText); destItems.Add(br); } } reportStructure.ReportItemCollection.AddRange(destItems); if ((this.sqlParamsCollection != null) && (this.sqlParamsCollection.Count > 0)) { reportStructure.SqlQueryParameters.AddRange(sqlParamsCollection); } if (abstractColumns != null) { reportStructure.AvailableFieldsCollection.AddRange(abstractColumns); } } base.EnableNext = true; base.EnableFinish = true; } return(true); }
void helper_RequestCompleted_getProductInfoForInventoryList(object o) { deleControlInvoke dele = delegate(object oProductList) { string strProduct = (string)oProductList; object olist = fastJSON.JSON.Instance.ToObjectList(strProduct, typeof(List <Product>), typeof(Product)); DataTable dt = null; if (this.dgvProductInfo.DataSource == null) { dt = new DataTable(); dt.Columns.Add("产品编号", typeof(string)); dt.Columns.Add("产品名称", typeof(string)); dt.Columns.Add("生产日期", typeof(string)); dt.Columns.Add("产品类别", typeof(string)); dt.Columns.Add("产品备注信息", typeof(string)); } else { dt = (DataTable)dgvProductInfo.DataSource; } dt.Rows.Clear(); foreach (Product p in (List <Product>)olist) { dt.Rows.Add(new object[] { p.productID, p.productName, p.produceDate, p.productCategory, p.descript }); } dgvProductInfo.DataSource = dt; if (!this.dgvProductInfo.Columns.Contains("checkColumn")) { DataGridViewCheckBoxColumn cbc = CreateCheckBoxColumn(); dgvProductInfo.Columns.Insert(0, cbc); } foreach (DataGridViewRow vr in this.dgvProductInfo.Rows) { DataGridViewCheckBoxCell cbc = (DataGridViewCheckBoxCell)vr.Cells[0]; cbc.Value = LightStatus.TurnedOff; } this.dgvProductInfo.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells); int headerW = this.dgvProductInfo.RowHeadersWidth; int columnsW = 0; DataGridViewColumnCollection columns = this.dgvProductInfo.Columns; columns[0].Width = 50; for (int i = 0; i < columns.Count; i++) { columnsW += columns[i].Width; } if (columnsW + headerW < this.dgvProductInfo.Width) { int leftTotalWidht = this.dgvProductInfo.Width - columnsW - headerW; int eachColumnAddedWidth = leftTotalWidht / (columns.Count - 1); for (int i = 1; i < columns.Count; i++) { columns[i].Width += eachColumnAddedWidth; } } }; this.Invoke(dele, o); }
public void RefreshOrderInfo() { DataTable dt = null; if (this.dgvOrderInfo.DataSource == null) { dt = new DataTable(); dt.Columns.Add("产品名称", typeof(string)); dt.Columns.Add("订购数量", typeof(string)); } else { dt = (DataTable)dgvOrderInfo.DataSource; } dgvOrderInfo.DataSource = dt; if (!this.dgvOrderInfo.Columns.Contains("checkColumn")) { DataGridViewCheckBoxColumn cc = new DataGridViewCheckBoxColumn(); cc.HeaderText = ""; cc.Name = "checkColumn"; cc.Width = 50; dgvOrderInfo.Columns.Insert(0, cc); } this.dgvOrderInfo.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells); int headerW = this.dgvOrderInfo.RowHeadersWidth; int columnsW = 0; DataGridViewColumnCollection columns = this.dgvOrderInfo.Columns; columns[0].Width = 50; for (int i = 0; i < columns.Count; i++) { columnsW += columns[i].Width; } if (columnsW + headerW < this.dgvOrderInfo.Width) { int leftTotalWidht = this.dgvOrderInfo.Width - columnsW - headerW; int eachColumnAddedWidth = leftTotalWidht / (columns.Count - 1); for (int i = 1; i < columns.Count; i++) { columns[i].Width += eachColumnAddedWidth; } } string jsonString = string.Empty; HttpWebConnect helper = new HttpWebConnect(); helper.RequestCompleted += new deleGetRequestObject(helper_RequestCompleted_getAllOrders); string url = RestUrl.getAllOrders; helper.TryPostData(url, jsonString); return; //DataTable table = new DataTable("order"); //DataColumn column; //DataRow row; //// Create new DataColumn, set DataType, //// ColumnName and add to DataTable. //column = new DataColumn("产品编号"); //table.Columns.Add(column); //column = new DataColumn("名称"); //table.Columns.Add(column); //column = new DataColumn("数量"); //table.Columns.Add(column); //for (int i = 0; i < 10; i++) //{ // row = table.NewRow(); // row["产品编号"] = "001" + i.ToString(); // row["名称"] = "john" + i.ToString(); // row["数量"] = i.ToString(); // table.Rows.Add(row); //} DataTable table = null; table = ctlOrder.GetOrderTable(); this.dgvOrderInfo.DataSource = table; }
///<summary> ///printUrikakeZan ///印刷ダイアログ ///</summary> private void printUrikakeZan() { //グリッドに表示されていない場合 if (gridTokuisaki.Rows.Count == 0) { return; } //PDF作成後の入れ物 string strFile = ""; //データの取り出し用 DataTable dtPrintData = new DataTable(); //列情報を取得 DataGridViewColumnCollection cols = gridTokuisaki.Columns; //行情報を取得 DataGridViewRowCollection rows = gridTokuisaki.Rows; //取引先経理情報登録時の情報 List <string> lstTorihiki = new List <string>(); //年月日の日付フォーマット後を入れる用 string strYMDformat = ""; this.Cursor = Cursors.WaitCursor; //空チェック(開始得意先コード) if (StringUtl.blIsEmpty(lblsetTokuisakiCdopen.CodeTxtText) == false) { this.Cursor = Cursors.Default; // メッセージボックスの処理、項目が空の場合のウィンドウ(OK) BaseMessageBox basemessagebox = new BaseMessageBox(this, CommonTeisu.TEXT_INPUT, "項目が空です。\r\n日付を入力してください。", CommonTeisu.BTN_OK, CommonTeisu.DIAG_ERROR); basemessagebox.ShowDialog(); lblsetTokuisakiCdopen.Focus(); return; } //空チェック(終了得意先コード) if (StringUtl.blIsEmpty(lblsetTokuisakiCdclose.CodeTxtText) == false) { this.Cursor = Cursors.Default; // メッセージボックスの処理、項目が空の場合のウィンドウ(OK) BaseMessageBox basemessagebox = new BaseMessageBox(this, CommonTeisu.TEXT_INPUT, "項目が空です。\r\n日付を入力してください。", CommonTeisu.BTN_OK, CommonTeisu.DIAG_ERROR); basemessagebox.ShowDialog(); lblsetTokuisakiCdclose.Focus(); return; } ////パワーユーザーの場合 //if ("1".Equals(this.etsuranFlg)) //{ // //空チェック(終了得意先コード) // if (StringUtl.blIsEmpty(lblsetTokuisakiCdclose.CodeTxtText) == false) // { // this.Cursor = Cursors.Default; // // メッセージボックスの処理、項目が空の場合のウィンドウ(OK) // BaseMessageBox basemessagebox = new BaseMessageBox(this, CommonTeisu.TEXT_INPUT, "項目が空です。\r\n日付を入力してください。", CommonTeisu.BTN_OK, CommonTeisu.DIAG_ERROR); // basemessagebox.ShowDialog(); // lblsetTokuisakiCdclose.Focus(); // return; // } //} //日付フォーマット生成、およびチェック strYMDformat = txtYMopen.chkDateYMDataFormat(txtYMopen.Text); //開始年月日の日付チェック if (strYMDformat == "") { this.Cursor = Cursors.Default; // メッセージボックスの処理、項目が日付でない場合のウィンドウ(OK) BaseMessageBox basemessagebox = new BaseMessageBox(this, CommonTeisu.TEXT_INPUT, "入力された日付が正しくありません。", CommonTeisu.BTN_OK, CommonTeisu.DIAG_ERROR); basemessagebox.ShowDialog(); txtYMopen.Focus(); return; } else { txtYMopen.Text = strYMDformat; } //初期化 strYMDformat = ""; //日付フォーマット生成、およびチェック strYMDformat = txtYMclose.chkDateYMDataFormat(txtYMclose.Text); //終了年月日の日付チェック if (strYMDformat == "") { this.Cursor = Cursors.Default; // メッセージボックスの処理、項目が日付でない場合のウィンドウ(OK) BaseMessageBox basemessagebox = new BaseMessageBox(this, CommonTeisu.TEXT_INPUT, "入力された日付が正しくありません。", CommonTeisu.BTN_OK, CommonTeisu.DIAG_ERROR); basemessagebox.ShowDialog(); txtYMclose.Focus(); return; } else { txtYMclose.Text = strYMDformat; } this.Cursor = Cursors.Default; //年月日が空の場合 if (txtYMopen.blIsEmpty() == false) { // メッセージボックスの処理、項目が空の場合のウィンドウ(OK) BaseMessageBox basemessagebox = new BaseMessageBox(this, CommonTeisu.TEXT_INPUT, "項目が空です。\r\n日付を入力してください。 ", CommonTeisu.BTN_OK, CommonTeisu.DIAG_ERROR); basemessagebox.ShowDialog(); txtYMopen.Focus(); return; } //年月日が空の場合 if (txtYMclose.blIsEmpty() == false) { // メッセージボックスの処理、項目が空の場合のウィンドウ(OK) BaseMessageBox basemessagebox = new BaseMessageBox(this, CommonTeisu.TEXT_INPUT, "項目が空です。\r\n日付を入力してください。 ", CommonTeisu.BTN_OK, CommonTeisu.DIAG_ERROR); basemessagebox.ShowDialog(); txtYMclose.Focus(); return; } //検索開始得意先コードのチェック if (lblsetTokuisakiCdopen.chkTxtTorihikisaki() == true) { lblsetTokuisakiCdopen.Focus(); return; } //検索終了得意先コードのチェック if (lblsetTokuisakiCdclose.chkTxtTorihikisaki() == true) { lblsetTokuisakiCdclose.Focus(); return; } ////パワーユーザーの場合 //if ("1".Equals(this.etsuranFlg)) //{ // //スルー //} //else //{ // //データチェック(年月度が同じの場合) // if (txtYMopen.Text == txtYMclose.Text) // { // //一か月単位は出来ないメッセージ(OK) // BaseMessageBox basemessagebox = new BaseMessageBox(this, CommonTeisu.TEXT_VIEW, "1ケ月単位は指定できません。", CommonTeisu.BTN_OK, CommonTeisu.DIAG_ERROR); // basemessagebox.ShowDialog(); // txtYMopen.Focus(); // return; // } //} this.Cursor = Cursors.WaitCursor; DataTable dtGridViewTokusaki = new DataTable(); List <string> lstStringViewData = new List <string>(); lstStringViewData.Add(lblsetTokuisakiCdopen.CodeTxtText); lstStringViewData.Add(lblsetTokuisakiCdclose.CodeTxtText); ////パワーユーザーの場合 //if ("1".Equals(this.etsuranFlg)) //{ // lstStringViewData.Add(lblsetTokuisakiCdclose.CodeTxtText); //} //else //{ // lstStringViewData.Add(lblsetTokuisakiCdopen.CodeTxtText); //} string strShuturyoku = ""; //出力順のラジオボタン判定 if (radShuturyoku.radbtn0.Checked == true) { strShuturyoku = "Tokuisaki"; } else { strShuturyoku = "Hurigana"; } lstStringViewData.Add(DateTime.Parse(txtYMopen.Text).ToString("yyyy/MM/dd")); lstStringViewData.Add(DateTime.Parse(txtYMclose.Text).ToString("yyyy/MM/dd")); lstStringViewData.Add(strShuturyoku); C0520_KaikakekinZandakaIchiranKakunin_B kaikakekakuninB = new C0520_KaikakekinZandakaIchiranKakunin_B(); try { dtPrintData = kaikakekakuninB.getPrintData(lstStringViewData); this.Cursor = Cursors.Default; //初期値 Common.Form.PrintForm pf = new Common.Form.PrintForm(this, "", CommonTeisu.SIZE_A4, YOKO); pf.ShowDialog(this); //プレビューの場合 if (this.printFlg == CommonTeisu.ACTION_PREVIEW) { //現在時間と使用者PCユーザー名を確保 lstTorihiki.Add(DateTime.Now.ToString()); lstTorihiki.Add(SystemInformation.UserName); this.Cursor = Cursors.WaitCursor; //結果セットをレコードセットに strFile = kaikakekakuninB.dbToPdf(dtPrintData, lstTorihiki); this.Cursor = Cursors.Default; //印刷できなかった場合 if (strFile == "") { //印刷時エラーメッセージ(OK) BaseMessageBox basemessagebox = new BaseMessageBox(this, "印刷", "印刷時エラーです。", CommonTeisu.BTN_OK, CommonTeisu.DIAG_ERROR); basemessagebox.ShowDialog(); return; } // プレビュー pf.execPreview(strFile); } // 一括印刷の場合 else if (this.printFlg == CommonTeisu.ACTION_PRINT) { //現在時間と使用者PCユーザー名を確保 lstTorihiki.Add(DateTime.Now.ToString()); lstTorihiki.Add(SystemInformation.UserName); this.Cursor = Cursors.WaitCursor; //結果セットをレコードセットに strFile = kaikakekakuninB.dbToPdf(dtPrintData, lstTorihiki); this.Cursor = Cursors.Default; //印刷できなかった場合 if (strFile == "") { //印刷時エラーメッセージ(OK) BaseMessageBox basemessagebox = new BaseMessageBox(this, "印刷", "印刷時エラーです。", CommonTeisu.BTN_OK, CommonTeisu.DIAG_ERROR); basemessagebox.ShowDialog(); return; } // 一括印刷 pf.execPrint(null, strFile, CommonTeisu.SIZE_A4, CommonTeisu.YOKO, true); } } catch (Exception ex) { this.Cursor = Cursors.Default; //データロギング new CommonException(ex); //例外発生メッセージ(OK) BaseMessageBox basemessagebox = new BaseMessageBox(this, CommonTeisu.TEXT_ERROR, CommonTeisu.LABEL_ERROR_MESSAGE, CommonTeisu.BTN_OK, CommonTeisu.DIAG_ERROR); basemessagebox.ShowDialog(); return; } }
/// <summary> /// Settings the read only for schedule grid. /// </summary> private void SettingReadOnlyForScheduleGrid() { try { ScheduleSearchDataGridView.ScrollBars = ScrollBars.Both; DataGridViewColumnCollection columns = this.ScheduleSearchDataGridView.Columns; columns[this.scheduleSelectionData.GetScheduleSelection.ScheduleIDColumn.ColumnName].ReadOnly = true; columns[this.scheduleSelectionData.GetScheduleSelection.ScheduleNumberColumn.ColumnName].ReadOnly = true; columns[this.scheduleSelectionData.GetScheduleSelection.RollYearColumn.ColumnName].ReadOnly = true; columns[this.scheduleSelectionData.GetScheduleSelection.StreetAddressColumn.ColumnName].ReadOnly = true; columns[this.scheduleSelectionData.GetScheduleSelection.FilingDateColumn.ColumnName].ReadOnly = true; columns[this.scheduleSelectionData.GetScheduleSelection.NAICSColumn.ColumnName].ReadOnly = true; columns[this.scheduleSelectionData.GetScheduleSelection.DescriptionColumn.ColumnName].ReadOnly = true; columns[this.scheduleSelectionData.GetScheduleSelection.BuisnessNameColumn.ColumnName].ReadOnly = true; columns[this.scheduleSelectionData.GetScheduleSelection.PropertyTypeColumn.ColumnName].ReadOnly = true; columns[this.scheduleSelectionData.GetScheduleSelection.ParcelNumberColumn.ColumnName].ReadOnly = true; columns[this.scheduleSelectionData.GetScheduleSelection.StatementNumberColumn.ColumnName].ReadOnly = true; columns[this.scheduleSelectionData.GetScheduleSelection.OwnerIDColumn.ColumnName].ReadOnly = true; columns[this.scheduleSelectionData.GetScheduleSelection.OwnerNameColumn.ColumnName].ReadOnly = true; columns[this.scheduleSelectionData.GetScheduleSelection.LegalColumn.ColumnName].ReadOnly = true; columns[this.scheduleSelectionData.GetScheduleSelection.DistrictColumn.ColumnName].ReadOnly = true; columns[this.scheduleSelectionData.GetScheduleSelection.ScheduleIDColumn.ColumnName].DefaultCellStyle.Alignment = DataGridViewContentAlignment.TopLeft; columns[this.scheduleSelectionData.GetScheduleSelection.ScheduleNumberColumn.ColumnName].DefaultCellStyle.Alignment = DataGridViewContentAlignment.TopLeft; columns[this.scheduleSelectionData.GetScheduleSelection.RollYearColumn.ColumnName].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; columns[this.scheduleSelectionData.GetScheduleSelection.StreetAddressColumn.ColumnName].DefaultCellStyle.Alignment = DataGridViewContentAlignment.TopLeft; columns[this.scheduleSelectionData.GetScheduleSelection.FilingDateColumn.ColumnName].DefaultCellStyle.Alignment = DataGridViewContentAlignment.TopLeft; columns[this.scheduleSelectionData.GetScheduleSelection.NAICSColumn.ColumnName].DefaultCellStyle.Alignment = DataGridViewContentAlignment.TopLeft; columns[this.scheduleSelectionData.GetScheduleSelection.DescriptionColumn.ColumnName].DefaultCellStyle.Alignment = DataGridViewContentAlignment.TopLeft; columns[this.scheduleSelectionData.GetScheduleSelection.BuisnessNameColumn.ColumnName].DefaultCellStyle.Alignment = DataGridViewContentAlignment.TopLeft; columns[this.scheduleSelectionData.GetScheduleSelection.PropertyTypeColumn.ColumnName].DefaultCellStyle.Alignment = DataGridViewContentAlignment.TopLeft; columns[this.scheduleSelectionData.GetScheduleSelection.ParcelNumberColumn.ColumnName].DefaultCellStyle.Alignment = DataGridViewContentAlignment.TopLeft; columns[this.scheduleSelectionData.GetScheduleSelection.StatementNumberColumn.ColumnName].DefaultCellStyle.Alignment = DataGridViewContentAlignment.TopLeft; columns[this.scheduleSelectionData.GetScheduleSelection.OwnerIDColumn.ColumnName].DefaultCellStyle.Alignment = DataGridViewContentAlignment.TopLeft; columns[this.scheduleSelectionData.GetScheduleSelection.OwnerNameColumn.ColumnName].DefaultCellStyle.Alignment = DataGridViewContentAlignment.TopLeft; columns[this.scheduleSelectionData.GetScheduleSelection.LegalColumn.ColumnName].DefaultCellStyle.Alignment = DataGridViewContentAlignment.TopLeft; columns[this.scheduleSelectionData.GetScheduleSelection.DistrictColumn.ColumnName].DefaultCellStyle.Alignment = DataGridViewContentAlignment.TopLeft; columns[this.scheduleSelectionData.GetScheduleSelection.ScheduleIDColumn.ColumnName].SortMode = DataGridViewColumnSortMode.Programmatic; columns[this.scheduleSelectionData.GetScheduleSelection.ScheduleNumberColumn.ColumnName].SortMode = DataGridViewColumnSortMode.Programmatic; columns[this.scheduleSelectionData.GetScheduleSelection.RollYearColumn.ColumnName].SortMode = DataGridViewColumnSortMode.Programmatic; columns[this.scheduleSelectionData.GetScheduleSelection.StreetAddressColumn.ColumnName].SortMode = DataGridViewColumnSortMode.Programmatic; columns[this.scheduleSelectionData.GetScheduleSelection.FilingDateColumn.ColumnName].SortMode = DataGridViewColumnSortMode.Programmatic; columns[this.scheduleSelectionData.GetScheduleSelection.NAICSColumn.ColumnName].SortMode = DataGridViewColumnSortMode.Programmatic; columns[this.scheduleSelectionData.GetScheduleSelection.DescriptionColumn.ColumnName].SortMode = DataGridViewColumnSortMode.Programmatic; columns[this.scheduleSelectionData.GetScheduleSelection.BuisnessNameColumn.ColumnName].SortMode = DataGridViewColumnSortMode.Programmatic; columns[this.scheduleSelectionData.GetScheduleSelection.PropertyTypeColumn.ColumnName].SortMode = DataGridViewColumnSortMode.Programmatic; columns[this.scheduleSelectionData.GetScheduleSelection.ParcelNumberColumn.ColumnName].SortMode = DataGridViewColumnSortMode.Programmatic; columns[this.scheduleSelectionData.GetScheduleSelection.StatementNumberColumn.ColumnName].SortMode = DataGridViewColumnSortMode.Programmatic; columns[this.scheduleSelectionData.GetScheduleSelection.OwnerIDColumn.ColumnName].SortMode = DataGridViewColumnSortMode.Programmatic; columns[this.scheduleSelectionData.GetScheduleSelection.OwnerNameColumn.ColumnName].SortMode = DataGridViewColumnSortMode.Programmatic; columns[this.scheduleSelectionData.GetScheduleSelection.LegalColumn.ColumnName].SortMode = DataGridViewColumnSortMode.Programmatic; columns[this.scheduleSelectionData.GetScheduleSelection.DistrictColumn.ColumnName].SortMode = DataGridViewColumnSortMode.Programmatic; columns[this.scheduleSelectionData.GetScheduleSelection.RollYearColumn.ColumnName].HeaderText = "Roll Year"; columns[this.scheduleSelectionData.GetScheduleSelection.FilingDateColumn.ColumnName].HeaderText = "Filling Date"; columns[this.scheduleSelectionData.GetScheduleSelection.BuisnessNameColumn.ColumnName].HeaderText = "Business Name"; columns[this.scheduleSelectionData.GetScheduleSelection.PropertyTypeColumn.ColumnName].HeaderText = "Property Type"; columns[this.scheduleSelectionData.GetScheduleSelection.BuisnessNameColumn.ColumnName].Width = 150; } catch (Exception ex) { ExceptionManager.ManageException(ex, ExceptionManager.ActionType.CloseCurrentForm, this.ParentForm); } }
///<summary> /// F10:Excel出力 ///</summary> private void exportXls() { // SaveFileDialogクラスのインスタンスを作成 SaveFileDialog sfd = new SaveFileDialog(); // ファイル名の指定 sfd.FileName = "買掛金残高一覧確認_" + DateTime.Now.ToString("yyyy_MM_dd_HH_mm_ss") + ".xlsx"; // デフォルトパス取得(デスクトップ) string Init_dir = Environment.GetFolderPath(Environment.SpecialFolder.Desktop); //はじめに表示されるフォルダを指定する sfd.InitialDirectory = Init_dir; // ファイルフィルタの設定 sfd.Filter = "すべてのファイル(*.*)|*.*"; if (sfd.ShowDialog() == DialogResult.OK) { // グリッドに表示されていない場合 if (gridTokuisaki.Rows.Count == 0) { return; } //データの取り出し用 DataTable dtPrintData = new DataTable(); //列情報を取得 DataGridViewColumnCollection cols = gridTokuisaki.Columns; //行情報を取得 DataGridViewRowCollection rows = gridTokuisaki.Rows; //取引先経理情報登録時の情報 List <string> lstTorihiki = new List <string>(); //年月日の日付フォーマット後を入れる用 string strYMDformat = ""; this.Cursor = Cursors.WaitCursor; //空チェック(開始得意先コード) if (StringUtl.blIsEmpty(lblsetTokuisakiCdopen.CodeTxtText) == false) { this.Cursor = Cursors.Default; // メッセージボックスの処理、項目が空の場合のウィンドウ(OK) BaseMessageBox basemessagebox = new BaseMessageBox(this, CommonTeisu.TEXT_INPUT, "項目が空です。\r\n日付を入力してください。", CommonTeisu.BTN_OK, CommonTeisu.DIAG_ERROR); basemessagebox.ShowDialog(); lblsetTokuisakiCdopen.Focus(); return; } //空チェック(終了得意先コード) if (StringUtl.blIsEmpty(lblsetTokuisakiCdclose.CodeTxtText) == false) { this.Cursor = Cursors.Default; // メッセージボックスの処理、項目が空の場合のウィンドウ(OK) BaseMessageBox basemessagebox = new BaseMessageBox(this, CommonTeisu.TEXT_INPUT, "項目が空です。\r\n日付を入力してください。", CommonTeisu.BTN_OK, CommonTeisu.DIAG_ERROR); basemessagebox.ShowDialog(); lblsetTokuisakiCdclose.Focus(); return; } //日付フォーマット生成、およびチェック strYMDformat = txtYMopen.chkDateYMDataFormat(txtYMopen.Text); //開始年月日の日付チェック if (strYMDformat == "") { this.Cursor = Cursors.Default; // メッセージボックスの処理、項目が日付でない場合のウィンドウ(OK) BaseMessageBox basemessagebox = new BaseMessageBox(this, CommonTeisu.TEXT_INPUT, "入力された日付が正しくありません。", CommonTeisu.BTN_OK, CommonTeisu.DIAG_ERROR); basemessagebox.ShowDialog(); txtYMopen.Focus(); return; } else { txtYMopen.Text = strYMDformat; } //初期化 strYMDformat = ""; //日付フォーマット生成、およびチェック strYMDformat = txtYMclose.chkDateYMDataFormat(txtYMclose.Text); //終了年月日の日付チェック if (strYMDformat == "") { this.Cursor = Cursors.Default; // メッセージボックスの処理、項目が日付でない場合のウィンドウ(OK) BaseMessageBox basemessagebox = new BaseMessageBox(this, CommonTeisu.TEXT_INPUT, "入力された日付が正しくありません。", CommonTeisu.BTN_OK, CommonTeisu.DIAG_ERROR); basemessagebox.ShowDialog(); txtYMclose.Focus(); return; } else { txtYMclose.Text = strYMDformat; } this.Cursor = Cursors.Default; //年月日が空の場合 if (txtYMopen.blIsEmpty() == false) { // メッセージボックスの処理、項目が空の場合のウィンドウ(OK) BaseMessageBox basemessagebox = new BaseMessageBox(this, CommonTeisu.TEXT_INPUT, "項目が空です。\r\n日付を入力してください。 ", CommonTeisu.BTN_OK, CommonTeisu.DIAG_ERROR); basemessagebox.ShowDialog(); txtYMopen.Focus(); return; } //年月日が空の場合 if (txtYMclose.blIsEmpty() == false) { // メッセージボックスの処理、項目が空の場合のウィンドウ(OK) BaseMessageBox basemessagebox = new BaseMessageBox(this, CommonTeisu.TEXT_INPUT, "項目が空です。\r\n日付を入力してください。 ", CommonTeisu.BTN_OK, CommonTeisu.DIAG_ERROR); basemessagebox.ShowDialog(); txtYMclose.Focus(); return; } //検索開始得意先コードのチェック if (lblsetTokuisakiCdopen.chkTxtTorihikisaki() == true) { lblsetTokuisakiCdopen.Focus(); return; } //検索終了得意先コードのチェック if (lblsetTokuisakiCdclose.chkTxtTorihikisaki() == true) { lblsetTokuisakiCdclose.Focus(); return; } this.Cursor = Cursors.WaitCursor; DataTable dtGridViewTokusaki = new DataTable(); List <string> lstStringViewData = new List <string>(); lstStringViewData.Add(lblsetTokuisakiCdopen.CodeTxtText); lstStringViewData.Add(lblsetTokuisakiCdclose.CodeTxtText); string strShuturyoku = ""; //出力順のラジオボタン判定 if (radShuturyoku.radbtn0.Checked == true) { strShuturyoku = "Tokuisaki"; } else { strShuturyoku = "Hurigana"; } lstStringViewData.Add(DateTime.Parse(txtYMopen.Text).ToString("yyyy/MM/dd")); lstStringViewData.Add(DateTime.Parse(txtYMclose.Text).ToString("yyyy/MM/dd")); lstStringViewData.Add(strShuturyoku); C0520_KaikakekinZandakaIchiranKakunin_B kaikakekakuninB = new C0520_KaikakekinZandakaIchiranKakunin_B(); try { DataTable dtXlsData = kaikakekakuninB.getPrintData(lstStringViewData); if (dtXlsData.Rows.Count > 0) { CreatePdf cpdf = new CreatePdf(); // 出力するヘッダを設定 string[] header = { "コード", "得意先名", "年月", "前月買掛残", "支払現金", "支払小切手", "支払振込", "支払手形", "支払相殺", "支払手数料", "支払その他", "繰越残高", "当月仕入高", "当月消費税", "当月残高", "税区", }; // Linqで出力対象の項目をSelect // カラム名は以下のようにつける(カラム名でフォーマットを判断するため) // 金額関係:***kingaku // 単価関係:***tanka // 原価:***genka // 数量:***suryo var outDat = dtXlsData.AsEnumerable() .Select(dat => new { code = dat["コード"], tokuisakiName = dat["得意先名"], YM = dat["年月"], zenkaikakezanKingaku = dat["前月買掛残"], siharaiGenkinKingaku = dat["支払現金"], siharaiKogiteKingaku = dat["支払小切手"], siharaiFurikomiKingaku = dat["支払振込"], siharaiTegataKingaku = dat["支払手形"], siharaiSosaiKingaku = dat["支払相殺"], siharaiTesuryoKingaku = dat["支払手数料"], siharaiSonotaKingaku = dat["支払その他"], kurikosizanKingaku = dat["繰越残高"], togetuUriageKingaku = dat["当月仕入高"], togetuZeiKingaku = dat["当月消費税"], togetuZanKingaku = dat["当月残高"], zeiku = dat["税区"] }).ToList(); // listをDataTableに変換 DataTable dtKaikakeZan = cpdf.ConvertToDataTable(outDat); string outFile = sfd.FileName; cpdf.DtToXls(dtKaikakeZan, "買掛金残高一覧確認", outFile, 3, 1, header); this.Cursor = Cursors.Default; // メッセージボックスの処理、Excel作成完了の場合のウィンドウ(OK) BaseMessageBox basemessagebox = new BaseMessageBox(this, CommonTeisu.TEXT_VIEW, "Excelファイルを作成しました。", CommonTeisu.BTN_OK, CommonTeisu.DIAG_INFOMATION); basemessagebox.ShowDialog(); } } catch (Exception ex) { this.Cursor = Cursors.Default; //データロギング new CommonException(ex); //例外発生メッセージ(OK) BaseMessageBox basemessagebox = new BaseMessageBox(this, CommonTeisu.TEXT_ERROR, CommonTeisu.LABEL_ERROR_MESSAGE, CommonTeisu.BTN_OK, CommonTeisu.DIAG_ERROR); basemessagebox.ShowDialog(); return; } } }
private static IDataGridViewColumnCollection GetColumnCollectionWithMock(out DataGridViewColumnCollection mock) { DataGridView dataGridView = new DataGridView(); mock = MockRepository.GenerateMock<Gizmox.WebGUI.Forms.DataGridViewColumnCollection>(dataGridView); return new DataGridViewVWG.DataGridViewColumnCollectionVWG(mock); }
private void SetRequestColumns(DataGridViewColumnCollection columns) { DataGridViewColumn column; DataGridViewCellStyle style; // //Index // column = new DataGridViewTextBoxColumn(); columns.Add(column); column.DataPropertyName = "Id"; column.HeaderText = "Id"; column.Name = "clmRequestId"; column.Width = 40; // //Request // column = new DataGridViewTextBoxColumn(); columns.Add(column); column.DataPropertyName = "Request"; column.HeaderText = "Request"; column.Name = "clmRequest"; column.Width = 150; // // Start // column = new DataGridViewTextBoxColumn(); columns.Add(column); style = new DataGridViewCellStyle(); style.Format = "MMM dd, HH:mm:ss.fff"; column.DataPropertyName = "StartDate"; column.DefaultCellStyle = style; column.HeaderText = "Start"; column.Name = "clmStart"; column.Width = 110; // // clmFinish // column = new DataGridViewTextBoxColumn(); columns.Add(column); style = new DataGridViewCellStyle(); style.Format = "HH:mm:ss.fff"; column.DataPropertyName = "FinishDate"; column.DefaultCellStyle = style; column.HeaderText = "Finish"; column.Name = "clmFinish"; column.Visible = false; column.Width = 75; // // clmTotalTime // column = new DataGridViewTextBoxColumn(); columns.Add(column); style = new DataGridViewCellStyle(); style.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight; style.Format = "N0"; column.DataPropertyName = "TotalTime"; column.DefaultCellStyle = style; column.HeaderText = "Total time"; column.Name = "clmTotalTime"; column.Width = 80; // // clmConnectId // column = new DataGridViewTextBoxColumn(); columns.Add(column); column.DataPropertyName = "ConnectId"; column.HeaderText = "ConnectId"; column.Name = "clmConnectId"; column.Visible = false; column.Width = 70; // // clmLoginId // column = new DataGridViewTextBoxColumn(); columns.Add(column); column.DataPropertyName = "LoginId"; column.HeaderText = "LoginId"; column.Name = "clmLoginId"; column.Visible = false; column.Width = 70; // // clmCallId // column = new DataGridViewTextBoxColumn(); columns.Add(column); column.DataPropertyName = "CallId"; column.HeaderText = "CallId"; column.Name = "clmCallId"; column.Visible = false; column.Width = 70; // // clmUserName // column = new DataGridViewTextBoxColumn(); columns.Add(column); column.DataPropertyName = "UserName"; column.HeaderText = "User"; column.Name = "clmUserName"; column.Visible = false; column.Width = 70; // // clmThreadName // column = new DataGridViewTextBoxColumn(); columns.Add(column); column.DataPropertyName = "ThreadName"; column.HeaderText = "Thread"; column.Name = "clmThreadName"; column.Visible = false; }