Exemple #1
0
 /// <summary>
 /// Build a minimal row from a class (key fields only)
 /// </summary>
 public static void BuildMinimalRow(ref DataRow row, PvPdmhdrBase entity)
 {
     row.SetField("setID", entity.setID);
     row.SetField("cono", entity.cono);
     row.SetField("pv_pdmhdrRowID", entity.rowID.ToByteArray());
 }
Exemple #2
0
 /// <summary>
 /// Update a database row from a class
 /// </summary>
 public static void UpdateRowFromPvPdmhdrBase(ref DataRow row, PvPdmhdrBase entity)
 {
     row.SetField("SetID", entity.setID);
     row.SetField("Source", entity.source);
     row.SetField("Destination", entity.destination);
     row.SetField("CreateDt", entity.createDt);
     row.SetField("OperInit", entity.operInit);
     row.SetField("LastSeqNo", entity.lastSeqNo);
     row.SetField("VendType", entity.vendType);
     row.SetField("PTypeSource", entity.pTypeSource);
     row.SetField("Line", entity.line);
     row.SetField("ProdPrcTy", entity.prodPrcTy);
     row.SetField("Family", entity.family);
     row.SetField("Class", entity.@class);
     row.SetField("RebateTy", entity.rebateTy);
     row.SetField("RebSubTy", entity.rebSubTy);
     row.SetField("RebateCd", entity.rebateCd);
     row.SetField("dropshipty", entity.dropshipty);
     row.SetField("Cono", entity.cono);
     row.SetField("Description", entity.description);
     row.SetField("RebCalcTy", entity.rebCalcTy);
     row.SetField("RebBasedOn", entity.rebBasedOn);
     row.SetField("RebDownTo", entity.rebDownTo);
     row.SetField("ProdCat", entity.prodCat);
     row.SetField("Whse", entity.whse);
     row.SetField("ShipTo", entity.shipTo);
     row.SetField("CustType", entity.custType);
     row.SetField("Prod", entity.prod);
     row.SetField("DefPrice", entity.defPrice);
     row.SetField("DefWhse", entity.defWhse);
     row.SetField("user1", entity.user1);
     row.SetField("user2", entity.user2);
     row.SetField("user3", entity.user3);
     row.SetField("user4", entity.user4);
     row.SetField("user5", entity.user5);
     row.SetField("user6", entity.user6);
     row.SetField("user7", entity.user7);
     row.SetField("user8", entity.user8);
     row.SetField("user9", entity.user9);
     row.SetField("transdt", entity.transdt);
     row.SetField("transtm", entity.transtm);
     row.SetField("transproc", entity.transproc);
     row.SetField("vendno", entity.vendno);
     row.SetField("RebateCap", entity.rebateCap);
     row.SetField("RebPercent", entity.rebPercent);
     row.SetField("RebAmount", entity.rebAmount);
     row.SetField("custno", entity.custno);
     row.SetField("StartFrom", entity.startFrom);
     row.SetField("StartTo", entity.startTo);
     row.SetField("EndFrom", entity.endFrom);
     row.SetField("EndTo", entity.endTo);
     row.SetField("AddCode", entity.addCode);
     row.SetField("UpdType", entity.updType);
     row.SetField("DefStart", entity.defStart);
     row.SetField("defend", entity.defend);
     row.SetField("ExcludePDSC1", entity.excludePDSC1);
     row.SetField("ExcludePDSC2", entity.excludePDSC2);
     row.SetField("ExcludePDSC3", entity.excludePDSC3);
     row.SetField("ExcludePDSC4", entity.excludePDSC4);
     row.SetField("ExcludePDSC5", entity.excludePDSC5);
     row.SetField("ExcludePDSC6", entity.excludePDSC6);
     row.SetField("ExcludePDSC7", entity.excludePDSC7);
     row.SetField("ExcludePDSC8", entity.excludePDSC8);
     row.SetField("delduringupd", entity.delduringupd);
     row.SetField("acctupdfl", entity.acctupdfl);
     row.SetField("sortselection", entity.sortselection);
     row.SetField("stagecd", entity.stagecd);
     row.SetField("reportnm", entity.reportnm);
     row.SetField("contractno", entity.contractno);
     row.SetField("begprod", entity.begprod);
     row.SetField("endprod", entity.endprod);
     row.SetField("prodline", entity.prodline);
     row.SetField("custrebty", entity.custrebty);
     row.SetField("modifiernm", entity.modifiernm);
     row.SetField("modifierrebfl", entity.modifierrebfl);
     row.SetField("lastuseddt", entity.lastuseddt);
     row.SetField("pricerebfl", entity.pricerebfl);
     row.SetField("pv_pdmhdrRowID", entity.rowID.ToByteArray());
 }