Example #1
0
 /// <summary>
 /// Build a minimal row from a class (key fields only)
 /// </summary>
 public static void BuildMinimalRow(ref DataRow row, SmssBase entity)
 {
     row.SetField("cono", entity.cono);
     row.SetField("slsrep", entity.slsrep);
     row.SetField("yr", entity.yr);
     row.SetField("slsreptype", entity.slsreptype);
     row.SetField("smssRowID", entity.rowID.ToByteArray());
 }
Example #2
0
 /// <summary>
 /// Update a database row from a class
 /// </summary>
 public static void UpdateRowFromSmssBase(ref DataRow row, SmssBase entity)
 {
     row.SetField("cono", entity.cono);
     row.SetField("slsrep", entity.slsrep);
     row.SetField("yr", entity.yr);
     row.SetField("nolinebill", entity.nolinebill);
     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("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("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("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("slsreptype", entity.slsreptype);
     row.SetField("quotaamt1", entity.quotaamt1);
     row.SetField("quotaamt2", entity.quotaamt2);
     row.SetField("quotaamt3", entity.quotaamt3);
     row.SetField("quotaamt4", entity.quotaamt4);
     row.SetField("quotaamt5", entity.quotaamt5);
     row.SetField("quotaamt6", entity.quotaamt6);
     row.SetField("quotaamt7", entity.quotaamt7);
     row.SetField("quotaamt8", entity.quotaamt8);
     row.SetField("quotaamt9", entity.quotaamt9);
     row.SetField("quotaamt10", entity.quotaamt10);
     row.SetField("quotaamt11", entity.quotaamt11);
     row.SetField("quotaamt12", entity.quotaamt12);
     row.SetField("commamt1", entity.commamt1);
     row.SetField("commamt2", entity.commamt2);
     row.SetField("commamt3", entity.commamt3);
     row.SetField("commamt4", entity.commamt4);
     row.SetField("commamt5", entity.commamt5);
     row.SetField("commamt6", entity.commamt6);
     row.SetField("commamt7", entity.commamt7);
     row.SetField("commamt8", entity.commamt8);
     row.SetField("commamt9", entity.commamt9);
     row.SetField("commamt10", entity.commamt10);
     row.SetField("commamt11", entity.commamt11);
     row.SetField("commamt12", entity.commamt12);
     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("smssRowID", entity.rowID.ToByteArray());
 }