예제 #1
0
 /// <summary>
 /// Update a database row from a class
 /// </summary>
 public static void UpdateRowFromSasosetupuser(ref DataRow row, Sasosetupuser entity)
 {
     row.SetField("ActivityOtherOperFl", entity.activityOtherOperFl);
     row.SetField("ActivitySecrLev", entity.activitySecrLev);
     row.SetField("AddFavorites", entity.addFavorites);
     row.SetField("addr1", entity.addr1);
     row.SetField("addr2", entity.addr2);
     row.SetField("addrenabled", entity.addrenabled);
     row.SetField("addr3", entity.addr3);
     row.SetField("addr3enabled", entity.addr3enabled);
     row.SetField("AOSecurityset", entity.aOSecurityset);
     row.SetField("apeiaddonfl", entity.apeiaddonfl);
     row.SetField("apeiexpensefl", entity.apeiexpensefl);
     row.SetField("apeiovertolfl", entity.apeiovertolfl);
     row.SetField("apeitradefl", entity.apeitradefl);
     row.SetField("apeiusecostfl", entity.apeiusecostfl);
     row.SetField("ArrangeCols", entity.arrangeCols);
     row.SetField("CannotChange", entity.cannotChange);
     row.SetField("cellph", entity.cellph);
     row.SetField("cellphenabled", entity.cellphenabled);
     row.SetField("ChangeAppServer", entity.changeAppServer);
     row.SetField("ChangeProfiles", entity.changeProfiles);
     row.SetField("city", entity.city);
     row.SetField("cityenabled", entity.cityenabled);
     row.SetField("ContactMgmntSecrLev", entity.contactMgmntSecrLev);
     row.SetField("Dept", entity.dept);
     row.SetField("Disabled", entity.disabled);
     row.SetField("divnoallowlistset", entity.divnoallowlistset);
     row.SetField("divnorestrictapfl", entity.divnorestrictapfl);
     row.SetField("divnorestrictarfl", entity.divnorestrictarfl);
     row.SetField("divnorestrictcrfl", entity.divnorestrictcrfl);
     row.SetField("divnorestrictglfl", entity.divnorestrictglfl);
     row.SetField("divnorestricticfl", entity.divnorestricticfl);
     row.SetField("divnorestrictoefl", entity.divnorestrictoefl);
     row.SetField("divnorestrictpofl", entity.divnorestrictpofl);
     row.SetField("divnorestrictwtallfl", entity.divnorestrictwtallfl);
     row.SetField("divnorestrictwtfl", entity.divnorestrictwtfl);
     row.SetField("dropboxkey", entity.dropboxkey);
     row.SetField("dropboxkeyvisible", entity.dropboxkeyvisible);
     row.SetField("email", entity.email);
     row.SetField("EntryLayout", entity.entryLayout);
     row.SetField("etsecurityset", entity.etsecurityset);
     row.SetField("faxph", entity.faxph);
     row.SetField("homeph", entity.homeph);
     row.SetField("homephenabled", entity.homephenabled);
     row.SetField("JobTitle", entity.jobTitle);
     row.SetField("maxwindows", entity.maxwindows);
     row.SetField("MenuSet", entity.menuSet);
     row.SetField("MenuSetenabled", entity.menuSetenabled);
     row.SetField("MustChange", entity.mustChange);
     row.SetField("operinit", entity.operinit);
     row.SetField("oereassignarfl", entity.oereassignarfl);
     row.SetField("pagerph", entity.pagerph);
     row.SetField("webprofilename", entity.webprofilename);
     row.SetField("webprofilenameenabled", entity.webprofilenameenabled);
     row.SetField("profileuserset", entity.profileuserset);
     row.SetField("profileusersetenabled", entity.profileusersetenabled);
     row.SetField("queue-d", entity.queueD);
     row.SetField("queue-dset", entity.queueDset);
     row.SetField("queue-s", entity.queueS);
     row.SetField("queue-sset", entity.queueSset);
     row.SetField("queuefl", entity.queuefl);
     row.SetField("restricteditapfl", entity.restricteditapfl);
     row.SetField("restricteditarfl", entity.restricteditarfl);
     row.SetField("seccredmgrfl", entity.seccredmgrfl);
     row.SetField("state", entity.state);
     row.SetField("stateenabled", entity.stateenabled);
     row.SetField("ToolbarLayout", entity.toolbarLayout);
     row.SetField("transdt", entity.transdt);
     row.SetField("transproc", entity.transproc);
     row.SetField("transtm", entity.transtm);
     row.SetField("twlwhse", entity.twlwhse);
     row.SetField("twlrestrictwhsefl", entity.twlrestrictwhsefl);
     row.SetField("twllastuseddt", entity.twllastuseddt);
     row.SetField("UnlimitedWebAccess", entity.unlimitedWebAccess);
     row.SetField("updategltrans", entity.updategltrans);
     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("workph", entity.workph);
     row.SetField("webextensiontype", entity.webextensiontype);
     row.SetField("webmodificationaccesslevel", entity.webmodificationaccesslevel);
     row.SetField("websettingaccesslevel", entity.websettingaccesslevel);
     row.SetField("zipcd", entity.zipcd);
     row.SetField("zipcdenabled", entity.zipcdenabled);
     row.SetField("_Password", entity.password);
     row.SetField("_User-Name", entity.userName);
     row.SetField("_User-Nameenabled", entity.userNameenabled);
     row.SetField("_Userid", entity.userid);
     row.SetField("userfield", entity.userfield);
 }
예제 #2
0
        public static Sasosetupuser BuildSasosetupuserFromRow(DataRow row)
        {
            Sasosetupuser entity = new Sasosetupuser();

            entity.activityOtherOperFl = row.IsNull("ActivityOtherOperFl") ? string.Empty : row.Field <string>("ActivityOtherOperFl");
            entity.activitySecrLev     = row.IsNull("ActivitySecrLev") ? 0 : row.Field <int>("ActivitySecrLev");
            entity.addFavorites        = row.IsNull("AddFavorites") ? string.Empty : row.Field <string>("AddFavorites");
            entity.addr1                      = row.IsNull("addr1") ? string.Empty : row.Field <string>("addr1");
            entity.addr2                      = row.IsNull("addr2") ? string.Empty : row.Field <string>("addr2");
            entity.addrenabled                = row.Field <bool>("addrenabled");
            entity.addr3                      = row.IsNull("addr3") ? string.Empty : row.Field <string>("addr3");
            entity.addr3enabled               = row.Field <bool>("addr3enabled");
            entity.aOSecurityset              = row.Field <bool>("AOSecurityset");
            entity.apeiaddonfl                = row.IsNull("apeiaddonfl") ? string.Empty : row.Field <string>("apeiaddonfl");
            entity.apeiexpensefl              = row.IsNull("apeiexpensefl") ? string.Empty : row.Field <string>("apeiexpensefl");
            entity.apeiovertolfl              = row.IsNull("apeiovertolfl") ? string.Empty : row.Field <string>("apeiovertolfl");
            entity.apeitradefl                = row.IsNull("apeitradefl") ? string.Empty : row.Field <string>("apeitradefl");
            entity.apeiusecostfl              = row.IsNull("apeiusecostfl") ? string.Empty : row.Field <string>("apeiusecostfl");
            entity.arrangeCols                = row.IsNull("ArrangeCols") ? string.Empty : row.Field <string>("ArrangeCols");
            entity.cannotChange               = row.IsNull("CannotChange") ? string.Empty : row.Field <string>("CannotChange");
            entity.cellph                     = row.IsNull("cellph") ? string.Empty : row.Field <string>("cellph");
            entity.cellphenabled              = row.Field <bool>("cellphenabled");
            entity.changeAppServer            = row.IsNull("ChangeAppServer") ? string.Empty : row.Field <string>("ChangeAppServer");
            entity.changeProfiles             = row.IsNull("ChangeProfiles") ? string.Empty : row.Field <string>("ChangeProfiles");
            entity.city                       = row.IsNull("city") ? string.Empty : row.Field <string>("city");
            entity.cityenabled                = row.Field <bool>("cityenabled");
            entity.contactMgmntSecrLev        = row.IsNull("ContactMgmntSecrLev") ? 0 : row.Field <int>("ContactMgmntSecrLev");
            entity.dept                       = row.IsNull("Dept") ? string.Empty : row.Field <string>("Dept");
            entity.disabled                   = row.IsNull("Disabled") ? string.Empty : row.Field <string>("Disabled");
            entity.divnoallowlistset          = row.Field <bool>("divnoallowlistset");
            entity.divnorestrictapfl          = row.IsNull("divnorestrictapfl") ? string.Empty : row.Field <string>("divnorestrictapfl");
            entity.divnorestrictarfl          = row.IsNull("divnorestrictarfl") ? string.Empty : row.Field <string>("divnorestrictarfl");
            entity.divnorestrictcrfl          = row.IsNull("divnorestrictcrfl") ? string.Empty : row.Field <string>("divnorestrictcrfl");
            entity.divnorestrictglfl          = row.IsNull("divnorestrictglfl") ? string.Empty : row.Field <string>("divnorestrictglfl");
            entity.divnorestricticfl          = row.IsNull("divnorestricticfl") ? string.Empty : row.Field <string>("divnorestricticfl");
            entity.divnorestrictoefl          = row.IsNull("divnorestrictoefl") ? string.Empty : row.Field <string>("divnorestrictoefl");
            entity.divnorestrictpofl          = row.IsNull("divnorestrictpofl") ? string.Empty : row.Field <string>("divnorestrictpofl");
            entity.divnorestrictwtallfl       = row.IsNull("divnorestrictwtallfl") ? string.Empty : row.Field <string>("divnorestrictwtallfl");
            entity.divnorestrictwtfl          = row.IsNull("divnorestrictwtfl") ? string.Empty : row.Field <string>("divnorestrictwtfl");
            entity.dropboxkey                 = row.IsNull("dropboxkey") ? string.Empty : row.Field <string>("dropboxkey");
            entity.dropboxkeyvisible          = row.Field <bool>("dropboxkeyvisible");
            entity.email                      = row.IsNull("email") ? string.Empty : row.Field <string>("email");
            entity.entryLayout                = row.IsNull("EntryLayout") ? string.Empty : row.Field <string>("EntryLayout");
            entity.etsecurityset              = row.Field <bool>("etsecurityset");
            entity.faxph                      = row.IsNull("faxph") ? string.Empty : row.Field <string>("faxph");
            entity.homeph                     = row.IsNull("homeph") ? string.Empty : row.Field <string>("homeph");
            entity.homephenabled              = row.Field <bool>("homephenabled");
            entity.jobTitle                   = row.IsNull("JobTitle") ? string.Empty : row.Field <string>("JobTitle");
            entity.maxwindows                 = row.IsNull("maxwindows") ? 0 : row.Field <int>("maxwindows");
            entity.menuSet                    = row.IsNull("MenuSet") ? string.Empty : row.Field <string>("MenuSet");
            entity.menuSetenabled             = row.Field <bool>("MenuSetenabled");
            entity.mustChange                 = row.IsNull("MustChange") ? string.Empty : row.Field <string>("MustChange");
            entity.operinit                   = row.IsNull("operinit") ? string.Empty : row.Field <string>("operinit");
            entity.oereassignarfl             = row.IsNull("oereassignarfl") ? string.Empty : row.Field <string>("oereassignarfl");
            entity.pagerph                    = row.IsNull("pagerph") ? string.Empty : row.Field <string>("pagerph");
            entity.webprofilename             = row.IsNull("webprofilename") ? string.Empty : row.Field <string>("webprofilename");
            entity.webprofilenameenabled      = row.Field <bool>("webprofilenameenabled");
            entity.profileuserset             = row.IsNull("profileuserset") ? string.Empty : row.Field <string>("profileuserset");
            entity.profileusersetenabled      = row.Field <bool>("profileusersetenabled");
            entity.queueD                     = row.IsNull("queue-d") ? string.Empty : row.Field <string>("queue-d");
            entity.queueDset                  = row.Field <bool>("queue-dset");
            entity.queueS                     = row.IsNull("queue-s") ? string.Empty : row.Field <string>("queue-s");
            entity.queueSset                  = row.Field <bool>("queue-sset");
            entity.queuefl                    = row.IsNull("queuefl") ? string.Empty : row.Field <string>("queuefl");
            entity.restricteditapfl           = row.IsNull("restricteditapfl") ? string.Empty : row.Field <string>("restricteditapfl");
            entity.restricteditarfl           = row.IsNull("restricteditarfl") ? string.Empty : row.Field <string>("restricteditarfl");
            entity.seccredmgrfl               = row.IsNull("seccredmgrfl") ? string.Empty : row.Field <string>("seccredmgrfl");
            entity.state                      = row.IsNull("state") ? string.Empty : row.Field <string>("state");
            entity.stateenabled               = row.Field <bool>("stateenabled");
            entity.toolbarLayout              = row.IsNull("ToolbarLayout") ? string.Empty : row.Field <string>("ToolbarLayout");
            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.twlwhse                    = row.IsNull("twlwhse") ? string.Empty : row.Field <string>("twlwhse");
            entity.twlrestrictwhsefl          = row.IsNull("twlrestrictwhsefl") ? string.Empty : row.Field <string>("twlrestrictwhsefl");
            entity.twllastuseddt              = row.Field <DateTime?>("twllastuseddt");
            entity.unlimitedWebAccess         = row.IsNull("UnlimitedWebAccess") ? string.Empty : row.Field <string>("UnlimitedWebAccess");
            entity.updategltrans              = row.IsNull("updategltrans") ? string.Empty : row.Field <string>("updategltrans");
            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.workph                     = row.IsNull("workph") ? string.Empty : row.Field <string>("workph");
            entity.webextensiontype           = row.IsNull("webextensiontype") ? string.Empty : row.Field <string>("webextensiontype");
            entity.webmodificationaccesslevel = row.IsNull("webmodificationaccesslevel") ? string.Empty : row.Field <string>("webmodificationaccesslevel");
            entity.websettingaccesslevel      = row.IsNull("websettingaccesslevel") ? string.Empty : row.Field <string>("websettingaccesslevel");
            entity.zipcd                      = row.IsNull("zipcd") ? string.Empty : row.Field <string>("zipcd");
            entity.zipcdenabled               = row.Field <bool>("zipcdenabled");
            entity.password                   = row.IsNull("_Password") ? string.Empty : row.Field <string>("_Password");
            entity.userName                   = row.IsNull("_User-Name") ? string.Empty : row.Field <string>("_User-Name");
            entity.userNameenabled            = row.Field <bool>("_User-Nameenabled");
            entity.userid                     = row.IsNull("_Userid") ? string.Empty : row.Field <string>("_Userid");
            entity.userfield                  = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield");
            return(entity);
        }