public static Apeiinvdettaxes BuildApeiinvdettaxesFromRow(DataRow row) { Apeiinvdettaxes entity = new Apeiinvdettaxes(); entity.groupnm = row.IsNull("groupnm") ? string.Empty : row.Field <string>("groupnm"); entity.groupseqno = row.IsNull("groupseqno") ? 0 : row.Field <int>("groupseqno"); entity.createddt = row.Field <DateTime?>("createddt"); entity.invseqno = row.IsNull("invseqno") ? 0 : row.Field <int>("invseqno"); entity.settamt = row.IsNull("settamt") ? decimal.Zero : row.Field <decimal>("settamt"); entity.settpct = row.IsNull("settpct") ? decimal.Zero : row.Field <decimal>("settpct"); entity.twetax1 = row.IsNull("twetax1") ? decimal.Zero : row.Field <decimal>("twetax1"); entity.twetax2 = row.IsNull("twetax2") ? decimal.Zero : row.Field <decimal>("twetax2"); entity.twetax3 = row.IsNull("twetax3") ? decimal.Zero : row.Field <decimal>("twetax3"); entity.twetax4 = row.IsNull("twetax4") ? decimal.Zero : row.Field <decimal>("twetax4"); entity.vendtax1 = row.IsNull("vendtax1") ? decimal.Zero : row.Field <decimal>("vendtax1"); entity.vendtax2 = row.IsNull("vendtax2") ? decimal.Zero : row.Field <decimal>("vendtax2"); entity.vendtax3 = row.IsNull("vendtax3") ? decimal.Zero : row.Field <decimal>("vendtax3"); entity.vendtax4 = row.IsNull("vendtax4") ? decimal.Zero : row.Field <decimal>("vendtax4"); entity.distribtax1 = row.IsNull("distribtax1") ? decimal.Zero : row.Field <decimal>("distribtax1"); entity.distribtax2 = row.IsNull("distribtax2") ? decimal.Zero : row.Field <decimal>("distribtax2"); entity.distribtax3 = row.IsNull("distribtax3") ? decimal.Zero : row.Field <decimal>("distribtax3"); entity.distribtax4 = row.IsNull("distribtax4") ? decimal.Zero : row.Field <decimal>("distribtax4"); entity.twetaxttl = row.IsNull("twetaxttl") ? decimal.Zero : row.Field <decimal>("twetaxttl"); entity.vendortaxttl = row.IsNull("vendortaxttl") ? decimal.Zero : row.Field <decimal>("vendortaxttl"); entity.distribtaxttl = row.IsNull("distribtaxttl") ? decimal.Zero : row.Field <decimal>("distribtaxttl"); entity.taxgroup1 = row.IsNull("taxgroup1") ? string.Empty : row.Field <string>("taxgroup1"); entity.taxgroup2 = row.IsNull("taxgroup2") ? string.Empty : row.Field <string>("taxgroup2"); entity.taxgroup3 = row.IsNull("taxgroup3") ? string.Empty : row.Field <string>("taxgroup3"); entity.taxgroup4 = row.IsNull("taxgroup4") ? string.Empty : row.Field <string>("taxgroup4"); entity.tax2hidden = row.Field <bool>("tax2hidden"); entity.tax3hidden = row.Field <bool>("tax3hidden"); entity.tax4hidden = row.Field <bool>("tax4hidden"); entity.vendtax1sensitive = row.Field <bool>("vendtax1sensitive"); entity.vendtax2sensitive = row.Field <bool>("vendtax2sensitive"); entity.vendtax3sensitive = row.Field <bool>("vendtax3sensitive"); entity.vendtax4sensitive = row.Field <bool>("vendtax4sensitive"); entity.disttax1sensitive = row.Field <bool>("disttax1sensitive"); entity.disttax2sensitive = row.Field <bool>("disttax2sensitive"); entity.disttax3sensitive = row.Field <bool>("disttax3sensitive"); entity.disttax4sensitive = row.Field <bool>("disttax4sensitive"); entity.settsensitive = row.Field <bool>("settsensitive"); entity.setthidden = row.Field <bool>("setthidden"); entity.disputesensitive = row.Field <bool>("disputesensitive"); entity.disputefl = row.Field <bool>("disputefl"); entity.reversalfl = row.Field <bool>("reversalfl"); entity.apeiRowid = row.Field <byte[]>("apei-rowid").ToStringEncoded(); entity.apeiRowpointer = row.IsNull("apei-rowpointer") ? string.Empty : row.Field <string>("apei-rowpointer"); 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 UpdateRowFromApeiinvdettaxes(ref DataRow row, Apeiinvdettaxes entity) { row.SetField("groupnm", entity.groupnm); row.SetField("groupseqno", entity.groupseqno); row.SetField("createddt", entity.createddt); row.SetField("invseqno", entity.invseqno); row.SetField("settamt", entity.settamt); row.SetField("settpct", entity.settpct); row.SetField("twetax1", entity.twetax1); row.SetField("twetax2", entity.twetax2); row.SetField("twetax3", entity.twetax3); row.SetField("twetax4", entity.twetax4); row.SetField("vendtax1", entity.vendtax1); row.SetField("vendtax2", entity.vendtax2); row.SetField("vendtax3", entity.vendtax3); row.SetField("vendtax4", entity.vendtax4); row.SetField("distribtax1", entity.distribtax1); row.SetField("distribtax2", entity.distribtax2); row.SetField("distribtax3", entity.distribtax3); row.SetField("distribtax4", entity.distribtax4); row.SetField("twetaxttl", entity.twetaxttl); row.SetField("vendortaxttl", entity.vendortaxttl); row.SetField("distribtaxttl", entity.distribtaxttl); row.SetField("taxgroup1", entity.taxgroup1); row.SetField("taxgroup2", entity.taxgroup2); row.SetField("taxgroup3", entity.taxgroup3); row.SetField("taxgroup4", entity.taxgroup4); row.SetField("tax2hidden", entity.tax2hidden); row.SetField("tax3hidden", entity.tax3hidden); row.SetField("tax4hidden", entity.tax4hidden); row.SetField("vendtax1sensitive", entity.vendtax1sensitive); row.SetField("vendtax2sensitive", entity.vendtax2sensitive); row.SetField("vendtax3sensitive", entity.vendtax3sensitive); row.SetField("vendtax4sensitive", entity.vendtax4sensitive); row.SetField("disttax1sensitive", entity.disttax1sensitive); row.SetField("disttax2sensitive", entity.disttax2sensitive); row.SetField("disttax3sensitive", entity.disttax3sensitive); row.SetField("disttax4sensitive", entity.disttax4sensitive); row.SetField("settsensitive", entity.settsensitive); row.SetField("setthidden", entity.setthidden); row.SetField("disputesensitive", entity.disputesensitive); row.SetField("disputefl", entity.disputefl); row.SetField("reversalfl", entity.reversalfl); row.SetField("apei-rowid", entity.apeiRowid.ToByteArray()); row.SetField("apei-rowpointer", entity.apeiRowpointer); row.SetField("userfield", entity.userfield); }