Пример #1
0
        public static Sleechgstatuscode BuildSleechgstatuscodeFromRow(DataRow row)
        {
            Sleechgstatuscode entity = new Sleechgstatuscode();

            entity.imptype       = row.IsNull("imptype") ? string.Empty : row.Field <string>("imptype");
            entity.slupdtno      = row.IsNull("slupdtno") ? string.Empty : row.Field <string>("slupdtno");
            entity.statuscdnew   = row.IsNull("statuscdnew") ? string.Empty : row.Field <string>("statuscdnew");
            entity.statuscdorig1 = row.IsNull("statuscdorig1") ? string.Empty : row.Field <string>("statuscdorig1");
            entity.statuscdorig2 = row.IsNull("statuscdorig2") ? string.Empty : row.Field <string>("statuscdorig2");
            entity.statuscdorig3 = row.IsNull("statuscdorig3") ? string.Empty : row.Field <string>("statuscdorig3");
            entity.statuscdorig4 = row.IsNull("statuscdorig4") ? string.Empty : row.Field <string>("statuscdorig4");
            entity.statuscdorig5 = row.IsNull("statuscdorig5") ? string.Empty : row.Field <string>("statuscdorig5");
            entity.whse          = row.IsNull("whse") ? string.Empty : row.Field <string>("whse");
            entity.prodfrom      = row.IsNull("prodfrom") ? string.Empty : row.Field <string>("prodfrom");
            entity.prodto        = row.IsNull("prodto") ? string.Empty : row.Field <string>("prodto");
            entity.slgroupfrom   = row.IsNull("slgroupfrom") ? string.Empty : row.Field <string>("slgroupfrom");
            entity.slgroupto     = row.IsNull("slgroupto") ? string.Empty : row.Field <string>("slgroupto");
            entity.prodlinefrom  = row.IsNull("prodlinefrom") ? string.Empty : row.Field <string>("prodlinefrom");
            entity.prodlineto    = row.IsNull("prodlineto") ? string.Empty : row.Field <string>("prodlineto");
            entity.prodcatfrom   = row.IsNull("prodcatfrom") ? string.Empty : row.Field <string>("prodcatfrom");
            entity.prodcatto     = row.IsNull("prodcatto") ? string.Empty : row.Field <string>("prodcatto");
            entity.pricetypefrom = row.IsNull("pricetypefrom") ? string.Empty : row.Field <string>("pricetypefrom");
            entity.pricetypeto   = row.IsNull("pricetypeto") ? string.Empty : row.Field <string>("pricetypeto");
            entity.userfield     = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield");
            return(entity);
        }
Пример #2
0
 /// <summary>
 /// Update a database row from a class
 /// </summary>
 public static void UpdateRowFromSleechgstatuscode(ref DataRow row, Sleechgstatuscode entity)
 {
     row.SetField("imptype", entity.imptype);
     row.SetField("slupdtno", entity.slupdtno);
     row.SetField("statuscdnew", entity.statuscdnew);
     row.SetField("statuscdorig1", entity.statuscdorig1);
     row.SetField("statuscdorig2", entity.statuscdorig2);
     row.SetField("statuscdorig3", entity.statuscdorig3);
     row.SetField("statuscdorig4", entity.statuscdorig4);
     row.SetField("statuscdorig5", entity.statuscdorig5);
     row.SetField("whse", entity.whse);
     row.SetField("prodfrom", entity.prodfrom);
     row.SetField("prodto", entity.prodto);
     row.SetField("slgroupfrom", entity.slgroupfrom);
     row.SetField("slgroupto", entity.slgroupto);
     row.SetField("prodlinefrom", entity.prodlinefrom);
     row.SetField("prodlineto", entity.prodlineto);
     row.SetField("prodcatfrom", entity.prodcatfrom);
     row.SetField("prodcatto", entity.prodcatto);
     row.SetField("pricetypefrom", entity.pricetypefrom);
     row.SetField("pricetypeto", entity.pricetypeto);
     row.SetField("userfield", entity.userfield);
 }