/// <summary>
/// Update a database row from a class
/// </summary>
public static void UpdateRowFromOtittrackline(ref DataRow row, Otittrackline entity)
{
row.SetField("trackno", entity.trackno);
row.SetField("lineno", entity.lineno);
row.SetField("comment", entity.comment);
row.SetField("vendno", entity.vendno);
row.SetField("vendnotes", entity.vendnotes);
row.SetField("vendname", entity.vendname);
row.SetField("pono", entity.pono);
row.SetField("posuf", entity.posuf);
row.SetField("polineno", entity.polineno);
row.SetField("pocomment", entity.pocomment);
row.SetField("shipprod", entity.shipprod);
row.SetField("prodnotes", entity.prodnotes);
row.SetField("proddesc", entity.proddesc);
row.SetField("qtyord", entity.qtyord);
row.SetField("unit", entity.unit);
row.SetField("stkqtyord", entity.stkqtyord);
row.SetField("cubes", entity.cubes);
row.SetField("weight", entity.weight);
row.SetField("duedt", entity.duedt);
row.SetField("expshipdt", entity.expshipdt);
row.SetField("reqshipdt", entity.reqshipdt);
row.SetField("userfield", entity.userfield);
}
public static Otittrackline BuildOtittracklineFromRow(DataRow row)
{
Otittrackline entity = new Otittrackline();
entity.trackno = row.IsNull("trackno") ? 0 : row.Field <int>("trackno");
entity.lineno = row.IsNull("lineno") ? 0 : row.Field <int>("lineno");
entity.comment = row.IsNull("comment") ? string.Empty : row.Field <string>("comment");
entity.vendno = row.IsNull("vendno") ? decimal.Zero : row.Field <decimal>("vendno");
entity.vendnotes = row.IsNull("vendnotes") ? string.Empty : row.Field <string>("vendnotes");
entity.vendname = row.IsNull("vendname") ? string.Empty : row.Field <string>("vendname");
entity.pono = row.IsNull("pono") ? 0 : row.Field <int>("pono");
entity.posuf = row.IsNull("posuf") ? 0 : row.Field <int>("posuf");
entity.polineno = row.IsNull("polineno") ? 0 : row.Field <int>("polineno");
entity.pocomment = row.IsNull("pocomment") ? string.Empty : row.Field <string>("pocomment");
entity.shipprod = row.IsNull("shipprod") ? string.Empty : row.Field <string>("shipprod");
entity.prodnotes = row.IsNull("prodnotes") ? string.Empty : row.Field <string>("prodnotes");
entity.proddesc = row.IsNull("proddesc") ? string.Empty : row.Field <string>("proddesc");
entity.qtyord = row.IsNull("qtyord") ? decimal.Zero : row.Field <decimal>("qtyord");
entity.unit = row.IsNull("unit") ? string.Empty : row.Field <string>("unit");
entity.stkqtyord = row.IsNull("stkqtyord") ? decimal.Zero : row.Field <decimal>("stkqtyord");
entity.cubes = row.IsNull("cubes") ? decimal.Zero : row.Field <decimal>("cubes");
entity.weight = row.IsNull("weight") ? decimal.Zero : row.Field <decimal>("weight");
entity.duedt = row.Field <DateTime?>("duedt");
entity.expshipdt = row.Field <DateTime?>("expshipdt");
entity.reqshipdt = row.Field <DateTime?>("reqshipdt");
entity.userfield = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield");
return(entity);
}
