Example #1
0
 /// <summary>
 /// Update a database row from a class
 /// </summary>
 public static void UpdateRowFromPackinglistporesults(ref DataRow row, Packinglistporesults entity)
 {
     row.SetField("co_num", entity.coNum);
     row.SetField("wh_num", entity.whNum);
     row.SetField("rt_num", entity.rtNum);
     row.SetField("rt_id", entity.rtId);
     row.SetField("row_status", entity.rowStatus);
     row.SetField("po_number", entity.poNumber);
     row.SetField("po_suffix", entity.poSuffix);
     row.SetField("vendor_id", entity.vendorId);
     row.SetField("delivery", entity.delivery);
     row.SetField("act_lines", entity.actLines);
     row.SetField("act_quantity", entity.actQuantity);
     row.SetField("exp_lines", entity.expLines);
     row.SetField("exp_quantity", entity.expQuantity);
     row.SetField("rtdetRowid", entity.rtdetRowid.ToByteArray());
     row.SetField("packinglistporesultsuserfield", entity.packinglistporesultsuserfield);
     row.SetField("userfield", entity.userfield);
 }
Example #2
0
        public static Packinglistporesults BuildPackinglistporesultsFromRow(DataRow row)
        {
            Packinglistporesults entity = new Packinglistporesults();

            entity.coNum       = row.IsNull("co_num") ? string.Empty : row.Field <string>("co_num");
            entity.whNum       = row.IsNull("wh_num") ? string.Empty : row.Field <string>("wh_num");
            entity.rtNum       = row.IsNull("rt_num") ? string.Empty : row.Field <string>("rt_num");
            entity.rtId        = row.IsNull("rt_id") ? 0 : row.Field <int>("rt_id");
            entity.rowStatus   = row.IsNull("row_status") ? string.Empty : row.Field <string>("row_status");
            entity.poNumber    = row.IsNull("po_number") ? string.Empty : row.Field <string>("po_number");
            entity.poSuffix    = row.IsNull("po_suffix") ? string.Empty : row.Field <string>("po_suffix");
            entity.vendorId    = row.IsNull("vendor_id") ? string.Empty : row.Field <string>("vendor_id");
            entity.delivery    = row.Field <DateTime?>("delivery");
            entity.actLines    = row.IsNull("act_lines") ? decimal.Zero : row.Field <decimal>("act_lines");
            entity.actQuantity = row.IsNull("act_quantity") ? decimal.Zero : row.Field <decimal>("act_quantity");
            entity.expLines    = row.IsNull("exp_lines") ? decimal.Zero : row.Field <decimal>("exp_lines");
            entity.expQuantity = row.IsNull("exp_quantity") ? decimal.Zero : row.Field <decimal>("exp_quantity");
            entity.rtdetRowid  = row.Field <byte[]>("rtdetRowid").ToStringEncoded();
            entity.packinglistporesultsuserfield = row.IsNull("packinglistporesultsuserfield") ? string.Empty : row.Field <string>("packinglistporesultsuserfield");
            entity.userfield = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield");
            return(entity);
        }