示例#1
0
 /// <summary>
 /// Update a database row from a class
 /// </summary>
 public static void UpdateRowFromSasaresults(ref DataRow row, Sasaresults entity)
 {
     row.SetField("forcelogin", entity.forcelogin);
     row.SetField("monitorfl", entity.monitorfl);
     row.SetField("docdir", entity.docdir);
     row.SetField("sysdir", entity.sysdir);
     row.SetField("timeout", entity.timeout);
     row.SetField("begwtno", entity.begwtno);
     row.SetField("nextwtno", entity.nextwtno);
     row.SetField("endwtno", entity.endwtno);
     row.SetField("licenseno", entity.licenseno);
     row.SetField("licenseto", entity.licenseto);
     row.SetField("nousers", entity.nousers);
     row.SetField("rdcustno", entity.rdcustno);
     row.SetField("licensedt", entity.licensedt);
     row.SetField("modapfl", entity.modapfl);
     row.SetField("modarfl", entity.modarfl);
     row.SetField("modbpfl", entity.modbpfl);
     row.SetField("modcmfl", entity.modcmfl);
     row.SetField("modedfl", entity.modedfl);
     row.SetField("modglfl", entity.modglfl);
     row.SetField("modibfl", entity.modibfl);
     row.SetField("modicfl", entity.modicfl);
     row.SetField("modisfl", entity.modisfl);
     row.SetField("modjmfl", entity.modjmfl);
     row.SetField("modkpfl", entity.modkpfl);
     row.SetField("modoefl", entity.modoefl);
     row.SetField("modogfl", entity.modogfl);
     row.SetField("modoifl", entity.modoifl);
     row.SetField("modotfl", entity.modotfl);
     row.SetField("modpmfl", entity.modpmfl);
     row.SetField("modpofl", entity.modpofl);
     row.SetField("modrsfl", entity.modrsfl);
     row.SetField("modslfl", entity.modslfl);
     row.SetField("modsvfl", entity.modsvfl);
     row.SetField("modswfl", entity.modswfl);
     row.SetField("modtqfl", entity.modtqfl);
     row.SetField("modvafl", entity.modvafl);
     row.SetField("modvtfl", entity.modvtfl);
     row.SetField("modwlfl", entity.modwlfl);
     row.SetField("modwmfl", entity.modwmfl);
     row.SetField("modwtfl", entity.modwtfl);
     row.SetField("operinit", entity.operinit);
     row.SetField("transdt", entity.transdt);
     row.SetField("transproc", entity.transproc);
     row.SetField("transtm", entity.transtm);
     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("ptxsensitive", entity.ptxsensitive);
     row.SetField("ptxcono", entity.ptxcono);
     row.SetField("ptxfeewhse", entity.ptxfeewhse);
     row.SetField("ptxwhse", entity.ptxwhse);
     row.SetField("multitenantfl", entity.multitenantfl);
     row.SetField("userfield", entity.userfield);
     row.SetField("sasaRowID", entity.sasaRowID.ToByteArray());
 }
示例#2
0
        public static Sasaresults BuildSasaresultsFromRow(DataRow row)
        {
            Sasaresults entity = new Sasaresults();

            entity.forcelogin    = row.Field <bool>("forcelogin");
            entity.monitorfl     = row.Field <bool>("monitorfl");
            entity.docdir        = row.IsNull("docdir") ? string.Empty : row.Field <string>("docdir");
            entity.sysdir        = row.IsNull("sysdir") ? string.Empty : row.Field <string>("sysdir");
            entity.timeout       = row.IsNull("timeout") ? 0 : row.Field <int>("timeout");
            entity.begwtno       = row.IsNull("begwtno") ? 0 : row.Field <int>("begwtno");
            entity.nextwtno      = row.IsNull("nextwtno") ? 0 : row.Field <int>("nextwtno");
            entity.endwtno       = row.IsNull("endwtno") ? 0 : row.Field <int>("endwtno");
            entity.licenseno     = row.IsNull("licenseno") ? string.Empty : row.Field <string>("licenseno");
            entity.licenseto     = row.IsNull("licenseto") ? string.Empty : row.Field <string>("licenseto");
            entity.nousers       = row.IsNull("nousers") ? 0 : row.Field <int>("nousers");
            entity.rdcustno      = row.IsNull("rdcustno") ? decimal.Zero : row.Field <decimal>("rdcustno");
            entity.licensedt     = row.Field <DateTime?>("licensedt");
            entity.modapfl       = row.Field <bool>("modapfl");
            entity.modarfl       = row.Field <bool>("modarfl");
            entity.modbpfl       = row.Field <bool>("modbpfl");
            entity.modcmfl       = row.Field <bool>("modcmfl");
            entity.modedfl       = row.Field <bool>("modedfl");
            entity.modglfl       = row.Field <bool>("modglfl");
            entity.modibfl       = row.Field <bool>("modibfl");
            entity.modicfl       = row.Field <bool>("modicfl");
            entity.modisfl       = row.Field <bool>("modisfl");
            entity.modjmfl       = row.Field <bool>("modjmfl");
            entity.modkpfl       = row.Field <bool>("modkpfl");
            entity.modoefl       = row.Field <bool>("modoefl");
            entity.modogfl       = row.Field <bool>("modogfl");
            entity.modoifl       = row.Field <bool>("modoifl");
            entity.modotfl       = row.Field <bool>("modotfl");
            entity.modpmfl       = row.Field <bool>("modpmfl");
            entity.modpofl       = row.Field <bool>("modpofl");
            entity.modrsfl       = row.Field <bool>("modrsfl");
            entity.modslfl       = row.Field <bool>("modslfl");
            entity.modsvfl       = row.Field <bool>("modsvfl");
            entity.modswfl       = row.Field <bool>("modswfl");
            entity.modtqfl       = row.Field <bool>("modtqfl");
            entity.modvafl       = row.Field <bool>("modvafl");
            entity.modvtfl       = row.Field <bool>("modvtfl");
            entity.modwlfl       = row.Field <bool>("modwlfl");
            entity.modwmfl       = row.Field <bool>("modwmfl");
            entity.modwtfl       = row.Field <bool>("modwtfl");
            entity.operinit      = row.IsNull("operinit") ? string.Empty : row.Field <string>("operinit");
            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.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.ptxsensitive  = row.Field <bool>("ptxsensitive");
            entity.ptxcono       = row.IsNull("ptxcono") ? 0 : row.Field <int>("ptxcono");
            entity.ptxfeewhse    = row.IsNull("ptxfeewhse") ? string.Empty : row.Field <string>("ptxfeewhse");
            entity.ptxwhse       = row.IsNull("ptxwhse") ? string.Empty : row.Field <string>("ptxwhse");
            entity.multitenantfl = row.Field <bool>("multitenantfl");
            entity.userfield     = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield");
            entity.sasaRowID     = row.Field <byte[]>("sasaRowID").ToStringEncoded();
            return(entity);
        }