public IList <BinByTaskExecution> Select(BinByTaskExecution data)
{
IList <BinByTaskExecution> datos = new List <BinByTaskExecution>();
try {
datos = GetHsql(data).List <BinByTaskExecution>();
if (!Factory.IsTransactional)
{
Factory.Commit();
}
}
catch (Exception e)
{
NHibernateHelper.WriteEventLog(WriteLog.GetTechMessage(e));
}
return(datos);
}
void View_ChangeCountedQty(object sender, DataEventArgs <object[]> e)
{
if (e.Value == null)
{
return;
}
//Change Quantitie.
BinByTaskExecution bte = new BinByTaskExecution {
RowID = int.Parse(e.Value[0].ToString())
};
bte = service.GetBinByTaskExecution(bte).First();
bte.QtyCount = double.Parse(e.Value[1].ToString());
bte.ModDate = DateTime.Now;
bte.ModifiedBy = App.curUser.UserName;
//Update the execution
service.UpdateBinByTaskExecution(bte);
View.Model.CountSummary = service.GetCountSummary(View.Model.Document, false);
RefreshCountSummary();
}
public void DeleteBinByTaskExecution(BinByTaskExecution data)
{
try
{
SetService(); SerClient.DeleteBinByTaskExecution(data);
}
finally
{
SerClient.Close();
if (SerClient.State == CommunicationState.Faulted)
SerClient.Abort();
}
}
public BinByTaskExecution SaveBinByTaskExecution(BinByTaskExecution data)
{
try
{
SetService(); return SerClient.SaveBinByTaskExecution(data);
}
finally
{
SerClient.Close();
if (SerClient.State == CommunicationState.Faulted)
SerClient.Abort();
}
}
public override IQuery GetHsql(Object data)
{
StringBuilder sql = new StringBuilder("select a from BinByTaskExecution a where ");
BinByTaskExecution binTask = (BinByTaskExecution)data;
if (binTask != null)
{
Parms = new List <Object[]>();
if (binTask.RowID != 0)
{
sql.Append(" a.RowID = :id and ");
Parms.Add(new Object[] { "id", binTask.RowID });
}
if (binTask.Status != null && binTask.Status.StatusID != 0)
{
sql.Append(" a.Status.StatusID = :idd5 and ");
Parms.Add(new Object[] { "idd5", binTask.Status.StatusID });
}
if (binTask.Sequence > 0)
{
sql.Append(" a.Sequence = :idd6 and ");
Parms.Add(new Object[] { "idd6", binTask.Sequence });
}
if (!string.IsNullOrEmpty(binTask.CountSession))
{
sql.Append(" a.CountSession = :idcs and ");
Parms.Add(new Object[] { "idcs", binTask.CountSession });
}
if (binTask.Product != null && binTask.Product.ProductID != 0)
{
sql.Append(" a.Product.ProductID = :ip5 and ");
Parms.Add(new Object[] { "ip5", binTask.Product.ProductID });
}
//Adicionado en FEB 25 /2010
if (binTask.Bin != null && binTask.Bin.BinID != 0)
{
sql.Append(" a.Bin.BinID = :ib5 and ");
Parms.Add(new Object[] { "ib5", binTask.Bin.BinID });
}
if (binTask.UnitCount != null && binTask.UnitCount.UnitID != 0)
{
sql.Append(" a.UnitCount.UnitID = :ibu5 and ");
Parms.Add(new Object[] { "ibu5", binTask.UnitCount.UnitID });
}
if (binTask.StockLabel != null && binTask.StockLabel.LabelID != 0)
{
if (binTask.StockLabel.LabelID > 0)
{
sql.Append(" a.StockLabel.LabelID = :lb5 and ");
Parms.Add(new Object[] { "lb5", binTask.StockLabel.LabelID });
}
else
{
sql.Append(" a.StockLabel.LabelID IS NULL and ");
}
}
if (binTask.BinTask != null)
{
if (binTask.BinTask.RowID != 0)
{
sql.Append(" a.BinTask.RowID = :idd1 and ");
Parms.Add(new Object[] { "idd1", binTask.BinTask.RowID });
}
if (binTask.BinTask.Product != null && binTask.BinTask.Product.ProductID != 0)
{
sql.Append(" a.BinTask.Product.ProductID = :ip4 and ");
Parms.Add(new Object[] { "ip4", binTask.BinTask.Product.ProductID });
}
if (binTask.BinTask.Bin != null && binTask.BinTask.Bin.BinID != 0)
{
sql.Append(" a.BinTask.Bin.BinID = :idd4 and ");
Parms.Add(new Object[] { "idd4", binTask.BinTask.Bin.BinID });
}
if (binTask.BinTask.Bin != null && !String.IsNullOrEmpty(binTask.BinTask.Bin.BinCode))
{
sql.Append(" a.BinTask.Bin.BinCode = :idd2 and ");
Parms.Add(new Object[] { "idd2", binTask.BinTask.Bin.BinCode });
}
if (binTask.BinTask.TaskDocument != null && binTask.BinTask.TaskDocument.DocID != 0)
{
sql.Append(" a.BinTask.TaskDocument.DocID = :idd3 and ");
Parms.Add(new Object[] { "idd3", binTask.BinTask.TaskDocument.DocID });
}
}
}
sql = new StringBuilder(sql.ToString());
sql.Append("1=1 order by a.BinTask.Bin.BinCode, a.Sequence Desc ");
IQuery query = Factory.Session.CreateQuery(sql.ToString());
SetParameters(query);
return(query);
}
public BinByTaskExecution SelectById(BinByTaskExecution data)
{
return((BinByTaskExecution)base.SelectById(data));
}
public Boolean Delete(BinByTaskExecution data)
{
return(base.Delete(data));
}
public Boolean Update(BinByTaskExecution data)
{
return(base.Update(data));
}
public BinByTaskExecution Save(BinByTaskExecution data)
{
return((BinByTaskExecution)base.Save(data));
}
void View_ChangeCountedQty(object sender, DataEventArgs<object[]> e)
{
if (e.Value == null)
return;
//Change Quantitie.
BinByTaskExecution bte = new BinByTaskExecution { RowID = int.Parse(e.Value[0].ToString()) };
bte = service.GetBinByTaskExecution(bte).First();
bte.QtyCount = double.Parse(e.Value[1].ToString());
bte.ModDate = DateTime.Now;
bte.ModifiedBy = App.curUser.UserName;
//Update the execution
service.UpdateBinByTaskExecution(bte);
View.Model.CountSummary = service.GetCountSummary(View.Model.Document, false);
RefreshCountSummary();
}
