public void SummaryDataSearch() { ClearGridViewData(gridDetailData); ShowQueryResultToGridView(gridSummaryData, Mapper.GetGridViewSummaryCommand(this.Name), null); // If there`s no query result for selected year if (gridSummaryData.Rows.Count == 0) { ClearGridViewData(gridSummaryData); SetSelectionLabelText(new List <string> { "" }); MessageBox.Show($"{dateTimePicker.Value.ToString("yyyy-MM")} is not closed yet."); return; } // There should not be automatic row selection when data is populated onto GridView DataGridViewFormat.UndoAutomaticRowSelection(gridSummaryData); DataGridViewFormat.ChangeGridViewFormat(gridSummaryData); ShowUpTypeSelectionLabel(); // Showing up detail data is only allowed after summary data is showed up IsDetailDataShowUpAllowed = true; }
public void SummaryDataSearch() { List <List <int> > closedMonths = new List <List <int> >(); List <string> commands = new List <string>() { DB_Configuration.FUNC_GET_CLOSED_MONTHS_tqtInOut, DB_Configuration.FUNC_GET_CLOSED_MONTHS_tqtInOutCKD, DB_Configuration.FUNC_GET_CLOSED_MONTHS_tmtInOutProd, DB_Configuration.FUNC_GET_CLOSED_MONTHS_tmtInOutSemi }; using (SqlConnection sqlConnection = new SqlConnection(DB_Configuration.ConnectionString)) { foreach (string command in commands) { using (SqlCommand sqlCommand = new SqlCommand(command, sqlConnection)) { sqlConnection.Open(); using (SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(sqlCommand)) { DataTable dataTable = new DataTable(); sqlDataAdapter.Fill(dataTable); closedMonths.Add(ConvertToList(dataTable)); } sqlConnection.Close(); } } gridClosedMonths.DataSource = GetCommonValue(closedMonths); } DataGridViewFormat.ChangeGridViewFormat(gridClosedMonths); DataGridViewFormat.UndoAutomaticRowSelection(gridClosedMonths); }
public void TotalInventoryStatus_Load(object sender, EventArgs e) { labelDatePicker.Text = "Reference Month"; dateTimePicker.Format = DateTimePickerFormat.Custom; dateTimePicker.CustomFormat = "yyyy.MM"; dateTimePicker.Size = new Size(120, 20); DataGridViewFormat.LimitUserInteractionWithDataGridView(gridSummaryData); gridSummaryData.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.ColumnHeader; DataGridViewFormat.LimitUserInteractionWithDataGridView(gridDetailData); gridDetailData.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells; labelSelectedTypes.Visible = false; labelSelectedTypes.Location = new Point(labelTotalDetail.Right + 5, labelTotalDetail.Top); labelSelectedTypes.BorderStyle = BorderStyle.Fixed3D; // To make Rowheader include upto 4 digits ( Temporary resolution ) gridDetailData.RowHeadersDefaultCellStyle.Padding = new Padding(4); }
private void ClosedInventoryStatusForm_Load(object sender, System.EventArgs e) { DataGridViewFormat.LimitUserInteractionWithDataGridView(gridClosedMonths); }