Ejemplo n.º 1
0
 /// <summary>
 /// Update a database row from a class
 /// </summary>
 public static void UpdateRowFromValmultiloccreatecriteria(ref DataRow row, Valmultiloccreatecriteria entity)
 {
     row.SetField("co_num", entity.coNum);
     row.SetField("wh_num", entity.whNum);
     row.SetField("whZone", entity.whZone);
     row.SetField("aisle", entity.aisle);
     row.SetField("prefix", entity.prefix);
     row.SetField("positionType", entity.positionType);
     row.SetField("positionFrom", entity.positionFrom);
     row.SetField("positionTo", entity.positionTo);
     row.SetField("positionLength", entity.positionLength);
     row.SetField("positionRangeType", entity.positionRangeType);
     row.SetField("levelType", entity.levelType);
     row.SetField("levelFrom", entity.levelFrom);
     row.SetField("levelTo", entity.levelTo);
     row.SetField("levelLength", entity.levelLength);
     row.SetField("locType", entity.locType);
     row.SetField("abc", entity.abc);
     row.SetField("height", entity.height);
     row.SetField("width", entity.width);
     row.SetField("depth", entity.depth);
     row.SetField("cube", entity.cube);
     row.SetField("maxWeight", entity.maxWeight);
     row.SetField("palletFootprint", entity.palletFootprint);
     row.SetField("stackHeight", entity.stackHeight);
     row.SetField("pickSequence", entity.pickSequence);
     row.SetField("putawayGroup", entity.putawayGroup);
     row.SetField("userfield", entity.userfield);
 }
Ejemplo n.º 2
0
        public static Valmultiloccreatecriteria BuildValmultiloccreatecriteriaFromRow(DataRow row)
        {
            Valmultiloccreatecriteria entity = new Valmultiloccreatecriteria();

            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.whZone            = row.IsNull("whZone") ? string.Empty : row.Field <string>("whZone");
            entity.aisle             = row.IsNull("aisle") ? 0 : row.Field <int>("aisle");
            entity.prefix            = row.IsNull("prefix") ? string.Empty : row.Field <string>("prefix");
            entity.positionType      = row.IsNull("positionType") ? 0 : row.Field <int>("positionType");
            entity.positionFrom      = row.IsNull("positionFrom") ? string.Empty : row.Field <string>("positionFrom");
            entity.positionTo        = row.IsNull("positionTo") ? string.Empty : row.Field <string>("positionTo");
            entity.positionLength    = row.IsNull("positionLength") ? 0 : row.Field <int>("positionLength");
            entity.positionRangeType = row.IsNull("positionRangeType") ? string.Empty : row.Field <string>("positionRangeType");
            entity.levelType         = row.IsNull("levelType") ? 0 : row.Field <int>("levelType");
            entity.levelFrom         = row.IsNull("levelFrom") ? string.Empty : row.Field <string>("levelFrom");
            entity.levelTo           = row.IsNull("levelTo") ? string.Empty : row.Field <string>("levelTo");
            entity.levelLength       = row.IsNull("levelLength") ? 0 : row.Field <int>("levelLength");
            entity.locType           = row.IsNull("locType") ? string.Empty : row.Field <string>("locType");
            entity.abc             = row.IsNull("abc") ? string.Empty : row.Field <string>("abc");
            entity.height          = row.IsNull("height") ? 0 : row.Field <int>("height");
            entity.width           = row.IsNull("width") ? 0 : row.Field <int>("width");
            entity.depth           = row.IsNull("depth") ? 0 : row.Field <int>("depth");
            entity.cube            = row.IsNull("cube") ? decimal.Zero : row.Field <decimal>("cube");
            entity.maxWeight       = row.IsNull("maxWeight") ? 0 : row.Field <int>("maxWeight");
            entity.palletFootprint = row.IsNull("palletFootprint") ? 0 : row.Field <int>("palletFootprint");
            entity.stackHeight     = row.IsNull("stackHeight") ? 0 : row.Field <int>("stackHeight");
            entity.pickSequence    = row.IsNull("pickSequence") ? 0 : row.Field <int>("pickSequence");
            entity.putawayGroup    = row.IsNull("putawayGroup") ? string.Empty : row.Field <string>("putawayGroup");
            entity.userfield       = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield");
            return(entity);
        }