private void DBComboxCPLibLivr_SelectedIndexChanged(object sender, EventArgs e) { UInt32 ID_UL; DBComboxCPLibLivr.GetSelectedItemID(out ID_UL); DBComboxCPLivr.SelectItemByID(ID_UL); ValueChanged(this, EventArgs.Empty); }
public ClientUC(DatabaseManager DBManager_O) { InitializeComponent(); mInitializingData_b = false; // Add btn tool tool strip list view this.DBListViewClient.ListTitle = "Sélection client"; this.DBListViewClient.AddToolStripBtn(this.ToolStripBtnAddClient); ToolStripUCClientTools.Visible = false; this.DBListViewComjobRecap.ListTitle = "Jobs du client"; ToolStripUCClientTools.Renderer = new BorderlessToolStripRenderer(); mDBManager_O = DBManager_O; List <String> TableField_ST = new List <String>(); List <String> ColumnHeaderName_ST = new List <String>(); List <int> ColumnHeaderDefaultSize_i = new List <int>(); List <HorizontalAlignment> TextAlign_O = new List <HorizontalAlignment>(); TableField_ST.Add("NumClientInterne"); TableField_ST.Add("ClientNom"); TableField_ST.Add("NrTVA"); TableField_ST.Add("ClientID"); ColumnHeaderName_ST.Add("N° de client"); ColumnHeaderName_ST.Add("Nom"); ColumnHeaderName_ST.Add("N° TVA"); ColumnHeaderDefaultSize_i.Add(100); ColumnHeaderDefaultSize_i.Add(300); ColumnHeaderDefaultSize_i.Add(150); TextAlign_O.Add(HorizontalAlignment.Left); TextAlign_O.Add(HorizontalAlignment.Left); TextAlign_O.Add(HorizontalAlignment.Left); DBListViewClient.Initialize(mDBManager_O, "Client", TableField_ST, 3, ColumnHeaderName_ST, ColumnHeaderDefaultSize_i, TextAlign_O); DBListViewClient.SelectionChanged += new DBListView.SelectionChangedHandler(this.ClientClick); DBComboxTypeSoc.FillList(mDBManager_O, "TypeSoc", "TypeSocID", "TypeSocLib"); DBComboxCPFact.FillList(mDBManager_O, "CodePostal", "CodePostalID", "CodePostal"); DBComboxCPLivr.FillList(mDBManager_O, "CodePostal", "CodePostalID", "CodePostal"); DBComboxCPLibFact.FillList(mDBManager_O, "CodePostal", "CodePostalID", "Localite"); DBComboxCPLibLivr.FillList(mDBManager_O, "CodePostal", "CodePostalID", "Localite"); // Define comjob recap list view List <String> TableFieldJobRecap_ST = new List <String>(); List <String> ColumnHeaderNameJobRecap_ST = new List <String>(); List <int> ColumnHeaderDefaultSizeJobRecap_i = new List <int>(); List <HorizontalAlignment> TextAlignJobRecap_O = new List <HorizontalAlignment>(); // Define column DB fields TableFieldJobRecap_ST.Add("NumRefInterne"); TableFieldJobRecap_ST.Add("LibelleCmd"); TableFieldJobRecap_ST.Add("NumCmdClient"); TableFieldJobRecap_ST.Add("NumOrdre"); TableFieldJobRecap_ST.Add("JobLib"); TableFieldJobRecap_ST.Add("Qte"); TableFieldJobRecap_ST.Add("NumPlan"); TableFieldJobRecap_ST.Add("DelaiPromis"); TableFieldJobRecap_ST.Add("JobStatusLib"); TableFieldJobRecap_ST.Add("DateEncod"); // Unshown elements TableFieldJobRecap_ST.Add("ComJobID"); // Define column headers text ColumnHeaderNameJobRecap_ST.Add("Num cmd int"); ColumnHeaderNameJobRecap_ST.Add("Libellé cmd"); ColumnHeaderNameJobRecap_ST.Add("Num cmd client"); ColumnHeaderNameJobRecap_ST.Add("# job"); ColumnHeaderNameJobRecap_ST.Add("Job libellé"); ColumnHeaderNameJobRecap_ST.Add("Qte"); ColumnHeaderNameJobRecap_ST.Add("Num plan"); ColumnHeaderNameJobRecap_ST.Add("Délai"); ColumnHeaderNameJobRecap_ST.Add("Statut"); ColumnHeaderNameJobRecap_ST.Add("Date encodage"); // size ColumnHeaderDefaultSizeJobRecap_i.Add(100); ColumnHeaderDefaultSizeJobRecap_i.Add(100); ColumnHeaderDefaultSizeJobRecap_i.Add(150); ColumnHeaderDefaultSizeJobRecap_i.Add(50); ColumnHeaderDefaultSizeJobRecap_i.Add(600); ColumnHeaderDefaultSizeJobRecap_i.Add(50); ColumnHeaderDefaultSizeJobRecap_i.Add(100); ColumnHeaderDefaultSizeJobRecap_i.Add(100); ColumnHeaderDefaultSizeJobRecap_i.Add(100); ColumnHeaderDefaultSizeJobRecap_i.Add(100); // alignment for (int i = 0; i < ColumnHeaderNameJobRecap_ST.Count; i++) { if (i == 3 || i == 5) { TextAlignJobRecap_O.Add(HorizontalAlignment.Center); } else { TextAlignJobRecap_O.Add(HorizontalAlignment.Left); } } DBListViewComjobRecap.Initialize(mDBManager_O, "ComJobSelectPop", TableFieldJobRecap_ST, 10, ColumnHeaderNameJobRecap_ST, ColumnHeaderDefaultSizeJobRecap_i, TextAlignJobRecap_O, null, null, false); SetEditState(false); TxtClientNumber.Width = Math.Max(50, TxtClientNumber.Width); TxtClientName.Width = ToolStripClientHeader.Width - toolStripLabel1.Width - TxtClientNumber.Width - toolStripLabel3.Width - 5; ToolStripClientEditFooter.Renderer = new BorderlessToolStripRenderer(); ToolStripClientHeader.Renderer = new BorderlessToolStripRenderer(); ControlStyle.SetBackgroundStyle(this); ControlStyle.SetBackgroundStyle(this.ToolStripUCClientTools); ControlStyle.SetFrameHeaderStyle(this.PanelClientList); ControlStyle.SetFrameHeaderStyle(this.PanelCheckHeader); ControlStyle.SetFrameHeaderStyle(this.PanelJobRecap); ControlStyle.SetFrameHeaderStyle(this.splitContainer2.Panel1); ControlStyle.SetFrameStyle(this.PanelCheckContent); ControlStyle.SetFrameStyle(this.ToolStripClientEditFooter); DBListViewClient.ForeColor = Color.Black; DBListViewClient.AllowMultipleSelecion = false; DBListViewComjobRecap.AllowMultipleSelecion = false; }
private void ClientClick(UInt32 ClientID_UL) { // Load client info in each control String SQLRequest_ST; SqlDataReader SqlDataReader_O; UInt32 TypeSocID_UL = 0; UInt32 CPID_UL = 0; int RappConf_i = 0, NoteEnvoi_i = 0, Certif_i = 0; // Fill info in panel edit controls mInitializingData_b = true; TxtClientNumber.Clear(); TxtClientName.Clear(); TxtTel.Clear(); TxtFax.Clear(); TxtAdressFact.Clear(); TxtAdressLivr.Clear(); TxtContactMail.Clear(); TxtContactTel.Clear(); TxtContactName.Clear(); TxtTVA.Clear(); TxtMail.Clear(); TxtRem.Clear(); CheckBoxRappConf.Checked = false; CheckBoxNE.Checked = false; CheckBoxCertif.Checked = false; DBComboxTypeSoc.ClearSelectedItem(); DBComboxCPFact.ClearSelectedItem(); DBComboxCPLivr.ClearSelectedItem(); DBComboxCPLibFact.ClearSelectedItem(); DBComboxCPLibLivr.ClearSelectedItem(); mInitializingData_b = false; if (mDBManager_O != null && mDBManager_O.mConnected_b) { SQLRequest_ST = "SELECT * FROM Client WHERE ClientID=" + ClientID_UL; SqlDataReader_O = mDBManager_O.Select(SQLRequest_ST); mInitializingData_b = true; while (SqlDataReader_O.Read()) { int.TryParse(SqlDataReader_O["RappConf"].ToString(), out RappConf_i); int.TryParse(SqlDataReader_O["NoteEnvoi"].ToString(), out NoteEnvoi_i); int.TryParse(SqlDataReader_O["Certif"].ToString(), out Certif_i); // Fill info in panel edit controls TxtClientNumber.Text = SqlDataReader_O["NumClientInterne"].ToString(); TxtClientName.Text = SqlDataReader_O["ClientNom"].ToString(); TxtTel.Text = SqlDataReader_O["ClientTel"].ToString(); TxtFax.Text = SqlDataReader_O["ClientFax"].ToString(); TxtAdressFact.Text = SqlDataReader_O["AdresseFact"].ToString(); TxtAdressLivr.Text = SqlDataReader_O["AdresseLivraison"].ToString(); TxtContactMail.Text = SqlDataReader_O["ContactEmail"].ToString(); TxtContactTel.Text = SqlDataReader_O["ContactTel"].ToString(); TxtContactName.Text = SqlDataReader_O["Contact"].ToString(); TxtTVA.Text = SqlDataReader_O["NrTVA"].ToString(); TxtMail.Text = SqlDataReader_O["ClientMail"].ToString(); TxtRem.Text = SqlDataReader_O["ClientRem"].ToString(); CheckBoxRappConf.Checked = RappConf_i != 0 ? true : false; CheckBoxNE.Checked = NoteEnvoi_i != 0 ? true : false; CheckBoxCertif.Checked = Certif_i != 0 ? true : false; if (UInt32.TryParse(SqlDataReader_O["TypeSocID"].ToString(), out TypeSocID_UL)) { DBComboxTypeSoc.SelectItemByID(TypeSocID_UL); } if (UInt32.TryParse(SqlDataReader_O["CodePostalFactID"].ToString(), out CPID_UL)) { DBComboxCPFact.SelectItemByID(CPID_UL); DBComboxCPLibFact.SelectItemByID(CPID_UL); } else { DBComboxCPFact.ClearSelectedItem(); DBComboxCPLibFact.ClearSelectedItem(); } if (UInt32.TryParse(SqlDataReader_O["CodePostalLivraisonID"].ToString(), out CPID_UL)) { DBComboxCPLivr.SelectItemByID(CPID_UL); DBComboxCPLibLivr.SelectItemByID(CPID_UL); } else { DBComboxCPLivr.ClearSelectedItem(); DBComboxCPLibLivr.ClearSelectedItem(); } // Refresh job recap if (!String.IsNullOrEmpty(SqlDataReader_O["ClientNom"].ToString())) { DBListViewComjobRecap.SetInitialFilter("ClientNom='" + SqlDataReader_O["ClientNom"].ToString() + "'", "DelaiPromis desc"); DBListViewComjobRecap.Refresh(); } } SqlDataReader_O.Close(); mInitializingData_b = false; } }