public static Wtimportdata BuildWtimportdataFromRow(DataRow row)
{
Wtimportdata entity = new Wtimportdata();
entity.addoncamt = row.IsNull("addoncamt") ? decimal.Zero : row.Field <decimal>("addoncamt");
entity.addoncty = row.IsNull("addoncty") ? string.Empty : row.Field <string>("addoncty");
entity.addoneamt = row.IsNull("addoneamt") ? decimal.Zero : row.Field <decimal>("addoneamt");
entity.addonety = row.IsNull("addonety") ? string.Empty : row.Field <string>("addonety");
entity.instruct = row.IsNull("instruct") ? string.Empty : row.Field <string>("instruct");
entity.orderdt = row.Field <DateTime?>("orderdt");
entity.processfl = row.Field <bool>("processfl");
entity.refer = row.IsNull("refer") ? string.Empty : row.Field <string>("refer");
entity.reqshipdt = row.Field <DateTime?>("reqshipdt");
entity.shipviaty = row.IsNull("shipviaty") ? string.Empty : row.Field <string>("shipviaty");
entity.reasoncode = row.IsNull("reasoncode") ? string.Empty : row.Field <string>("reasoncode");
entity.tocono = row.IsNull("tocono") ? 0 : row.Field <int>("tocono");
entity.towhse = row.IsNull("towhse") ? string.Empty : row.Field <string>("towhse");
entity.whse = row.IsNull("whse") ? string.Empty : row.Field <string>("whse");
entity.prod = row.IsNull("prod") ? string.Empty : row.Field <string>("prod");
entity.descrip = row.IsNull("descrip") ? string.Empty : row.Field <string>("descrip");
entity.qtyord = row.IsNull("qtyord") ? decimal.Zero : row.Field <decimal>("qtyord");
entity.unit = row.IsNull("unit") ? string.Empty : row.Field <string>("unit");
entity.printfl = row.Field <bool>("printfl");
entity.requirefl = row.Field <bool>("requirefl");
entity.name = row.IsNull("name") ? string.Empty : row.Field <string>("name");
entity.cono2 = row.IsNull("cono2") ? 0 : row.Field <int>("cono2");
entity.duedt = row.Field <DateTime?>("duedt");
entity.ordertype = row.IsNull("ordertype") ? string.Empty : row.Field <string>("ordertype");
entity.origseqno = row.IsNull("origseqno") ? 0 : row.Field <int>("origseqno");
entity.stagecd = row.IsNull("stagecd") ? 0 : row.Field <int>("stagecd");
entity.totamt = row.IsNull("totamt") ? decimal.Zero : row.Field <decimal>("totamt");
entity.addonno = row.IsNull("addonno") ? 0 : row.Field <int>("addonno");
entity.addontype1 = row.Field <bool>("addontype1");
entity.catalogfl = row.Field <bool>("catalogfl");
entity.commentfl = row.IsNull("commentfl") ? string.Empty : row.Field <string>("commentfl");
entity.currsymbol = row.IsNull("currsymbol") ? string.Empty : row.Field <string>("currsymbol");
entity.descrip2 = row.IsNull("descrip2") ? string.Empty : row.Field <string>("descrip2");
entity.manprice = row.Field <bool>("manprice");
entity.netamt = row.IsNull("netamt") ? decimal.Zero : row.Field <decimal>("netamt");
entity.nonstockty = row.IsNull("nonstockty") ? string.Empty : row.Field <string>("nonstockty");
entity.orderaltno = row.IsNull("orderaltno") ? 0 : row.Field <int>("orderaltno");
entity.prodcat = row.IsNull("prodcat") ? string.Empty : row.Field <string>("prodcat");
entity.prodline = row.IsNull("prodline") ? string.Empty : row.Field <string>("prodline");
entity.qtyship = row.IsNull("qtyship") ? decimal.Zero : row.Field <decimal>("qtyship");
entity.reasunavty = row.IsNull("reasunavty") ? string.Empty : row.Field <string>("reasunavty");
entity.vendprod = row.IsNull("vendprod") ? string.Empty : row.Field <string>("vendprod");
entity.lineno = row.IsNull("lineno") ? 0 : row.Field <int>("lineno");
entity.seqno = row.IsNull("seqno") ? 0 : row.Field <int>("seqno");
entity.orderbreak = row.IsNull("orderbreak") ? string.Empty : row.Field <string>("orderbreak");
entity.worksheetno = row.IsNull("worksheetno") ? 0 : row.Field <int>("worksheetno");
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 UpdateRowFromWtimportdata(ref DataRow row, Wtimportdata entity)
{
row.SetField("addoncamt", entity.addoncamt);
row.SetField("addoncty", entity.addoncty);
row.SetField("addoneamt", entity.addoneamt);
row.SetField("addonety", entity.addonety);
row.SetField("instruct", entity.instruct);
row.SetField("orderdt", entity.orderdt);
row.SetField("processfl", entity.processfl);
row.SetField("refer", entity.refer);
row.SetField("reqshipdt", entity.reqshipdt);
row.SetField("shipviaty", entity.shipviaty);
row.SetField("reasoncode", entity.reasoncode);
row.SetField("tocono", entity.tocono);
row.SetField("towhse", entity.towhse);
row.SetField("whse", entity.whse);
row.SetField("prod", entity.prod);
row.SetField("descrip", entity.descrip);
row.SetField("qtyord", entity.qtyord);
row.SetField("unit", entity.unit);
row.SetField("printfl", entity.printfl);
row.SetField("requirefl", entity.requirefl);
row.SetField("name", entity.name);
row.SetField("cono2", entity.cono2);
row.SetField("duedt", entity.duedt);
row.SetField("ordertype", entity.ordertype);
row.SetField("origseqno", entity.origseqno);
row.SetField("stagecd", entity.stagecd);
row.SetField("totamt", entity.totamt);
row.SetField("addonno", entity.addonno);
row.SetField("addontype1", entity.addontype1);
row.SetField("catalogfl", entity.catalogfl);
row.SetField("commentfl", entity.commentfl);
row.SetField("currsymbol", entity.currsymbol);
row.SetField("descrip2", entity.descrip2);
row.SetField("manprice", entity.manprice);
row.SetField("netamt", entity.netamt);
row.SetField("nonstockty", entity.nonstockty);
row.SetField("orderaltno", entity.orderaltno);
row.SetField("prodcat", entity.prodcat);
row.SetField("prodline", entity.prodline);
row.SetField("qtyship", entity.qtyship);
row.SetField("reasunavty", entity.reasunavty);
row.SetField("vendprod", entity.vendprod);
row.SetField("lineno", entity.lineno);
row.SetField("seqno", entity.seqno);
row.SetField("orderbreak", entity.orderbreak);
row.SetField("worksheetno", entity.worksheetno);
row.SetField("userfield", entity.userfield);
}
