private void TypeComboBox_SelectedValueChanged(object sender, EventArgs e)
{
this.PoleCombobox.Clear();
this.PoleCombobox.setTextBox("");
if (this.TypeComboBox.SelectedItem.ToString() == "Carte Naftal")
{
this.checkBoxCalc.Checked = false;
this.checkBoxCalc.Enabled = false;
DataTable cardDt = GGAO.NaftalCardCRUDOps.getVisibleNaftalCard();
this.PoleCombobox.SourceDataString = Tools.ConvColNametoArray(cardDt.Columns);
this.PoleCombobox.DataSource = cardDt;
if (this.InsertOrUpdate)
{
this.ReftextBox.Text = "CRD" +
GGAO.ConsommationCRUDOps.getLastPieceNumber("getLastPieceNumberNaftalCard");
}
// "getLastPieceNumber"; //
//#ERROR452
}
else
{
this.checkBoxCalc.Checked = true;
this.checkBoxCalc.Enabled = true;
DataTable poleDtDES = GGAO.PoleCRUDOps.getVisiblePole(true, "SELECT");
this.PoleCombobox.SourceDataString = Tools.ConvColNametoArray(poleDtDES.Columns);
this.PoleCombobox.DataSource = poleDtDES;
if (this.InsertOrUpdate)
{
this.ReftextBox.Text = GGAO.ConsommationCRUDOps.getLastPieceNumber("getLastPieceNumber");
}
}
PoleCombobox.setTextBox(this.selectedPoleLib);
}
private void loadCardDataIntoCombo()
{
DataTable poleDtDES = GGAO.NaftalCardCRUDOps.getVisibleNaftalCard();
this.PoleCombobox.Clear();
PoleCombobox.SourceDataString = Tools.ConvColNametoArray(poleDtDES.Columns);
PoleCombobox.DataSource = poleDtDES;
PoleCombobox.setTextBox(this.selectedPoleLib);
}
void ResetFields()
{
ReftextBox.Text = "";
TypeComboBox.Text = "";
QuanitytextBox.Text = "";
KilotextBox.Text = "";
DriverCombobox.setTextBox("");
PoleCombobox.setTextBox("");
ProductCombobox.setTextBox("");
}
private void comboBox1_SelectedValueChanged(object sender, EventArgs e)
{
DataTable poleDtRM = (itsSource()) ? GGAO.PoleCRUDOps.getVisiblePole(true, "SELECT") : GGAO.PoleCRUDOps.getVisiblePole(false, "SELECT");
this.PoleCombobox.Clear();
PoleCombobox.SourceDataString = GGAO.Utilities.Tools.ConvColNametoArray(poleDtRM.Columns);
PoleCombobox.DataSource = poleDtRM;
PoleCombobox.setTextBox("");
}
void ResetFields()
{
ReftextBox.Text = "REF" + System.DateTime.Now.Day.ToString();
TypeComboBox.Text = "Bon Transfer";
//TypeComboBox.ValueMember
QuanitytextBox.Text = "";
KilotextBox.Text = "";
DriverCombobox.setTextBox("");
PoleCombobox.setTextBox("");
ToPoleCombobox.setTextBox("");
ProductCombobox.setTextBox("");
EngineCombobox.setTextBox("");
}
private void FiltreCancelBtn_Click(object sender, EventArgs e)
{
fromThisDate.Value = System.DateTime.Today;
toThisDate.Value = System.DateTime.Today;
ReftextBox.Text = "";
TypeComboBox.Text = "";
KilotextBox.Text = "";
QuanitytextBox.Text = "";
EngineCombobox.setTextBox(""); EngineCombobox.SelectedItem = null;
DriverCombobox.setTextBox(""); DriverCombobox.SelectedItem = null;
ProductCombobox.setTextBox(""); ProductCombobox.SelectedItem = null;
PoleCombobox.setTextBox(""); PoleCombobox.SelectedItem = null;
ImputationComboBox.setTextBox(""); ImputationComboBox.SelectedItem = null;
}
void ResetFields()
{
this.ReftextBox.Text =
(this.TypeComboBox.SelectedItem.ToString() == "Carte Naftal") ?
GGAO.ConsommationCRUDOps.getLastPieceNumber("getLastPieceNumberNaftalCard"):
GGAO.ConsommationCRUDOps.getLastPieceNumber("getLastPieceNumber");
//TypeComboBox.Text = "Bon Pour"; // ValueMember
QuanitytextBox.Text = "";
KilotextBox.Text = "";
DriverCombobox.setTextBox("");
PoleCombobox.setTextBox("");
this.ImputationComboBox.setTextBox("");
ProductCombobox.setTextBox("");
EngineCombobox.setTextBox("");
}
private void InsertUpdateTransfer_Load(object sender, EventArgs e)
{
// load the tables
DataTable poleDtSD = GGAO.PoleCRUDOps.getVisiblePole(true, "SELECT");
DataTable driverDt = GGAO.DriverCRUDOps.getVisibleDriver();
DataTable engineDt = GGAO.EngineCRUDOps.getVisibleEngine();
DataTable produitDt = GGAO.ProductCRUDOps.getVisibleProduct();
this.PoleCombobox.Clear();
this.ToPoleCombobox.Clear();
this.DriverCombobox.Clear();
this.EngineCombobox.Clear();
this.ProductCombobox.Clear();
// auto generate this column
//multiColumComboBox.SourceDataString = ColumnNames.ToArray();
PoleCombobox.SourceDataString = Tools.ConvColNametoArray(poleDtSD.Columns);
ToPoleCombobox.SourceDataString = Tools.ConvColNametoArray(poleDtSD.Columns);
DriverCombobox.SourceDataString = Tools.ConvColNametoArray(driverDt.Columns);
EngineCombobox.SourceDataString = Tools.ConvColNametoArray(engineDt.Columns);
ProductCombobox.SourceDataString = Tools.ConvColNametoArray(produitDt.Columns);
PoleCombobox.DataSource = poleDtSD;
ToPoleCombobox.DataSource = poleDtSD;
DriverCombobox.DataSource = driverDt;
EngineCombobox.DataSource = engineDt;
ProductCombobox.DataSource = produitDt;
//multiColumComboBox.setTextBox(this.selectedPoleLibelle.Trim());
DriverCombobox.setTextBox(this.selectedDriverLib);
PoleCombobox.setTextBox(this.selectedPoleLib);
ToPoleCombobox.setTextBox(this.selectedToPoleLib);
ProductCombobox.setTextBox(this.selectedProductLib);
//_Engine.Split('-')[0].Trim();
EngineCombobox.setTextBox(this.selectedEngineLib.Split('-')[0].Trim());
this.PoleCombobox.setFilter(new int[] { 1, 2, 3 });
this.DriverCombobox.setFilter(new int[] { 1, 2, 3 });
this.EngineCombobox.setFilter(new int[] { 1, 2, 3, 5, 7 });
this.ProductCombobox.setFilter(new int[] { 1, 2, 3 });
this.dateTimePicker.Value = System.DateTime.Today;
}
private void ReportWindow_Load(object sender, EventArgs e)
{
DataTable poleDtRM = (itsSource())? GGAO.PoleCRUDOps.getVisiblePole(true, "SELECT") : GGAO.PoleCRUDOps.getVisiblePole(false, "SELECT");
this.PoleCombobox.Clear();
PoleCombobox.SourceDataString = GGAO.Utilities.Tools.ConvColNametoArray(poleDtRM.Columns);
PoleCombobox.DataSource = poleDtRM;
PoleCombobox.setTextBox("");
this.PoleCombobox.setFilter(new int[] { 1, 2 });
this.fromDatePkr.Value = System.DateTime.Now;
this.ToDatePkr.Value = System.DateTime.Now;
//this.rptViewer.RefreshReport();
//this.ShowReport();
//this.rptViewer.RefreshReport();
}
private void raportJournalier_Load(object sender, EventArgs e)
{
DataTable poleDtrj = GGAO.PoleCRUDOps.getVisiblePole(false, "SELECT");
DataTable SourceDtrj = GGAO.PoleCRUDOps.getVisiblePole(true, "SELECT");
this.PoleCombobox.Clear();
this.SourceComboBox.Clear();
this.PoleCombobox.setFilter(new int[] { 1, 2 });
this.SourceComboBox.setFilter(new int[] { 1, 2 });
this.dateTimePickerLocal.Value = System.DateTime.Now;
PoleCombobox.SourceDataString = GGAO.Utilities.Tools.ConvColNametoArray(poleDtrj.Columns);
SourceComboBox.SourceDataString = GGAO.Utilities.Tools.ConvColNametoArray(SourceDtrj.Columns);
PoleCombobox.DataSource = poleDtrj;
SourceComboBox.DataSource = SourceDtrj;
PoleCombobox.setTextBox("");
SourceComboBox.setTextBox("");
}