/// <summary> /// Update a database row from a class /// </summary> public static void UpdateRowFromIcsebresults(ref DataRow row, Icsebresults entity) { row.SetField("cono", entity.cono); row.SetField("bundleseqno", entity.bundleseqno); row.SetField("bundleid", entity.bundleid); row.SetField("bundlestatus", entity.bundlestatus); row.SetField("intype", entity.intype); row.SetField("docno", entity.docno); row.SetField("totlf", entity.totlf); row.SetField("totbf", entity.totbf); row.SetField("loosefl", entity.loosefl); row.SetField("qty1", entity.qty1); row.SetField("qty2", entity.qty2); row.SetField("qty3", entity.qty3); row.SetField("qty4", entity.qty4); row.SetField("qty5", entity.qty5); row.SetField("qty6", entity.qty6); row.SetField("qty7", entity.qty7); row.SetField("qty8", entity.qty8); row.SetField("qty9", entity.qty9); row.SetField("qty10", entity.qty10); row.SetField("qty11", entity.qty11); row.SetField("qty12", entity.qty12); row.SetField("qty13", entity.qty13); row.SetField("qty14", entity.qty14); row.SetField("qty15", entity.qty15); row.SetField("qty16", entity.qty16); row.SetField("qty17", entity.qty17); row.SetField("qty18", entity.qty18); row.SetField("qty19", entity.qty19); row.SetField("qty20", entity.qty20); row.SetField("prevqty1", entity.prevqty1); row.SetField("prevqty2", entity.prevqty2); row.SetField("prevqty3", entity.prevqty3); row.SetField("prevqty4", entity.prevqty4); row.SetField("prevqty5", entity.prevqty5); row.SetField("prevqty6", entity.prevqty6); row.SetField("prevqty7", entity.prevqty7); row.SetField("prevqty8", entity.prevqty8); row.SetField("prevqty9", entity.prevqty9); row.SetField("prevqty10", entity.prevqty10); row.SetField("prevqty11", entity.prevqty11); row.SetField("prevqty12", entity.prevqty12); row.SetField("prevqty13", entity.prevqty13); row.SetField("prevqty14", entity.prevqty14); row.SetField("prevqty15", entity.prevqty15); row.SetField("prevqty16", entity.prevqty16); row.SetField("prevqty17", entity.prevqty17); row.SetField("prevqty18", entity.prevqty18); row.SetField("prevqty19", entity.prevqty19); row.SetField("prevqty20", entity.prevqty20); row.SetField("length1", entity.length1); row.SetField("length2", entity.length2); row.SetField("length3", entity.length3); row.SetField("length4", entity.length4); row.SetField("length5", entity.length5); row.SetField("length6", entity.length6); row.SetField("length7", entity.length7); row.SetField("length8", entity.length8); row.SetField("length9", entity.length9); row.SetField("length10", entity.length10); row.SetField("length11", entity.length11); row.SetField("length12", entity.length12); row.SetField("length13", entity.length13); row.SetField("length14", entity.length14); row.SetField("length15", entity.length15); row.SetField("length16", entity.length16); row.SetField("length17", entity.length17); row.SetField("length18", entity.length18); row.SetField("length19", entity.length19); row.SetField("length20", entity.length20); row.SetField("csunperstk1", entity.csunperstk1); row.SetField("csunperstk2", entity.csunperstk2); row.SetField("csunperstk3", entity.csunperstk3); row.SetField("csunperstk4", entity.csunperstk4); row.SetField("csunperstk5", entity.csunperstk5); row.SetField("csunperstk6", entity.csunperstk6); row.SetField("csunperstk7", entity.csunperstk7); row.SetField("csunperstk8", entity.csunperstk8); row.SetField("csunperstk9", entity.csunperstk9); row.SetField("csunperstk10", entity.csunperstk10); row.SetField("csunperstk11", entity.csunperstk11); row.SetField("csunperstk12", entity.csunperstk12); row.SetField("csunperstk13", entity.csunperstk13); row.SetField("csunperstk14", entity.csunperstk14); row.SetField("csunperstk15", entity.csunperstk15); row.SetField("csunperstk16", entity.csunperstk16); row.SetField("csunperstk17", entity.csunperstk17); row.SetField("csunperstk18", entity.csunperstk18); row.SetField("csunperstk19", entity.csunperstk19); row.SetField("csunperstk20", entity.csunperstk20); row.SetField("prod1", entity.prod1); row.SetField("prod2", entity.prod2); row.SetField("prod3", entity.prod3); row.SetField("prod4", entity.prod4); row.SetField("prod5", entity.prod5); row.SetField("prod6", entity.prod6); row.SetField("prod7", entity.prod7); row.SetField("prod8", entity.prod8); row.SetField("prod9", entity.prod9); row.SetField("prod10", entity.prod10); row.SetField("prod11", entity.prod11); row.SetField("prod12", entity.prod12); row.SetField("prod13", entity.prod13); row.SetField("prod14", entity.prod14); row.SetField("prod15", entity.prod15); row.SetField("prod16", entity.prod16); row.SetField("prod17", entity.prod17); row.SetField("prod18", entity.prod18); row.SetField("prod19", entity.prod19); row.SetField("prod20", entity.prod20); row.SetField("changefl", entity.changefl); row.SetField("extrafld", entity.extrafld); row.SetField("user1", entity.user1); row.SetField("user2", entity.user2); row.SetField("user3", entity.user3); row.SetField("user4", entity.user4); row.SetField("user5", entity.user5); row.SetField("user6", entity.user6); row.SetField("user7", entity.user7); row.SetField("user8", entity.user8); row.SetField("user9", entity.user9); row.SetField("orderno", entity.orderno); row.SetField("ordersuf", entity.ordersuf); row.SetField("lineno", entity.lineno); row.SetField("indoc", entity.indoc); row.SetField("outdoc", entity.outdoc); row.SetField("p-prod", entity.pProd); row.SetField("whse", entity.whse); row.SetField("rowid-icseb", entity.rowidIcseb.ToByteArray()); row.SetField("userfield", entity.userfield); }
public static Icsebresults BuildIcsebresultsFromRow(DataRow row) { Icsebresults entity = new Icsebresults(); entity.cono = row.IsNull("cono") ? 0 : row.Field <int>("cono"); entity.bundleseqno = row.IsNull("bundleseqno") ? 0 : row.Field <int>("bundleseqno"); entity.bundleid = row.IsNull("bundleid") ? string.Empty : row.Field <string>("bundleid"); entity.bundlestatus = row.IsNull("bundlestatus") ? string.Empty : row.Field <string>("bundlestatus"); entity.intype = row.IsNull("intype") ? string.Empty : row.Field <string>("intype"); entity.docno = row.IsNull("docno") ? string.Empty : row.Field <string>("docno"); entity.totlf = row.IsNull("totlf") ? decimal.Zero : row.Field <decimal>("totlf"); entity.totbf = row.IsNull("totbf") ? decimal.Zero : row.Field <decimal>("totbf"); entity.loosefl = row.Field <bool>("loosefl"); entity.qty1 = row.IsNull("qty1") ? decimal.Zero : row.Field <decimal>("qty1"); entity.qty2 = row.IsNull("qty2") ? decimal.Zero : row.Field <decimal>("qty2"); entity.qty3 = row.IsNull("qty3") ? decimal.Zero : row.Field <decimal>("qty3"); entity.qty4 = row.IsNull("qty4") ? decimal.Zero : row.Field <decimal>("qty4"); entity.qty5 = row.IsNull("qty5") ? decimal.Zero : row.Field <decimal>("qty5"); entity.qty6 = row.IsNull("qty6") ? decimal.Zero : row.Field <decimal>("qty6"); entity.qty7 = row.IsNull("qty7") ? decimal.Zero : row.Field <decimal>("qty7"); entity.qty8 = row.IsNull("qty8") ? decimal.Zero : row.Field <decimal>("qty8"); entity.qty9 = row.IsNull("qty9") ? decimal.Zero : row.Field <decimal>("qty9"); entity.qty10 = row.IsNull("qty10") ? decimal.Zero : row.Field <decimal>("qty10"); entity.qty11 = row.IsNull("qty11") ? decimal.Zero : row.Field <decimal>("qty11"); entity.qty12 = row.IsNull("qty12") ? decimal.Zero : row.Field <decimal>("qty12"); entity.qty13 = row.IsNull("qty13") ? decimal.Zero : row.Field <decimal>("qty13"); entity.qty14 = row.IsNull("qty14") ? decimal.Zero : row.Field <decimal>("qty14"); entity.qty15 = row.IsNull("qty15") ? decimal.Zero : row.Field <decimal>("qty15"); entity.qty16 = row.IsNull("qty16") ? decimal.Zero : row.Field <decimal>("qty16"); entity.qty17 = row.IsNull("qty17") ? decimal.Zero : row.Field <decimal>("qty17"); entity.qty18 = row.IsNull("qty18") ? decimal.Zero : row.Field <decimal>("qty18"); entity.qty19 = row.IsNull("qty19") ? decimal.Zero : row.Field <decimal>("qty19"); entity.qty20 = row.IsNull("qty20") ? decimal.Zero : row.Field <decimal>("qty20"); entity.prevqty1 = row.IsNull("prevqty1") ? decimal.Zero : row.Field <decimal>("prevqty1"); entity.prevqty2 = row.IsNull("prevqty2") ? decimal.Zero : row.Field <decimal>("prevqty2"); entity.prevqty3 = row.IsNull("prevqty3") ? decimal.Zero : row.Field <decimal>("prevqty3"); entity.prevqty4 = row.IsNull("prevqty4") ? decimal.Zero : row.Field <decimal>("prevqty4"); entity.prevqty5 = row.IsNull("prevqty5") ? decimal.Zero : row.Field <decimal>("prevqty5"); entity.prevqty6 = row.IsNull("prevqty6") ? decimal.Zero : row.Field <decimal>("prevqty6"); entity.prevqty7 = row.IsNull("prevqty7") ? decimal.Zero : row.Field <decimal>("prevqty7"); entity.prevqty8 = row.IsNull("prevqty8") ? decimal.Zero : row.Field <decimal>("prevqty8"); entity.prevqty9 = row.IsNull("prevqty9") ? decimal.Zero : row.Field <decimal>("prevqty9"); entity.prevqty10 = row.IsNull("prevqty10") ? decimal.Zero : row.Field <decimal>("prevqty10"); entity.prevqty11 = row.IsNull("prevqty11") ? decimal.Zero : row.Field <decimal>("prevqty11"); entity.prevqty12 = row.IsNull("prevqty12") ? decimal.Zero : row.Field <decimal>("prevqty12"); entity.prevqty13 = row.IsNull("prevqty13") ? decimal.Zero : row.Field <decimal>("prevqty13"); entity.prevqty14 = row.IsNull("prevqty14") ? decimal.Zero : row.Field <decimal>("prevqty14"); entity.prevqty15 = row.IsNull("prevqty15") ? decimal.Zero : row.Field <decimal>("prevqty15"); entity.prevqty16 = row.IsNull("prevqty16") ? decimal.Zero : row.Field <decimal>("prevqty16"); entity.prevqty17 = row.IsNull("prevqty17") ? decimal.Zero : row.Field <decimal>("prevqty17"); entity.prevqty18 = row.IsNull("prevqty18") ? decimal.Zero : row.Field <decimal>("prevqty18"); entity.prevqty19 = row.IsNull("prevqty19") ? decimal.Zero : row.Field <decimal>("prevqty19"); entity.prevqty20 = row.IsNull("prevqty20") ? decimal.Zero : row.Field <decimal>("prevqty20"); entity.length1 = row.IsNull("length1") ? 0 : row.Field <int>("length1"); entity.length2 = row.IsNull("length2") ? 0 : row.Field <int>("length2"); entity.length3 = row.IsNull("length3") ? 0 : row.Field <int>("length3"); entity.length4 = row.IsNull("length4") ? 0 : row.Field <int>("length4"); entity.length5 = row.IsNull("length5") ? 0 : row.Field <int>("length5"); entity.length6 = row.IsNull("length6") ? 0 : row.Field <int>("length6"); entity.length7 = row.IsNull("length7") ? 0 : row.Field <int>("length7"); entity.length8 = row.IsNull("length8") ? 0 : row.Field <int>("length8"); entity.length9 = row.IsNull("length9") ? 0 : row.Field <int>("length9"); entity.length10 = row.IsNull("length10") ? 0 : row.Field <int>("length10"); entity.length11 = row.IsNull("length11") ? 0 : row.Field <int>("length11"); entity.length12 = row.IsNull("length12") ? 0 : row.Field <int>("length12"); entity.length13 = row.IsNull("length13") ? 0 : row.Field <int>("length13"); entity.length14 = row.IsNull("length14") ? 0 : row.Field <int>("length14"); entity.length15 = row.IsNull("length15") ? 0 : row.Field <int>("length15"); entity.length16 = row.IsNull("length16") ? 0 : row.Field <int>("length16"); entity.length17 = row.IsNull("length17") ? 0 : row.Field <int>("length17"); entity.length18 = row.IsNull("length18") ? 0 : row.Field <int>("length18"); entity.length19 = row.IsNull("length19") ? 0 : row.Field <int>("length19"); entity.length20 = row.IsNull("length20") ? 0 : row.Field <int>("length20"); entity.csunperstk1 = row.IsNull("csunperstk1") ? decimal.Zero : row.Field <decimal>("csunperstk1"); entity.csunperstk2 = row.IsNull("csunperstk2") ? decimal.Zero : row.Field <decimal>("csunperstk2"); entity.csunperstk3 = row.IsNull("csunperstk3") ? decimal.Zero : row.Field <decimal>("csunperstk3"); entity.csunperstk4 = row.IsNull("csunperstk4") ? decimal.Zero : row.Field <decimal>("csunperstk4"); entity.csunperstk5 = row.IsNull("csunperstk5") ? decimal.Zero : row.Field <decimal>("csunperstk5"); entity.csunperstk6 = row.IsNull("csunperstk6") ? decimal.Zero : row.Field <decimal>("csunperstk6"); entity.csunperstk7 = row.IsNull("csunperstk7") ? decimal.Zero : row.Field <decimal>("csunperstk7"); entity.csunperstk8 = row.IsNull("csunperstk8") ? decimal.Zero : row.Field <decimal>("csunperstk8"); entity.csunperstk9 = row.IsNull("csunperstk9") ? decimal.Zero : row.Field <decimal>("csunperstk9"); entity.csunperstk10 = row.IsNull("csunperstk10") ? decimal.Zero : row.Field <decimal>("csunperstk10"); entity.csunperstk11 = row.IsNull("csunperstk11") ? decimal.Zero : row.Field <decimal>("csunperstk11"); entity.csunperstk12 = row.IsNull("csunperstk12") ? decimal.Zero : row.Field <decimal>("csunperstk12"); entity.csunperstk13 = row.IsNull("csunperstk13") ? decimal.Zero : row.Field <decimal>("csunperstk13"); entity.csunperstk14 = row.IsNull("csunperstk14") ? decimal.Zero : row.Field <decimal>("csunperstk14"); entity.csunperstk15 = row.IsNull("csunperstk15") ? decimal.Zero : row.Field <decimal>("csunperstk15"); entity.csunperstk16 = row.IsNull("csunperstk16") ? decimal.Zero : row.Field <decimal>("csunperstk16"); entity.csunperstk17 = row.IsNull("csunperstk17") ? decimal.Zero : row.Field <decimal>("csunperstk17"); entity.csunperstk18 = row.IsNull("csunperstk18") ? decimal.Zero : row.Field <decimal>("csunperstk18"); entity.csunperstk19 = row.IsNull("csunperstk19") ? decimal.Zero : row.Field <decimal>("csunperstk19"); entity.csunperstk20 = row.IsNull("csunperstk20") ? decimal.Zero : row.Field <decimal>("csunperstk20"); entity.prod1 = row.IsNull("prod1") ? string.Empty : row.Field <string>("prod1"); entity.prod2 = row.IsNull("prod2") ? string.Empty : row.Field <string>("prod2"); entity.prod3 = row.IsNull("prod3") ? string.Empty : row.Field <string>("prod3"); entity.prod4 = row.IsNull("prod4") ? string.Empty : row.Field <string>("prod4"); entity.prod5 = row.IsNull("prod5") ? string.Empty : row.Field <string>("prod5"); entity.prod6 = row.IsNull("prod6") ? string.Empty : row.Field <string>("prod6"); entity.prod7 = row.IsNull("prod7") ? string.Empty : row.Field <string>("prod7"); entity.prod8 = row.IsNull("prod8") ? string.Empty : row.Field <string>("prod8"); entity.prod9 = row.IsNull("prod9") ? string.Empty : row.Field <string>("prod9"); entity.prod10 = row.IsNull("prod10") ? string.Empty : row.Field <string>("prod10"); entity.prod11 = row.IsNull("prod11") ? string.Empty : row.Field <string>("prod11"); entity.prod12 = row.IsNull("prod12") ? string.Empty : row.Field <string>("prod12"); entity.prod13 = row.IsNull("prod13") ? string.Empty : row.Field <string>("prod13"); entity.prod14 = row.IsNull("prod14") ? string.Empty : row.Field <string>("prod14"); entity.prod15 = row.IsNull("prod15") ? string.Empty : row.Field <string>("prod15"); entity.prod16 = row.IsNull("prod16") ? string.Empty : row.Field <string>("prod16"); entity.prod17 = row.IsNull("prod17") ? string.Empty : row.Field <string>("prod17"); entity.prod18 = row.IsNull("prod18") ? string.Empty : row.Field <string>("prod18"); entity.prod19 = row.IsNull("prod19") ? string.Empty : row.Field <string>("prod19"); entity.prod20 = row.IsNull("prod20") ? string.Empty : row.Field <string>("prod20"); entity.changefl = row.Field <bool>("changefl"); entity.extrafld = row.IsNull("extrafld") ? string.Empty : row.Field <string>("extrafld"); entity.user1 = row.IsNull("user1") ? string.Empty : row.Field <string>("user1"); entity.user2 = row.IsNull("user2") ? string.Empty : row.Field <string>("user2"); entity.user3 = row.IsNull("user3") ? string.Empty : row.Field <string>("user3"); entity.user4 = row.IsNull("user4") ? string.Empty : row.Field <string>("user4"); entity.user5 = row.IsNull("user5") ? string.Empty : row.Field <string>("user5"); entity.user6 = row.Field <decimal?>("user6"); entity.user7 = row.Field <decimal?>("user7"); entity.user8 = row.Field <DateTime?>("user8"); entity.user9 = row.Field <DateTime?>("user9"); entity.orderno = row.IsNull("orderno") ? 0 : row.Field <int>("orderno"); entity.ordersuf = row.IsNull("ordersuf") ? 0 : row.Field <int>("ordersuf"); entity.lineno = row.IsNull("lineno") ? 0 : row.Field <int>("lineno"); entity.indoc = row.IsNull("indoc") ? string.Empty : row.Field <string>("indoc"); entity.outdoc = row.IsNull("outdoc") ? string.Empty : row.Field <string>("outdoc"); entity.pProd = row.IsNull("p-prod") ? string.Empty : row.Field <string>("p-prod"); entity.whse = row.IsNull("whse") ? string.Empty : row.Field <string>("whse"); entity.rowidIcseb = row.Field <byte[]>("rowid-icseb").ToStringEncoded(); entity.userfield = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield"); return(entity); }