public static Oeimportdata BuildOeimportdataFromRow(DataRow row)
{
Oeimportdata entity = new Oeimportdata();
entity.custno = row.IsNull("custno") ? decimal.Zero : row.Field <decimal>("custno");
entity.shipto = row.IsNull("shipto") ? string.Empty : row.Field <string>("shipto");
entity.whse = row.IsNull("whse") ? string.Empty : row.Field <string>("whse");
entity.ordertype = row.IsNull("ordertype") ? string.Empty : row.Field <string>("ordertype");
entity.custpo = row.IsNull("custpo") ? string.Empty : row.Field <string>("custpo");
entity.placedby = row.IsNull("placedby") ? string.Empty : row.Field <string>("placedby");
entity.shipviaty = row.IsNull("shipviaty") ? string.Empty : row.Field <string>("shipviaty");
entity.termstype = row.IsNull("termstype") ? string.Empty : row.Field <string>("termstype");
entity.refer = row.IsNull("refer") ? string.Empty : row.Field <string>("refer");
entity.reqshipdt = row.Field <DateTime?>("reqshipdt");
entity.shipinstr = row.IsNull("shipinstr") ? string.Empty : row.Field <string>("shipinstr");
entity.prod = row.IsNull("prod") ? string.Empty : row.Field <string>("prod");
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.price = row.IsNull("price") ? decimal.Zero : row.Field <decimal>("price");
entity.discamt = row.IsNull("discamt") ? decimal.Zero : row.Field <decimal>("discamt");
entity.disctype = row.Field <bool>("disctype");
entity.vendno = row.IsNull("vendno") ? decimal.Zero : row.Field <decimal>("vendno");
entity.prodline = row.IsNull("prodline") ? string.Empty : row.Field <string>("prodline");
entity.prodcat = row.IsNull("prodcat") ? string.Empty : row.Field <string>("prodcat");
entity.prodcost = row.IsNull("prodcost") ? decimal.Zero : row.Field <decimal>("prodcost");
entity.tietype = row.IsNull("tietype") ? string.Empty : row.Field <string>("tietype");
entity.tiewhse = row.IsNull("tiewhse") ? string.Empty : row.Field <string>("tiewhse");
entity.dropshipfl = row.Field <bool>("dropshipfl");
entity.printfl = row.Field <bool>("printfl");
entity.requirefl = row.Field <bool>("requirefl");
entity.subtotalfl = row.Field <bool>("subtotalfl");
entity.printprfl = row.Field <bool>("printprfl");
entity.copycomfl = row.Field <bool>("copycomfl");
entity.processfl = row.Field <bool>("processfl");
entity.worksheetno = row.IsNull("worksheetno") ? 0 : row.Field <int>("worksheetno");
entity.lineno = row.IsNull("lineno") ? 0 : row.Field <int>("lineno");
entity.seqno = row.IsNull("seqno") ? 0 : row.Field <int>("seqno");
entity.custprod = row.IsNull("custprod") ? string.Empty : row.Field <string>("custprod");
entity.name = row.IsNull("name") ? string.Empty : row.Field <string>("name");
entity.specnstype = row.IsNull("specnstype") ? string.Empty : row.Field <string>("specnstype");
entity.returnfl = row.Field <bool>("returnfl");
entity.manprice = row.Field <bool>("manprice");
entity.costoverfl = row.Field <bool>("costoverfl");
entity.catalogfl = row.Field <bool>("catalogfl");
entity.commentfl = row.IsNull("commentfl") ? string.Empty : row.Field <string>("commentfl");
entity.reqprod = row.IsNull("reqprod") ? string.Empty : row.Field <string>("reqprod");
entity.altwhse = row.IsNull("altwhse") ? string.Empty : row.Field <string>("altwhse");
entity.xrefprodty = row.IsNull("xrefprodty") ? string.Empty : row.Field <string>("xrefprodty");
entity.orderbreak = row.IsNull("orderbreak") ? string.Empty : row.Field <string>("orderbreak");
entity.currsymbol = row.IsNull("currsymbol") ? string.Empty : row.Field <string>("currsymbol");
entity.npfl = row.Field <bool>("npfl");
entity.nprecno = row.IsNull("nprecno") ? 0 : row.Field <int>("nprecno");
entity.npcd = row.IsNull("npcd") ? string.Empty : row.Field <string>("npcd");
entity.userfield = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield");
return(entity);
}
/// <summary>
/// Update a database row from a class
/// </summary>
public static void UpdateRowFromOeimportdata(ref DataRow row, Oeimportdata entity)
{
row.SetField("custno", entity.custno);
row.SetField("shipto", entity.shipto);
row.SetField("whse", entity.whse);
row.SetField("ordertype", entity.ordertype);
row.SetField("custpo", entity.custpo);
row.SetField("placedby", entity.placedby);
row.SetField("shipviaty", entity.shipviaty);
row.SetField("termstype", entity.termstype);
row.SetField("refer", entity.refer);
row.SetField("reqshipdt", entity.reqshipdt);
row.SetField("shipinstr", entity.shipinstr);
row.SetField("prod", entity.prod);
row.SetField("proddesc", entity.proddesc);
row.SetField("qtyord", entity.qtyord);
row.SetField("unit", entity.unit);
row.SetField("price", entity.price);
row.SetField("discamt", entity.discamt);
row.SetField("disctype", entity.disctype);
row.SetField("vendno", entity.vendno);
row.SetField("prodline", entity.prodline);
row.SetField("prodcat", entity.prodcat);
row.SetField("prodcost", entity.prodcost);
row.SetField("tietype", entity.tietype);
row.SetField("tiewhse", entity.tiewhse);
row.SetField("dropshipfl", entity.dropshipfl);
row.SetField("printfl", entity.printfl);
row.SetField("requirefl", entity.requirefl);
row.SetField("subtotalfl", entity.subtotalfl);
row.SetField("printprfl", entity.printprfl);
row.SetField("copycomfl", entity.copycomfl);
row.SetField("processfl", entity.processfl);
row.SetField("worksheetno", entity.worksheetno);
row.SetField("lineno", entity.lineno);
row.SetField("seqno", entity.seqno);
row.SetField("custprod", entity.custprod);
row.SetField("name", entity.name);
row.SetField("specnstype", entity.specnstype);
row.SetField("returnfl", entity.returnfl);
row.SetField("manprice", entity.manprice);
row.SetField("costoverfl", entity.costoverfl);
row.SetField("catalogfl", entity.catalogfl);
row.SetField("commentfl", entity.commentfl);
row.SetField("reqprod", entity.reqprod);
row.SetField("altwhse", entity.altwhse);
row.SetField("xrefprodty", entity.xrefprodty);
row.SetField("orderbreak", entity.orderbreak);
row.SetField("currsymbol", entity.currsymbol);
row.SetField("npfl", entity.npfl);
row.SetField("nprecno", entity.nprecno);
row.SetField("npcd", entity.npcd);
row.SetField("userfield", entity.userfield);
}
