public override void fillLst(IDbTransaction trans = null)
{
try
{
this.comm = GenericDataAccess.CreateCommandSP("sp_Asn_partida");
addParameters(0);
if (trans == null)
{
this.dt = GenericDataAccess.ExecuteSelectCommand(comm);
}
else
{
this.dt = GenericDataAccess.ExecuteSelectCommand(comm, trans);
}
this._lst = new List <Asn_partida>();
foreach (DataRow dr in dt.Rows)
{
Asn_partida o = new Asn_partida();
BindByDataRow(dr, o);
this._lst.Add(o);
}
}
catch
{
throw;
}
}
protected void BindByDataRow(DataRow dr, Asn_partida o)
{
try
{
int.TryParse(dr["id"].ToString(), out entero);
o.Id = entero;
entero = 0;
if (dr["id_asn"] != DBNull.Value)
{
int.TryParse(dr["id_asn"].ToString(), out entero);
o.Id_asn = entero;
entero = 0;
}
o.Sku = dr["sku"].ToString();
if (dr["tarima"] != DBNull.Value)
{
int.TryParse(dr["tarima"].ToString(), out entero);
o.Tarima = entero;
entero = 0;
}
if (dr["caja"] != DBNull.Value)
{
int.TryParse(dr["caja"].ToString(), out entero);
o.Caja = entero;
entero = 0;
}
if (dr["pieza"] != DBNull.Value)
{
int.TryParse(dr["pieza"].ToString(), out entero);
o.Pieza = entero;
entero = 0;
}
}
catch
{
throw;
}
}
public Asn_partidaMng()
{
this._oAsn_partida = new Asn_partida();
this._lst = new List <Asn_partida>();
}