/// <summary>
/// Update a database row from a class
/// </summary>
public static void UpdateRowFromLoadcrossrefttresults(ref DataRow row, Loadcrossrefttresults entity)
{
row.SetField("altprod", entity.altprod);
row.SetField("prod", entity.prod);
row.SetField("extprod", entity.extprod);
row.SetField("rectype", entity.rectype);
row.SetField("custno", entity.custno);
row.SetField("shipto", entity.shipto);
row.SetField("keyno", entity.keyno);
row.SetField("unitbuy", entity.unitbuy);
row.SetField("unitsell", entity.unitsell);
row.SetField("unitstnd", entity.unitstnd);
row.SetField("lastchgdt", entity.lastchgdt);
row.SetField("leadtm", entity.leadtm);
row.SetField("price", entity.price);
row.SetField("orderqty", entity.orderqty);
row.SetField("icsec_rowid", entity.icsecRowid.ToByteArray());
row.SetField("proddspl", entity.proddspl);
row.SetField("rectypedspl", entity.rectypedspl);
row.SetField("altproddspl", entity.altproddspl);
row.SetField("prodnotes", entity.prodnotes);
row.SetField("proddesc", entity.proddesc);
row.SetField("proddescrip3", entity.proddescrip3);
row.SetField("custnodspl", entity.custnodspl);
row.SetField("custnotes", entity.custnotes);
row.SetField("custname", entity.custname);
row.SetField("vendname", entity.vendname);
row.SetField("shiptonotes", entity.shiptonotes);
row.SetField("shiptoname", entity.shiptoname);
row.SetField("keynodspl", entity.keynodspl);
row.SetField("qtyavail", entity.qtyavail);
row.SetField("vendno", entity.vendno);
row.SetField("userfield", entity.userfield);
}
public static Loadcrossrefttresults BuildLoadcrossrefttresultsFromRow(DataRow row)
{
Loadcrossrefttresults entity = new Loadcrossrefttresults();
entity.altprod = row.IsNull("altprod") ? string.Empty : row.Field <string>("altprod");
entity.prod = row.IsNull("prod") ? string.Empty : row.Field <string>("prod");
entity.extprod = row.IsNull("extprod") ? string.Empty : row.Field <string>("extprod");
entity.rectype = row.IsNull("rectype") ? string.Empty : row.Field <string>("rectype");
entity.custno = row.IsNull("custno") ? decimal.Zero : row.Field <decimal>("custno");
entity.shipto = row.IsNull("shipto") ? string.Empty : row.Field <string>("shipto");
entity.keyno = row.IsNull("keyno") ? decimal.Zero : row.Field <decimal>("keyno");
entity.unitbuy = row.IsNull("unitbuy") ? string.Empty : row.Field <string>("unitbuy");
entity.unitsell = row.IsNull("unitsell") ? string.Empty : row.Field <string>("unitsell");
entity.unitstnd = row.IsNull("unitstnd") ? string.Empty : row.Field <string>("unitstnd");
entity.lastchgdt = row.Field <DateTime?>("lastchgdt");
entity.leadtm = row.IsNull("leadtm") ? 0 : row.Field <int>("leadtm");
entity.price = row.IsNull("price") ? decimal.Zero : row.Field <decimal>("price");
entity.orderqty = row.IsNull("orderqty") ? decimal.Zero : row.Field <decimal>("orderqty");
entity.icsecRowid = row.Field <byte[]>("icsec_rowid").ToStringEncoded();
entity.proddspl = row.IsNull("proddspl") ? string.Empty : row.Field <string>("proddspl");
entity.rectypedspl = row.IsNull("rectypedspl") ? string.Empty : row.Field <string>("rectypedspl");
entity.altproddspl = row.IsNull("altproddspl") ? string.Empty : row.Field <string>("altproddspl");
entity.prodnotes = row.IsNull("prodnotes") ? string.Empty : row.Field <string>("prodnotes");
entity.proddesc = row.IsNull("proddesc") ? string.Empty : row.Field <string>("proddesc");
entity.proddescrip3 = row.IsNull("proddescrip3") ? string.Empty : row.Field <string>("proddescrip3");
entity.custnodspl = row.IsNull("custnodspl") ? decimal.Zero : row.Field <decimal>("custnodspl");
entity.custnotes = row.IsNull("custnotes") ? string.Empty : row.Field <string>("custnotes");
entity.custname = row.IsNull("custname") ? string.Empty : row.Field <string>("custname");
entity.vendname = row.IsNull("vendname") ? string.Empty : row.Field <string>("vendname");
entity.shiptonotes = row.IsNull("shiptonotes") ? string.Empty : row.Field <string>("shiptonotes");
entity.shiptoname = row.IsNull("shiptoname") ? string.Empty : row.Field <string>("shiptoname");
entity.keynodspl = row.IsNull("keynodspl") ? decimal.Zero : row.Field <decimal>("keynodspl");
entity.qtyavail = row.IsNull("qtyavail") ? string.Empty : row.Field <string>("qtyavail");
entity.vendno = row.IsNull("vendno") ? decimal.Zero : row.Field <decimal>("vendno");
entity.userfield = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield");
return(entity);
}