Пример #1
0
 /// <summary>
 /// Update a database row from a class
 /// </summary>
 public static void UpdateRowFromManifestcriteria(ref DataRow row, Manifestcriteria entity)
 {
     row.SetField("co_num", entity.coNum);
     row.SetField("wh_num", entity.whNum);
     row.SetField("carrier_id", entity.carrierId);
     row.SetField("manifest_id", entity.manifestId);
     row.SetField("dock_id", entity.dockId);
     row.SetField("trailer_num", entity.trailerNum);
     row.SetField("from_date_time", entity.fromDateTime);
     row.SetField("to_date_time", entity.toDateTime);
     row.SetField("manifestRowID", entity.manifestRowID.ToByteArray());
     row.SetField("recordlimit", entity.recordlimit);
     row.SetField("manifestcriteriauserfield", entity.manifestcriteriauserfield);
     row.SetField("userfield", entity.userfield);
 }
Пример #2
0
        public static Manifestcriteria BuildManifestcriteriaFromRow(DataRow row)
        {
            Manifestcriteria entity = new Manifestcriteria();

            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.carrierId                 = row.IsNull("carrier_id") ? string.Empty : row.Field <string>("carrier_id");
            entity.manifestId                = row.IsNull("manifest_id") ? 0 : row.Field <int>("manifest_id");
            entity.dockId                    = row.IsNull("dock_id") ? string.Empty : row.Field <string>("dock_id");
            entity.trailerNum                = row.IsNull("trailer_num") ? string.Empty : row.Field <string>("trailer_num");
            entity.fromDateTime              = row.IsNull("from_date_time") ? string.Empty : row.Field <string>("from_date_time");
            entity.toDateTime                = row.IsNull("to_date_time") ? string.Empty : row.Field <string>("to_date_time");
            entity.manifestRowID             = row.Field <byte[]>("manifestRowID").ToStringEncoded();
            entity.recordlimit               = row.IsNull("recordlimit") ? 0 : row.Field <int>("recordlimit");
            entity.manifestcriteriauserfield = row.IsNull("manifestcriteriauserfield") ? string.Empty : row.Field <string>("manifestcriteriauserfield");
            entity.userfield                 = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield");
            return(entity);
        }