예제 #1
0
 /// <summary>
 /// Update a database row from a class
 /// </summary>
 public static void UpdateRowFromPolinelistresults(ref DataRow row, Polinelistresults entity)
 {
     row.SetField("pono", entity.pono);
     row.SetField("posuf", entity.posuf);
     row.SetField("commentfl", entity.commentfl);
     row.SetField("lineno", entity.lineno);
     row.SetField("nonstockty", entity.nonstockty);
     row.SetField("nonstocktytxt", entity.nonstocktytxt);
     row.SetField("shipprod", entity.shipprod);
     row.SetField("unit", entity.unit);
     row.SetField("cdescription", entity.cdescription);
     row.SetField("enterdt", entity.enterdt);
     row.SetField("cnotesfl", entity.cnotesfl);
     row.SetField("duedt", entity.duedt);
     row.SetField("ignoreltfl", entity.ignoreltfl);
     row.SetField("dqtyord", entity.dqtyord);
     row.SetField("dstkqtyord", entity.dstkqtyord);
     row.SetField("dprice", entity.dprice);
     row.SetField("dnetamt", entity.dnetamt);
     row.SetField("pdsvcrecno", entity.pdsvcrecno);
     row.SetField("cvendquote", entity.cvendquote);
     row.SetField("tiesexistfl", entity.tiesexistfl);
     row.SetField("statustype", entity.statustype);
     row.SetField("impliedcorefl", entity.impliedcorefl);
     row.SetField("ncnr", entity.ncnr);
     row.SetField("dutyrate", entity.dutyrate);
     row.SetField("tariffcd", entity.tariffcd);
     row.SetField("countryoforigin", entity.countryoforigin);
     row.SetField("brandcode", entity.brandcode);
     row.SetField("mfgprod", entity.mfgprod);
     row.SetField("vendprod", entity.vendprod);
     row.SetField("msdsfl", entity.msdsfl);
     row.SetField("upcid", entity.upcid);
     row.SetField("userfield", entity.userfield);
 }
예제 #2
0
        public static Polinelistresults BuildPolinelistresultsFromRow(DataRow row)
        {
            Polinelistresults entity = new Polinelistresults();

            entity.pono            = row.IsNull("pono") ? 0 : row.Field <int>("pono");
            entity.posuf           = row.IsNull("posuf") ? 0 : row.Field <int>("posuf");
            entity.commentfl       = row.Field <bool>("commentfl");
            entity.lineno          = row.IsNull("lineno") ? 0 : row.Field <int>("lineno");
            entity.nonstockty      = row.IsNull("nonstockty") ? string.Empty : row.Field <string>("nonstockty");
            entity.nonstocktytxt   = row.IsNull("nonstocktytxt") ? string.Empty : row.Field <string>("nonstocktytxt");
            entity.shipprod        = row.IsNull("shipprod") ? string.Empty : row.Field <string>("shipprod");
            entity.unit            = row.IsNull("unit") ? string.Empty : row.Field <string>("unit");
            entity.cdescription    = row.IsNull("cdescription") ? string.Empty : row.Field <string>("cdescription");
            entity.enterdt         = row.Field <DateTime?>("enterdt");
            entity.cnotesfl        = row.IsNull("cnotesfl") ? string.Empty : row.Field <string>("cnotesfl");
            entity.duedt           = row.Field <DateTime?>("duedt");
            entity.ignoreltfl      = row.Field <bool>("ignoreltfl");
            entity.dqtyord         = row.IsNull("dqtyord") ? decimal.Zero : row.Field <decimal>("dqtyord");
            entity.dstkqtyord      = row.IsNull("dstkqtyord") ? decimal.Zero : row.Field <decimal>("dstkqtyord");
            entity.dprice          = row.IsNull("dprice") ? decimal.Zero : row.Field <decimal>("dprice");
            entity.dnetamt         = row.IsNull("dnetamt") ? decimal.Zero : row.Field <decimal>("dnetamt");
            entity.pdsvcrecno      = row.IsNull("pdsvcrecno") ? 0 : row.Field <int>("pdsvcrecno");
            entity.cvendquote      = row.IsNull("cvendquote") ? string.Empty : row.Field <string>("cvendquote");
            entity.tiesexistfl     = row.Field <bool>("tiesexistfl");
            entity.statustype      = row.IsNull("statustype") ? string.Empty : row.Field <string>("statustype");
            entity.impliedcorefl   = row.Field <bool>("impliedcorefl");
            entity.ncnr            = row.IsNull("ncnr") ? string.Empty : row.Field <string>("ncnr");
            entity.dutyrate        = row.IsNull("dutyrate") ? decimal.Zero : row.Field <decimal>("dutyrate");
            entity.tariffcd        = row.IsNull("tariffcd") ? string.Empty : row.Field <string>("tariffcd");
            entity.countryoforigin = row.IsNull("countryoforigin") ? string.Empty : row.Field <string>("countryoforigin");
            entity.brandcode       = row.IsNull("brandcode") ? string.Empty : row.Field <string>("brandcode");
            entity.mfgprod         = row.IsNull("mfgprod") ? string.Empty : row.Field <string>("mfgprod");
            entity.vendprod        = row.IsNull("vendprod") ? string.Empty : row.Field <string>("vendprod");
            entity.msdsfl          = row.Field <bool>("msdsfl");
            entity.upcid           = row.IsNull("upcid") ? string.Empty : row.Field <string>("upcid");
            entity.userfield       = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield");
            return(entity);
        }