Пример #1
0
 /// <summary>
 /// Update a database row from a class
 /// </summary>
 public static void UpdateRowFromSasosetupoper(ref DataRow row, Sasosetupoper entity)
 {
     row.SetField("allowfulfillmentty", entity.allowfulfillmentty);
     row.SetField("altoperinit", entity.altoperinit);
     row.SetField("altoperinitenabled", entity.altoperinitenabled);
     row.SetField("apsuperfl", entity.apsuperfl);
     row.SetField("arecedbfl", entity.arecedbfl);
     row.SetField("arwrtofflim", entity.arwrtofflim);
     row.SetField("autobillwhsefl", entity.autobillwhsefl);
     row.SetField("bprvunlkfl", entity.bprvunlkfl);
     row.SetField("catconvertfl", entity.catconvertfl);
     row.SetField("caticcrtty", entity.caticcrtty);
     row.SetField("cfgaccesscd", entity.cfgaccesscd);
     row.SetField("chgbalfl", entity.chgbalfl);
     row.SetField("chgglcostfl", entity.chgglcostfl);
     row.SetField("contactnotety", entity.contactnotety);
     row.SetField("credpostfl", entity.credpostfl);
     row.SetField("custno", entity.custno);
     row.SetField("custnoenabled", entity.custnoenabled);
     row.SetField("custnotesfl", entity.custnotesfl);
     row.SetField("devlocset", entity.devlocset);
     row.SetField("devloc", entity.devloc);
     row.SetField("extendfl", entity.extendfl);
     row.SetField("formprinternm", entity.formprinternm);
     row.SetField("formprinternmset", entity.formprinternmset);
     row.SetField("helpfl", entity.helpfl);
     row.SetField("holdforauthdefault", entity.holdforauthdefault);
     row.SetField("holdoverfl", entity.holdoverfl);
     row.SetField("holdintlfl", entity.holdintlfl);
     row.SetField("homewhsefl", entity.homewhsefl);
     row.SetField("icacquiredtfl", entity.icacquiredtfl);
     row.SetField("icmanlistoverfl", entity.icmanlistoverfl);
     row.SetField("icmanlistty", entity.icmanlistty);
     row.SetField("icmassmaintfl", entity.icmassmaintfl);
     row.SetField("icswstchgfl", entity.icswstchgfl);
     row.SetField("ifsuser", entity.ifsuser);
     row.SetField("ifsuserenabled", entity.ifsuserenabled);
     row.SetField("intercofl", entity.intercofl);
     row.SetField("jmapprvty", entity.jmapprvty);
     row.SetField("jmupdprtpofl", entity.jmupdprtpofl);
     row.SetField("kptietype", entity.kptietype);
     row.SetField("kpverchg", entity.kpverchg);
     row.SetField("kpveruse", entity.kpveruse);
     row.SetField("langcd", entity.langcd);
     row.SetField("langcdenabled", entity.langcdenabled);
     row.SetField("langcdset", entity.langcdset);
     row.SetField("limitholdcds", entity.limitholdcds);
     row.SetField("limitholdcdsset", entity.limitholdcdsset);
     row.SetField("limitslsrepfl", entity.limitslsrepfl);
     row.SetField("limittakenbyfl", entity.limittakenbyfl);
     row.SetField("ncnrfl", entity.ncnrfl);
     row.SetField("nonstockfl", entity.nonstockfl);
     row.SetField("notesfl", entity.notesfl);
     row.SetField("nsbinlocfl", entity.nsbinlocfl);
     row.SetField("nscommfl", entity.nscommfl);
     row.SetField("nscrtoanty", entity.nscrtoanty);
     row.SetField("nsquoteoanty", entity.nsquoteoanty);
     row.SetField("oeautoapplyovrfl", entity.oeautoapplyovrfl);
     row.SetField("oechglntypefl", entity.oechglntypefl);
     row.SetField("oecostoverty", entity.oecostoverty);
     row.SetField("oedotyamtmax", entity.oedotyamtmax);
     row.SetField("oedotyamtmin", entity.oedotyamtmin);
     row.SetField("oedotymrgamtmax", entity.oedotymrgamtmax);
     row.SetField("oedotymrgamtmin", entity.oedotymrgamtmin);
     row.SetField("oedotymrgpctmax", entity.oedotymrgpctmax);
     row.SetField("oedotymrgpctmin", entity.oedotymrgpctmin);
     row.SetField("oehardprcovrfl", entity.oehardprcovrfl);
     row.SetField("oetoleranceovrfl", entity.oetoleranceovrfl);
     row.SetField("oenoinvoicefl", entity.oenoinvoicefl);
     row.SetField("oensqtyshpty", entity.oensqtyshpty);
     row.SetField("oeonlyfl", entity.oeonlyfl);
     row.SetField("oeoptionfl", entity.oeoptionfl);
     row.SetField("oeorigpromisefl", entity.oeorigpromisefl);
     row.SetField("oepricefl", entity.oepricefl);
     row.SetField("oeqtyshipty", entity.oeqtyshipty);
     row.SetField("oerebty", entity.oerebty);
     row.SetField("oesaleswhsety", entity.oesaleswhsety);
     row.SetField("oeslsrepfl", entity.oeslsrepfl);
     row.SetField("oesotyamtmax", entity.oesotyamtmax);
     row.SetField("oesotyamtmin", entity.oesotyamtmin);
     row.SetField("oesotymrgamtmax", entity.oesotymrgamtmax);
     row.SetField("oesotymrgamtmin", entity.oesotymrgamtmin);
     row.SetField("oesotymrgpctmax", entity.oesotymrgpctmax);
     row.SetField("oesotymrgpctmin", entity.oesotymrgpctmin);
     row.SetField("oetietype", entity.oetietype);
     row.SetField("oetokenmodifyfl", entity.oetokenmodifyfl);
     row.SetField("oetrntype", entity.oetrntype);
     row.SetField("oeupdtcustpofl", entity.oeupdtcustpofl);
     row.SetField("operinit", entity.operinit);
     row.SetField("originchangefl", entity.originchangefl);
     row.SetField("ourproc", entity.ourproc);
     row.SetField("password", entity.password);
     row.SetField("pocrctfl", entity.pocrctfl);
     row.SetField("podotyamtmax", entity.podotyamtmax);
     row.SetField("podotyamtmin", entity.podotyamtmin);
     row.SetField("popotyamtmax", entity.popotyamtmax);
     row.SetField("popotyamtmin", entity.popotyamtmin);
     row.SetField("printernm", entity.printernm);
     row.SetField("printernmset", entity.printernmset);
     row.SetField("prodnotesfl", entity.prodnotesfl);
     row.SetField("promoprcwin", entity.promoprcwin);
     row.SetField("reqtakenfl", entity.reqtakenfl);
     row.SetField("resalefl", entity.resalefl);
     row.SetField("returnpostfl", entity.returnpostfl);
     row.SetField("rprinternm", entity.rprinternm);
     row.SetField("rprinternmset", entity.rprinternmset);
     row.SetField("saspgroup", entity.saspgroup);
     row.SetField("saspgroupset", entity.saspgroupset);
     row.SetField("secdeptno", entity.secdeptno);
     row.SetField("secdivno", entity.secdivno);
     row.SetField("secnotefl", entity.secnotefl);
     row.SetField("secsubno", entity.secsubno);
     row.SetField("seecommfl", entity.seecommfl);
     row.SetField("seecostfl", entity.seecostfl);
     row.SetField("shippingpt", entity.shippingpt);
     row.SetField("shippingptenabled", entity.shippingptenabled);
     row.SetField("shiptofl", entity.shiptofl);
     row.SetField("showroomuserfl", entity.showroomuserfl);
     row.SetField("showroomuserflenabled", entity.showroomuserflenabled);
     row.SetField("slsrep", entity.slsrep);
     row.SetField("storefrontuserid", entity.storefrontuserid);
     row.SetField("storefrontuseridenabled", entity.storefrontuseridenabled);
     row.SetField("superfl", entity.superfl);
     row.SetField("sysadminfl", entity.sysadminfl);
     row.SetField("taxoverfl", entity.taxoverfl);
     row.SetField("tenderty", entity.tenderty);
     row.SetField("termsoverfl", entity.termsoverfl);
     row.SetField("tqemailaddr", entity.tqemailaddr);
     row.SetField("tqposition", entity.tqposition);
     row.SetField("transdt", entity.transdt);
     row.SetField("transproc", entity.transproc);
     row.SetField("transtm", entity.transtm);
     row.SetField("twlrfuser", entity.twlrfuser);
     row.SetField("twlrfuserenabled", entity.twlrfuserenabled);
     row.SetField("unmaskccty", entity.unmaskccty);
     row.SetField("updglapty", entity.updglapty);
     row.SetField("updglarty", entity.updglarty);
     row.SetField("updglicty", entity.updglicty);
     row.SetField("updglkpty", entity.updglkpty);
     row.SetField("updgloety", entity.updgloety);
     row.SetField("updglpoty", entity.updglpoty);
     row.SetField("updglwtty", entity.updglwtty);
     row.SetField("useprevnsfl", entity.useprevnsfl);
     row.SetField("user1", entity.user1);
     row.SetField("user2", entity.user2);
     row.SetField("user3", entity.user3);
     row.SetField("user4", entity.user4);
     row.SetField("user5", entity.user5);
     row.SetField("user6", entity.user6);
     row.SetField("user7", entity.user7);
     row.SetField("user8", entity.user8);
     row.SetField("user9", entity.user9);
     row.SetField("userclearfl", entity.userclearfl);
     row.SetField("usergroup", entity.usergroup);
     row.SetField("usergroupset", entity.usergroupset);
     row.SetField("vaautolnentryty", entity.vaautolnentryty);
     row.SetField("vaautoshipty", entity.vaautoshipty);
     row.SetField("vaheaderty", entity.vaheaderty);
     row.SetField("valinecancelfl", entity.valinecancelfl);
     row.SetField("valtakenfl", entity.valtakenfl);
     row.SetField("vaverchg", entity.vaverchg);
     row.SetField("vaveruse", entity.vaveruse);
     row.SetField("vendpostfl", entity.vendpostfl);
     row.SetField("verrcvchgfl", entity.verrcvchgfl);
     row.SetField("whse", entity.whse);
     row.SetField("whseenabled", entity.whseenabled);
     row.SetField("whsegroup", entity.whsegroup);
     row.SetField("wlpicktype", entity.wlpicktype);
     row.SetField("wlpicktypeset", entity.wlpicktypeset);
     row.SetField("wtapprwhse", entity.wtapprwhse);
     row.SetField("xconocostfl", entity.xconocostfl);
     row.SetField("cMyDayUser", entity.cMyDayUser);
     row.SetField("cMyDayUserenabled", entity.cMyDayUserenabled);
     row.SetField("cMyDayTimer", entity.cMyDayTimer);
     row.SetField("cMyDayTimerenabled", entity.cMyDayTimerenabled);
     row.SetField("logintype", entity.logintype);
     row.SetField("userfield", entity.userfield);
 }
Пример #2
0
        public static Sasosetupoper BuildSasosetupoperFromRow(DataRow row)
        {
            Sasosetupoper entity = new Sasosetupoper();

            entity.allowfulfillmentty      = row.IsNull("allowfulfillmentty") ? string.Empty : row.Field <string>("allowfulfillmentty");
            entity.altoperinit             = row.IsNull("altoperinit") ? string.Empty : row.Field <string>("altoperinit");
            entity.altoperinitenabled      = row.Field <bool>("altoperinitenabled");
            entity.apsuperfl               = row.IsNull("apsuperfl") ? string.Empty : row.Field <string>("apsuperfl");
            entity.arecedbfl               = row.IsNull("arecedbfl") ? string.Empty : row.Field <string>("arecedbfl");
            entity.arwrtofflim             = row.IsNull("arwrtofflim") ? decimal.Zero : row.Field <decimal>("arwrtofflim");
            entity.autobillwhsefl          = row.IsNull("autobillwhsefl") ? string.Empty : row.Field <string>("autobillwhsefl");
            entity.bprvunlkfl              = row.IsNull("bprvunlkfl") ? string.Empty : row.Field <string>("bprvunlkfl");
            entity.catconvertfl            = row.IsNull("catconvertfl") ? string.Empty : row.Field <string>("catconvertfl");
            entity.caticcrtty              = row.IsNull("caticcrtty") ? string.Empty : row.Field <string>("caticcrtty");
            entity.cfgaccesscd             = row.IsNull("cfgaccesscd") ? string.Empty : row.Field <string>("cfgaccesscd");
            entity.chgbalfl                = row.IsNull("chgbalfl") ? string.Empty : row.Field <string>("chgbalfl");
            entity.chgglcostfl             = row.IsNull("chgglcostfl") ? string.Empty : row.Field <string>("chgglcostfl");
            entity.contactnotety           = row.IsNull("contactnotety") ? string.Empty : row.Field <string>("contactnotety");
            entity.credpostfl              = row.IsNull("credpostfl") ? string.Empty : row.Field <string>("credpostfl");
            entity.custno                  = row.IsNull("custno") ? decimal.Zero : row.Field <decimal>("custno");
            entity.custnoenabled           = row.Field <bool>("custnoenabled");
            entity.custnotesfl             = row.IsNull("custnotesfl") ? string.Empty : row.Field <string>("custnotesfl");
            entity.devlocset               = row.Field <bool>("devlocset");
            entity.devloc                  = row.IsNull("devloc") ? string.Empty : row.Field <string>("devloc");
            entity.extendfl                = row.IsNull("extendfl") ? string.Empty : row.Field <string>("extendfl");
            entity.formprinternm           = row.IsNull("formprinternm") ? string.Empty : row.Field <string>("formprinternm");
            entity.formprinternmset        = row.Field <bool>("formprinternmset");
            entity.helpfl                  = row.IsNull("helpfl") ? string.Empty : row.Field <string>("helpfl");
            entity.holdforauthdefault      = row.IsNull("holdforauthdefault") ? string.Empty : row.Field <string>("holdforauthdefault");
            entity.holdoverfl              = row.IsNull("holdoverfl") ? string.Empty : row.Field <string>("holdoverfl");
            entity.holdintlfl              = row.IsNull("holdintlfl") ? string.Empty : row.Field <string>("holdintlfl");
            entity.homewhsefl              = row.IsNull("homewhsefl") ? string.Empty : row.Field <string>("homewhsefl");
            entity.icacquiredtfl           = row.IsNull("icacquiredtfl") ? string.Empty : row.Field <string>("icacquiredtfl");
            entity.icmanlistoverfl         = row.IsNull("icmanlistoverfl") ? string.Empty : row.Field <string>("icmanlistoverfl");
            entity.icmanlistty             = row.IsNull("icmanlistty") ? string.Empty : row.Field <string>("icmanlistty");
            entity.icmassmaintfl           = row.IsNull("icmassmaintfl") ? string.Empty : row.Field <string>("icmassmaintfl");
            entity.icswstchgfl             = row.IsNull("icswstchgfl") ? string.Empty : row.Field <string>("icswstchgfl");
            entity.ifsuser                 = row.IsNull("ifsuser") ? string.Empty : row.Field <string>("ifsuser");
            entity.ifsuserenabled          = row.Field <bool>("ifsuserenabled");
            entity.intercofl               = row.IsNull("intercofl") ? string.Empty : row.Field <string>("intercofl");
            entity.jmapprvty               = row.IsNull("jmapprvty") ? string.Empty : row.Field <string>("jmapprvty");
            entity.jmupdprtpofl            = row.IsNull("jmupdprtpofl") ? string.Empty : row.Field <string>("jmupdprtpofl");
            entity.kptietype               = row.IsNull("kptietype") ? string.Empty : row.Field <string>("kptietype");
            entity.kpverchg                = row.IsNull("kpverchg") ? string.Empty : row.Field <string>("kpverchg");
            entity.kpveruse                = row.IsNull("kpveruse") ? string.Empty : row.Field <string>("kpveruse");
            entity.langcd                  = row.IsNull("langcd") ? string.Empty : row.Field <string>("langcd");
            entity.langcdenabled           = row.Field <bool>("langcdenabled");
            entity.langcdset               = row.Field <bool>("langcdset");
            entity.limitholdcds            = row.IsNull("limitholdcds") ? string.Empty : row.Field <string>("limitholdcds");
            entity.limitholdcdsset         = row.Field <bool>("limitholdcdsset");
            entity.limitslsrepfl           = row.IsNull("limitslsrepfl") ? string.Empty : row.Field <string>("limitslsrepfl");
            entity.limittakenbyfl          = row.IsNull("limittakenbyfl") ? string.Empty : row.Field <string>("limittakenbyfl");
            entity.ncnrfl                  = row.IsNull("ncnrfl") ? string.Empty : row.Field <string>("ncnrfl");
            entity.nonstockfl              = row.IsNull("nonstockfl") ? string.Empty : row.Field <string>("nonstockfl");
            entity.notesfl                 = row.IsNull("notesfl") ? string.Empty : row.Field <string>("notesfl");
            entity.nsbinlocfl              = row.IsNull("nsbinlocfl") ? string.Empty : row.Field <string>("nsbinlocfl");
            entity.nscommfl                = row.IsNull("nscommfl") ? string.Empty : row.Field <string>("nscommfl");
            entity.nscrtoanty              = row.IsNull("nscrtoanty") ? string.Empty : row.Field <string>("nscrtoanty");
            entity.nsquoteoanty            = row.IsNull("nsquoteoanty") ? string.Empty : row.Field <string>("nsquoteoanty");
            entity.oeautoapplyovrfl        = row.IsNull("oeautoapplyovrfl") ? string.Empty : row.Field <string>("oeautoapplyovrfl");
            entity.oechglntypefl           = row.IsNull("oechglntypefl") ? string.Empty : row.Field <string>("oechglntypefl");
            entity.oecostoverty            = row.IsNull("oecostoverty") ? string.Empty : row.Field <string>("oecostoverty");
            entity.oedotyamtmax            = row.IsNull("oedotyamtmax") ? decimal.Zero : row.Field <decimal>("oedotyamtmax");
            entity.oedotyamtmin            = row.IsNull("oedotyamtmin") ? decimal.Zero : row.Field <decimal>("oedotyamtmin");
            entity.oedotymrgamtmax         = row.IsNull("oedotymrgamtmax") ? decimal.Zero : row.Field <decimal>("oedotymrgamtmax");
            entity.oedotymrgamtmin         = row.IsNull("oedotymrgamtmin") ? decimal.Zero : row.Field <decimal>("oedotymrgamtmin");
            entity.oedotymrgpctmax         = row.IsNull("oedotymrgpctmax") ? decimal.Zero : row.Field <decimal>("oedotymrgpctmax");
            entity.oedotymrgpctmin         = row.IsNull("oedotymrgpctmin") ? decimal.Zero : row.Field <decimal>("oedotymrgpctmin");
            entity.oehardprcovrfl          = row.IsNull("oehardprcovrfl") ? string.Empty : row.Field <string>("oehardprcovrfl");
            entity.oetoleranceovrfl        = row.IsNull("oetoleranceovrfl") ? string.Empty : row.Field <string>("oetoleranceovrfl");
            entity.oenoinvoicefl           = row.IsNull("oenoinvoicefl") ? string.Empty : row.Field <string>("oenoinvoicefl");
            entity.oensqtyshpty            = row.IsNull("oensqtyshpty") ? string.Empty : row.Field <string>("oensqtyshpty");
            entity.oeonlyfl                = row.IsNull("oeonlyfl") ? string.Empty : row.Field <string>("oeonlyfl");
            entity.oeoptionfl              = row.IsNull("oeoptionfl") ? string.Empty : row.Field <string>("oeoptionfl");
            entity.oeorigpromisefl         = row.IsNull("oeorigpromisefl") ? string.Empty : row.Field <string>("oeorigpromisefl");
            entity.oepricefl               = row.IsNull("oepricefl") ? string.Empty : row.Field <string>("oepricefl");
            entity.oeqtyshipty             = row.IsNull("oeqtyshipty") ? string.Empty : row.Field <string>("oeqtyshipty");
            entity.oerebty                 = row.IsNull("oerebty") ? string.Empty : row.Field <string>("oerebty");
            entity.oesaleswhsety           = row.IsNull("oesaleswhsety") ? string.Empty : row.Field <string>("oesaleswhsety");
            entity.oeslsrepfl              = row.IsNull("oeslsrepfl") ? string.Empty : row.Field <string>("oeslsrepfl");
            entity.oesotyamtmax            = row.IsNull("oesotyamtmax") ? decimal.Zero : row.Field <decimal>("oesotyamtmax");
            entity.oesotyamtmin            = row.IsNull("oesotyamtmin") ? decimal.Zero : row.Field <decimal>("oesotyamtmin");
            entity.oesotymrgamtmax         = row.IsNull("oesotymrgamtmax") ? decimal.Zero : row.Field <decimal>("oesotymrgamtmax");
            entity.oesotymrgamtmin         = row.IsNull("oesotymrgamtmin") ? decimal.Zero : row.Field <decimal>("oesotymrgamtmin");
            entity.oesotymrgpctmax         = row.IsNull("oesotymrgpctmax") ? decimal.Zero : row.Field <decimal>("oesotymrgpctmax");
            entity.oesotymrgpctmin         = row.IsNull("oesotymrgpctmin") ? decimal.Zero : row.Field <decimal>("oesotymrgpctmin");
            entity.oetietype               = row.IsNull("oetietype") ? string.Empty : row.Field <string>("oetietype");
            entity.oetokenmodifyfl         = row.IsNull("oetokenmodifyfl") ? string.Empty : row.Field <string>("oetokenmodifyfl");
            entity.oetrntype               = row.IsNull("oetrntype") ? string.Empty : row.Field <string>("oetrntype");
            entity.oeupdtcustpofl          = row.IsNull("oeupdtcustpofl") ? string.Empty : row.Field <string>("oeupdtcustpofl");
            entity.operinit                = row.IsNull("operinit") ? string.Empty : row.Field <string>("operinit");
            entity.originchangefl          = row.IsNull("originchangefl") ? string.Empty : row.Field <string>("originchangefl");
            entity.ourproc                 = row.IsNull("ourproc") ? string.Empty : row.Field <string>("ourproc");
            entity.password                = row.IsNull("password") ? string.Empty : row.Field <string>("password");
            entity.pocrctfl                = row.IsNull("pocrctfl") ? string.Empty : row.Field <string>("pocrctfl");
            entity.podotyamtmax            = row.IsNull("podotyamtmax") ? decimal.Zero : row.Field <decimal>("podotyamtmax");
            entity.podotyamtmin            = row.IsNull("podotyamtmin") ? decimal.Zero : row.Field <decimal>("podotyamtmin");
            entity.popotyamtmax            = row.IsNull("popotyamtmax") ? decimal.Zero : row.Field <decimal>("popotyamtmax");
            entity.popotyamtmin            = row.IsNull("popotyamtmin") ? decimal.Zero : row.Field <decimal>("popotyamtmin");
            entity.printernm               = row.IsNull("printernm") ? string.Empty : row.Field <string>("printernm");
            entity.printernmset            = row.Field <bool>("printernmset");
            entity.prodnotesfl             = row.IsNull("prodnotesfl") ? string.Empty : row.Field <string>("prodnotesfl");
            entity.promoprcwin             = row.IsNull("promoprcwin") ? string.Empty : row.Field <string>("promoprcwin");
            entity.reqtakenfl              = row.IsNull("reqtakenfl") ? string.Empty : row.Field <string>("reqtakenfl");
            entity.resalefl                = row.IsNull("resalefl") ? string.Empty : row.Field <string>("resalefl");
            entity.returnpostfl            = row.IsNull("returnpostfl") ? string.Empty : row.Field <string>("returnpostfl");
            entity.rprinternm              = row.IsNull("rprinternm") ? string.Empty : row.Field <string>("rprinternm");
            entity.rprinternmset           = row.Field <bool>("rprinternmset");
            entity.saspgroup               = row.IsNull("saspgroup") ? string.Empty : row.Field <string>("saspgroup");
            entity.saspgroupset            = row.Field <bool>("saspgroupset");
            entity.secdeptno               = row.IsNull("secdeptno") ? 0 : row.Field <int>("secdeptno");
            entity.secdivno                = row.IsNull("secdivno") ? 0 : row.Field <int>("secdivno");
            entity.secnotefl               = row.IsNull("secnotefl") ? string.Empty : row.Field <string>("secnotefl");
            entity.secsubno                = row.IsNull("secsubno") ? 0 : row.Field <int>("secsubno");
            entity.seecommfl               = row.IsNull("seecommfl") ? string.Empty : row.Field <string>("seecommfl");
            entity.seecostfl               = row.IsNull("seecostfl") ? string.Empty : row.Field <string>("seecostfl");
            entity.shippingpt              = row.IsNull("shippingpt") ? string.Empty : row.Field <string>("shippingpt");
            entity.shippingptenabled       = row.Field <bool>("shippingptenabled");
            entity.shiptofl                = row.IsNull("shiptofl") ? string.Empty : row.Field <string>("shiptofl");
            entity.showroomuserfl          = row.IsNull("showroomuserfl") ? string.Empty : row.Field <string>("showroomuserfl");
            entity.showroomuserflenabled   = row.Field <bool>("showroomuserflenabled");
            entity.slsrep                  = row.IsNull("slsrep") ? string.Empty : row.Field <string>("slsrep");
            entity.storefrontuserid        = row.IsNull("storefrontuserid") ? string.Empty : row.Field <string>("storefrontuserid");
            entity.storefrontuseridenabled = row.Field <bool>("storefrontuseridenabled");
            entity.superfl                 = row.IsNull("superfl") ? string.Empty : row.Field <string>("superfl");
            entity.sysadminfl              = row.IsNull("sysadminfl") ? string.Empty : row.Field <string>("sysadminfl");
            entity.taxoverfl               = row.IsNull("taxoverfl") ? string.Empty : row.Field <string>("taxoverfl");
            entity.tenderty                = row.IsNull("tenderty") ? string.Empty : row.Field <string>("tenderty");
            entity.termsoverfl             = row.IsNull("termsoverfl") ? string.Empty : row.Field <string>("termsoverfl");
            entity.tqemailaddr             = row.IsNull("tqemailaddr") ? string.Empty : row.Field <string>("tqemailaddr");
            entity.tqposition              = row.IsNull("tqposition") ? string.Empty : row.Field <string>("tqposition");
            entity.transdt                 = row.Field <DateTime?>("transdt");
            entity.transproc               = row.IsNull("transproc") ? string.Empty : row.Field <string>("transproc");
            entity.transtm                 = row.IsNull("transtm") ? string.Empty : row.Field <string>("transtm");
            entity.twlrfuser               = row.IsNull("twlrfuser") ? string.Empty : row.Field <string>("twlrfuser");
            entity.twlrfuserenabled        = row.Field <bool>("twlrfuserenabled");
            entity.unmaskccty              = row.IsNull("unmaskccty") ? string.Empty : row.Field <string>("unmaskccty");
            entity.updglapty               = row.IsNull("updglapty") ? string.Empty : row.Field <string>("updglapty");
            entity.updglarty               = row.IsNull("updglarty") ? string.Empty : row.Field <string>("updglarty");
            entity.updglicty               = row.IsNull("updglicty") ? string.Empty : row.Field <string>("updglicty");
            entity.updglkpty               = row.IsNull("updglkpty") ? string.Empty : row.Field <string>("updglkpty");
            entity.updgloety               = row.IsNull("updgloety") ? string.Empty : row.Field <string>("updgloety");
            entity.updglpoty               = row.IsNull("updglpoty") ? string.Empty : row.Field <string>("updglpoty");
            entity.updglwtty               = row.IsNull("updglwtty") ? string.Empty : row.Field <string>("updglwtty");
            entity.useprevnsfl             = row.IsNull("useprevnsfl") ? string.Empty : row.Field <string>("useprevnsfl");
            entity.user1              = row.IsNull("user1") ? string.Empty : row.Field <string>("user1");
            entity.user2              = row.IsNull("user2") ? string.Empty : row.Field <string>("user2");
            entity.user3              = row.IsNull("user3") ? string.Empty : row.Field <string>("user3");
            entity.user4              = row.IsNull("user4") ? string.Empty : row.Field <string>("user4");
            entity.user5              = row.IsNull("user5") ? string.Empty : row.Field <string>("user5");
            entity.user6              = row.Field <decimal?>("user6");
            entity.user7              = row.Field <decimal?>("user7");
            entity.user8              = row.Field <DateTime?>("user8");
            entity.user9              = row.Field <DateTime?>("user9");
            entity.userclearfl        = row.IsNull("userclearfl") ? string.Empty : row.Field <string>("userclearfl");
            entity.usergroup          = row.IsNull("usergroup") ? string.Empty : row.Field <string>("usergroup");
            entity.usergroupset       = row.Field <bool>("usergroupset");
            entity.vaautolnentryty    = row.IsNull("vaautolnentryty") ? string.Empty : row.Field <string>("vaautolnentryty");
            entity.vaautoshipty       = row.IsNull("vaautoshipty") ? string.Empty : row.Field <string>("vaautoshipty");
            entity.vaheaderty         = row.IsNull("vaheaderty") ? string.Empty : row.Field <string>("vaheaderty");
            entity.valinecancelfl     = row.IsNull("valinecancelfl") ? string.Empty : row.Field <string>("valinecancelfl");
            entity.valtakenfl         = row.IsNull("valtakenfl") ? string.Empty : row.Field <string>("valtakenfl");
            entity.vaverchg           = row.IsNull("vaverchg") ? string.Empty : row.Field <string>("vaverchg");
            entity.vaveruse           = row.IsNull("vaveruse") ? string.Empty : row.Field <string>("vaveruse");
            entity.vendpostfl         = row.IsNull("vendpostfl") ? string.Empty : row.Field <string>("vendpostfl");
            entity.verrcvchgfl        = row.IsNull("verrcvchgfl") ? string.Empty : row.Field <string>("verrcvchgfl");
            entity.whse               = row.IsNull("whse") ? string.Empty : row.Field <string>("whse");
            entity.whseenabled        = row.Field <bool>("whseenabled");
            entity.whsegroup          = row.IsNull("whsegroup") ? string.Empty : row.Field <string>("whsegroup");
            entity.wlpicktype         = row.IsNull("wlpicktype") ? string.Empty : row.Field <string>("wlpicktype");
            entity.wlpicktypeset      = row.Field <bool>("wlpicktypeset");
            entity.wtapprwhse         = row.IsNull("wtapprwhse") ? string.Empty : row.Field <string>("wtapprwhse");
            entity.xconocostfl        = row.IsNull("xconocostfl") ? string.Empty : row.Field <string>("xconocostfl");
            entity.cMyDayUser         = row.IsNull("cMyDayUser") ? string.Empty : row.Field <string>("cMyDayUser");
            entity.cMyDayUserenabled  = row.Field <bool>("cMyDayUserenabled");
            entity.cMyDayTimer        = row.IsNull("cMyDayTimer") ? string.Empty : row.Field <string>("cMyDayTimer");
            entity.cMyDayTimerenabled = row.Field <bool>("cMyDayTimerenabled");
            entity.logintype          = row.IsNull("logintype") ? string.Empty : row.Field <string>("logintype");
            entity.userfield          = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield");
            return(entity);
        }