/// <summary>
/// Update a database row from a class
/// </summary>
public static void UpdateRowFromOeordercopy(ref DataRow row, Oeordercopy entity)
{
row.SetField("autoapplycreditfl", entity.autoapplycreditfl);
row.SetField("btncancelenabled", entity.btncancelenabled);
row.SetField("btncopyenabled", entity.btncopyenabled);
row.SetField("btnexitlabel", entity.btnexitlabel);
row.SetField("btnordlistenabled", entity.btnordlistenabled);
row.SetField("btnrevisionenabled", entity.btnrevisionenabled);
row.SetField("btnselectlinesenabled", entity.btnselectlinesenabled);
row.SetField("btnvalidateenabled", entity.btnvalidateenabled);
row.SetField("copycommentsfl", entity.copycommentsfl);
row.SetField("copycommentsflenabled", entity.copycommentsflenabled);
row.SetField("copyedi", entity.copyedi);
row.SetField("copyedienabled", entity.copyedienabled);
row.SetField("copyintextsubtotsfl", entity.copyintextsubtotsfl);
row.SetField("copyintextsubtotsflenabled", entity.copyintextsubtotsflenabled);
row.SetField("copynotesfl", entity.copynotesfl);
row.SetField("copynotesflenabled", entity.copynotesflenabled);
row.SetField("copyncnrfl", entity.copyncnrfl);
row.SetField("copyncnrflenabled", entity.copyncnrflenabled);
row.SetField("custno", entity.custno);
row.SetField("custnoenabled", entity.custnoenabled);
row.SetField("custpo", entity.custpo);
row.SetField("custpoenabled", entity.custpoenabled);
row.SetField("disposition", entity.disposition);
row.SetField("dispositionenabled", entity.dispositionenabled);
row.SetField("fabwhsemethod", entity.fabwhsemethod);
row.SetField("fabwhsemethodenabled", entity.fabwhsemethodenabled);
row.SetField("fpcustno", entity.fpcustno);
row.SetField("freezepricesfl", entity.freezepricesfl);
row.SetField("freezepricesflenabled", entity.freezepricesflenabled);
row.SetField("fulfillmentordfl", entity.fulfillmentordfl);
row.SetField("invoiceto", entity.invoiceto);
row.SetField("invoicetoenabled", entity.invoicetoenabled);
row.SetField("neworderno", entity.neworderno);
row.SetField("neworderrowid", entity.neworderrowid.ToByteArray());
row.SetField("newordernotesfl", entity.newordernotesfl);
row.SetField("orderno", entity.orderno);
row.SetField("ordernoenabled", entity.ordernoenabled);
row.SetField("ordersuf", entity.ordersuf);
row.SetField("origincd", entity.origincd);
row.SetField("origincdenabled", entity.origincdenabled);
row.SetField("origpromisedt", entity.origpromisedt);
row.SetField("pdscmessage", entity.pdscmessage);
row.SetField("pdscmessagehidden", entity.pdscmessagehidden);
row.SetField("pdscmessagelabel", entity.pdscmessagelabel);
row.SetField("pdscmessagelabelhidden", entity.pdscmessagelabelhidden);
row.SetField("reason", entity.reason);
row.SetField("reasonenabled", entity.reasonenabled);
row.SetField("reasonhidden", entity.reasonhidden);
row.SetField("recalccostfl", entity.recalccostfl);
row.SetField("recalccostflenabled", entity.recalccostflenabled);
row.SetField("recalccostflhidden", entity.recalccostflhidden);
row.SetField("refer", entity.refer);
row.SetField("repairordno", entity.repairordno);
row.SetField("repairordsuf", entity.repairordsuf);
row.SetField("repricefl", entity.repricefl);
row.SetField("repriceflenabled", entity.repriceflenabled);
row.SetField("resetaddonsfl", entity.resetaddonsfl);
row.SetField("resetaddonsflenabled", entity.resetaddonsflenabled);
row.SetField("saleswhse", entity.saleswhse);
row.SetField("savefl", entity.savefl);
row.SetField("saveflenabled", entity.saveflenabled);
row.SetField("saveflhidden", entity.saveflhidden);
row.SetField("shipto", entity.shipto);
row.SetField("shiptoenabled", entity.shiptoenabled);
row.SetField("shiptonm", entity.shiptonm);
row.SetField("slsrepin", entity.slsrepin);
row.SetField("slsrepinenabled", entity.slsrepinenabled);
row.SetField("slsrepout", entity.slsrepout);
row.SetField("slsrepoutenabled", entity.slsrepoutenabled);
row.SetField("stage", entity.stage);
row.SetField("transtype", entity.transtype);
row.SetField("type", entity.type);
row.SetField("typeenabled", entity.typeenabled);
row.SetField("varolllines", entity.varolllines);
row.SetField("whse", entity.whse);
row.SetField("whseenabled", entity.whseenabled);
row.SetField("mDOConfirmFl", entity.mDOConfirmFl);
row.SetField("mDOCono", entity.mDOCono);
row.SetField("mDODueDt", entity.mDODueDt);
row.SetField("mDOFOBFl", entity.mDOFOBFl);
row.SetField("mDOShipFmNo", entity.mDOShipFmNo);
row.SetField("mDOShipViaTy", entity.mDOShipViaTy);
row.SetField("mDOType", entity.mDOType);
row.SetField("mDOVendNo", entity.mDOVendNo);
row.SetField("mDOWhse", entity.mDOWhse);
row.SetField("mMaintMode", entity.mMaintMode);
row.SetField("mTransType", entity.mTransType);
row.SetField("mWhse", entity.mWhse);
row.SetField("cCountry", entity.cCountry);
row.SetField("cHomeWhse", entity.cHomeWhse);
row.SetField("cOESlsrepFl", entity.cOESlsrepFl);
row.SetField("cOETieType", entity.cOETieType);
row.SetField("cOETrnType", entity.cOETrnType);
row.SetField("cOrderType", entity.cOrderType);
row.SetField("cOrigTransType", entity.cOrigTransType);
row.SetField("cTaxInterfaceTy", entity.cTaxInterfaceTy);
row.SetField("cTaxMethodTy", entity.cTaxMethodTy);
row.SetField("dLumpBillAmt", entity.dLumpBillAmt);
row.SetField("iSecure", entity.iSecure);
row.SetField("lCredPostFl", entity.lCredPostFl);
row.SetField("lGLDivFl", entity.lGLDivFl);
row.SetField("lHomeWhseFl", entity.lHomeWhseFl);
row.SetField("lLumpBillFl", entity.lLumpBillFl);
row.SetField("lLumpPriceFl", entity.lLumpPriceFl);
row.SetField("lOEDivFl", entity.lOEDivFl);
row.SetField("lOEDupFl", entity.lOEDupFl);
row.SetField("lOEOnlyFl", entity.lOEOnlyFl);
row.SetField("lOrdListFl", entity.lOrdListFl);
row.SetField("lPDLevel1Fl", entity.lPDLevel1Fl);
row.SetField("lReturnPostFl", entity.lReturnPostFl);
row.SetField("invno", entity.invno);
row.SetField("invsuf", entity.invsuf);
row.SetField("crlineno", entity.crlineno);
row.SetField("userfield", entity.userfield);
}
public static Oeordercopy BuildOeordercopyFromRow(DataRow row)
{
Oeordercopy entity = new Oeordercopy();
entity.autoapplycreditfl = row.Field <bool>("autoapplycreditfl");
entity.btncancelenabled = row.Field <bool>("btncancelenabled");
entity.btncopyenabled = row.Field <bool>("btncopyenabled");
entity.btnexitlabel = row.IsNull("btnexitlabel") ? string.Empty : row.Field <string>("btnexitlabel");
entity.btnordlistenabled = row.Field <bool>("btnordlistenabled");
entity.btnrevisionenabled = row.Field <bool>("btnrevisionenabled");
entity.btnselectlinesenabled = row.Field <bool>("btnselectlinesenabled");
entity.btnvalidateenabled = row.Field <bool>("btnvalidateenabled");
entity.copycommentsfl = row.Field <bool>("copycommentsfl");
entity.copycommentsflenabled = row.Field <bool>("copycommentsflenabled");
entity.copyedi = row.Field <bool>("copyedi");
entity.copyedienabled = row.Field <bool>("copyedienabled");
entity.copyintextsubtotsfl = row.Field <bool>("copyintextsubtotsfl");
entity.copyintextsubtotsflenabled = row.Field <bool>("copyintextsubtotsflenabled");
entity.copynotesfl = row.Field <bool>("copynotesfl");
entity.copynotesflenabled = row.Field <bool>("copynotesflenabled");
entity.copyncnrfl = row.Field <bool>("copyncnrfl");
entity.copyncnrflenabled = row.Field <bool>("copyncnrflenabled");
entity.custno = row.IsNull("custno") ? decimal.Zero : row.Field <decimal>("custno");
entity.custnoenabled = row.Field <bool>("custnoenabled");
entity.custpo = row.IsNull("custpo") ? string.Empty : row.Field <string>("custpo");
entity.custpoenabled = row.Field <bool>("custpoenabled");
entity.disposition = row.IsNull("disposition") ? string.Empty : row.Field <string>("disposition");
entity.dispositionenabled = row.Field <bool>("dispositionenabled");
entity.fabwhsemethod = row.IsNull("fabwhsemethod") ? string.Empty : row.Field <string>("fabwhsemethod");
entity.fabwhsemethodenabled = row.Field <bool>("fabwhsemethodenabled");
entity.fpcustno = row.IsNull("fpcustno") ? decimal.Zero : row.Field <decimal>("fpcustno");
entity.freezepricesfl = row.Field <bool>("freezepricesfl");
entity.freezepricesflenabled = row.Field <bool>("freezepricesflenabled");
entity.fulfillmentordfl = row.Field <bool>("fulfillmentordfl");
entity.invoiceto = row.IsNull("invoiceto") ? decimal.Zero : row.Field <decimal>("invoiceto");
entity.invoicetoenabled = row.Field <bool>("invoicetoenabled");
entity.neworderno = row.IsNull("neworderno") ? string.Empty : row.Field <string>("neworderno");
entity.neworderrowid = row.Field <byte[]>("neworderrowid").ToStringEncoded();
entity.newordernotesfl = row.IsNull("newordernotesfl") ? string.Empty : row.Field <string>("newordernotesfl");
entity.orderno = row.IsNull("orderno") ? 0 : row.Field <int>("orderno");
entity.ordernoenabled = row.Field <bool>("ordernoenabled");
entity.ordersuf = row.IsNull("ordersuf") ? 0 : row.Field <int>("ordersuf");
entity.origincd = row.IsNull("origincd") ? string.Empty : row.Field <string>("origincd");
entity.origincdenabled = row.Field <bool>("origincdenabled");
entity.origpromisedt = row.Field <DateTime?>("origpromisedt");
entity.pdscmessage = row.IsNull("pdscmessage") ? string.Empty : row.Field <string>("pdscmessage");
entity.pdscmessagehidden = row.Field <bool>("pdscmessagehidden");
entity.pdscmessagelabel = row.IsNull("pdscmessagelabel") ? string.Empty : row.Field <string>("pdscmessagelabel");
entity.pdscmessagelabelhidden = row.Field <bool>("pdscmessagelabelhidden");
entity.reason = row.IsNull("reason") ? string.Empty : row.Field <string>("reason");
entity.reasonenabled = row.Field <bool>("reasonenabled");
entity.reasonhidden = row.Field <bool>("reasonhidden");
entity.recalccostfl = row.Field <bool>("recalccostfl");
entity.recalccostflenabled = row.Field <bool>("recalccostflenabled");
entity.recalccostflhidden = row.Field <bool>("recalccostflhidden");
entity.refer = row.IsNull("refer") ? string.Empty : row.Field <string>("refer");
entity.repairordno = row.IsNull("repairordno") ? 0 : row.Field <int>("repairordno");
entity.repairordsuf = row.IsNull("repairordsuf") ? 0 : row.Field <int>("repairordsuf");
entity.repricefl = row.Field <bool>("repricefl");
entity.repriceflenabled = row.Field <bool>("repriceflenabled");
entity.resetaddonsfl = row.Field <bool>("resetaddonsfl");
entity.resetaddonsflenabled = row.Field <bool>("resetaddonsflenabled");
entity.saleswhse = row.IsNull("saleswhse") ? string.Empty : row.Field <string>("saleswhse");
entity.savefl = row.Field <bool>("savefl");
entity.saveflenabled = row.Field <bool>("saveflenabled");
entity.saveflhidden = row.Field <bool>("saveflhidden");
entity.shipto = row.IsNull("shipto") ? string.Empty : row.Field <string>("shipto");
entity.shiptoenabled = row.Field <bool>("shiptoenabled");
entity.shiptonm = row.IsNull("shiptonm") ? string.Empty : row.Field <string>("shiptonm");
entity.slsrepin = row.IsNull("slsrepin") ? string.Empty : row.Field <string>("slsrepin");
entity.slsrepinenabled = row.Field <bool>("slsrepinenabled");
entity.slsrepout = row.IsNull("slsrepout") ? string.Empty : row.Field <string>("slsrepout");
entity.slsrepoutenabled = row.Field <bool>("slsrepoutenabled");
entity.stage = row.IsNull("stage") ? string.Empty : row.Field <string>("stage");
entity.transtype = row.IsNull("transtype") ? string.Empty : row.Field <string>("transtype");
entity.type = row.IsNull("type") ? string.Empty : row.Field <string>("type");
entity.typeenabled = row.Field <bool>("typeenabled");
entity.varolllines = row.IsNull("varolllines") ? string.Empty : row.Field <string>("varolllines");
entity.whse = row.IsNull("whse") ? string.Empty : row.Field <string>("whse");
entity.whseenabled = row.Field <bool>("whseenabled");
entity.mDOConfirmFl = row.Field <bool>("mDOConfirmFl");
entity.mDOCono = row.IsNull("mDOCono") ? 0 : row.Field <int>("mDOCono");
entity.mDODueDt = row.Field <DateTime?>("mDODueDt");
entity.mDOFOBFl = row.Field <bool>("mDOFOBFl");
entity.mDOShipFmNo = row.IsNull("mDOShipFmNo") ? 0 : row.Field <int>("mDOShipFmNo");
entity.mDOShipViaTy = row.IsNull("mDOShipViaTy") ? string.Empty : row.Field <string>("mDOShipViaTy");
entity.mDOType = row.IsNull("mDOType") ? string.Empty : row.Field <string>("mDOType");
entity.mDOVendNo = row.IsNull("mDOVendNo") ? decimal.Zero : row.Field <decimal>("mDOVendNo");
entity.mDOWhse = row.IsNull("mDOWhse") ? string.Empty : row.Field <string>("mDOWhse");
entity.mMaintMode = row.IsNull("mMaintMode") ? string.Empty : row.Field <string>("mMaintMode");
entity.mTransType = row.IsNull("mTransType") ? string.Empty : row.Field <string>("mTransType");
entity.mWhse = row.IsNull("mWhse") ? string.Empty : row.Field <string>("mWhse");
entity.cCountry = row.IsNull("cCountry") ? string.Empty : row.Field <string>("cCountry");
entity.cHomeWhse = row.IsNull("cHomeWhse") ? string.Empty : row.Field <string>("cHomeWhse");
entity.cOESlsrepFl = row.IsNull("cOESlsrepFl") ? string.Empty : row.Field <string>("cOESlsrepFl");
entity.cOETieType = row.IsNull("cOETieType") ? string.Empty : row.Field <string>("cOETieType");
entity.cOETrnType = row.IsNull("cOETrnType") ? string.Empty : row.Field <string>("cOETrnType");
entity.cOrderType = row.IsNull("cOrderType") ? string.Empty : row.Field <string>("cOrderType");
entity.cOrigTransType = row.IsNull("cOrigTransType") ? string.Empty : row.Field <string>("cOrigTransType");
entity.cTaxInterfaceTy = row.IsNull("cTaxInterfaceTy") ? string.Empty : row.Field <string>("cTaxInterfaceTy");
entity.cTaxMethodTy = row.IsNull("cTaxMethodTy") ? string.Empty : row.Field <string>("cTaxMethodTy");
entity.dLumpBillAmt = row.IsNull("dLumpBillAmt") ? decimal.Zero : row.Field <decimal>("dLumpBillAmt");
entity.iSecure = row.IsNull("iSecure") ? 0 : row.Field <int>("iSecure");
entity.lCredPostFl = row.Field <bool>("lCredPostFl");
entity.lGLDivFl = row.Field <bool>("lGLDivFl");
entity.lHomeWhseFl = row.Field <bool>("lHomeWhseFl");
entity.lLumpBillFl = row.Field <bool>("lLumpBillFl");
entity.lLumpPriceFl = row.Field <bool>("lLumpPriceFl");
entity.lOEDivFl = row.Field <bool>("lOEDivFl");
entity.lOEDupFl = row.Field <bool>("lOEDupFl");
entity.lOEOnlyFl = row.Field <bool>("lOEOnlyFl");
entity.lOrdListFl = row.Field <bool>("lOrdListFl");
entity.lPDLevel1Fl = row.Field <bool>("lPDLevel1Fl");
entity.lReturnPostFl = row.Field <bool>("lReturnPostFl");
entity.invno = row.IsNull("invno") ? 0 : row.Field <int>("invno");
entity.invsuf = row.IsNull("invsuf") ? 0 : row.Field <int>("invsuf");
entity.crlineno = row.IsNull("crlineno") ? 0 : row.Field <int>("crlineno");
entity.userfield = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield");
return(entity);
}
