Esempio n. 1
0
 /// <summary>
 /// Update a database row from a class
 /// </summary>
 public static void UpdateRowFromPdgetpdscrecordscriteria(ref DataRow row, Pdgetpdscrecordscriteria entity)
 {
     row.SetField("prod", entity.prod);
     row.SetField("whse", entity.whse);
     row.SetField("custno", entity.custno);
     row.SetField("shipto", entity.shipto);
     row.SetField("modifiernm", entity.modifiernm);
     row.SetField("lastuseddt", entity.lastuseddt);
     row.SetField("includeinactive", entity.includeinactive);
     row.SetField("includeexpireinactive", entity.includeexpireinactive);
     row.SetField("includepromos", entity.includepromos);
     row.SetField("includecustomerprod", entity.includecustomerprod);
     row.SetField("includecustomer", entity.includecustomer);
     row.SetField("includecustomerprodpricetype", entity.includecustomerprodpricetype);
     row.SetField("includecustomerprodline", entity.includecustomerprodline);
     row.SetField("includecustomerprodcat", entity.includecustomerprodcat);
     row.SetField("includecustomerprodrebate", entity.includecustomerprodrebate);
     row.SetField("includecustpricetypeprod", entity.includecustpricetypeprod);
     row.SetField("includecustpricetypeprodtype", entity.includecustpricetypeprodtype);
     row.SetField("includecustpricetypeprodrebtype", entity.includecustpricetypeprodrebtype);
     row.SetField("includecustpricetype", entity.includecustpricetype);
     row.SetField("includeprod", entity.includeprod);
     row.SetField("includeprodpricetype", entity.includeprodpricetype);
     row.SetField("recordcountlimit", entity.recordcountlimit);
 }
Esempio n. 2
0
        public static Pdgetpdscrecordscriteria BuildPdgetpdscrecordscriteriaFromRow(DataRow row)
        {
            Pdgetpdscrecordscriteria entity = new Pdgetpdscrecordscriteria();

            entity.prod                            = row.IsNull("prod") ? string.Empty : row.Field <string>("prod");
            entity.whse                            = row.IsNull("whse") ? string.Empty : row.Field <string>("whse");
            entity.custno                          = row.IsNull("custno") ? decimal.Zero : row.Field <decimal>("custno");
            entity.shipto                          = row.IsNull("shipto") ? string.Empty : row.Field <string>("shipto");
            entity.modifiernm                      = row.IsNull("modifiernm") ? string.Empty : row.Field <string>("modifiernm");
            entity.lastuseddt                      = row.Field <DateTime?>("lastuseddt");
            entity.includeinactive                 = row.Field <bool>("includeinactive");
            entity.includeexpireinactive           = row.Field <bool>("includeexpireinactive");
            entity.includepromos                   = row.Field <bool>("includepromos");
            entity.includecustomerprod             = row.Field <bool>("includecustomerprod");
            entity.includecustomer                 = row.Field <bool>("includecustomer");
            entity.includecustomerprodpricetype    = row.Field <bool>("includecustomerprodpricetype");
            entity.includecustomerprodline         = row.Field <bool>("includecustomerprodline");
            entity.includecustomerprodcat          = row.Field <bool>("includecustomerprodcat");
            entity.includecustomerprodrebate       = row.Field <bool>("includecustomerprodrebate");
            entity.includecustpricetypeprod        = row.Field <bool>("includecustpricetypeprod");
            entity.includecustpricetypeprodtype    = row.Field <bool>("includecustpricetypeprodtype");
            entity.includecustpricetypeprodrebtype = row.Field <bool>("includecustpricetypeprodrebtype");
            entity.includecustpricetype            = row.Field <bool>("includecustpricetype");
            entity.includeprod                     = row.Field <bool>("includeprod");
            entity.includeprodpricetype            = row.Field <bool>("includeprodpricetype");
            entity.recordcountlimit                = row.IsNull("recordcountlimit") ? 0 : row.Field <int>("recordcountlimit");
            return(entity);
        }