public static Tartim[] getTartims(DateTime Date1, DateTime Date2, Tartim.SCENARIO Scenario, PlateNumber Plate)
{
Program.sql.connect();
Program.sql.initializeStoredProcedure("SP_TARTIM_SEARCH");
Program.sql.addStoredProcedureParameter("@DATE1", new DateTime(Date1.Year, Date1.Month, Date1.Day, 0, 0, 0));
Program.sql.addStoredProcedureParameter("@DATE2", new DateTime(Date2.Year, Date2.Month, Date2.Day, 23, 59, 59));
if (Scenario != Tartim.SCENARIO.NULL)
{
Program.sql.addStoredProcedureParameter("@TARTI", Tartim.parseScenario(Scenario));
}
if (Plate != null && Plate.plateNumber != null && Plate.plateNumber.Trim().Length > 0)
{
Program.sql.addStoredProcedureParameter("@TRAID", Plate.plateNumber);
}
DataTable dt = Program.sql.executeStoredProcedureReader();
if (dt == null)
{
return(null);
}
Tartim[] ret = new Tartim[dt.Rows.Count];
for (int n = 0; n < dt.Rows.Count; n++)
{
ret[n] = new Tartim(dt.Rows[n]);
}
return(ret);
}
public FormWeight2(Tartim.SCENARIO Scenario)
{
InitializeComponent();
// Senaryo
scenario = Scenario;
// Tartýmlarý çekelim ve Combobox'a dolduralým
tartims = Tartim.getTartims(scenario);
if (tartims == null)
{
MessageBox.Show("Herhangi bir açýk tartým bulunamadý");
this.Close();
return;
}
cmbPlate.Items.Clear();
for (int n = 0; n < tartims.Length; n++)
{
cmbPlate.Items.Add(tartims[n].plateNumber.plateNumber);
}
// Senaryoya baðlý olarak belli alanlarý kapatacaðýz
if (scenario != Tartim.SCENARIO.SALES)
{
txtBag.Enabled = false;
}
// Event'leri serbest býrak
enablePlateEvents = true;
}
private void displayFormWeight1(Tartim.SCENARIO S)
{
if (Program.frmW1 == null || Program.frmW1.Visible == false)
{
Program.frmW1 = new FormWeight1(S);
Program.frmW1.Show();
}
}
private void displayFormWeight2(Tartim.SCENARIO S)
{
try
{
if (Program.frmW2 == null || Program.frmW2.Visible == false)
{
Program.frmW2 = new FormWeight2(S);
Program.frmW2.Show();
}
} catch { }
}
private void getTartims()
{
Tartim.SCENARIO s = Tartim.SCENARIO.NULL;
switch (cmbScenario.SelectedIndex)
{
case 0:
s = Tartim.SCENARIO.NULL;
break;
case 1:
s = Tartim.SCENARIO.PURCHASING;
break;
case 2:
s = Tartim.SCENARIO.SALES;
break;
}
tartims = Tartim.getTartims(date1.Value, date2.Value, s, ucPlate1.plateNumber);
}
public static Material[] getAll(Tartim.SCENARIO S)
{
Material[] ret;
DataTable dt = new DataTable();
Program.sql.connect();
switch (S)
{
case Tartim.SCENARIO.PURCHASING:
Program.sql.initializeStoredProcedure("SP_MARA_GET_PURCHASEABLES");
dt = Program.sql.executeStoredProcedureReader();
break;
case Tartim.SCENARIO.SALES:
Program.sql.initializeStoredProcedure("SP_MARA_GET_SELLABLES");
dt = Program.sql.executeStoredProcedureReader();
break;
}
if (dt == null)
{
return(null);
}
if (dt.Rows.Count <= 0)
{
return(null);
}
ret = new Material[dt.Rows.Count];
for (int n = 0; n < dt.Rows.Count; n++)
{
ret[n] = new Material(dt.Rows[n]["MATNR"].ToString(), dt.Rows[n]["MAKTX_TR"].ToString(), dt.Rows[n]["MAKTX_AR"].ToString(), new MaterialGroup(dt.Rows[0]["MATKL"].ToString(), dt.Rows[0]["WGBEZ_TR"].ToString(), dt.Rows[0]["WGBEZ_AR"].ToString()), dt.Rows[n]["SELLA"].ToString() == "X");
}
return(ret);
}
public FormWeight1(Tartim.SCENARIO Scenario)
{
InitializeComponent();
scenario = Scenario;
init();
}
