/// <summary> /// Build a minimal row from a class (key fields only) /// </summary> public static void BuildMinimalRow(ref DataRow row, SmswBase entity) { row.SetField("cono", entity.cono); row.SetField("prod", entity.prod); row.SetField("whse", entity.whse); row.SetField("yr", entity.yr); row.SetField("stockfl", entity.stockfl); row.SetField("componentfl", entity.componentfl); row.SetField("smswRowID", entity.rowID.ToByteArray()); }
/// <summary> /// Update a database row from a class /// </summary> public static void UpdateRowFromSmswBase(ref DataRow row, SmswBase entity) { row.SetField("cono", entity.cono); row.SetField("prod", entity.prod); row.SetField("whse", entity.whse); row.SetField("yr", entity.yr); row.SetField("stockfl", entity.stockfl); row.SetField("nolinebill", entity.nolinebill); row.SetField("qtylost1", entity.qtylost1); row.SetField("qtylost2", entity.qtylost2); row.SetField("qtylost3", entity.qtylost3); row.SetField("qtylost4", entity.qtylost4); row.SetField("qtylost5", entity.qtylost5); row.SetField("qtylost6", entity.qtylost6); row.SetField("qtylost7", entity.qtylost7); row.SetField("qtylost8", entity.qtylost8); row.SetField("qtylost9", entity.qtylost9); row.SetField("qtylost10", entity.qtylost10); row.SetField("qtylost11", entity.qtylost11); row.SetField("qtylost12", entity.qtylost12); row.SetField("qtylost13", entity.qtylost13); row.SetField("salesamt1", entity.salesamt1); row.SetField("salesamt2", entity.salesamt2); row.SetField("salesamt3", entity.salesamt3); row.SetField("salesamt4", entity.salesamt4); row.SetField("salesamt5", entity.salesamt5); row.SetField("salesamt6", entity.salesamt6); row.SetField("salesamt7", entity.salesamt7); row.SetField("salesamt8", entity.salesamt8); row.SetField("salesamt9", entity.salesamt9); row.SetField("salesamt10", entity.salesamt10); row.SetField("salesamt11", entity.salesamt11); row.SetField("salesamt12", entity.salesamt12); row.SetField("salesamt13", entity.salesamt13); row.SetField("cogamt1", entity.cogamt1); row.SetField("cogamt2", entity.cogamt2); row.SetField("cogamt3", entity.cogamt3); row.SetField("cogamt4", entity.cogamt4); row.SetField("cogamt5", entity.cogamt5); row.SetField("cogamt6", entity.cogamt6); row.SetField("cogamt7", entity.cogamt7); row.SetField("cogamt8", entity.cogamt8); row.SetField("cogamt9", entity.cogamt9); row.SetField("cogamt10", entity.cogamt10); row.SetField("cogamt11", entity.cogamt11); row.SetField("cogamt12", entity.cogamt12); row.SetField("cogamt13", entity.cogamt13); row.SetField("transdt", entity.transdt); row.SetField("transtm", entity.transtm); row.SetField("operinit", entity.operinit); row.SetField("discamt1", entity.discamt1); row.SetField("discamt2", entity.discamt2); row.SetField("discamt3", entity.discamt3); row.SetField("discamt4", entity.discamt4); row.SetField("discamt5", entity.discamt5); row.SetField("discamt6", entity.discamt6); row.SetField("discamt7", entity.discamt7); row.SetField("discamt8", entity.discamt8); row.SetField("discamt9", entity.discamt9); row.SetField("discamt10", entity.discamt10); row.SetField("discamt11", entity.discamt11); row.SetField("discamt12", entity.discamt12); row.SetField("discamt13", entity.discamt13); row.SetField("qtysold1", entity.qtysold1); row.SetField("qtysold2", entity.qtysold2); row.SetField("qtysold3", entity.qtysold3); row.SetField("qtysold4", entity.qtysold4); row.SetField("qtysold5", entity.qtysold5); row.SetField("qtysold6", entity.qtysold6); row.SetField("qtysold7", entity.qtysold7); row.SetField("qtysold8", entity.qtysold8); row.SetField("qtysold9", entity.qtysold9); row.SetField("qtysold10", entity.qtysold10); row.SetField("qtysold11", entity.qtysold11); row.SetField("qtysold12", entity.qtysold12); row.SetField("qtysold13", entity.qtysold13); row.SetField("componentfl", entity.componentfl); row.SetField("budgetamt1", entity.budgetamt1); row.SetField("budgetamt2", entity.budgetamt2); row.SetField("budgetamt3", entity.budgetamt3); row.SetField("budgetamt4", entity.budgetamt4); row.SetField("budgetamt5", entity.budgetamt5); row.SetField("budgetamt6", entity.budgetamt6); row.SetField("budgetamt7", entity.budgetamt7); row.SetField("budgetamt8", entity.budgetamt8); row.SetField("budgetamt9", entity.budgetamt9); row.SetField("budgetamt10", entity.budgetamt10); row.SetField("budgetamt11", entity.budgetamt11); row.SetField("budgetamt12", entity.budgetamt12); row.SetField("budgetamt13", entity.budgetamt13); 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("transproc", entity.transproc); row.SetField("smswRowID", entity.rowID.ToByteArray()); }