/// <summary> /// Update a database row from a class /// </summary> public static void UpdateRowFromSasgsgldata(ref DataRow row, Sasgsgldata entity) { row.SetField("recty", entity.recty); row.SetField("taxgroup", entity.taxgroup); row.SetField("statecd", entity.statecd); row.SetField("countycd", entity.countycd); row.SetField("citycd", entity.citycd); row.SetField("othercd", entity.othercd); row.SetField("sasgm-rowid", entity.sasgmRowid.ToByteArray()); row.SetField("glyear", entity.glyear); row.SetField("salesglno", entity.salesglno); row.SetField("useglno", entity.useglno); row.SetField("transitglno", entity.transitglno); row.SetField("exciseglno", entity.exciseglno); row.SetField("cashsalesglno", entity.cashsalesglno); row.SetField("cashuseglno", entity.cashuseglno); row.SetField("cashtransitglno", entity.cashtransitglno); row.SetField("cashexciseglno", entity.cashexciseglno); row.SetField("salesglnodesc", entity.salesglnodesc); row.SetField("useglnodesc", entity.useglnodesc); row.SetField("transitglnodesc", entity.transitglnodesc); row.SetField("exciseglnodesc", entity.exciseglnodesc); row.SetField("cashsalesglnodesc", entity.cashsalesglnodesc); row.SetField("cashuseglnodesc", entity.cashuseglnodesc); row.SetField("cashtransitglnodesc", entity.cashtransitglnodesc); row.SetField("cashexciseglnodesc", entity.cashexciseglnodesc); row.SetField("cashbasislabel", entity.cashbasislabel); row.SetField("cashhiddenfl", entity.cashhiddenfl); row.SetField("userfield", entity.userfield); }
public static Sasgsgldata BuildSasgsgldataFromRow(DataRow row) { Sasgsgldata entity = new Sasgsgldata(); entity.recty = row.IsNull("recty") ? 0 : row.Field <int>("recty"); entity.taxgroup = row.IsNull("taxgroup") ? 0 : row.Field <int>("taxgroup"); entity.statecd = row.IsNull("statecd") ? string.Empty : row.Field <string>("statecd"); entity.countycd = row.IsNull("countycd") ? string.Empty : row.Field <string>("countycd"); entity.citycd = row.IsNull("citycd") ? string.Empty : row.Field <string>("citycd"); entity.othercd = row.IsNull("othercd") ? string.Empty : row.Field <string>("othercd"); entity.sasgmRowid = row.Field <byte[]>("sasgm-rowid").ToStringEncoded(); entity.glyear = row.IsNull("glyear") ? 0 : row.Field <int>("glyear"); entity.salesglno = row.IsNull("salesglno") ? string.Empty : row.Field <string>("salesglno"); entity.useglno = row.IsNull("useglno") ? string.Empty : row.Field <string>("useglno"); entity.transitglno = row.IsNull("transitglno") ? string.Empty : row.Field <string>("transitglno"); entity.exciseglno = row.IsNull("exciseglno") ? string.Empty : row.Field <string>("exciseglno"); entity.cashsalesglno = row.IsNull("cashsalesglno") ? string.Empty : row.Field <string>("cashsalesglno"); entity.cashuseglno = row.IsNull("cashuseglno") ? string.Empty : row.Field <string>("cashuseglno"); entity.cashtransitglno = row.IsNull("cashtransitglno") ? string.Empty : row.Field <string>("cashtransitglno"); entity.cashexciseglno = row.IsNull("cashexciseglno") ? string.Empty : row.Field <string>("cashexciseglno"); entity.salesglnodesc = row.IsNull("salesglnodesc") ? string.Empty : row.Field <string>("salesglnodesc"); entity.useglnodesc = row.IsNull("useglnodesc") ? string.Empty : row.Field <string>("useglnodesc"); entity.transitglnodesc = row.IsNull("transitglnodesc") ? string.Empty : row.Field <string>("transitglnodesc"); entity.exciseglnodesc = row.IsNull("exciseglnodesc") ? string.Empty : row.Field <string>("exciseglnodesc"); entity.cashsalesglnodesc = row.IsNull("cashsalesglnodesc") ? string.Empty : row.Field <string>("cashsalesglnodesc"); entity.cashuseglnodesc = row.IsNull("cashuseglnodesc") ? string.Empty : row.Field <string>("cashuseglnodesc"); entity.cashtransitglnodesc = row.IsNull("cashtransitglnodesc") ? string.Empty : row.Field <string>("cashtransitglnodesc"); entity.cashexciseglnodesc = row.IsNull("cashexciseglnodesc") ? string.Empty : row.Field <string>("cashexciseglnodesc"); entity.cashbasislabel = row.IsNull("cashbasislabel") ? string.Empty : row.Field <string>("cashbasislabel"); entity.cashhiddenfl = row.Field <bool>("cashhiddenfl"); entity.userfield = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield"); return(entity); }