Exemple #1
0
 /// <summary>
 /// Update a database row from a class
 /// </summary>
 public static void UpdateRowFromAosystemrptitem(ref DataRow row, Aosystemrptitem entity)
 {
     row.SetField("currproc", entity.currproc);
     row.SetField("trmgrlang", entity.trmgrlang);
     row.SetField("rpttitle", entity.rpttitle);
     row.SetField("lastupdated", entity.lastupdated);
     row.SetField("printoptfl", entity.printoptfl);
     row.SetField("reportid", entity.reportid);
     row.SetField("standardty", entity.standardty);
     row.SetField("pglength", entity.pglength);
     row.SetField("xpglength1", entity.xpglength1);
     row.SetField("xpglength2", entity.xpglength2);
     row.SetField("xpglength3", entity.xpglength3);
     row.SetField("xpglength4", entity.xpglength4);
     row.SetField("xpglength5", entity.xpglength5);
     row.SetField("recaloptno", entity.recaloptno);
     row.SetField("recaloptno-sensitive", entity.recaloptnoSensitive);
     row.SetField("uselistoption", entity.uselistoption);
     row.SetField("recaloptno2", entity.recaloptno2);
     row.SetField("recaloptno2-sensitive", entity.recaloptno2Sensitive);
     row.SetField("uselistoption2", entity.uselistoption2);
     row.SetField("recaloptno3", entity.recaloptno3);
     row.SetField("recaloptno3-sensitive", entity.recaloptno3Sensitive);
     row.SetField("uselistoption3", entity.uselistoption3);
     row.SetField("listproc", entity.listproc);
     row.SetField("listproc-sensitive", entity.listprocSensitive);
     row.SetField("listproc2", entity.listproc2);
     row.SetField("listproc2-sensitive", entity.listproc2Sensitive);
     row.SetField("listproc3", entity.listproc3);
     row.SetField("listproc3-sensitive", entity.listproc3Sensitive);
     row.SetField("pausebeg", entity.pausebeg);
     row.SetField("openprno", entity.openprno);
     row.SetField("openprno-sensitive", entity.openprnoSensitive);
     row.SetField("whseprtno", entity.whseprtno);
     row.SetField("wide", entity.wide);
     row.SetField("xwide1", entity.xwide1);
     row.SetField("xwide2", entity.xwide2);
     row.SetField("xwide3", entity.xwide3);
     row.SetField("xwide4", entity.xwide4);
     row.SetField("xwide5", entity.xwide5);
     row.SetField("coldfl", entity.coldfl);
     row.SetField("xcoldfl1", entity.xcoldfl1);
     row.SetField("xcoldfl2", entity.xcoldfl2);
     row.SetField("xcoldfl3", entity.xcoldfl3);
     row.SetField("xcoldfl4", entity.xcoldfl4);
     row.SetField("xcoldfl5", entity.xcoldfl5);
     row.SetField("backfl", entity.backfl);
     row.SetField("headerprfl", entity.headerprfl);
     row.SetField("xheaderprfl1", entity.xheaderprfl1);
     row.SetField("xheaderprfl2", entity.xheaderprfl2);
     row.SetField("xheaderprfl3", entity.xheaderprfl3);
     row.SetField("xheaderprfl4", entity.xheaderprfl4);
     row.SetField("xheaderprfl5", entity.xheaderprfl5);
     row.SetField("jrnlfl", entity.jrnlfl);
     row.SetField("openprfl", entity.openprfl);
     row.SetField("optpgfl", entity.optpgfl);
     row.SetField("xoptpgfl1", entity.xoptpgfl1);
     row.SetField("xoptpgfl2", entity.xoptpgfl2);
     row.SetField("xoptpgfl3", entity.xoptpgfl3);
     row.SetField("xoptpgfl4", entity.xoptpgfl4);
     row.SetField("xoptpgfl5", entity.xoptpgfl5);
     row.SetField("pagedfl", entity.pagedfl);
     row.SetField("xpagedfl1", entity.xpagedfl1);
     row.SetField("xpagedfl2", entity.xpagedfl2);
     row.SetField("xpagedfl3", entity.xpagedfl3);
     row.SetField("xpagedfl4", entity.xpagedfl4);
     row.SetField("xpagedfl5", entity.xpagedfl5);
     row.SetField("titletype", entity.titletype);
     row.SetField("xtitletype1", entity.xtitletype1);
     row.SetField("xtitletype2", entity.xtitletype2);
     row.SetField("xtitletype3", entity.xtitletype3);
     row.SetField("xtitletype4", entity.xtitletype4);
     row.SetField("xtitletype5", entity.xtitletype5);
     row.SetField("sassr-rowid", entity.sassrRowid.ToByteArray());
     row.SetField("userfield", entity.userfield);
 }
Exemple #2
0
        public static Aosystemrptitem BuildAosystemrptitemFromRow(DataRow row)
        {
            Aosystemrptitem entity = new Aosystemrptitem();

            entity.currproc             = row.IsNull("currproc") ? string.Empty : row.Field <string>("currproc");
            entity.trmgrlang            = row.IsNull("trmgrlang") ? string.Empty : row.Field <string>("trmgrlang");
            entity.rpttitle             = row.IsNull("rpttitle") ? string.Empty : row.Field <string>("rpttitle");
            entity.lastupdated          = row.IsNull("lastupdated") ? string.Empty : row.Field <string>("lastupdated");
            entity.printoptfl           = row.Field <bool>("printoptfl");
            entity.reportid             = row.IsNull("reportid") ? string.Empty : row.Field <string>("reportid");
            entity.standardty           = row.IsNull("standardty") ? string.Empty : row.Field <string>("standardty");
            entity.pglength             = row.IsNull("pglength") ? 0 : row.Field <int>("pglength");
            entity.xpglength1           = row.IsNull("xpglength1") ? 0 : row.Field <int>("xpglength1");
            entity.xpglength2           = row.IsNull("xpglength2") ? 0 : row.Field <int>("xpglength2");
            entity.xpglength3           = row.IsNull("xpglength3") ? 0 : row.Field <int>("xpglength3");
            entity.xpglength4           = row.IsNull("xpglength4") ? 0 : row.Field <int>("xpglength4");
            entity.xpglength5           = row.IsNull("xpglength5") ? 0 : row.Field <int>("xpglength5");
            entity.recaloptno           = row.IsNull("recaloptno") ? 0 : row.Field <int>("recaloptno");
            entity.recaloptnoSensitive  = row.Field <bool>("recaloptno-sensitive");
            entity.uselistoption        = row.Field <bool>("uselistoption");
            entity.recaloptno2          = row.IsNull("recaloptno2") ? 0 : row.Field <int>("recaloptno2");
            entity.recaloptno2Sensitive = row.Field <bool>("recaloptno2-sensitive");
            entity.uselistoption2       = row.Field <bool>("uselistoption2");
            entity.recaloptno3          = row.IsNull("recaloptno3") ? 0 : row.Field <int>("recaloptno3");
            entity.recaloptno3Sensitive = row.Field <bool>("recaloptno3-sensitive");
            entity.uselistoption3       = row.Field <bool>("uselistoption3");
            entity.listproc             = row.IsNull("listproc") ? string.Empty : row.Field <string>("listproc");
            entity.listprocSensitive    = row.Field <bool>("listproc-sensitive");
            entity.listproc2            = row.IsNull("listproc2") ? string.Empty : row.Field <string>("listproc2");
            entity.listproc2Sensitive   = row.Field <bool>("listproc2-sensitive");
            entity.listproc3            = row.IsNull("listproc3") ? string.Empty : row.Field <string>("listproc3");
            entity.listproc3Sensitive   = row.Field <bool>("listproc3-sensitive");
            entity.pausebeg             = row.IsNull("pausebeg") ? string.Empty : row.Field <string>("pausebeg");
            entity.openprno             = row.IsNull("openprno") ? 0 : row.Field <int>("openprno");
            entity.openprnoSensitive    = row.Field <bool>("openprno-sensitive");
            entity.whseprtno            = row.IsNull("whseprtno") ? 0 : row.Field <int>("whseprtno");
            entity.wide         = row.Field <bool>("wide");
            entity.xwide1       = row.Field <bool>("xwide1");
            entity.xwide2       = row.Field <bool>("xwide2");
            entity.xwide3       = row.Field <bool>("xwide3");
            entity.xwide4       = row.Field <bool>("xwide4");
            entity.xwide5       = row.Field <bool>("xwide5");
            entity.coldfl       = row.Field <bool>("coldfl");
            entity.xcoldfl1     = row.Field <bool>("xcoldfl1");
            entity.xcoldfl2     = row.Field <bool>("xcoldfl2");
            entity.xcoldfl3     = row.Field <bool>("xcoldfl3");
            entity.xcoldfl4     = row.Field <bool>("xcoldfl4");
            entity.xcoldfl5     = row.Field <bool>("xcoldfl5");
            entity.backfl       = row.Field <bool>("backfl");
            entity.headerprfl   = row.Field <bool>("headerprfl");
            entity.xheaderprfl1 = row.Field <bool>("xheaderprfl1");
            entity.xheaderprfl2 = row.Field <bool>("xheaderprfl2");
            entity.xheaderprfl3 = row.Field <bool>("xheaderprfl3");
            entity.xheaderprfl4 = row.Field <bool>("xheaderprfl4");
            entity.xheaderprfl5 = row.Field <bool>("xheaderprfl5");
            entity.jrnlfl       = row.Field <bool>("jrnlfl");
            entity.openprfl     = row.Field <bool>("openprfl");
            entity.optpgfl      = row.Field <bool>("optpgfl");
            entity.xoptpgfl1    = row.Field <bool>("xoptpgfl1");
            entity.xoptpgfl2    = row.Field <bool>("xoptpgfl2");
            entity.xoptpgfl3    = row.Field <bool>("xoptpgfl3");
            entity.xoptpgfl4    = row.Field <bool>("xoptpgfl4");
            entity.xoptpgfl5    = row.Field <bool>("xoptpgfl5");
            entity.pagedfl      = row.Field <bool>("pagedfl");
            entity.xpagedfl1    = row.Field <bool>("xpagedfl1");
            entity.xpagedfl2    = row.Field <bool>("xpagedfl2");
            entity.xpagedfl3    = row.Field <bool>("xpagedfl3");
            entity.xpagedfl4    = row.Field <bool>("xpagedfl4");
            entity.xpagedfl5    = row.Field <bool>("xpagedfl5");
            entity.titletype    = row.Field <bool>("titletype");
            entity.xtitletype1  = row.Field <bool>("xtitletype1");
            entity.xtitletype2  = row.Field <bool>("xtitletype2");
            entity.xtitletype3  = row.Field <bool>("xtitletype3");
            entity.xtitletype4  = row.Field <bool>("xtitletype4");
            entity.xtitletype5  = row.Field <bool>("xtitletype5");
            entity.sassrRowid   = row.Field <byte[]>("sassr-rowid").ToStringEncoded();
            entity.userfield    = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield");
            return(entity);
        }