Exemplo n.º 1
0
        public static Icipfetchreplresults BuildIcipfetchreplresultsFromRow(DataRow row)
        {
            Icipfetchreplresults entity = new Icipfetchreplresults();

            entity.unittext           = row.IsNull("unittext") ? string.Empty : row.Field <string>("unittext");
            entity.ctext              = row.IsNull("ctext") ? string.Empty : row.Field <string>("ctext");
            entity.btnusagehidden     = row.Field <bool>("btnusagehidden");
            entity.arptype            = row.IsNull("arptype") ? string.Empty : row.Field <string>("arptype");
            entity.arpvendno          = row.IsNull("arpvendno") ? decimal.Zero : row.Field <decimal>("arpvendno");
            entity.arpvendname        = row.IsNull("arpvendname") ? string.Empty : row.Field <string>("arpvendname");
            entity.btnalthidden       = row.Field <bool>("btnalthidden");
            entity.lblvendno          = row.IsNull("lblvendno") ? string.Empty : row.Field <string>("lblvendno");
            entity.prodline           = row.IsNull("prodline") ? string.Empty : row.Field <string>("prodline");
            entity.prodlinename       = row.IsNull("prodlinename") ? string.Empty : row.Field <string>("prodlinename");
            entity.btnroaihidden      = row.Field <bool>("btnroaihidden");
            entity.arpwhse            = row.IsNull("arpwhse") ? string.Empty : row.Field <string>("arpwhse");
            entity.arpwhsename        = row.IsNull("arpwhsename") ? string.Empty : row.Field <string>("arpwhsename");
            entity.btnadjusterhidden  = row.Field <bool>("btnadjusterhidden");
            entity.familygroup        = row.IsNull("familygroup") ? string.Empty : row.Field <string>("familygroup");
            entity.btnrolluphidden    = row.Field <bool>("btnrolluphidden");
            entity.usagerate          = row.IsNull("usagerate") ? decimal.Zero : row.Field <decimal>("usagerate");
            entity.usagetext          = row.IsNull("usagetext") ? string.Empty : row.Field <string>("usagetext");
            entity.btntrendinfohidden = row.Field <bool>("btntrendinfohidden");
            entity.leadtmavg          = row.IsNull("leadtmavg") ? 0 : row.Field <int>("leadtmavg");
            entity.avgltdt            = row.Field <DateTime?>("avgltdt");
            entity.frozenltty         = row.IsNull("frozenltty") ? string.Empty : row.Field <string>("frozenltty");
            entity.criticalpt         = row.IsNull("criticalpt") ? decimal.Zero : row.Field <decimal>("criticalpt");
            entity.oordpt             = row.IsNull("oordpt") ? decimal.Zero : row.Field <decimal>("oordpt");
            entity.orderpt            = row.IsNull("orderpt") ? decimal.Zero : row.Field <decimal>("orderpt");
            entity.olinept            = row.IsNull("olinept") ? decimal.Zero : row.Field <decimal>("olinept");
            entity.linept             = row.IsNull("linept") ? decimal.Zero : row.Field <decimal>("linept");
            entity.ordqtyin           = row.IsNull("ordqtyin") ? decimal.Zero : row.Field <decimal>("ordqtyin");
            entity.ordcalc            = row.IsNull("ordcalc") ? string.Empty : row.Field <string>("ordcalc");
            entity.@class             = row.IsNull("class") ? 0 : row.Field <int>("class");
            entity.criticalfl         = row.IsNull("criticalfl") ? string.Empty : row.Field <string>("criticalfl");
            entity.safetyallow        = row.IsNull("safetyallow") ? string.Empty : row.Field <string>("safetyallow");
            entity.unit             = row.IsNull("unit") ? string.Empty : row.Field <string>("unit");
            entity.criticalflhidden = row.Field <bool>("criticalflhidden");
            entity.frozenlttyhidden = row.Field <bool>("frozenlttyhidden");
            entity.ncnr             = row.IsNull("ncnr") ? string.Empty : row.Field <string>("ncnr");
            entity.eccnclasscd      = row.IsNull("eccnclasscd") ? string.Empty : row.Field <string>("eccnclasscd");
            entity.totusagerate     = row.IsNull("totusagerate") ? decimal.Zero : row.Field <decimal>("totusagerate");
            entity.userfield        = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield");
            return(entity);
        }
Exemplo n.º 2
0
 /// <summary>
 /// Update a database row from a class
 /// </summary>
 public static void UpdateRowFromIcipfetchreplresults(ref DataRow row, Icipfetchreplresults entity)
 {
     row.SetField("unittext", entity.unittext);
     row.SetField("ctext", entity.ctext);
     row.SetField("btnusagehidden", entity.btnusagehidden);
     row.SetField("arptype", entity.arptype);
     row.SetField("arpvendno", entity.arpvendno);
     row.SetField("arpvendname", entity.arpvendname);
     row.SetField("btnalthidden", entity.btnalthidden);
     row.SetField("lblvendno", entity.lblvendno);
     row.SetField("prodline", entity.prodline);
     row.SetField("prodlinename", entity.prodlinename);
     row.SetField("btnroaihidden", entity.btnroaihidden);
     row.SetField("arpwhse", entity.arpwhse);
     row.SetField("arpwhsename", entity.arpwhsename);
     row.SetField("btnadjusterhidden", entity.btnadjusterhidden);
     row.SetField("familygroup", entity.familygroup);
     row.SetField("btnrolluphidden", entity.btnrolluphidden);
     row.SetField("usagerate", entity.usagerate);
     row.SetField("usagetext", entity.usagetext);
     row.SetField("btntrendinfohidden", entity.btntrendinfohidden);
     row.SetField("leadtmavg", entity.leadtmavg);
     row.SetField("avgltdt", entity.avgltdt);
     row.SetField("frozenltty", entity.frozenltty);
     row.SetField("criticalpt", entity.criticalpt);
     row.SetField("oordpt", entity.oordpt);
     row.SetField("orderpt", entity.orderpt);
     row.SetField("olinept", entity.olinept);
     row.SetField("linept", entity.linept);
     row.SetField("ordqtyin", entity.ordqtyin);
     row.SetField("ordcalc", entity.ordcalc);
     row.SetField("class", entity.@class);
     row.SetField("criticalfl", entity.criticalfl);
     row.SetField("safetyallow", entity.safetyallow);
     row.SetField("unit", entity.unit);
     row.SetField("criticalflhidden", entity.criticalflhidden);
     row.SetField("frozenlttyhidden", entity.frozenlttyhidden);
     row.SetField("ncnr", entity.ncnr);
     row.SetField("eccnclasscd", entity.eccnclasscd);
     row.SetField("totusagerate", entity.totusagerate);
     row.SetField("userfield", entity.userfield);
 }