public JobLifeCycle(DatabaseManager DBManager_O, UInt32 ComJobID_UL)
{
InitializeComponent();
mDBManager_O = DBManager_O;
mComJobID_UL = ComJobID_UL;
ToolStripJobStates.Renderer = new BorderlessToolStripRenderer();
ToolStripJobInfos1.Renderer = new BorderlessToolStripRenderer();
ControlStyle.SetFrameStyle(this);
ControlStyle.SetFrameStyle(this.ToolStripJobStates);
ControlStyle.SetFrameStyle(this.JobLifeCyclePanel);
InitializeInfos();
UpdateJobStatus();
}
public ComJobUC(DatabaseManager DBManager_O, DocumentManager DocManager_O)
{
InitializeComponent();
this.ComJobSelector.AddComToolStripBtn(this.ToolStripBtnCancelCmd);
this.ComJobSelector.AddComToolStripBtn(this.ToolStripBtnAddCom);
this.ToolStripCom.Visible = false;
this.ComJobSelector.AddJobToolStripBtn(this.ToolStripBtnCancelJob);
this.ComJobSelector.AddJobToolStripBtn(this.ToolStripBtnAddJob);
this.ToolStripJob.Visible = false;
mDBManager_O = DBManager_O;
mDocManager_O = DocManager_O;
ComJobSelector.Initialize(mDBManager_O);
SetComEditState(false);
SetJobEditState(false);
ComJobSelector.GetComListView().SelectionChanged += new DBListView.SelectionChangedHandler(this.ComClick);
ComJobSelector.GetJobListView().SelectionChanged += new DBListView.SelectionChangedHandler(this.JobClick);
JobAssociatedDep.Initialize(mDBManager_O);
JobAssociatedDep.DepartmentsModified += new DepartmentSelector.DepartmentsModifiedHandler(this.JobValueChanged);
ToolStripComTools.Renderer = new BorderlessToolStripRenderer();
ToolStripJobTools.Renderer = new BorderlessToolStripRenderer();
ToolStripComHeader.Renderer = new BorderlessToolStripRenderer();
ToolStripJobHeader.Renderer = new BorderlessToolStripRenderer();
ToolStripJobDocuments.Renderer = new BorderlessToolStripRenderer();
ToolStripNEAndCertif.Renderer = new BorderlessToolStripRenderer();
ControlStyle.SetBackgroundStyle(this);
ControlStyle.SetFrameHeaderStyle(this.ToolStripComTools);
ControlStyle.SetFrameHeaderStyle(this.ToolStripJobTools);
ControlStyle.SetBackgroundStyle(this.splitContainer1.Panel2);
ControlStyle.SetFrameHeaderStyle(this.splitContainer2.Panel1);
ControlStyle.SetFrameHeaderStyle(this.splitContainer2.Panel2);
ControlStyle.SetFrameStyle(this.ToolStripComEditFooter);
ControlStyle.SetFrameStyle(this.PanelCmdInfo);
ControlStyle.SetFrameStyle(this.PanelJobInfo);
ControlStyle.SetFrameStyle(this.ToolStripJobEditFooter);
ControlStyle.SetFrameStyle(this.JobAssociatedDep);
ControlStyle.SetFrameStyle(this.ToolStripJobDocuments);
ControlStyle.SetFrameStyle(this.ToolStripNEAndCertif);
}
public FormNeCertif(DatabaseManager DBManager_O, UInt32 ComJobID_UL)
{
InitializeComponent();
this.CenterToParent();
mDBManager_O = DBManager_O;
mComJobID_UL = ComJobID_UL;
ToolStripValidate.Renderer = new BorderlessToolStripRenderer();
ControlStyle.SetBackgroundColorFocusStyle(this);
ControlStyle.SetFrameHeaderStyle(PanelFormHeader);
ControlStyle.SetFrameHeaderStyle(ToolStripValidate);
ControlStyle.SetFrameStyle(this.PanelNECertfif);
Initialize();
}
public JobsState(DatabaseManager DBManager_O)
{
mDBManager_O = DBManager_O;
InitializeComponent();
ToolStripStatusFilter.Renderer = new BorderlessToolStripRenderer();
ToolStripJobInfos1.Renderer = new BorderlessToolStripRenderer();
ToolStripBtnDone.Checked = true;
ControlStyle.SetBackgroundStyle(this);
ControlStyle.SetFrameStyle(MainFlowLayoutPanel);
ControlStyle.SetFrameHeaderStyle(PanelFilterHeader);
ControlStyle.SetFrameHeaderStyle(PanelJobLifeCycleHeader);
ControlStyle.SetFrameHeaderStyle(this.splitContainer1.Panel1);
ControlStyle.SetFrameHeaderStyle(this.splitContainer1.Panel2);
ControlStyle.SetFrameStyle(ToolStripStatusFilter);
}
public FormAskJobHourCorrection()
{
InitializeComponent();
mEnteredString_ST = "";
this.CenterToParent();
ToolStripControlHost ToolStripControlHost_O = new ToolStripControlHost(TxtEnteredString);
this.ToolStripValidatePref.Items.Insert(1, ToolStripControlHost_O);
ToolStripValidatePref.Renderer = new BorderlessToolStripRenderer();
ControlStyle.SetBackgroundColorFocusStyle(this);
ControlStyle.SetFrameStyle(this.PanelUserPref);
ControlStyle.SetFrameHeaderStyle(this.ToolStripValidatePref);
this.ActiveControl = TxtEnteredString;
}
public FormDocumentViewer(Microsoft.Office.Interop.Word.Document WordDoc_O)
{
InitializeComponent();
ToolStripTools.Renderer = new BorderlessToolStripRenderer();
ControlStyle.SetFrameStyle(this);
ControlStyle.SetFrameStyle(this.ToolStripTools);
ControlStyle.SetFrameStyle(this.WebBrowser);
mWordDoc_O = WordDoc_O;
mTempFileName_st = Path.Combine(MMSoftAppDataFolder_st, "Word_TEMP" + Directory.GetFiles(MMSoftAppDataFolder_st, "*.html").Length + ".pdf");
// Call ConvertDocument asynchronously.
ConvertDocumentDelegate Delegate_O = new ConvertDocumentDelegate(ConvertDocument);
// Call DocumentConversionComplete when the method has completed.
Delegate_O.BeginInvoke(DocumentConversionComplete, null);
}
public FormCheckingEdition()
{
InitializeComponent();
ToolStripAddChecking.Renderer = new BorderlessToolStripRenderer();
// Register on checking validated event
CheckingEditionCtrl.CheckingValidated += new CheckingEdition.CheckingValidatedHandler(CheckingValidated);
ControlStyle.SetBackgroundColorFocusStyle(CheckingEditionPanel);
// Not so good for different screen resolutions
//this.Width = (int)(Screen.PrimaryScreen.Bounds.Width * 0.75);
//this.Height = (int)(Screen.PrimaryScreen.Bounds.Height * 0.75);
this.CenterToScreen();
ControlStyle.SetFrameHeaderStyle(this);
ControlStyle.SetFrameHeaderStyle(this.ToolStripAddChecking);
}
public FormAskClient(DatabaseManager DBManager_O)
{
InitializeComponent();
mDBManager_O = DBManager_O;
this.CenterToParent();
this.DBListViewClient.ListTitle = "Sélection client";
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.ItemDoubleClicked += new DBListView.ItemDoubleClickedHandler(this.ClientDoubleClic);
ToolStripValidate.Renderer = new BorderlessToolStripRenderer();
ControlStyle.SetBackgroundColorFocusStyle(this);
ControlStyle.SetFrameStyle(this.PanelUserPref);
ControlStyle.SetFrameHeaderStyle(this.ToolStripValidate);
}
public NECertifUC(DatabaseManager DBManager_O, DocumentManager DocumentManager_O, UInt32 SendNoteID_UL)
{
InitializeComponent();
mDBManager_O = DBManager_O;
mSendNoteID_UL = SendNoteID_UL;
mDocumentManager_O = DocumentManager_O;
// Set UC style
ToolStripNeCertif.Renderer = new BorderlessToolStripRenderer();
ControlStyle.SetFrameStyle(ToolStripNeCertif);
// Initialize user control
if (mDBManager_O != null && mDBManager_O.mConnected_b)
{
try
{
DateTime Date_O = Convert.ToDateTime(mDBManager_O.GetTableField("NoteEnvoiAndCertif", "DateExpedition", "NoteEnvoiID=" + mSendNoteID_UL));
ToolStripLblDate.Text = Date_O.ToShortDateString();
// Hide certif button if do not exist
UInt32 CertifID_UL;
if (!UInt32.TryParse(mDBManager_O.GetTableField("NoteEnvoiAndCertif", "CertifID", "NoteEnvoiID=" + mSendNoteID_UL), out CertifID_UL))
{
ToolStripBtnCertif.Visible = false;
}
else if (CertifID_UL == 0)
{
ToolStripBtnCertif.Visible = false;
}
}
catch (FormatException e)
{
ToolStripLblDate.Text = mDBManager_O.GetTableField("NoteEnvoiAndCertif", "DateExpedition", "NoteEnvoiID=" + mSendNoteID_UL);
}
}
}
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;
}
public DayCheckingViewer()
{
InitializeComponent();
this.DBListViewCheckings.ListTitle = "Pointages";
this.DBListViewCheckings.AddToolStripBtn(this.ToolStripBtnFastDayBack);
this.DBListViewCheckings.AddToolStripBtn(this.ToolStripBtnDayBack);
this.DBListViewCheckings.AddToolStripBtn(this.ToolStripBtnDayFwd);
this.DBListViewCheckings.AddToolStripBtn(this.ToolStripBtnDayFastFwd);
this.DBListViewCheckings.AddToolStripBtn(this.ToolStripBtnDateTimePick);
ToolStripControlHost ToolStripControlHost_O = new ToolStripControlHost(CustomDateTimePickerCtrl);
this.DBListViewCheckings.AddToolStripControlHost(ToolStripControlHost_O);
this.DBListViewCheckings.AddToolStripBtn(this.ToolStripBtnEdit);
this.DBListViewCheckings.AddToolStripBtn(this.ToolStripBtnDelete);
FormCheckingToolStrip.Visible = false;
mColumnPersCheckDBField_O = new List <String>();
mColumnPersCheckDBField_O.Add("NumRefInterne");
mColumnPersCheckDBField_O.Add("ClientNom");
mColumnPersCheckDBField_O.Add("JobLib");
mColumnPersCheckDBField_O.Add("TypeTacheLib");
mColumnPersCheckDBField_O.Add("QteProd");
mColumnPersCheckDBField_O.Add("DelaiPromis");
mColumnPersCheckDBField_O.Add("DatePrest");
mColumnPersCheckDBField_O.Add("NbrH");
mColumnPersCheckDBField_O.Add("Rem");
mColumnPersCheckDBField_O.Add("ComJobEtapeID");
mColumnHeaderName_ST = new List <String>();
mColumnHeaderName_ST.Add("N° ref interne");
mColumnHeaderName_ST.Add("Client");
mColumnHeaderName_ST.Add("Libellé job");
mColumnHeaderName_ST.Add("Type tâche");
mColumnHeaderName_ST.Add("Qte prod");
mColumnHeaderName_ST.Add("Delai Promis");
mColumnHeaderName_ST.Add("Date Prestation");
mColumnHeaderName_ST.Add("NbrH");
mColumnHeaderName_ST.Add("Remarques");
mColumnHeaderDefaultSize_i = new List <int>();
mColumnHeaderDefaultSize_i.Add(100);
mColumnHeaderDefaultSize_i.Add(150);
mColumnHeaderDefaultSize_i.Add(600);
mColumnHeaderDefaultSize_i.Add(150);
mColumnHeaderDefaultSize_i.Add(75);
mColumnHeaderDefaultSize_i.Add(100);
mColumnHeaderDefaultSize_i.Add(100);
mColumnHeaderDefaultSize_i.Add(50);
mColumnHeaderDefaultSize_i.Add(300);
mTextAlign_O = new List <HorizontalAlignment>();
for (int i = 0; i < mColumnHeaderName_ST.Count; i++)
{
if (i == 4 || i == 7)
{
mTextAlign_O.Add(HorizontalAlignment.Center);
}
else
{
mTextAlign_O.Add(HorizontalAlignment.Left);
}
}
DBListViewCheckings.ItemDoubleClicked += new DBListView.ItemDoubleClickedHandler(this.CheckingDoubleClic);
ControlStyle.SetFrameStyle(this);
ControlStyle.SetFrameStyle(this.PanelCheckings);
ControlStyle.SetFrameStyle(this.PanelFooter);
ControlStyle.SetFrameHeaderStyle(this.PanelFooterPadding);
ControlStyle.SetFrameHeaderStyle(this.CustomDateTimePickerCtrl);
this.CustomDateTimePickerCtrl.ForeColor = Color.White;
}
private void JobLifeCycle_MouseLeave(object sender, EventArgs e)
{
ControlStyle.SetFrameStyle(this);
}
private void JobLifeCycle_MouseEnter(object sender, EventArgs e)
{
ControlStyle.SetBackgroundColorFocusStyle(this);
}
public JobsCorrectionUC(DatabaseManager DBManager_O)
{
mDBManager_O = DBManager_O;
InitializeComponent();
DBListViewJobs.ListRefreshed += ApplyCorrectedHoursFormating;
this.DBListViewJobs.ItemClicked += new DBListView.ItemClickedHandler(JobClicked);
// Set default date from first day of month to today
CustomDTPFrom.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1);
CustomDTPTo.Value = DateTime.Now;
this.DBListViewJobs.ListTitle = "Cycle de vie des jobs";
this.DBListViewJobs.AddToolStripBtn(this.ToolStripBtnPreviousMonth);
this.DBListViewJobs.AddToolStripBtn(this.ToolStripBtnDTPFrom);
ToolStripControlHost ToolStripControlHostFrom_O = new ToolStripControlHost(CustomDTPFrom);
this.DBListViewJobs.AddToolStripControlHost(ToolStripControlHostFrom_O);
this.DBListViewJobs.AddToolStripBtn(this.ToolStripBtnDTPTo);
ToolStripControlHost ToolStripControlHostTo_O = new ToolStripControlHost(CustomDTPTo);
this.DBListViewJobs.AddToolStripControlHost(ToolStripControlHostTo_O);
this.DBListViewJobs.AddToolStripBtn(this.ToolStripBtnNextMonth);
this.JobCorrectionToolStrip.Visible = false;
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("ClientNom");
TableFieldJobRecap_ST.Add("NumOrdre");
TableFieldJobRecap_ST.Add("JobLib");
TableFieldJobRecap_ST.Add("DateEncod");
TableFieldJobRecap_ST.Add("HTravEstim");
TableFieldJobRecap_ST.Add("SommeHeuresTot");
TableFieldJobRecap_ST.Add("SommeHeureCorrect");
// Unshown elements
TableFieldJobRecap_ST.Add("ComJobID");
TableFieldJobRecap_ST.Add("ChkHoursCorrected");
// Define column headers text
ColumnHeaderNameJobRecap_ST.Add("Num cmd int");
ColumnHeaderNameJobRecap_ST.Add("Client");
ColumnHeaderNameJobRecap_ST.Add("# job");
ColumnHeaderNameJobRecap_ST.Add("Job libellé");
ColumnHeaderNameJobRecap_ST.Add("Date encodage");
ColumnHeaderNameJobRecap_ST.Add("H estim.");
ColumnHeaderNameJobRecap_ST.Add("H. tot.");
ColumnHeaderNameJobRecap_ST.Add("H. tot. corr.");
// size
ColumnHeaderDefaultSizeJobRecap_i.Add(100);
ColumnHeaderDefaultSizeJobRecap_i.Add(250);
ColumnHeaderDefaultSizeJobRecap_i.Add(50);
ColumnHeaderDefaultSizeJobRecap_i.Add(600);
ColumnHeaderDefaultSizeJobRecap_i.Add(100);
ColumnHeaderDefaultSizeJobRecap_i.Add(75);
ColumnHeaderDefaultSizeJobRecap_i.Add(75);
ColumnHeaderDefaultSizeJobRecap_i.Add(75);
// alignment
for (int i = 0; i < ColumnHeaderNameJobRecap_ST.Count; i++)
{
if (i == 2 || i == 5 || i == 6 || i == 7)
{
TextAlignJobRecap_O.Add(HorizontalAlignment.Center);
}
else
{
TextAlignJobRecap_O.Add(HorizontalAlignment.Left);
}
}
DBListViewJobs.Initialize(mDBManager_O, "ComJobSelectPop", TableFieldJobRecap_ST, 8, ColumnHeaderNameJobRecap_ST, ColumnHeaderDefaultSizeJobRecap_i, TextAlignJobRecap_O,
"JobStatusID <= 4 AND DateEncod >= '" + CustomDTPFrom.Value.ToShortDateString() + "' AND DateEncod <= dateadd(day, 1, '" + CustomDTPTo.Value.ToShortDateString() + "')");
RefreshSum();
ToolStripJobCorrectionFooter.Renderer = new BorderlessToolStripRenderer();
ControlStyle.SetFrameHeaderStyle(this);
ControlStyle.SetFrameHeaderStyle(this.CustomDTPFrom);
ControlStyle.SetFrameHeaderStyle(this.CustomDTPTo);
ControlStyle.SetFrameStyle(this.ToolStripJobCorrectionFooter);
}
/// <summary>
/// Initialization method
/// </summary>
public void Initialize(DatabaseManager DBManager_O)
{
mDBManager_O = DBManager_O;
mLastSQLRequest_st = "";
mLastClickedFilterIndex_i = -1;
Asc_b = true;
// Set list view style : done here because list view is private
ControlStyle.SetFrameStyle(CustomComJobListView);
// Define column DB fields
mColumnDBField_O = new List <String>();
mColumnDBField_O.Add("NumRefInterne");
mColumnDBField_O.Add("LibelleCmd");
mColumnDBField_O.Add("NumCmdClient");
mColumnDBField_O.Add("ClientNom");
mColumnDBField_O.Add("NumOrdre");
mColumnDBField_O.Add("JobLib");
mColumnDBField_O.Add("Qte");
mColumnDBField_O.Add("NumPlan");
mColumnDBField_O.Add("DelaiPromis");
mColumnDBField_O.Add("ComStatusLib");
mColumnDBField_O.Add("DateEncod");
// Unshown elements
mColumnDBField_O.Add("ComJobID");
// Define column headers text
mColumnHeaders_st = new List <string>();
mColumnHeaders_st.Add("Num cmd int");
mColumnHeaders_st.Add("Libellé cmd");
mColumnHeaders_st.Add("Num cmd client");
mColumnHeaders_st.Add("Nom client");
mColumnHeaders_st.Add("# job");
mColumnHeaders_st.Add("Job libellé");
mColumnHeaders_st.Add("Qte");
mColumnHeaders_st.Add("Num plan");
mColumnHeaders_st.Add("Délai");
mColumnHeaders_st.Add("Statut");
mColumnHeaders_st.Add("Date encodage");
// Define column headers objects
mColumnHeaders_O = new List <ColumnHeader>();
for (int i = 0; i < mColumnHeaders_st.Count; i++)
{
mColumnHeaders_O.Add(new ColumnHeader());
mColumnHeaders_O[i].Name = mColumnDBField_O[i];
mColumnHeaders_O[i].Text = mColumnHeaders_st[i];
if (i == 4 || i == 6)
{
mColumnHeaders_O[i].TextAlign = HorizontalAlignment.Center;
}
else
{
mColumnHeaders_O[i].TextAlign = HorizontalAlignment.Left;
}
}
mColumnHeaders_O[0].Width = 100;
mColumnHeaders_O[1].Width = 100;
mColumnHeaders_O[2].Width = 150;
mColumnHeaders_O[3].Width = 150;
mColumnHeaders_O[4].Width = 50;
mColumnHeaders_O[5].Width = 600;
mColumnHeaders_O[6].Width = 50;
mColumnHeaders_O[7].Width = 100;
mColumnHeaders_O[8].Width = 100;
mColumnHeaders_O[9].Width = 100;
mColumnHeaders_O[10].Width = 100;
// Define list view column header
for (int i = 0; i < mColumnHeaders_st.Count; i++)
{
CustomComJobListView.Columns.Add(mColumnHeaders_O[i]);
}
// Set text box as filter
mFilterTextBox_O = new List <TextBox>();
mFilterTextBox_O.Add(TxtNumPlan);
mFilterTextBox_O.Add(TxtDelaiPromis);
mFilterTextBox_O.Add(TxtDateEncod);
mFilterTextBox_O.Add(TxtStatut);
mFilterTextBox_O.Add(TxtJobNumOrdre);
mFilterTextBox_O.Add(TxtJobLib);
mFilterTextBox_O.Add(TxtQte);
mFilterTextBox_O.Add(TxtLibCmd);
mFilterTextBox_O.Add(TxtNumCmdClient);
mFilterTextBox_O.Add(TxtNomClient);
mFilterTextBox_O.Add(TxtNumCmdInt);
//this.FilterPanel.Height = mFilterTextBox_O[0].Height + 3;
for (int i = 0; i < mFilterTextBox_O.Count; i++)
{
mFilterTextBox_O[i].TabIndex = i;
mFilterTextBox_O[i].Tag = i;
mFilterTextBox_O[i].TextChanged += new System.EventHandler(this.FilterTextChanged);
}
// Set filter txt according to column header
RefreshFilterTxt(true);
// Set filter text box style
ControlStyle.SetFrameStyle(this);
ControlStyle.SetFrameStyle(this.ListViewPanel);
ControlStyle.SetFrameStyle(this.CustomComJobListView);
ControlStyle.SetFrameStyle(this.FilterPanel);
ControlStyle.SetFrameHeaderStyle(this.FilterPanelPadding);
ControlStyle.SetFrameStyle(this.TxtNumCmdInt);
ControlStyle.SetFrameStyle(this.TxtNomClient);
ControlStyle.SetFrameStyle(this.TxtNumCmdClient);
ControlStyle.SetFrameStyle(this.TxtLibCmd);
ControlStyle.SetFrameStyle(this.TxtQte);
ControlStyle.SetFrameStyle(this.TxtJobLib);
ControlStyle.SetFrameStyle(this.TxtJobNumOrdre);
ControlStyle.SetFrameStyle(this.TxtStatut);
ControlStyle.SetFrameStyle(this.TxtDateEncod);
ControlStyle.SetFrameStyle(this.TxtDelaiPromis);
ControlStyle.SetFrameStyle(this.TxtNumPlan);
ControlStyle.SetFrameStyle(this.BtnClearFilter);
// Display jobs
RefreshJobs();
}
public void Initialize(DatabaseManager DBManager_O)
{
mDBManager_O = DBManager_O;
this.DBListViewCom.ListTitle = "Commandes";
this.DBListViewJob.ListTitle = "Jobs";
List <String> TableFieldCom_ST = new List <String>();
List <String> ColumnHeaderNameCom_ST = new List <String>();
List <int> ColumnHeaderDefaultSizeCom_i = new List <int>();
List <HorizontalAlignment> TextAlignCom_O = new List <HorizontalAlignment>();
// Fill com info
TableFieldCom_ST.Add("NumRefInterne");
TableFieldCom_ST.Add("ComDate");
TableFieldCom_ST.Add("LibelleCmd");
TableFieldCom_ST.Add("NumCmdClient");
TableFieldCom_ST.Add("ClientNom");
TableFieldCom_ST.Add("ComID");
ColumnHeaderNameCom_ST.Add("Num cmd interne");
ColumnHeaderNameCom_ST.Add("Date");
ColumnHeaderNameCom_ST.Add("Libellé commande");
ColumnHeaderNameCom_ST.Add("Num cmd client");
ColumnHeaderNameCom_ST.Add("Client");
ColumnHeaderDefaultSizeCom_i.Add(90);
ColumnHeaderDefaultSizeCom_i.Add(80);
ColumnHeaderDefaultSizeCom_i.Add(150);
ColumnHeaderDefaultSizeCom_i.Add(100);
ColumnHeaderDefaultSizeCom_i.Add(200);
TextAlignCom_O.Add(HorizontalAlignment.Left);
TextAlignCom_O.Add(HorizontalAlignment.Left);
TextAlignCom_O.Add(HorizontalAlignment.Left);
TextAlignCom_O.Add(HorizontalAlignment.Left);
TextAlignCom_O.Add(HorizontalAlignment.Left);
DBListViewCom.Initialize(mDBManager_O, "ComSelectPop", TableFieldCom_ST, 5, ColumnHeaderNameCom_ST, ColumnHeaderDefaultSizeCom_i, TextAlignCom_O, null, "NumRefInterne DESC");
List <String> TableFieldJob_ST = new List <String>();
List <String> ColumnHeaderNameJob_ST = new List <String>();
List <int> ColumnHeaderDefaultSizeJob_i = new List <int>();
List <HorizontalAlignment> TextAlignJob_O = new List <HorizontalAlignment>();
// Fill job info
TableFieldJob_ST.Add("NumOrdre");
TableFieldJob_ST.Add("JobLib");
TableFieldJob_ST.Add("Qte");
TableFieldJob_ST.Add("JobStatusLib");
TableFieldJob_ST.Add("DelaiPromis");
TableFieldJob_ST.Add("NumPlan");
TableFieldJob_ST.Add("DateEncod");
TableFieldJob_ST.Add("ComJobID");
ColumnHeaderNameJob_ST.Add("Job #");
ColumnHeaderNameJob_ST.Add("Libellé");
ColumnHeaderNameJob_ST.Add("Qte");
ColumnHeaderNameJob_ST.Add("Statut");
ColumnHeaderNameJob_ST.Add("Délai promis");
ColumnHeaderNameJob_ST.Add("N° plan");
ColumnHeaderNameJob_ST.Add("Date d'encodage");
ColumnHeaderDefaultSizeJob_i.Add(40);
ColumnHeaderDefaultSizeJob_i.Add(300);
ColumnHeaderDefaultSizeJob_i.Add(40);
ColumnHeaderDefaultSizeJob_i.Add(80);
ColumnHeaderDefaultSizeJob_i.Add(80);
ColumnHeaderDefaultSizeJob_i.Add(100);
ColumnHeaderDefaultSizeJob_i.Add(90);
TextAlignJob_O.Add(HorizontalAlignment.Left);
TextAlignJob_O.Add(HorizontalAlignment.Left);
TextAlignJob_O.Add(HorizontalAlignment.Left);
TextAlignJob_O.Add(HorizontalAlignment.Left);
TextAlignJob_O.Add(HorizontalAlignment.Left);
TextAlignJob_O.Add(HorizontalAlignment.Left);
TextAlignJob_O.Add(HorizontalAlignment.Left);
DBListViewJob.Initialize(mDBManager_O, "ComJobSelectPop", TableFieldJob_ST, 7, ColumnHeaderNameJob_ST, ColumnHeaderDefaultSizeJob_i, TextAlignJob_O, null, null, false);
// Record on selection changed event for DBListViewCom
DBListViewCom.SelectionChanged += new DBListView.SelectionChangedHandler(ComSelectionChanged);
ControlStyle.SetFrameHeaderStyle(this);
}
public HomeUC(DatabaseManager DBManager_O)
{
InitializeComponent();
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("PersNom");
TableField_ST.Add("Msg");
TableField_ST.Add("MsgID");
ColumnHeaderName_ST.Add("Expéditeur");
ColumnHeaderName_ST.Add("Message");
ColumnHeaderDefaultSize_i.Add(100);
ColumnHeaderDefaultSize_i.Add(DBListViewMsg.Width - 100);
TextAlign_O.Add(HorizontalAlignment.Left);
TextAlign_O.Add(HorizontalAlignment.Left);
DBListViewMsg.Initialize(mDBManager_O, "MsgSelectPop", TableField_ST, 2, ColumnHeaderName_ST, ColumnHeaderDefaultSize_i, TextAlign_O);
DBListViewMsg.ListTitle = "Messages";
DBListViewMsg.AllowMultipleSelecion = true;
DBListViewMsg.AddToolStripBtn(ToolStripBtnDelete);
FormMsgToolStrip.Visible = false;
// Initialize db list view com job
DbListViewComJobs.ListTitle = "Sélection des jobs";
List <String> mComJobTableField_ST = new List <String>();
List <String> mComJobColumnHeaderName_ST = new List <String>();
List <int> mComJobColumnHeaderDefaultSize_i = new List <int>();
List <HorizontalAlignment> mComJobTextAlign_O = new List <HorizontalAlignment>();
// Define column DB fields
mComJobTableField_ST = new List <String>();
mComJobTableField_ST.Add("NumRefInterne");
mComJobTableField_ST.Add("LibelleCmd");
mComJobTableField_ST.Add("NumCmdClient");
mComJobTableField_ST.Add("ClientNom");
mComJobTableField_ST.Add("NumOrdre");
mComJobTableField_ST.Add("JobLib");
mComJobTableField_ST.Add("Qte");
mComJobTableField_ST.Add("NumPlan");
mComJobTableField_ST.Add("DelaiPromis");
mComJobTableField_ST.Add("JobStatusLib");
mComJobTableField_ST.Add("DateEncod");
// Unshown elements
mComJobTableField_ST.Add("ComJobID");
// Define column headers text
mComJobColumnHeaderName_ST = new List <string>();
mComJobColumnHeaderName_ST.Add("Num cmd int");
mComJobColumnHeaderName_ST.Add("Libellé cmd");
mComJobColumnHeaderName_ST.Add("Num cmd client");
mComJobColumnHeaderName_ST.Add("Nom client");
mComJobColumnHeaderName_ST.Add("# job");
mComJobColumnHeaderName_ST.Add("Job libellé");
mComJobColumnHeaderName_ST.Add("Qte");
mComJobColumnHeaderName_ST.Add("Num plan");
mComJobColumnHeaderName_ST.Add("Délai");
mComJobColumnHeaderName_ST.Add("Statut");
mComJobColumnHeaderName_ST.Add("Date encodage");
// Define column headers objects
mComJobTextAlign_O = new List <HorizontalAlignment>();
for (int i = 0; i < mComJobColumnHeaderName_ST.Count; i++)
{
if (i == 4 || i == 6)
{
mComJobTextAlign_O.Add(HorizontalAlignment.Center);
}
else
{
mComJobTextAlign_O.Add(HorizontalAlignment.Left);
}
}
mComJobColumnHeaderDefaultSize_i = new List <int>();
mComJobColumnHeaderDefaultSize_i.Add(100);
mComJobColumnHeaderDefaultSize_i.Add(100);
mComJobColumnHeaderDefaultSize_i.Add(150);
mComJobColumnHeaderDefaultSize_i.Add(150);
mComJobColumnHeaderDefaultSize_i.Add(50);
mComJobColumnHeaderDefaultSize_i.Add(600);
mComJobColumnHeaderDefaultSize_i.Add(50);
mComJobColumnHeaderDefaultSize_i.Add(100);
mComJobColumnHeaderDefaultSize_i.Add(100);
mComJobColumnHeaderDefaultSize_i.Add(100);
mComJobColumnHeaderDefaultSize_i.Add(100);
DbListViewComJobs.Initialize(mDBManager_O, "ComJobSelectPop", mComJobTableField_ST, 11, mComJobColumnHeaderName_ST, mComJobColumnHeaderDefaultSize_i, mComJobTextAlign_O);
ControlStyle.SetFrameHeaderStyle(this);
ControlStyle.SetFrameHeaderStyle(this.splitContainer1);
}
public MembersUC(DatabaseManager DBManager_O, DocumentManager DocManager_O)
{
mDBManager_O = DBManager_O;
mDocManager_O = DocManager_O;
mInitializingData_b = false;
InitializeComponent();
// Add btn tool tool strip list view
this.DBListViewMembers.ListTitle = "Equipe Malcourant Mécanique";
this.DBListViewMembers.AddToolStripBtn(this.ToolStripBtnAddMember);
ToolStripUCMembersTools.Visible = false;
ToolStripUCMembersTools.Renderer = new BorderlessToolStripRenderer();
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("PersNom");
TableField_ST.Add("NumTel");
TableField_ST.Add("PersID");
ColumnHeaderName_ST.Add("Nom");
ColumnHeaderName_ST.Add("Téléphone");
ColumnHeaderDefaultSize_i.Add(200);
ColumnHeaderDefaultSize_i.Add(200);
TextAlign_O.Add(HorizontalAlignment.Left);
TextAlign_O.Add(HorizontalAlignment.Left);
DBListViewMembers.Initialize(mDBManager_O, "Pers", TableField_ST, 2, ColumnHeaderName_ST, ColumnHeaderDefaultSize_i, TextAlign_O);
DBListViewMembers.SelectionChanged += new DBListView.SelectionChangedHandler(this.MemberClick);
DBComboxStatus.FillList(mDBManager_O, "PersStatus", "PersStatutID", "PersStatutLib");
ComBoxFamilyState.Items.Add("Célibataire");
ComBoxFamilyState.Items.Add("Cohabitant");
ComBoxFamilyState.Items.Add("Marié");
ComboxPostalCode.FillList(mDBManager_O, "CodePostal", "CodePostalID", "CodePostal");
ComboxLocality.FillList(mDBManager_O, "CodePostal", "CodePostalID", "Localite");
// Put fields of DB in a list to be able to set their edit state in one loop
Fields_O = new List <Control>();
Fields_O.Add(DBComboxStatus);
Fields_O.Add(DTPBirthdate);
Fields_O.Add(TxtCost);
Fields_O.Add(DTPEntryDate);
Fields_O.Add(TxtBankAccount);
Fields_O.Add(TxtRegNumber);
Fields_O.Add(ComBoxFamilyState);
Fields_O.Add(TxtChilds);
Fields_O.Add(CheckBoxActivePartner);
Fields_O.Add(TxtTel);
Fields_O.Add(TxtAdress);
Fields_O.Add(ComboxPostalCode);
Fields_O.Add(ComboxLocality);
SetEditState(false);
// Define checking recap list view
List <String> TableFieldCheckingRecap_ST = new List <String>();
List <String> ColumnHeaderNameCheckingRecap_ST = new List <String>();
List <int> ColumnHeaderDefaultSizeCheckingRecap_i = new List <int>();
List <HorizontalAlignment> TextAlignCheckingRecap_O = new List <HorizontalAlignment>();
// Define column DB fields
TableFieldCheckingRecap_ST.Add("NumRefInterne");
TableFieldCheckingRecap_ST.Add("ClientNom");
TableFieldCheckingRecap_ST.Add("TypeTacheCod");
TableFieldCheckingRecap_ST.Add("JobLib");
TableFieldCheckingRecap_ST.Add("QteProd");
TableFieldCheckingRecap_ST.Add("DelaiPromis");
TableFieldCheckingRecap_ST.Add("DatePrest");
TableFieldCheckingRecap_ST.Add("NbrH");
TableFieldCheckingRecap_ST.Add("Rem");
// Unshown elements
TableFieldCheckingRecap_ST.Add("PointageID");
// Define column headers text
ColumnHeaderNameCheckingRecap_ST.Add("Num ref int");
ColumnHeaderNameCheckingRecap_ST.Add("Client");
ColumnHeaderNameCheckingRecap_ST.Add("Tâche");
ColumnHeaderNameCheckingRecap_ST.Add("Job libellé");
ColumnHeaderNameCheckingRecap_ST.Add("Qte prod");
ColumnHeaderNameCheckingRecap_ST.Add("Délais promis");
ColumnHeaderNameCheckingRecap_ST.Add("Date prest");
ColumnHeaderNameCheckingRecap_ST.Add("Nbr H");
ColumnHeaderNameCheckingRecap_ST.Add("Remarques");
// size
ColumnHeaderDefaultSizeCheckingRecap_i.Add(100);
ColumnHeaderDefaultSizeCheckingRecap_i.Add(100);
ColumnHeaderDefaultSizeCheckingRecap_i.Add(50);
ColumnHeaderDefaultSizeCheckingRecap_i.Add(600);
ColumnHeaderDefaultSizeCheckingRecap_i.Add(50);
ColumnHeaderDefaultSizeCheckingRecap_i.Add(100);
ColumnHeaderDefaultSizeCheckingRecap_i.Add(100);
ColumnHeaderDefaultSizeCheckingRecap_i.Add(50);
ColumnHeaderDefaultSizeCheckingRecap_i.Add(300);
// alignment
for (int i = 0; i < ColumnHeaderNameCheckingRecap_ST.Count; i++)
{
if (i == 2 || i == 4 || i == 7)
{
TextAlignCheckingRecap_O.Add(HorizontalAlignment.Center);
}
else
{
TextAlignCheckingRecap_O.Add(HorizontalAlignment.Left);
}
}
MemberDayChickingViewer.Initialize(mDBManager_O, DateTime.Today, 0, true);
DBListViewMembers.AllowMultipleSelecion = false;
DepartmentSelector.Initialize(mDBManager_O);
DepartmentSelector.DepartmentsModified += new DepartmentSelector.DepartmentsModifiedHandler(this.ValueChanged);
ToolStripMemberDocuments.Renderer = new BorderlessToolStripRenderer();
ControlStyle.SetBackgroundStyle(this);
ControlStyle.SetBackgroundStyle(ToolStripUCMembersTools);
ControlStyle.SetFrameHeaderStyle(this.PanelMembersList);
ControlStyle.SetFrameHeaderStyle(this.PanelCheckHeader);
ControlStyle.SetFrameStyle(this.PanelCheckContent);
ControlStyle.SetFrameHeaderStyle(this.splitContainer2.Panel2);
ControlStyle.SetFrameHeaderStyle(this.splitContainer2.Panel1);
ControlStyle.SetFrameStyle(this.PanelCheckContent);
ControlStyle.SetFrameStyle(this.ToolStripMemberEditFooter);
ControlStyle.SetFrameStyle(this.DepartmentSelector);
ControlStyle.SetFrameStyle(this.ToolStripMemberDocuments);
}
public ProviderUC(DatabaseManager DBManager_O)
{
InitializeComponent();
mInitializingData_b = false;
// Add btn tool tool strip list view
this.DBListViewProvider.ListTitle = "Sélection fournisseur";
this.DBListViewProvider.AddToolStripBtn(this.ToolStripBtnAddProvider);
ToolStripUCProviderTools.Visible = false;
this.DBListViewBuyRecap.ListTitle = "Achats chez le fournisseur";
ToolStripUCProviderTools.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("NumFournInterne");
TableField_ST.Add("FournNom");
TableField_ST.Add("NrTVA");
TableField_ST.Add("FournID");
ColumnHeaderName_ST.Add("N° de fournisseur");
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);
DBListViewProvider.Initialize(mDBManager_O, "Fourn", TableField_ST, 3, ColumnHeaderName_ST, ColumnHeaderDefaultSize_i, TextAlign_O);
DBListViewProvider.SelectionChanged += new DBListView.SelectionChangedHandler(this.ProviderClick);
DBComboxTypeSoc.FillList(mDBManager_O, "TypeSoc", "TypeSocID", "TypeSocLib");
DBComboxCPFact.FillList(mDBManager_O, "CodePostal", "CodePostalID", "CodePostal");
DBComboxCPLibFact.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>();
// 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);
}
}
DBListViewBuyRecap.Initialize(mDBManager_O, "ComJobAchatSelectPop", TableFieldJobRecap_ST, 10, ColumnHeaderNameJobRecap_ST, ColumnHeaderDefaultSizeJobRecap_i, TextAlignJobRecap_O, null, null, false);
Fields_O = new List <Control>();
Fields_O.Add(DBComboxTypeSoc);
Fields_O.Add(DBComboxCPFact);
Fields_O.Add(DBComboxCPLibFact);
Fields_O.Add(TxtTel);
Fields_O.Add(TxtFax);
Fields_O.Add(TxtAdressFact);
Fields_O.Add(TxtContactMail);
Fields_O.Add(TxtContactTel);
Fields_O.Add(TxtContactName);
Fields_O.Add(TxtTVA);
Fields_O.Add(TxtMail);
Fields_O.Add(TxtRem);
SetEditState(false);
TxtProviderNumber.Width = Math.Max(50, TxtProviderNumber.Width);
TxtProviderName.Width = ToolStripProviderHeader.Width - toolStripLabel1.Width - TxtProviderNumber.Width - toolStripLabel3.Width - 5;
ToolStripProviderEditFooter.Renderer = new BorderlessToolStripRenderer();
ToolStripProviderHeader.Renderer = new BorderlessToolStripRenderer();
ControlStyle.SetBackgroundStyle(this);
ControlStyle.SetBackgroundStyle(this.ToolStripUCProviderTools);
ControlStyle.SetFrameHeaderStyle(this.PanelProviderList);
ControlStyle.SetFrameHeaderStyle(this.PanelCheckHeader);
ControlStyle.SetFrameHeaderStyle(this.PanelJobRecap);
ControlStyle.SetFrameHeaderStyle(this.splitContainer2.Panel1);
ControlStyle.SetFrameStyle(this.PanelCheckContent);
ControlStyle.SetFrameStyle(this.ToolStripProviderEditFooter);
DBListViewProvider.ForeColor = Color.Black;
}
public void Initialize(DatabaseManager DBManager_O, String TableName_ST, List <String> TableFields_ST, UInt32 DBIDIndex_UL, List <String> ColumnHeaderName_ST,
List <int> ColumnHeaderDefaultSize_O, List <HorizontalAlignment> TextAlig_O, String InitialWhere_ST = null, String OrderBy_ST = null, bool InitList_b = true)
{
mDBManager_O = DBManager_O;
mDBIDIndex_UL = DBIDIndex_UL;
mTableFields_ST = TableFields_ST;
mTableName_ST = TableName_ST;
mColumnHeaderName_ST = ColumnHeaderName_ST;
mLastClickedFilterIndex_i = -1;
Asc_b = true;
mLastSQLRequest_st = "";
mInitialWhere_ST = InitialWhere_ST;
mInitialOrderBy_ST = OrderBy_ST;
mListView_O.View = View.Details;
mListView_O.FullRowSelect = true;
PanelListView.Controls.Add(mListView_O);
mListView_O.BringToFront();
mListView_O.Dock = DockStyle.Fill;
mListView_O.ColumnClick += new ColumnClickEventHandler(this.ColumnClick);
mListView_O.ColumnWidthChanging += new ColumnWidthChangingEventHandler(this.ColumnWidthChanging);
mListView_O.ColumnWidthChanged += new ColumnWidthChangedEventHandler(this.ColumnWidthChanged);
mListView_O.ItemSelectionChanged += new ListViewItemSelectionChangedEventHandler(this.ListViewItemSelectionChanged);
mListView_O.MouseDoubleClick += new System.Windows.Forms.MouseEventHandler(this.MouseDoubleClick);
mListView_O.MouseClick += new System.Windows.Forms.MouseEventHandler(this.MouseClick);
// Define column headers objects
List <ColumnHeader> ColumnHeaders_O = new List <ColumnHeader>();
mFilterTextBox_O = new List <TextBox>();
for (int i = 0; i < mColumnHeaderName_ST.Count; i++)
{
// Define column header
ColumnHeaders_O.Add(new ColumnHeader());
ColumnHeaders_O[i].Name = mTableFields_ST[i];
ColumnHeaders_O[i].Text = mColumnHeaderName_ST[i];
ColumnHeaders_O[i].TextAlign = TextAlig_O[i];
ColumnHeaders_O[i].Width = ColumnHeaderDefaultSize_O[i];
// Add it to list view
mListView_O.Columns.Add(ColumnHeaders_O[i]);
// Define filter text box
mFilterTextBox_O.Add(new TextBox());
PanelFilter.Controls.Add(mFilterTextBox_O[i]);
mFilterTextBox_O[i].TabIndex = i;
mFilterTextBox_O[i].Tag = i;
mFilterTextBox_O[i].TextChanged += new System.EventHandler(this.FilterTextChanged);
mFilterTextBox_O[i].Width = ColumnHeaders_O[i].Width - 2 * mFilterPadding_i; // cannot control height of textbox ! so it is set to 20 and filter panel is 22 to get a padding of 1 pixel
mFilterTextBox_O[i].Location = new Point((i == 0) ? mFilterPadding_i : mFilterTextBox_O[i - 1].Location.X + mFilterTextBox_O[i - 1].Width + 2 * mFilterPadding_i, mFilterPadding_i);
mFilterTextBox_O[i].BorderStyle = BorderStyle.FixedSingle;
mFilterTextBox_O[i].BackColor = Color.Gainsboro;
}
ControlStyle.SetFrameHeaderStyle(MainToolStrip);
MainToolStrip.Renderer = new BorderlessToolStripRenderer();
ControlStyle.SetFrameStyle(this);
ControlStyle.SetFrameStyle(PanelListView);
ControlStyle.SetFrameStyle(PanelFilter);
if (InitList_b)
{
this.Refresh();
}
mInitialized_b = true;
SelectFirst();
}
/// <summary>
/// Constructor
/// </summary>
public FormChecking(DatabaseManager DBManager_O, UInt32 UserID_UL)
{
InitializeComponent();
// Init Database Manager
mDBManager_O = DBManager_O;
mDocManager_O = new DocumentManager(mDBManager_O);
mUserID_UL = UserID_UL;
DbListViewComJobs.AddToolStripBtn(ToolStripBtnAddChecking);
DbListViewComJobs.AddToolStripBtn(ToolStripBtnCloseJob);
DbListViewComJobs.AddToolStripBtn(ToolStripBtnAll);
FormCheckingToolStrip.Visible = false;
// Set drag bar parent window an title
this.FormDragBar.SetParentWindow(this);
this.FormDragBar.SetTitle("MMSoft - Pointages");
// Initialize db list view com job
DbListViewComJobs.ListTitle = "Sélection des jobs";
// Define column DB fields
mComJobTableField_ST = new List <String>();
mComJobTableField_ST.Add("NumRefInterne");
mComJobTableField_ST.Add("LibelleCmd");
mComJobTableField_ST.Add("NumCmdClient");
mComJobTableField_ST.Add("ClientNom");
mComJobTableField_ST.Add("NumOrdre");
mComJobTableField_ST.Add("JobLib");
mComJobTableField_ST.Add("Qte");
mComJobTableField_ST.Add("NumPlan");
mComJobTableField_ST.Add("DelaiPromis");
mComJobTableField_ST.Add("JobStatusLib");
//mComJobTableField_ST.Add("DateEncod");
// Unshown elements
mComJobTableField_ST.Add("ComJobID");
// Define column headers text
mComJobColumnHeaderName_ST = new List <string>();
mComJobColumnHeaderName_ST.Add("Num cmd int");
mComJobColumnHeaderName_ST.Add("Libellé cmd");
mComJobColumnHeaderName_ST.Add("Num cmd client");
mComJobColumnHeaderName_ST.Add("Nom client");
mComJobColumnHeaderName_ST.Add("# job");
mComJobColumnHeaderName_ST.Add("Job libellé");
mComJobColumnHeaderName_ST.Add("Qte");
mComJobColumnHeaderName_ST.Add("Num plan");
mComJobColumnHeaderName_ST.Add("Délai");
mComJobColumnHeaderName_ST.Add("Statut");
//mComJobColumnHeaderName_ST.Add("Date encodage");
// Define column headers objects
mComJobTextAlign_O = new List <HorizontalAlignment>();
for (int i = 0; i < mComJobColumnHeaderName_ST.Count; i++)
{
if (i == 4 || i == 6)
{
mComJobTextAlign_O.Add(HorizontalAlignment.Center);
}
else
{
mComJobTextAlign_O.Add(HorizontalAlignment.Left);
}
}
mComJobColumnHeaderDefaultSize_i = new List <int>();
mComJobColumnHeaderDefaultSize_i.Add(100);
mComJobColumnHeaderDefaultSize_i.Add(100);
mComJobColumnHeaderDefaultSize_i.Add(150);
mComJobColumnHeaderDefaultSize_i.Add(150);
mComJobColumnHeaderDefaultSize_i.Add(50);
mComJobColumnHeaderDefaultSize_i.Add(600);
mComJobColumnHeaderDefaultSize_i.Add(50);
mComJobColumnHeaderDefaultSize_i.Add(100);
mComJobColumnHeaderDefaultSize_i.Add(100);
mComJobColumnHeaderDefaultSize_i.Add(100);
mComJobColumnHeaderDefaultSize_i.Add(100);
DbListViewComJobs.Initialize(mDBManager_O, "PersComJobSelectPop", mComJobTableField_ST, 10, mComJobColumnHeaderName_ST, mComJobColumnHeaderDefaultSize_i, mComJobTextAlign_O,
"JobStatusID < 3 AND PersID=" + mUserID_UL, null);
DbListViewComJobs.ItemDoubleClicked += new DBListView.ItemDoubleClickedHandler(ComJobDoubleClick);
// Initialize day checking viewer
DayCheckingViewerCtrl.Initialize(mDBManager_O, DateTime.Today, mUserID_UL, false);
DayCheckingViewerCtrl.RefreshPersPointage();
this.splitContainer1.SplitterDistance = this.Height / 3;
// Set menu items renderer
MainMenuStrip.RenderMode = ToolStripRenderMode.Professional;
MainMenuStrip.Renderer = new CustomMenuItemRenderer();
//Display user name
if (mDBManager_O.mConnected_b)
{
LblUsername.Text = mDBManager_O.GetTableField("Pers", "PersNom", "PersID=" + mUserID_UL);
}
LblConnectionStatus.Text = mDBManager_O.mDBInstanceName_ST;
// Set control style
ControlStyle.SetBackgroundStyle(this.splitContainer1);
ControlStyle.SetFrameHeaderStyle(this.splitContainer1.Panel1);
ControlStyle.SetFrameHeaderStyle(this.splitContainer1.Panel2);
ControlStyle.SetBackgroundStyle(MainMenuStrip);
ControlStyle.SetBackgroundStyle(this.StatusStripFormChecking);
RefreshPersPointage();
}