Exemple #1
0
 /// <summary>
 /// Update a database row from a class
 /// </summary>
 public static void UpdateRowFromLoadwtlinedetailresults(ref DataRow row, Loadwtlinedetailresults entity)
 {
     row.SetField("lineno", entity.lineno);
     row.SetField("commentfl", entity.commentfl);
     row.SetField("nonstockty", entity.nonstockty);
     row.SetField("shipprod", entity.shipprod);
     row.SetField("notesfl", entity.notesfl);
     row.SetField("unit", entity.unit);
     row.SetField("qtyord", entity.qtyord);
     row.SetField("qtyship", entity.qtyship);
     row.SetField("prodcost", entity.prodcost);
     row.SetField("netamt", entity.netamt);
     row.SetField("cancelfl", entity.cancelfl);
     row.SetField("orderaltno", entity.orderaltno);
     row.SetField("sourcingtype", entity.sourcingtype);
     row.SetField("proddesc", entity.proddesc);
     row.SetField("qtyrcv", entity.qtyrcv);
     row.SetField("approval", entity.approval);
     row.SetField("custstkqtyshp", entity.custstkqtyshp);
     row.SetField("custprodcost", entity.custprodcost);
     row.SetField("brandcode", entity.brandcode);
     row.SetField("mfgprod", entity.mfgprod);
     row.SetField("vendprod", entity.vendprod);
     row.SetField("msdsfl", entity.msdsfl);
     row.SetField("addonamt", entity.addonamt);
     row.SetField("addonmarkupcost", entity.addonmarkupcost);
     row.SetField("addonmarkuptype", entity.addonmarkuptype);
     row.SetField("addonpct", entity.addonpct);
     row.SetField("addontype", entity.addontype);
     row.SetField("userfield", entity.userfield);
 }
Exemple #2
0
        public static Loadwtlinedetailresults BuildLoadwtlinedetailresultsFromRow(DataRow row)
        {
            Loadwtlinedetailresults entity = new Loadwtlinedetailresults();

            entity.lineno          = row.IsNull("lineno") ? 0 : row.Field <int>("lineno");
            entity.commentfl       = row.Field <bool>("commentfl");
            entity.nonstockty      = row.IsNull("nonstockty") ? string.Empty : row.Field <string>("nonstockty");
            entity.shipprod        = row.IsNull("shipprod") ? string.Empty : row.Field <string>("shipprod");
            entity.notesfl         = row.IsNull("notesfl") ? string.Empty : row.Field <string>("notesfl");
            entity.unit            = row.IsNull("unit") ? string.Empty : row.Field <string>("unit");
            entity.qtyord          = row.IsNull("qtyord") ? decimal.Zero : row.Field <decimal>("qtyord");
            entity.qtyship         = row.IsNull("qtyship") ? decimal.Zero : row.Field <decimal>("qtyship");
            entity.prodcost        = row.IsNull("prodcost") ? decimal.Zero : row.Field <decimal>("prodcost");
            entity.netamt          = row.IsNull("netamt") ? decimal.Zero : row.Field <decimal>("netamt");
            entity.cancelfl        = row.Field <bool>("cancelfl");
            entity.orderaltno      = row.IsNull("orderaltno") ? 0 : row.Field <int>("orderaltno");
            entity.sourcingtype    = row.IsNull("sourcingtype") ? string.Empty : row.Field <string>("sourcingtype");
            entity.proddesc        = row.IsNull("proddesc") ? string.Empty : row.Field <string>("proddesc");
            entity.qtyrcv          = row.IsNull("qtyrcv") ? decimal.Zero : row.Field <decimal>("qtyrcv");
            entity.approval        = row.IsNull("approval") ? string.Empty : row.Field <string>("approval");
            entity.custstkqtyshp   = row.IsNull("custstkqtyshp") ? decimal.Zero : row.Field <decimal>("custstkqtyshp");
            entity.custprodcost    = row.IsNull("custprodcost") ? decimal.Zero : row.Field <decimal>("custprodcost");
            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.addonamt        = row.IsNull("addonamt") ? decimal.Zero : row.Field <decimal>("addonamt");
            entity.addonmarkupcost = row.IsNull("addonmarkupcost") ? decimal.Zero : row.Field <decimal>("addonmarkupcost");
            entity.addonmarkuptype = row.IsNull("addonmarkuptype") ? string.Empty : row.Field <string>("addonmarkuptype");
            entity.addonpct        = row.IsNull("addonpct") ? decimal.Zero : row.Field <decimal>("addonpct");
            entity.addontype       = row.IsNull("addontype") ? string.Empty : row.Field <string>("addontype");
            entity.userfield       = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield");
            return(entity);
        }