示例#1
0
 /// <summary>
 /// Update a database row from a class
 /// </summary>
 public static void UpdateRowFromOebundlescontrol(ref DataRow row, Oebundlescontrol entity)
 {
     row.SetField("columnlabel1", entity.columnlabel1);
     row.SetField("columnlabel2", entity.columnlabel2);
     row.SetField("columnlabel3", entity.columnlabel3);
     row.SetField("columnlabel4", entity.columnlabel4);
     row.SetField("columnlabel5", entity.columnlabel5);
     row.SetField("columnlabel6", entity.columnlabel6);
     row.SetField("columnlabel7", entity.columnlabel7);
     row.SetField("columnlabel8", entity.columnlabel8);
     row.SetField("columnlabel9", entity.columnlabel9);
     row.SetField("columnlabel10", entity.columnlabel10);
     row.SetField("columnlabel11", entity.columnlabel11);
     row.SetField("columnlabel12", entity.columnlabel12);
     row.SetField("columnlabel13", entity.columnlabel13);
     row.SetField("columnlabel14", entity.columnlabel14);
     row.SetField("columnlabel15", entity.columnlabel15);
     row.SetField("columnlabel16", entity.columnlabel16);
     row.SetField("columnlabel17", entity.columnlabel17);
     row.SetField("columnlabel18", entity.columnlabel18);
     row.SetField("columnlabel19", entity.columnlabel19);
     row.SetField("columnlabel20", entity.columnlabel20);
     row.SetField("columnprod1", entity.columnprod1);
     row.SetField("columnprod2", entity.columnprod2);
     row.SetField("columnprod3", entity.columnprod3);
     row.SetField("columnprod4", entity.columnprod4);
     row.SetField("columnprod5", entity.columnprod5);
     row.SetField("columnprod6", entity.columnprod6);
     row.SetField("columnprod7", entity.columnprod7);
     row.SetField("columnprod8", entity.columnprod8);
     row.SetField("columnprod9", entity.columnprod9);
     row.SetField("columnprod10", entity.columnprod10);
     row.SetField("columnprod11", entity.columnprod11);
     row.SetField("columnprod12", entity.columnprod12);
     row.SetField("columnprod13", entity.columnprod13);
     row.SetField("columnprod14", entity.columnprod14);
     row.SetField("columnprod15", entity.columnprod15);
     row.SetField("columnprod16", entity.columnprod16);
     row.SetField("columnprod17", entity.columnprod17);
     row.SetField("columnprod18", entity.columnprod18);
     row.SetField("columnprod19", entity.columnprod19);
     row.SetField("columnprod20", entity.columnprod20);
     row.SetField("columnhidden1", entity.columnhidden1);
     row.SetField("columnhidden2", entity.columnhidden2);
     row.SetField("columnhidden3", entity.columnhidden3);
     row.SetField("columnhidden4", entity.columnhidden4);
     row.SetField("columnhidden5", entity.columnhidden5);
     row.SetField("columnhidden6", entity.columnhidden6);
     row.SetField("columnhidden7", entity.columnhidden7);
     row.SetField("columnhidden8", entity.columnhidden8);
     row.SetField("columnhidden9", entity.columnhidden9);
     row.SetField("columnhidden10", entity.columnhidden10);
     row.SetField("columnhidden11", entity.columnhidden11);
     row.SetField("columnhidden12", entity.columnhidden12);
     row.SetField("columnhidden13", entity.columnhidden13);
     row.SetField("columnhidden14", entity.columnhidden14);
     row.SetField("columnhidden15", entity.columnhidden15);
     row.SetField("columnhidden16", entity.columnhidden16);
     row.SetField("columnhidden17", entity.columnhidden17);
     row.SetField("columnhidden18", entity.columnhidden18);
     row.SetField("columnhidden19", entity.columnhidden19);
     row.SetField("columnhidden20", entity.columnhidden20);
     row.SetField("qtyreq", entity.qtyreq);
     row.SetField("unit", entity.unit);
     row.SetField("prod", entity.prod);
     row.SetField("proddesc", entity.proddesc);
     row.SetField("qtyact", entity.qtyact);
     row.SetField("qtybf", entity.qtybf);
     row.SetField("cUnitStock", entity.cUnitStock);
     row.SetField("lUnitConv", entity.lUnitConv);
     row.SetField("lRandomMix", entity.lRandomMix);
     row.SetField("lMemoMix", entity.lMemoMix);
     row.SetField("lInitializedFl", entity.lInitializedFl);
     row.SetField("dConv", entity.dConv);
     row.SetField("btnaddenabled", entity.btnaddenabled);
     row.SetField("btndeleteenabled", entity.btndeleteenabled);
     row.SetField("btnselectenabled", entity.btnselectenabled);
     row.SetField("qtyreqenabled", entity.qtyreqenabled);
     row.SetField("userfield", entity.userfield);
 }
示例#2
0
        public static Oebundlescontrol BuildOebundlescontrolFromRow(DataRow row)
        {
            Oebundlescontrol entity = new Oebundlescontrol();

            entity.columnlabel1     = row.IsNull("columnlabel1") ? string.Empty : row.Field <string>("columnlabel1");
            entity.columnlabel2     = row.IsNull("columnlabel2") ? string.Empty : row.Field <string>("columnlabel2");
            entity.columnlabel3     = row.IsNull("columnlabel3") ? string.Empty : row.Field <string>("columnlabel3");
            entity.columnlabel4     = row.IsNull("columnlabel4") ? string.Empty : row.Field <string>("columnlabel4");
            entity.columnlabel5     = row.IsNull("columnlabel5") ? string.Empty : row.Field <string>("columnlabel5");
            entity.columnlabel6     = row.IsNull("columnlabel6") ? string.Empty : row.Field <string>("columnlabel6");
            entity.columnlabel7     = row.IsNull("columnlabel7") ? string.Empty : row.Field <string>("columnlabel7");
            entity.columnlabel8     = row.IsNull("columnlabel8") ? string.Empty : row.Field <string>("columnlabel8");
            entity.columnlabel9     = row.IsNull("columnlabel9") ? string.Empty : row.Field <string>("columnlabel9");
            entity.columnlabel10    = row.IsNull("columnlabel10") ? string.Empty : row.Field <string>("columnlabel10");
            entity.columnlabel11    = row.IsNull("columnlabel11") ? string.Empty : row.Field <string>("columnlabel11");
            entity.columnlabel12    = row.IsNull("columnlabel12") ? string.Empty : row.Field <string>("columnlabel12");
            entity.columnlabel13    = row.IsNull("columnlabel13") ? string.Empty : row.Field <string>("columnlabel13");
            entity.columnlabel14    = row.IsNull("columnlabel14") ? string.Empty : row.Field <string>("columnlabel14");
            entity.columnlabel15    = row.IsNull("columnlabel15") ? string.Empty : row.Field <string>("columnlabel15");
            entity.columnlabel16    = row.IsNull("columnlabel16") ? string.Empty : row.Field <string>("columnlabel16");
            entity.columnlabel17    = row.IsNull("columnlabel17") ? string.Empty : row.Field <string>("columnlabel17");
            entity.columnlabel18    = row.IsNull("columnlabel18") ? string.Empty : row.Field <string>("columnlabel18");
            entity.columnlabel19    = row.IsNull("columnlabel19") ? string.Empty : row.Field <string>("columnlabel19");
            entity.columnlabel20    = row.IsNull("columnlabel20") ? string.Empty : row.Field <string>("columnlabel20");
            entity.columnprod1      = row.IsNull("columnprod1") ? string.Empty : row.Field <string>("columnprod1");
            entity.columnprod2      = row.IsNull("columnprod2") ? string.Empty : row.Field <string>("columnprod2");
            entity.columnprod3      = row.IsNull("columnprod3") ? string.Empty : row.Field <string>("columnprod3");
            entity.columnprod4      = row.IsNull("columnprod4") ? string.Empty : row.Field <string>("columnprod4");
            entity.columnprod5      = row.IsNull("columnprod5") ? string.Empty : row.Field <string>("columnprod5");
            entity.columnprod6      = row.IsNull("columnprod6") ? string.Empty : row.Field <string>("columnprod6");
            entity.columnprod7      = row.IsNull("columnprod7") ? string.Empty : row.Field <string>("columnprod7");
            entity.columnprod8      = row.IsNull("columnprod8") ? string.Empty : row.Field <string>("columnprod8");
            entity.columnprod9      = row.IsNull("columnprod9") ? string.Empty : row.Field <string>("columnprod9");
            entity.columnprod10     = row.IsNull("columnprod10") ? string.Empty : row.Field <string>("columnprod10");
            entity.columnprod11     = row.IsNull("columnprod11") ? string.Empty : row.Field <string>("columnprod11");
            entity.columnprod12     = row.IsNull("columnprod12") ? string.Empty : row.Field <string>("columnprod12");
            entity.columnprod13     = row.IsNull("columnprod13") ? string.Empty : row.Field <string>("columnprod13");
            entity.columnprod14     = row.IsNull("columnprod14") ? string.Empty : row.Field <string>("columnprod14");
            entity.columnprod15     = row.IsNull("columnprod15") ? string.Empty : row.Field <string>("columnprod15");
            entity.columnprod16     = row.IsNull("columnprod16") ? string.Empty : row.Field <string>("columnprod16");
            entity.columnprod17     = row.IsNull("columnprod17") ? string.Empty : row.Field <string>("columnprod17");
            entity.columnprod18     = row.IsNull("columnprod18") ? string.Empty : row.Field <string>("columnprod18");
            entity.columnprod19     = row.IsNull("columnprod19") ? string.Empty : row.Field <string>("columnprod19");
            entity.columnprod20     = row.IsNull("columnprod20") ? string.Empty : row.Field <string>("columnprod20");
            entity.columnhidden1    = row.Field <bool>("columnhidden1");
            entity.columnhidden2    = row.Field <bool>("columnhidden2");
            entity.columnhidden3    = row.Field <bool>("columnhidden3");
            entity.columnhidden4    = row.Field <bool>("columnhidden4");
            entity.columnhidden5    = row.Field <bool>("columnhidden5");
            entity.columnhidden6    = row.Field <bool>("columnhidden6");
            entity.columnhidden7    = row.Field <bool>("columnhidden7");
            entity.columnhidden8    = row.Field <bool>("columnhidden8");
            entity.columnhidden9    = row.Field <bool>("columnhidden9");
            entity.columnhidden10   = row.Field <bool>("columnhidden10");
            entity.columnhidden11   = row.Field <bool>("columnhidden11");
            entity.columnhidden12   = row.Field <bool>("columnhidden12");
            entity.columnhidden13   = row.Field <bool>("columnhidden13");
            entity.columnhidden14   = row.Field <bool>("columnhidden14");
            entity.columnhidden15   = row.Field <bool>("columnhidden15");
            entity.columnhidden16   = row.Field <bool>("columnhidden16");
            entity.columnhidden17   = row.Field <bool>("columnhidden17");
            entity.columnhidden18   = row.Field <bool>("columnhidden18");
            entity.columnhidden19   = row.Field <bool>("columnhidden19");
            entity.columnhidden20   = row.Field <bool>("columnhidden20");
            entity.qtyreq           = row.IsNull("qtyreq") ? decimal.Zero : row.Field <decimal>("qtyreq");
            entity.unit             = row.IsNull("unit") ? string.Empty : row.Field <string>("unit");
            entity.prod             = row.IsNull("prod") ? string.Empty : row.Field <string>("prod");
            entity.proddesc         = row.IsNull("proddesc") ? string.Empty : row.Field <string>("proddesc");
            entity.qtyact           = row.IsNull("qtyact") ? decimal.Zero : row.Field <decimal>("qtyact");
            entity.qtybf            = row.IsNull("qtybf") ? decimal.Zero : row.Field <decimal>("qtybf");
            entity.cUnitStock       = row.IsNull("cUnitStock") ? string.Empty : row.Field <string>("cUnitStock");
            entity.lUnitConv        = row.Field <bool>("lUnitConv");
            entity.lRandomMix       = row.Field <bool>("lRandomMix");
            entity.lMemoMix         = row.Field <bool>("lMemoMix");
            entity.lInitializedFl   = row.Field <bool>("lInitializedFl");
            entity.dConv            = row.IsNull("dConv") ? decimal.Zero : row.Field <decimal>("dConv");
            entity.btnaddenabled    = row.Field <bool>("btnaddenabled");
            entity.btndeleteenabled = row.Field <bool>("btndeleteenabled");
            entity.btnselectenabled = row.Field <bool>("btnselectenabled");
            entity.qtyreqenabled    = row.Field <bool>("qtyreqenabled");
            entity.userfield        = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield");
            return(entity);
        }