public static Icearbuildlistresults BuildIcearbuildlistresultsFromRow(DataRow row) { Icearbuildlistresults entity = new Icearbuildlistresults(); entity.orderty = row.IsNull("orderty") ? string.Empty : row.Field <string>("orderty"); entity.inoutfl = row.IsNull("inoutfl") ? string.Empty : row.Field <string>("inoutfl"); entity.orderno = row.IsNull("orderno") ? 0 : row.Field <int>("orderno"); entity.ordersuf = row.IsNull("ordersuf") ? 0 : row.Field <int>("ordersuf"); entity.stagecd = row.IsNull("stagecd") ? 0 : row.Field <int>("stagecd"); entity.stage = row.IsNull("stage") ? string.Empty : row.Field <string>("stage"); entity.notesfl = row.IsNull("notesfl") ? string.Empty : row.Field <string>("notesfl"); entity.lineno = row.IsNull("lineno") ? 0 : row.Field <int>("lineno"); entity.seqno = row.IsNull("seqno") ? 0 : row.Field <int>("seqno"); entity.date = row.Field <DateTime?>("date"); entity.transty = row.IsNull("transty") ? string.Empty : row.Field <string>("transty"); entity.qtyord = row.IsNull("qtyord") ? decimal.Zero : row.Field <decimal>("qtyord"); entity.stkqtyord = row.IsNull("stkqtyord") ? decimal.Zero : row.Field <decimal>("stkqtyord"); entity.qtyship = row.IsNull("qtyship") ? decimal.Zero : row.Field <decimal>("qtyship"); entity.stkqtyship = row.IsNull("stkqtyship") ? decimal.Zero : row.Field <decimal>("stkqtyship"); entity.unit = row.IsNull("unit") ? string.Empty : row.Field <string>("unit"); entity.unitconv = row.IsNull("unitconv") ? decimal.Zero : row.Field <decimal>("unitconv"); entity.delayresrvfl = row.Field <bool>("delayresrvfl"); entity.qtyorddisp = row.IsNull("qtyorddisp") ? decimal.Zero : row.Field <decimal>("qtyorddisp"); entity.qtyshpdisp = row.IsNull("qtyshpdisp") ? decimal.Zero : row.Field <decimal>("qtyshpdisp"); entity.origqtyshpdisp = row.IsNull("origqtyshpdisp") ? decimal.Zero : row.Field <decimal>("origqtyshpdisp"); entity.prevqtyshpdisp = row.IsNull("prevqtyshpdisp") ? decimal.Zero : row.Field <decimal>("prevqtyshpdisp"); entity.balance = row.IsNull("balance") ? decimal.Zero : row.Field <decimal>("balance"); entity.lchangefl = row.Field <bool>("lchangefl"); entity.uomfl = row.Field <bool>("uomfl"); entity.custno = row.IsNull("custno") ? decimal.Zero : row.Field <decimal>("custno"); entity.kittype = row.IsNull("kittype") ? string.Empty : row.Field <string>("kittype"); entity.wllivefl = row.Field <bool>("wllivefl"); entity.wlwhsefl = row.Field <bool>("wlwhsefl"); entity.wlrcvonlyfl = row.Field <bool>("wlrcvonlyfl"); entity.wlesbfl = row.Field <bool>("wlesbfl"); entity.gave8751warn = row.Field <bool>("gave8751warn"); 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 UpdateRowFromIcearbuildlistresults(ref DataRow row, Icearbuildlistresults entity) { row.SetField("orderty", entity.orderty); row.SetField("inoutfl", entity.inoutfl); row.SetField("orderno", entity.orderno); row.SetField("ordersuf", entity.ordersuf); row.SetField("stagecd", entity.stagecd); row.SetField("stage", entity.stage); row.SetField("notesfl", entity.notesfl); row.SetField("lineno", entity.lineno); row.SetField("seqno", entity.seqno); row.SetField("date", entity.date); row.SetField("transty", entity.transty); row.SetField("qtyord", entity.qtyord); row.SetField("stkqtyord", entity.stkqtyord); row.SetField("qtyship", entity.qtyship); row.SetField("stkqtyship", entity.stkqtyship); row.SetField("unit", entity.unit); row.SetField("unitconv", entity.unitconv); row.SetField("delayresrvfl", entity.delayresrvfl); row.SetField("qtyorddisp", entity.qtyorddisp); row.SetField("qtyshpdisp", entity.qtyshpdisp); row.SetField("origqtyshpdisp", entity.origqtyshpdisp); row.SetField("prevqtyshpdisp", entity.prevqtyshpdisp); row.SetField("balance", entity.balance); row.SetField("lchangefl", entity.lchangefl); row.SetField("uomfl", entity.uomfl); row.SetField("custno", entity.custno); row.SetField("kittype", entity.kittype); row.SetField("wllivefl", entity.wllivefl); row.SetField("wlwhsefl", entity.wlwhsefl); row.SetField("wlrcvonlyfl", entity.wlrcvonlyfl); row.SetField("wlesbfl", entity.wlesbfl); row.SetField("gave8751warn", entity.gave8751warn); row.SetField("userfield", entity.userfield); }