public RaportCumulatMuncitorIMO(ScanareIMO s, ScanareDetaliiIMO det)
{
this.Firma = s.Firma;
this.DataScanare = s.DataScanare;
this.Ambalaj = det.Ambalaj;
this.Numar = Convert.ToInt32(det.Numar);
this.Greutate = det.Greutate;
this.TotalGreutateZi = s.TotalGreutateZi;
this.TotalGreutatePerioada += s.TotalGreutateZi;
this.DataStart = s.DataStart;
this.DataEnd = s.DataEnd;
this.SefEchipa = s.SefEchipa;
}
internal IList<ScanareIMO> GetScanariAmbalaje(string firma,string ambalaj, DateTime dataStart, DateTime dataEnd)
{
List<ScanareIMO> ret = null;
IList<ScanareDetaliiIMO> listDetalii=null;
DateTime dataE = new DateTime();
DateTime dataS = new DateTime();
ScanareIMO scanare=null;
decimal totalGreutateZi = 0;
try
{
ret = new List<ScanareIMO>();
for (DateTime date = dataStart.Date; date < dataEnd.Date.AddDays(1).AddMilliseconds(-1); date += TimeSpan.FromDays(1))
{
IList param = new ArrayList();
dataS = date;
dataE = dataS.Date.AddDays(1).AddMilliseconds(-1);
param.Add(new QueryParameter("xDataS", date.Date, "s.DataScanare", OperatorType.GreatherOrEquals, OperatorJoinType.AND));
param.Add(new QueryParameter("xDataE", dataE, "s.DataScanare", OperatorType.LessOrEquals, OperatorJoinType.AND));
if (ambalaj != "" && ambalaj != "ALL")
{
param.Add(new QueryParameter("xDenumireA", ambalaj, "a.Denumire", OperatorType.Equals, OperatorJoinType.AND));
}
if (firma != "" && firma != "ALL")
{
param.Add(new QueryParameter("yDenumireF", firma, "f.Denumire", OperatorType.Equals, OperatorJoinType.AND));
}
listDetalii = dao.ExecuteHql("select new ScanareDetaliiIMO(a,count(s.Id),sum(a.Greutate)) " +
" from Scanare s inner join s.Muncitor m inner join m.Firma f "+
" inner join s.Ambalaj a group by a.Denumire",
param).Cast<ScanareDetaliiIMO>().ToList<ScanareDetaliiIMO>().AsReadOnly();
if (listDetalii.Count != 0)
{
scanare = new ScanareIMO();
scanare.DataScanare = date;
scanare.DataStart = dataStart;
scanare.DataEnd = dataEnd;
scanare.Firma = firma;
totalGreutateZi = 0;
foreach (ScanareDetaliiIMO det in listDetalii)
{
scanare.Detalii.Add(det);
totalGreutateZi += det.Greutate;
}
scanare.TotalGreutateZi = totalGreutateZi;
ret.Add(scanare);
}
param = null;
}
}
catch (Exception ex)
{
throw ex;
}
return ret;
}
private IList<ScanareIMO> GetScanareDetaliiIMO(Persoana p, DateTime dataStart, DateTime dataEnd)
{
IList<ScanareDetaliiIMO> list = null;
IList<ScanareIMO> scanari = null;
ScanareIMO scanare = null;
DateTime dataE = new DateTime();
DateTime dataS = new DateTime();
try
{
scanari = new List<ScanareIMO>();
for (DateTime date = dataStart.Date; date < dataEnd.Date.AddDays(1).AddMilliseconds(-1); date += TimeSpan.FromDays(1))
{
IList param = new ArrayList();
dataS = date;
dataE = dataS.Date.AddDays(1).AddMilliseconds(-1);
param.Add(new QueryParameter("xDataS", date.Date, "s.DataScanare", OperatorType.GreatherOrEquals, OperatorJoinType.AND));
param.Add(new QueryParameter("xDataE", dataE, "s.DataScanare", OperatorType.LessOrEquals, OperatorJoinType.AND));
param.Add(new QueryParameter("xPId", p.Id, "m.Id", OperatorType.Equals, OperatorJoinType.AND));
list = dao.ExecuteHql("select new ScanareDetaliiIMO(m, s) " +
" from Scanare s inner join s.Muncitor m ", param).Cast<ScanareDetaliiIMO>().ToList <ScanareDetaliiIMO>().AsReadOnly();
if (list.Count != 0)
{
scanare = new ScanareIMO();
scanare.Nume = p.Nume;
scanare.Prenume = p.Prenume;
scanare.DataScanare = date;
scanare.Detalii = list;
scanare.Firma = p.Firma.Denumire;
scanare.SefEchipa = list[0].Sef;
scanari.Add(scanare);
}
param = null;
}
}
catch (Exception ex)
{
throw ex;
}
return scanari;
}
private void grdScanari_SelectionChanged(object sender, EventArgs e)
{
if (bindingSource1.Current != null)
{
scanareCurenta = bindingSource1.Current as ScanareIMO;
}
else
{
//scanareCurenta = new ScanareIMO();
MessageBox.Show("Criteriile specificate nu au returnat vreun rezultat");
return;
}
detalii = scanareCurenta.Detalii;
bindingSource3.DataSource = detalii;
grdDetalii.Update(true);
PopulateScanariDetalii();
}
