Esempio n. 1
0
      /// <summary>
      /// Update a database row from a class
      /// </summary>
      public static void UpdateRowFromLoadpototalsresults(ref DataRow row, Loadpototalsresults entity)
      {
         row.SetField("wodiscamt", entity.wodiscamt);
         row.SetField("wodisctype", entity.wodisctype);
         row.SetField("wodiscnet", entity.wodiscnet);
         row.SetField("enterdt", entity.enterdt);
         row.SetField("orderdt", entity.orderdt);
         row.SetField("printeddt", entity.printeddt);
         row.SetField("addondesc-1", entity.addondesc1);
         row.SetField("addonamt-1", entity.addonamt1);
         row.SetField("addontype-1", entity.addontype1);
         row.SetField("btnAddOnCapFl1label", entity.btnAddOnCapFl1label);
         row.SetField("addonnet-1", entity.addonnet1);
         row.SetField("duedt", entity.duedt);
         row.SetField("addondesc-2", entity.addondesc2);
         row.SetField("addonamt-2", entity.addonamt2);
         row.SetField("addontype-2", entity.addontype2);
         row.SetField("btnAddOnCapFl2label", entity.btnAddOnCapFl2label);
         row.SetField("addonnet-2", entity.addonnet2);
         row.SetField("reqshipdt", entity.reqshipdt);
         row.SetField("addondesc-3", entity.addondesc3);
         row.SetField("addonamt-3", entity.addonamt3);
         row.SetField("addontype-3", entity.addontype3);
         row.SetField("btnAddOnCapFl3label", entity.btnAddOnCapFl3label);
         row.SetField("addonnet-3", entity.addonnet3);
         row.SetField("expshipdt", entity.expshipdt);
         row.SetField("addondesc-4", entity.addondesc4);
         row.SetField("addonamt-4", entity.addonamt4);
         row.SetField("addontype-4", entity.addontype4);
         row.SetField("btnAddOnCapFl4label", entity.btnAddOnCapFl4label);
         row.SetField("addonnet-4", entity.addonnet4);
         row.SetField("receiptdt", entity.receiptdt);
         row.SetField("rcvoperinit", entity.rcvoperinit);
         row.SetField("freightexpectedmsg", entity.freightexpectedmsg);
         row.SetField("costeddt", entity.costeddt);
         row.SetField("cstoperinit", entity.cstoperinit);
         row.SetField("freightexpected", entity.freightexpected);
         row.SetField("paiddt", entity.paiddt);
         row.SetField("apetaddonmsg", entity.apetaddonmsg);
         row.SetField("apetaddon-1", entity.apetaddon1);
         row.SetField("apetaddon-2", entity.apetaddon2);
         row.SetField("target", entity.target);
         row.SetField("totqtycost", entity.totqtycost);
         row.SetField("totweight", entity.totweight);
         row.SetField("wtarget", entity.wtarget);
         row.SetField("totqtyord", entity.totqtyord);
         row.SetField("qtarget", entity.qtarget);
         row.SetField("totlineamt", entity.totlineamt);
         row.SetField("dtarget", entity.dtarget);
         row.SetField("totcubes", entity.totcubes);
         row.SetField("ctarget", entity.ctarget);
         row.SetField("totqtyrcv", entity.totqtyrcv);
         row.SetField("addon1hidden", entity.addon1hidden);
         row.SetField("addon2hidden", entity.addon2hidden);
         row.SetField("addon3hidden", entity.addon3hidden);
         row.SetField("addon4hidden", entity.addon4hidden);
         row.SetField("btnAdditAddonenabled", entity.btnAdditAddonenabled);
         row.SetField("addaddontot", entity.addaddontot);

      }
Esempio n. 2
0
 public static Loadpototalsresults BuildLoadpototalsresultsFromRow(DataRow row)
 {
    Loadpototalsresults entity = new Loadpototalsresults();
    entity.wodiscamt = row.IsNull("wodiscamt") ? decimal.Zero : row.Field<decimal>("wodiscamt");
    entity.wodisctype = row.IsNull("wodisctype") ? string.Empty : row.Field<string>("wodisctype");
    entity.wodiscnet = row.IsNull("wodiscnet") ? decimal.Zero : row.Field<decimal>("wodiscnet");
    entity.enterdt = row.Field<DateTime?>("enterdt");
    entity.orderdt = row.Field<DateTime?>("orderdt");
    entity.printeddt = row.Field<DateTime?>("printeddt");
    entity.addondesc1 = row.IsNull("addondesc-1") ? string.Empty : row.Field<string>("addondesc-1");
    entity.addonamt1 = row.IsNull("addonamt-1") ? decimal.Zero : row.Field<decimal>("addonamt-1");
    entity.addontype1 = row.IsNull("addontype-1") ? string.Empty : row.Field<string>("addontype-1");
    entity.btnAddOnCapFl1label = row.IsNull("btnAddOnCapFl1label") ? string.Empty : row.Field<string>("btnAddOnCapFl1label");
    entity.addonnet1 = row.IsNull("addonnet-1") ? decimal.Zero : row.Field<decimal>("addonnet-1");
    entity.duedt = row.Field<DateTime?>("duedt");
    entity.addondesc2 = row.IsNull("addondesc-2") ? string.Empty : row.Field<string>("addondesc-2");
    entity.addonamt2 = row.IsNull("addonamt-2") ? decimal.Zero : row.Field<decimal>("addonamt-2");
    entity.addontype2 = row.IsNull("addontype-2") ? string.Empty : row.Field<string>("addontype-2");
    entity.btnAddOnCapFl2label = row.IsNull("btnAddOnCapFl2label") ? string.Empty : row.Field<string>("btnAddOnCapFl2label");
    entity.addonnet2 = row.IsNull("addonnet-2") ? decimal.Zero : row.Field<decimal>("addonnet-2");
    entity.reqshipdt = row.Field<DateTime?>("reqshipdt");
    entity.addondesc3 = row.IsNull("addondesc-3") ? string.Empty : row.Field<string>("addondesc-3");
    entity.addonamt3 = row.IsNull("addonamt-3") ? decimal.Zero : row.Field<decimal>("addonamt-3");
    entity.addontype3 = row.IsNull("addontype-3") ? string.Empty : row.Field<string>("addontype-3");
    entity.btnAddOnCapFl3label = row.IsNull("btnAddOnCapFl3label") ? string.Empty : row.Field<string>("btnAddOnCapFl3label");
    entity.addonnet3 = row.IsNull("addonnet-3") ? decimal.Zero : row.Field<decimal>("addonnet-3");
    entity.expshipdt = row.Field<DateTime?>("expshipdt");
    entity.addondesc4 = row.IsNull("addondesc-4") ? string.Empty : row.Field<string>("addondesc-4");
    entity.addonamt4 = row.IsNull("addonamt-4") ? decimal.Zero : row.Field<decimal>("addonamt-4");
    entity.addontype4 = row.IsNull("addontype-4") ? string.Empty : row.Field<string>("addontype-4");
    entity.btnAddOnCapFl4label = row.IsNull("btnAddOnCapFl4label") ? string.Empty : row.Field<string>("btnAddOnCapFl4label");
    entity.addonnet4 = row.IsNull("addonnet-4") ? decimal.Zero : row.Field<decimal>("addonnet-4");
    entity.receiptdt = row.Field<DateTime?>("receiptdt");
    entity.rcvoperinit = row.IsNull("rcvoperinit") ? string.Empty : row.Field<string>("rcvoperinit");
    entity.freightexpectedmsg = row.IsNull("freightexpectedmsg") ? string.Empty : row.Field<string>("freightexpectedmsg");
    entity.costeddt = row.Field<DateTime?>("costeddt");
    entity.cstoperinit = row.IsNull("cstoperinit") ? string.Empty : row.Field<string>("cstoperinit");
    entity.freightexpected = row.Field<bool>("freightexpected");
    entity.paiddt = row.Field<DateTime?>("paiddt");
    entity.apetaddonmsg = row.IsNull("apetaddonmsg") ? string.Empty : row.Field<string>("apetaddonmsg");
    entity.apetaddon1 = row.IsNull("apetaddon-1") ? decimal.Zero : row.Field<decimal>("apetaddon-1");
    entity.apetaddon2 = row.IsNull("apetaddon-2") ? decimal.Zero : row.Field<decimal>("apetaddon-2");
    entity.target = row.IsNull("target") ? decimal.Zero : row.Field<decimal>("target");
    entity.totqtycost = row.IsNull("totqtycost") ? decimal.Zero : row.Field<decimal>("totqtycost");
    entity.totweight = row.IsNull("totweight") ? decimal.Zero : row.Field<decimal>("totweight");
    entity.wtarget = row.IsNull("wtarget") ? string.Empty : row.Field<string>("wtarget");
    entity.totqtyord = row.IsNull("totqtyord") ? decimal.Zero : row.Field<decimal>("totqtyord");
    entity.qtarget = row.IsNull("qtarget") ? string.Empty : row.Field<string>("qtarget");
    entity.totlineamt = row.IsNull("totlineamt") ? decimal.Zero : row.Field<decimal>("totlineamt");
    entity.dtarget = row.IsNull("dtarget") ? string.Empty : row.Field<string>("dtarget");
    entity.totcubes = row.IsNull("totcubes") ? decimal.Zero : row.Field<decimal>("totcubes");
    entity.ctarget = row.IsNull("ctarget") ? string.Empty : row.Field<string>("ctarget");
    entity.totqtyrcv = row.IsNull("totqtyrcv") ? decimal.Zero : row.Field<decimal>("totqtyrcv");
    entity.addon1hidden = row.Field<bool>("addon1hidden");
    entity.addon2hidden = row.Field<bool>("addon2hidden");
    entity.addon3hidden = row.Field<bool>("addon3hidden");
    entity.addon4hidden = row.Field<bool>("addon4hidden");
    entity.btnAdditAddonenabled = row.Field<bool>("btnAdditAddonenabled");
    entity.addaddontot = row.IsNull("addaddontot") ? decimal.Zero : row.Field<decimal>("addaddontot");
    return entity;
 }