Example #1
0
        public static Varollcstprccriteria BuildVarollcstprccriteriaFromRow(DataRow row)
        {
            Varollcstprccriteria entity = new Varollcstprccriteria();

            entity.ourproc        = row.IsNull("ourproc") ? string.Empty : row.Field <string>("ourproc");
            entity.orderno        = row.IsNull("orderno") ? 0 : row.Field <int>("orderno");
            entity.ordersuf       = row.IsNull("ordersuf") ? 0 : row.Field <int>("ordersuf");
            entity.lineno         = row.IsNull("lineno") ? 0 : row.Field <int>("lineno");
            entity.prod           = row.IsNull("prod") ? string.Empty : row.Field <string>("prod");
            entity.whse           = row.IsNull("whse") ? string.Empty : row.Field <string>("whse");
            entity.qty            = row.IsNull("qty") ? decimal.Zero : row.Field <decimal>("qty");
            entity.unit           = row.IsNull("unit") ? string.Empty : row.Field <string>("unit");
            entity.custno         = row.IsNull("custno") ? decimal.Zero : row.Field <decimal>("custno");
            entity.shipto         = row.IsNull("shipto") ? string.Empty : row.Field <string>("shipto");
            entity.varollfl       = row.Field <bool>("varollfl");
            entity.vamarkupfl     = row.Field <bool>("vamarkupfl");
            entity.vaintmarkup    = row.IsNull("vaintmarkup") ? decimal.Zero : row.Field <decimal>("vaintmarkup");
            entity.vaextmarkup    = row.IsNull("vaextmarkup") ? decimal.Zero : row.Field <decimal>("vaextmarkup");
            entity.vanonstkmarkup = row.IsNull("vanonstkmarkup") ? decimal.Zero : row.Field <decimal>("vanonstkmarkup");
            entity.vacalcdfltty   = row.IsNull("vacalcdfltty") ? string.Empty : row.Field <string>("vacalcdfltty");
            entity.vainvmarkupfl  = row.Field <bool>("vainvmarkupfl");
            entity.vainvmarkup    = row.IsNull("vainvmarkup") ? decimal.Zero : row.Field <decimal>("vainvmarkup");
            entity.userfield      = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield");
            return(entity);
        }
Example #2
0
 /// <summary>
 /// Update a database row from a class
 /// </summary>
 public static void UpdateRowFromVarollcstprccriteria(ref DataRow row, Varollcstprccriteria entity)
 {
     row.SetField("ourproc", entity.ourproc);
     row.SetField("orderno", entity.orderno);
     row.SetField("ordersuf", entity.ordersuf);
     row.SetField("lineno", entity.lineno);
     row.SetField("prod", entity.prod);
     row.SetField("whse", entity.whse);
     row.SetField("qty", entity.qty);
     row.SetField("unit", entity.unit);
     row.SetField("custno", entity.custno);
     row.SetField("shipto", entity.shipto);
     row.SetField("varollfl", entity.varollfl);
     row.SetField("vamarkupfl", entity.vamarkupfl);
     row.SetField("vaintmarkup", entity.vaintmarkup);
     row.SetField("vaextmarkup", entity.vaextmarkup);
     row.SetField("vanonstkmarkup", entity.vanonstkmarkup);
     row.SetField("vacalcdfltty", entity.vacalcdfltty);
     row.SetField("vainvmarkupfl", entity.vainvmarkupfl);
     row.SetField("vainvmarkup", entity.vainvmarkup);
     row.SetField("userfield", entity.userfield);
 }