/// <summary> /// Update a database row from a class /// </summary> public static void UpdateRowFromIcentrylotscriteria(ref DataRow row, Icentrylotscriteria entity) { row.SetField("whse", entity.whse); row.SetField("prod", entity.prod); row.SetField("type", entity.type); row.SetField("orderno", entity.orderno); row.SetField("ordersuf", entity.ordersuf); row.SetField("lineno", entity.lineno); row.SetField("linenochar", entity.linenochar); row.SetField("seqno", entity.seqno); row.SetField("seqnochar", entity.seqnochar); row.SetField("inquiryfl", entity.inquiryfl); row.SetField("returnfl", entity.returnfl); row.SetField("origqty", entity.origqty); row.SetField("proofqty", entity.proofqty); row.SetField("ordqty", entity.ordqty); row.SetField("outqty", entity.outqty); row.SetField("ictype", entity.ictype); row.SetField("cost", entity.cost); row.SetField("qtyunavail", entity.qtyunavail); row.SetField("iclotrcptty", entity.iclotrcptty); row.SetField("method", entity.method); row.SetField("retorderno", entity.retorderno); row.SetField("retordersuf", entity.retordersuf); row.SetField("retlineno", entity.retlineno); row.SetField("retseqno", entity.retseqno); row.SetField("returnty", entity.returnty); row.SetField("reasunavty", entity.reasunavty); row.SetField("s-qtyunavail", entity.sQtyunavail); row.SetField("custno", entity.custno); row.SetField("shipto", entity.shipto); row.SetField("vendno", entity.vendno); row.SetField("wono", entity.wono); row.SetField("wosuf", entity.wosuf); row.SetField("cono2", entity.cono2); row.SetField("shipfmwhse", entity.shipfmwhse); row.SetField("shiptowhse", entity.shiptowhse); row.SetField("jrnlno", entity.jrnlno); row.SetField("ourproc", entity.ourproc); row.SetField("actionty", entity.actionty); row.SetField("icspecrecno", entity.icspecrecno); row.SetField("assignoldest", entity.assignoldest); row.SetField("currproc", entity.currproc); row.SetField("seqdash", entity.seqdash); row.SetField("rettext", entity.rettext); row.SetField("kplabel", entity.kplabel); row.SetField("wonosuf", entity.wonosuf); row.SetField("origqtylabel", entity.origqtylabel); row.SetField("proddesc", entity.proddesc); row.SetField("prodnotesfl", entity.prodnotesfl); row.SetField("frametitle", entity.frametitle); row.SetField("btnoldestenabled", entity.btnoldestenabled); row.SetField("btnoldesthidden", entity.btnoldesthidden); row.SetField("btnautoassignenabled", entity.btnautoassignenabled); row.SetField("btnautoassignhidden", entity.btnautoassignhidden); row.SetField("btncreateenabled", entity.btncreateenabled); row.SetField("selectfieldenabled", entity.selectfieldenabled); row.SetField("accesscutsenabled", entity.accesscutsenabled); row.SetField("accesscutshidden", entity.accesscutshidden); row.SetField("userfield", entity.userfield); }
public static Icentrylotscriteria BuildIcentrylotscriteriaFromRow(DataRow row) { Icentrylotscriteria entity = new Icentrylotscriteria(); entity.whse = row.IsNull("whse") ? string.Empty : row.Field <string>("whse"); entity.prod = row.IsNull("prod") ? string.Empty : row.Field <string>("prod"); entity.type = row.IsNull("type") ? string.Empty : row.Field <string>("type"); 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.linenochar = row.IsNull("linenochar") ? string.Empty : row.Field <string>("linenochar"); entity.seqno = row.IsNull("seqno") ? 0 : row.Field <int>("seqno"); entity.seqnochar = row.IsNull("seqnochar") ? string.Empty : row.Field <string>("seqnochar"); entity.inquiryfl = row.Field <bool>("inquiryfl"); entity.returnfl = row.Field <bool>("returnfl"); entity.origqty = row.IsNull("origqty") ? decimal.Zero : row.Field <decimal>("origqty"); entity.proofqty = row.IsNull("proofqty") ? decimal.Zero : row.Field <decimal>("proofqty"); entity.ordqty = row.IsNull("ordqty") ? decimal.Zero : row.Field <decimal>("ordqty"); entity.outqty = row.IsNull("outqty") ? decimal.Zero : row.Field <decimal>("outqty"); entity.ictype = row.IsNull("ictype") ? string.Empty : row.Field <string>("ictype"); entity.cost = row.IsNull("cost") ? decimal.Zero : row.Field <decimal>("cost"); entity.qtyunavail = row.IsNull("qtyunavail") ? decimal.Zero : row.Field <decimal>("qtyunavail"); entity.iclotrcptty = row.IsNull("iclotrcptty") ? string.Empty : row.Field <string>("iclotrcptty"); entity.method = row.IsNull("method") ? string.Empty : row.Field <string>("method"); entity.retorderno = row.IsNull("retorderno") ? 0 : row.Field <int>("retorderno"); entity.retordersuf = row.IsNull("retordersuf") ? 0 : row.Field <int>("retordersuf"); entity.retlineno = row.IsNull("retlineno") ? 0 : row.Field <int>("retlineno"); entity.retseqno = row.IsNull("retseqno") ? 0 : row.Field <int>("retseqno"); entity.returnty = row.IsNull("returnty") ? string.Empty : row.Field <string>("returnty"); entity.reasunavty = row.IsNull("reasunavty") ? string.Empty : row.Field <string>("reasunavty"); entity.sQtyunavail = row.IsNull("s-qtyunavail") ? decimal.Zero : row.Field <decimal>("s-qtyunavail"); entity.custno = row.IsNull("custno") ? decimal.Zero : row.Field <decimal>("custno"); entity.shipto = row.IsNull("shipto") ? string.Empty : row.Field <string>("shipto"); entity.vendno = row.IsNull("vendno") ? decimal.Zero : row.Field <decimal>("vendno"); entity.wono = row.IsNull("wono") ? 0 : row.Field <int>("wono"); entity.wosuf = row.IsNull("wosuf") ? 0 : row.Field <int>("wosuf"); entity.cono2 = row.IsNull("cono2") ? 0 : row.Field <int>("cono2"); entity.shipfmwhse = row.IsNull("shipfmwhse") ? string.Empty : row.Field <string>("shipfmwhse"); entity.shiptowhse = row.IsNull("shiptowhse") ? string.Empty : row.Field <string>("shiptowhse"); entity.jrnlno = row.IsNull("jrnlno") ? 0 : row.Field <int>("jrnlno"); entity.ourproc = row.IsNull("ourproc") ? string.Empty : row.Field <string>("ourproc"); entity.actionty = row.IsNull("actionty") ? string.Empty : row.Field <string>("actionty"); entity.icspecrecno = row.IsNull("icspecrecno") ? 0 : row.Field <int>("icspecrecno"); entity.assignoldest = row.IsNull("assignoldest") ? string.Empty : row.Field <string>("assignoldest"); entity.currproc = row.IsNull("currproc") ? string.Empty : row.Field <string>("currproc"); entity.seqdash = row.IsNull("seqdash") ? string.Empty : row.Field <string>("seqdash"); entity.rettext = row.IsNull("rettext") ? string.Empty : row.Field <string>("rettext"); entity.kplabel = row.IsNull("kplabel") ? string.Empty : row.Field <string>("kplabel"); entity.wonosuf = row.IsNull("wonosuf") ? string.Empty : row.Field <string>("wonosuf"); entity.origqtylabel = row.IsNull("origqtylabel") ? string.Empty : row.Field <string>("origqtylabel"); entity.proddesc = row.IsNull("proddesc") ? string.Empty : row.Field <string>("proddesc"); entity.prodnotesfl = row.IsNull("prodnotesfl") ? string.Empty : row.Field <string>("prodnotesfl"); entity.frametitle = row.IsNull("frametitle") ? string.Empty : row.Field <string>("frametitle"); entity.btnoldestenabled = row.Field <bool>("btnoldestenabled"); entity.btnoldesthidden = row.Field <bool>("btnoldesthidden"); entity.btnautoassignenabled = row.Field <bool>("btnautoassignenabled"); entity.btnautoassignhidden = row.Field <bool>("btnautoassignhidden"); entity.btncreateenabled = row.Field <bool>("btncreateenabled"); entity.selectfieldenabled = row.Field <bool>("selectfieldenabled"); entity.accesscutsenabled = row.Field <bool>("accesscutsenabled"); entity.accesscutshidden = row.Field <bool>("accesscutshidden"); entity.userfield = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield"); return(entity); }