public static Aosaleshistory BuildAosaleshistoryFromRow(DataRow row) { Aosaleshistory entity = new Aosaleshistory(); entity.cono = row.IsNull("cono") ? 0 : row.Field <int>("cono"); entity.smmergefl1 = row.Field <bool>("smmergefl1"); entity.smmergefl2 = row.Field <bool>("smmergefl2"); entity.smmergefl3 = row.Field <bool>("smmergefl3"); entity.smmergefl4 = row.Field <bool>("smmergefl4"); entity.smmergefl5 = row.Field <bool>("smmergefl5"); entity.smmergefl6 = row.Field <bool>("smmergefl6"); entity.smshiptofl1 = row.Field <bool>("smshiptofl1"); entity.smshiptofl2 = row.Field <bool>("smshiptofl2"); entity.smshiptofl3 = row.Field <bool>("smshiptofl3"); entity.smwhsefl1 = row.Field <bool>("smwhsefl1"); entity.smwhsefl2 = row.Field <bool>("smwhsefl2"); entity.smwhsefl3 = row.Field <bool>("smwhsefl3"); entity.smwhsefl4 = row.Field <bool>("smwhsefl4"); entity.smsvfl = row.Field <bool>("smsvfl"); entity.smsvpfl = row.Field <bool>("smsvpfl"); entity.smsvpwhsefl = row.Field <bool>("smsvpwhsefl"); entity.smsvwfl = row.Field <bool>("smsvwfl"); entity.smsvwwhsefl = row.Field <bool>("smsvwwhsefl"); entity.smnsfl = row.Field <bool>("smnsfl"); entity.smstorety = row.Field <bool>("smstorety"); entity.smcompfl = row.Field <bool>("smcompfl"); entity.smwodiscfl = row.Field <bool>("smwodiscfl"); entity.smcommtype = row.Field <bool>("smcommtype"); entity.smcustrebfl = row.Field <bool>("smcustrebfl"); entity.smvendrebfl = row.Field <bool>("smvendrebfl"); entity.smordcost = row.IsNull("smordcost") ? decimal.Zero : row.Field <decimal>("smordcost"); entity.smdeadmin = row.IsNull("smdeadmin") ? decimal.Zero : row.Field <decimal>("smdeadmin"); entity.smclass1 = row.IsNull("smclass1") ? decimal.Zero : row.Field <decimal>("smclass1"); entity.smclass2 = row.IsNull("smclass2") ? decimal.Zero : row.Field <decimal>("smclass2"); entity.smclass3 = row.IsNull("smclass3") ? decimal.Zero : row.Field <decimal>("smclass3"); entity.smclass4 = row.IsNull("smclass4") ? decimal.Zero : row.Field <decimal>("smclass4"); entity.smclass5 = row.IsNull("smclass5") ? decimal.Zero : row.Field <decimal>("smclass5"); entity.smclass6 = row.IsNull("smclass6") ? decimal.Zero : row.Field <decimal>("smclass6"); entity.smclass7 = row.IsNull("smclass7") ? decimal.Zero : row.Field <decimal>("smclass7"); entity.smclass8 = row.IsNull("smclass8") ? decimal.Zero : row.Field <decimal>("smclass8"); entity.smclass9 = row.IsNull("smclass9") ? decimal.Zero : row.Field <decimal>("smclass9"); entity.smclass10 = row.IsNull("smclass10") ? decimal.Zero : row.Field <decimal>("smclass10"); entity.smclass11 = row.IsNull("smclass11") ? decimal.Zero : row.Field <decimal>("smclass11"); entity.smclass12 = row.IsNull("smclass12") ? decimal.Zero : row.Field <decimal>("smclass12"); entity.sascRowid = row.Field <byte[]>("sasc-rowid").ToStringEncoded(); entity.userfield = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield"); return(entity); }
/// <summary> /// Update a database row from a class /// </summary> public static void UpdateRowFromAosaleshistory(ref DataRow row, Aosaleshistory entity) { row.SetField("cono", entity.cono); row.SetField("smmergefl1", entity.smmergefl1); row.SetField("smmergefl2", entity.smmergefl2); row.SetField("smmergefl3", entity.smmergefl3); row.SetField("smmergefl4", entity.smmergefl4); row.SetField("smmergefl5", entity.smmergefl5); row.SetField("smmergefl6", entity.smmergefl6); row.SetField("smshiptofl1", entity.smshiptofl1); row.SetField("smshiptofl2", entity.smshiptofl2); row.SetField("smshiptofl3", entity.smshiptofl3); row.SetField("smwhsefl1", entity.smwhsefl1); row.SetField("smwhsefl2", entity.smwhsefl2); row.SetField("smwhsefl3", entity.smwhsefl3); row.SetField("smwhsefl4", entity.smwhsefl4); row.SetField("smsvfl", entity.smsvfl); row.SetField("smsvpfl", entity.smsvpfl); row.SetField("smsvpwhsefl", entity.smsvpwhsefl); row.SetField("smsvwfl", entity.smsvwfl); row.SetField("smsvwwhsefl", entity.smsvwwhsefl); row.SetField("smnsfl", entity.smnsfl); row.SetField("smstorety", entity.smstorety); row.SetField("smcompfl", entity.smcompfl); row.SetField("smwodiscfl", entity.smwodiscfl); row.SetField("smcommtype", entity.smcommtype); row.SetField("smcustrebfl", entity.smcustrebfl); row.SetField("smvendrebfl", entity.smvendrebfl); row.SetField("smordcost", entity.smordcost); row.SetField("smdeadmin", entity.smdeadmin); row.SetField("smclass1", entity.smclass1); row.SetField("smclass2", entity.smclass2); row.SetField("smclass3", entity.smclass3); row.SetField("smclass4", entity.smclass4); row.SetField("smclass5", entity.smclass5); row.SetField("smclass6", entity.smclass6); row.SetField("smclass7", entity.smclass7); row.SetField("smclass8", entity.smclass8); row.SetField("smclass9", entity.smclass9); row.SetField("smclass10", entity.smclass10); row.SetField("smclass11", entity.smclass11); row.SetField("smclass12", entity.smclass12); row.SetField("sasc-rowid", entity.sascRowid.ToByteArray()); row.SetField("userfield", entity.userfield); }