Beispiel #1
0
        public static Oefulfillmentresults BuildOefulfillmentresultsFromRow(DataRow row)
        {
            Oefulfillmentresults entity = new Oefulfillmentresults();

            entity.selectedfl   = row.Field <bool>("selectedfl");
            entity.lineno       = row.IsNull("lineno") ? 0 : row.Field <int>("lineno");
            entity.srcwhse      = row.IsNull("srcwhse") ? string.Empty : row.Field <string>("srcwhse");
            entity.seqno        = row.IsNull("seqno") ? 0 : row.Field <int>("seqno");
            entity.shipprod     = row.IsNull("shipprod") ? string.Empty : row.Field <string>("shipprod");
            entity.qtyord       = row.IsNull("qtyord") ? decimal.Zero : row.Field <decimal>("qtyord");
            entity.sourcedqty   = row.IsNull("sourcedqty") ? decimal.Zero : row.Field <decimal>("sourcedqty");
            entity.unit         = row.IsNull("unit") ? string.Empty : row.Field <string>("unit");
            entity.unitconv     = row.IsNull("unitconv") ? decimal.Zero : row.Field <decimal>("unitconv");
            entity.netavail     = row.IsNull("netavail") ? decimal.Zero : row.Field <decimal>("netavail");
            entity.surplus      = row.IsNull("surplus") ? decimal.Zero : row.Field <decimal>("surplus");
            entity.nonstockfl   = row.Field <bool>("nonstockfl");
            entity.fullstockfl  = row.Field <bool>("fullstockfl");
            entity.shortstockfl = row.Field <bool>("shortstockfl");
            entity.orignetavail = row.IsNull("orignetavail") ? decimal.Zero : row.Field <decimal>("orignetavail");
            entity.origsurplus  = row.IsNull("origsurplus") ? decimal.Zero : row.Field <decimal>("origsurplus");
            entity.arpvendno    = row.IsNull("arpvendno") ? decimal.Zero : row.Field <decimal>("arpvendno");
            entity.arpwhse      = row.IsNull("arpwhse") ? string.Empty : row.Field <string>("arpwhse");
            entity.reqshipdt    = row.Field <DateTime?>("reqshipdt");
            entity.region       = row.IsNull("region") ? string.Empty : row.Field <string>("region");
            entity.tiedordernum = row.IsNull("tiedordernum") ? string.Empty : row.Field <string>("tiedordernum");
            entity.tiedorderno  = row.IsNull("tiedorderno") ? 0 : row.Field <int>("tiedorderno");
            entity.tiedordersuf = row.IsNull("tiedordersuf") ? 0 : row.Field <int>("tiedordersuf");
            entity.tiedlineno   = row.IsNull("tiedlineno") ? 0 : row.Field <int>("tiedlineno");
            entity.tiedqtyord   = row.IsNull("tiedqtyord") ? decimal.Zero : row.Field <decimal>("tiedqtyord");
            entity.tiedqtyship  = row.IsNull("tiedqtyship") ? decimal.Zero : row.Field <decimal>("tiedqtyship");
            entity.tiedstagecd  = row.IsNull("tiedstagecd") ? 0 : row.Field <int>("tiedstagecd");
            entity.tiedlinetype = row.IsNull("tiedlinetype") ? string.Empty : row.Field <string>("tiedlinetype");
            entity.tiedvendno   = row.IsNull("tiedvendno") ? decimal.Zero : row.Field <decimal>("tiedvendno");
            entity.tiedwhse     = row.IsNull("tiedwhse") ? string.Empty : row.Field <string>("tiedwhse");
            entity.origruleused = row.IsNull("origruleused") ? string.Empty : row.Field <string>("origruleused");
            entity.overruleused = row.IsNull("overruleused") ? string.Empty : row.Field <string>("overruleused");
            entity.userfield    = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield");
            return(entity);
        }
Beispiel #2
0
 /// <summary>
 /// Update a database row from a class
 /// </summary>
 public static void UpdateRowFromOefulfillmentresults(ref DataRow row, Oefulfillmentresults entity)
 {
     row.SetField("selectedfl", entity.selectedfl);
     row.SetField("lineno", entity.lineno);
     row.SetField("srcwhse", entity.srcwhse);
     row.SetField("seqno", entity.seqno);
     row.SetField("shipprod", entity.shipprod);
     row.SetField("qtyord", entity.qtyord);
     row.SetField("sourcedqty", entity.sourcedqty);
     row.SetField("unit", entity.unit);
     row.SetField("unitconv", entity.unitconv);
     row.SetField("netavail", entity.netavail);
     row.SetField("surplus", entity.surplus);
     row.SetField("nonstockfl", entity.nonstockfl);
     row.SetField("fullstockfl", entity.fullstockfl);
     row.SetField("shortstockfl", entity.shortstockfl);
     row.SetField("orignetavail", entity.orignetavail);
     row.SetField("origsurplus", entity.origsurplus);
     row.SetField("arpvendno", entity.arpvendno);
     row.SetField("arpwhse", entity.arpwhse);
     row.SetField("reqshipdt", entity.reqshipdt);
     row.SetField("region", entity.region);
     row.SetField("tiedordernum", entity.tiedordernum);
     row.SetField("tiedorderno", entity.tiedorderno);
     row.SetField("tiedordersuf", entity.tiedordersuf);
     row.SetField("tiedlineno", entity.tiedlineno);
     row.SetField("tiedqtyord", entity.tiedqtyord);
     row.SetField("tiedqtyship", entity.tiedqtyship);
     row.SetField("tiedstagecd", entity.tiedstagecd);
     row.SetField("tiedlinetype", entity.tiedlinetype);
     row.SetField("tiedvendno", entity.tiedvendno);
     row.SetField("tiedwhse", entity.tiedwhse);
     row.SetField("origruleused", entity.origruleused);
     row.SetField("overruleused", entity.overruleused);
     row.SetField("userfield", entity.userfield);
 }