Ejemplo n.º 1
0
 /// <summary>
 /// Update a database row from a class
 /// </summary>
 public static void UpdateRowFromLoadwtquickviewresults(ref DataRow row, Loadwtquickviewresults entity)
 {
     row.SetField("lineno", entity.lineno);
     row.SetField("nonstockty", entity.nonstockty);
     row.SetField("prodinrcvfl", entity.prodinrcvfl);
     row.SetField("shipprod", entity.shipprod);
     row.SetField("cproddesc", entity.cproddesc);
     row.SetField("qtyord", entity.qtyord);
     row.SetField("unit", entity.unit);
     row.SetField("capprovety", entity.capprovety);
     row.SetField("dprodcost", entity.dprodcost);
     row.SetField("dnetamt", entity.dnetamt);
     row.SetField("cordertype", entity.cordertype);
     row.SetField("orderaltno", entity.orderaltno);
     row.SetField("cstatusinfo", entity.cstatusinfo);
     row.SetField("isLowStock", entity.isLowStock);
     row.SetField("userField", entity.userField);
 }
Ejemplo n.º 2
0
        public static Loadwtquickviewresults BuildLoadwtquickviewresultsFromRow(DataRow row)
        {
            Loadwtquickviewresults entity = new Loadwtquickviewresults();

            entity.lineno      = row.IsNull("lineno") ? 0 : row.Field <int>("lineno");
            entity.nonstockty  = row.IsNull("nonstockty") ? string.Empty : row.Field <string>("nonstockty");
            entity.prodinrcvfl = row.Field <bool>("prodinrcvfl");
            entity.shipprod    = row.IsNull("shipprod") ? string.Empty : row.Field <string>("shipprod");
            entity.cproddesc   = row.IsNull("cproddesc") ? string.Empty : row.Field <string>("cproddesc");
            entity.qtyord      = row.IsNull("qtyord") ? decimal.Zero : row.Field <decimal>("qtyord");
            entity.unit        = row.IsNull("unit") ? string.Empty : row.Field <string>("unit");
            entity.capprovety  = row.IsNull("capprovety") ? string.Empty : row.Field <string>("capprovety");
            entity.dprodcost   = row.IsNull("dprodcost") ? decimal.Zero : row.Field <decimal>("dprodcost");
            entity.dnetamt     = row.IsNull("dnetamt") ? decimal.Zero : row.Field <decimal>("dnetamt");
            entity.cordertype  = row.IsNull("cordertype") ? string.Empty : row.Field <string>("cordertype");
            entity.orderaltno  = row.IsNull("orderaltno") ? 0 : row.Field <int>("orderaltno");
            entity.cstatusinfo = row.IsNull("cstatusinfo") ? string.Empty : row.Field <string>("cstatusinfo");
            entity.isLowStock  = row.Field <bool>("isLowStock");
            entity.userField   = row.IsNull("userField") ? string.Empty : row.Field <string>("userField");
            return(entity);
        }