예제 #1
0
 /// <summary>
 /// Update a database row from a class
 /// </summary>
 public static void UpdateRowFromPdsclookupcriteria(ref DataRow row, Pdsclookupcriteria entity)
 {
     row.SetField("levelcd", entity.levelcd);
     row.SetField("custno", entity.custno);
     row.SetField("shipto", entity.shipto);
     row.SetField("prod", entity.prod);
     row.SetField("whse", entity.whse);
     row.SetField("unit", entity.unit);
     row.SetField("prodpricety", entity.prodpricety);
     row.SetField("vendno", entity.vendno);
     row.SetField("prodline", entity.prodline);
     row.SetField("prodcat", entity.prodcat);
     row.SetField("rebtype", entity.rebtype);
     row.SetField("custpricety", entity.custpricety);
     row.SetField("recordcountlimit", entity.recordcountlimit);
     row.SetField("userfield", entity.userfield);
 }
예제 #2
0
        public static Pdsclookupcriteria BuildPdsclookupcriteriaFromRow(DataRow row)
        {
            Pdsclookupcriteria entity = new Pdsclookupcriteria();

            entity.levelcd          = row.IsNull("levelcd") ? string.Empty : row.Field <string>("levelcd");
            entity.custno           = row.IsNull("custno") ? decimal.Zero : row.Field <decimal>("custno");
            entity.shipto           = row.IsNull("shipto") ? string.Empty : row.Field <string>("shipto");
            entity.prod             = row.IsNull("prod") ? string.Empty : row.Field <string>("prod");
            entity.whse             = row.IsNull("whse") ? string.Empty : row.Field <string>("whse");
            entity.unit             = row.IsNull("unit") ? string.Empty : row.Field <string>("unit");
            entity.prodpricety      = row.IsNull("prodpricety") ? string.Empty : row.Field <string>("prodpricety");
            entity.vendno           = row.IsNull("vendno") ? decimal.Zero : row.Field <decimal>("vendno");
            entity.prodline         = row.IsNull("prodline") ? string.Empty : row.Field <string>("prodline");
            entity.prodcat          = row.IsNull("prodcat") ? string.Empty : row.Field <string>("prodcat");
            entity.rebtype          = row.IsNull("rebtype") ? string.Empty : row.Field <string>("rebtype");
            entity.custpricety      = row.IsNull("custpricety") ? string.Empty : row.Field <string>("custpricety");
            entity.recordcountlimit = row.IsNull("recordcountlimit") ? 0 : row.Field <int>("recordcountlimit");
            entity.userfield        = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield");
            return(entity);
        }