Beispiel #1
0
 /// <summary>
 /// Update a database row from a class
 /// </summary>
 public static void UpdateRowFromOelineoptprodresults(ref DataRow row, Oelineoptprodresults entity)
 {
     row.SetField("seqno", entity.seqno);
     row.SetField("prod", entity.prod);
     row.SetField("notesfl", entity.notesfl);
     row.SetField("proddesc", entity.proddesc);
     row.SetField("proddesc2", entity.proddesc2);
     row.SetField("qtyship", entity.qtyship);
     row.SetField("unit", entity.unit);
     row.SetField("chrg", entity.chrg);
     row.SetField("qtyavail", entity.qtyavail);
     row.SetField("qtyavaild", entity.qtyavaild);
     row.SetField("conv", entity.conv);
     row.SetField("price", entity.price);
     row.SetField("priceoverfl", entity.priceoverfl);
     row.SetField("discoverfl", entity.discoverfl);
     row.SetField("discamt", entity.discamt);
     row.SetField("disctype", entity.disctype);
     row.SetField("addswoptprodfl", entity.addswoptprodfl);
     row.SetField("prodcat", entity.prodcat);
     row.SetField("dsplchrg", entity.dsplchrg);
     row.SetField("dsplchrgenabled", entity.dsplchrgenabled);
     row.SetField("optrowid", entity.optrowid.ToByteArray());
     row.SetField("addswoptprodaskedfl", entity.addswoptprodaskedfl);
     row.SetField("userfield", entity.userfield);
 }
Beispiel #2
0
        public static Oelineoptprodresults BuildOelineoptprodresultsFromRow(DataRow row)
        {
            Oelineoptprodresults entity = new Oelineoptprodresults();

            entity.seqno               = row.IsNull("seqno") ? decimal.Zero : row.Field <decimal>("seqno");
            entity.prod                = row.IsNull("prod") ? string.Empty : row.Field <string>("prod");
            entity.notesfl             = row.IsNull("notesfl") ? string.Empty : row.Field <string>("notesfl");
            entity.proddesc            = row.IsNull("proddesc") ? string.Empty : row.Field <string>("proddesc");
            entity.proddesc2           = row.IsNull("proddesc2") ? string.Empty : row.Field <string>("proddesc2");
            entity.qtyship             = row.IsNull("qtyship") ? decimal.Zero : row.Field <decimal>("qtyship");
            entity.unit                = row.IsNull("unit") ? string.Empty : row.Field <string>("unit");
            entity.chrg                = row.IsNull("chrg") ? string.Empty : row.Field <string>("chrg");
            entity.qtyavail            = row.IsNull("qtyavail") ? decimal.Zero : row.Field <decimal>("qtyavail");
            entity.qtyavaild           = row.IsNull("qtyavaild") ? decimal.Zero : row.Field <decimal>("qtyavaild");
            entity.conv                = row.IsNull("conv") ? decimal.Zero : row.Field <decimal>("conv");
            entity.price               = row.IsNull("price") ? decimal.Zero : row.Field <decimal>("price");
            entity.priceoverfl         = row.Field <bool>("priceoverfl");
            entity.discoverfl          = row.Field <bool>("discoverfl");
            entity.discamt             = row.IsNull("discamt") ? decimal.Zero : row.Field <decimal>("discamt");
            entity.disctype            = row.Field <bool>("disctype");
            entity.addswoptprodfl      = row.Field <bool>("addswoptprodfl");
            entity.prodcat             = row.IsNull("prodcat") ? string.Empty : row.Field <string>("prodcat");
            entity.dsplchrg            = row.Field <bool>("dsplchrg");
            entity.dsplchrgenabled     = row.Field <bool>("dsplchrgenabled");
            entity.optrowid            = row.Field <byte[]>("optrowid").ToStringEncoded();
            entity.addswoptprodaskedfl = row.Field <bool>("addswoptprodaskedfl");
            entity.userfield           = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield");
            return(entity);
        }