Beispiel #1
0
        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);
        }
Beispiel #2
0
 /// <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);
 }