public ICollection <SCEEmbarque> Get(
DateTime FechaInicio, DateTime FechaFinal,
string IdCampana, string IdSucursal, string Cliente, string NroPackingList)
{
List <SCEEmbarque> embarques = new List <SCEEmbarque>();
try
{
DbCommand cmd;
cmd = objDBSCE.GetStoredProcCommand(EsquemaSCE + ".[PR_SCE_INSTRUCCION_QRY_ParaDocumento]");
objDBSCE.AddInParameter(cmd, "@FechaInicio", DbType.Date, FechaInicio);
objDBSCE.AddInParameter(cmd, "@FechaFin", DbType.Date, FechaFinal);
objDBSCE.AddInParameter(cmd, "@IdCampaña", DbType.String, IdCampana);
objDBSCE.AddInParameter(cmd, "@IdSucursal", DbType.String, IdSucursal);
objDBSCE.AddInParameter(cmd, "@Cliente", DbType.String, Cliente);
objDBSCE.AddInParameter(cmd, "@NroPackingList", DbType.String, NroPackingList);
foreach (DataRow dr in objDBSCE.ExecuteDataSet(cmd).Tables[0].Rows)
{
SCEEmbarque pr = new SCEEmbarque();
pr.NroPackingList = dr[0].ToString();
pr.IdInstruccion = int.Parse(dr[1].ToString());
pr.Instruccion = dr[2].ToString();
pr.Embarque = dr[3].ToString();
pr.FechaEmbarque = DateTime.Parse(dr[4].ToString());
pr.FechaArribo = DateTime.Parse(dr[5].ToString());
pr.Cantidad = decimal.Parse(dr[6].ToString());
embarques.Add(pr);
}
}
catch (Exception ex)
{
throw ex;
}
return(embarques);
}
public SCEEmbarque Update(SCEEmbarque entidad)
{
throw new NotImplementedException();
}