示例#1
0
 /// <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);
 }
示例#2
0
        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);
        }