/// <summary>
/// Update a database row from a class
/// </summary>
public static void UpdateRowFromOereturn(ref DataRow row, Oereturn entity)
{
row.SetField("orderno", entity.orderno);
row.SetField("ordersuf", entity.ordersuf);
row.SetField("lineno", entity.lineno);
row.SetField("btnsourcingenabled", entity.btnsourcingenabled);
row.SetField("createpofl", entity.createpofl);
row.SetField("createpoflenabled", entity.createpoflenabled);
row.SetField("crreasonty", entity.crreasonty);
row.SetField("crreasontyenabled", entity.crreasontyenabled);
row.SetField("orderaltno", entity.orderaltno);
row.SetField("orderaltnoenabled", entity.orderaltnoenabled);
row.SetField("qtyunavail", entity.qtyunavail);
row.SetField("qtyunavailenabled", entity.qtyunavailenabled);
row.SetField("reasunavty", entity.reasunavty);
row.SetField("reasunavtyenabled", entity.reasunavtyenabled);
row.SetField("reqauthfl", entity.reqauthfl);
row.SetField("reqinvfl", entity.reqinvfl);
row.SetField("reqwarrfl", entity.reqwarrfl);
row.SetField("restktaxgrp", entity.restktaxgrp);
row.SetField("restktaxgrpenabled", entity.restktaxgrpenabled);
row.SetField("restockamt", entity.restockamt);
row.SetField("restockfl", entity.restockfl);
row.SetField("retlineno", entity.retlineno);
row.SetField("retlinenoenabled", entity.retlinenoenabled);
row.SetField("retorderno", entity.retorderno);
row.SetField("retordernoenabled", entity.retordernoenabled);
row.SetField("retordersuf", entity.retordersuf);
row.SetField("retordersufenabled", entity.retordersufenabled);
row.SetField("returntype", entity.returntype);
row.SetField("stkunit", entity.stkunit);
row.SetField("usagefl", entity.usagefl);
row.SetField("warrantymsg", entity.warrantymsg);
row.SetField("warrexchgfl", entity.warrexchgfl);
row.SetField("warrtag", entity.warrtag);
row.SetField("ehfaddonno", entity.ehfaddonno);
row.SetField("ehfamt", entity.ehfamt);
row.SetField("ehfexemptamt", entity.ehfexemptamt);
row.SetField("userfield", entity.userfield);
row.SetField("addswoptprodfl", entity.addswoptprodfl);
row.SetField("cCallMode", entity.cCallMode);
row.SetField("cCoreRtnTy", entity.cCoreRtnTy);
row.SetField("cMaintModeL", entity.cMaintModeL);
row.SetField("cProd", entity.cProd);
row.SetField("cSerLotType", entity.cSerLotType);
row.SetField("cSpecNSType", entity.cSpecNSType);
row.SetField("cUnit", entity.cUnit);
row.SetField("cWarrantyCd", entity.cWarrantyCd);
row.SetField("dConv", entity.dConv);
row.SetField("dQtyOrd", entity.dQtyOrd);
row.SetField("dVendno", entity.dVendno);
row.SetField("iOrderAltNo", entity.iOrderAltNo);
row.SetField("iRepLineNo", entity.iRepLineNo);
row.SetField("iRepOrdno", entity.iRepOrdno);
row.SetField("iRepOrdSuf", entity.iRepOrdSuf);
row.SetField("iShipfmno", entity.iShipfmno);
row.SetField("lKitfl", entity.lKitfl);
row.SetField("lRemanCore", entity.lRemanCore);
row.SetField("lRetOrdLkupfl", entity.lRetOrdLkupfl);
row.SetField("lTallyfl", entity.lTallyfl);
row.SetField("dVVendno", entity.dVVendno);
row.SetField("cVShipfmno", entity.cVShipfmno);
row.SetField("cVName", entity.cVName);
row.SetField("cVAddr1", entity.cVAddr1);
row.SetField("cVAddr2", entity.cVAddr2);
row.SetField("cVAddr3", entity.cVAddr3);
row.SetField("cVCity", entity.cVCity);
row.SetField("cVState", entity.cVState);
row.SetField("cVZipcd", entity.cVZipcd);
row.SetField("lVFOBfl", entity.lVFOBfl);
row.SetField("lVConfirmfl", entity.lVConfirmfl);
row.SetField("cVShipviaty", entity.cVShipviaty);
row.SetField("dVDuedt", entity.dVDuedt);
row.SetField("lVPOWTIntfl", entity.lVPOWTIntfl);
row.SetField("cVOrderType", entity.cVOrderType);
row.SetField("v-commentfl", entity.vCommentfl);
row.SetField("vendretauth", entity.vendretauth);
}
public static Oereturn BuildOereturnFromRow(DataRow row)
{
Oereturn entity = new Oereturn();
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.btnsourcingenabled = row.Field <bool>("btnsourcingenabled");
entity.createpofl = row.Field <bool>("createpofl");
entity.createpoflenabled = row.Field <bool>("createpoflenabled");
entity.crreasonty = row.IsNull("crreasonty") ? string.Empty : row.Field <string>("crreasonty");
entity.crreasontyenabled = row.Field <bool>("crreasontyenabled");
entity.orderaltno = row.IsNull("orderaltno") ? 0 : row.Field <int>("orderaltno");
entity.orderaltnoenabled = row.Field <bool>("orderaltnoenabled");
entity.qtyunavail = row.IsNull("qtyunavail") ? decimal.Zero : row.Field <decimal>("qtyunavail");
entity.qtyunavailenabled = row.Field <bool>("qtyunavailenabled");
entity.reasunavty = row.IsNull("reasunavty") ? string.Empty : row.Field <string>("reasunavty");
entity.reasunavtyenabled = row.Field <bool>("reasunavtyenabled");
entity.reqauthfl = row.Field <bool>("reqauthfl");
entity.reqinvfl = row.Field <bool>("reqinvfl");
entity.reqwarrfl = row.Field <bool>("reqwarrfl");
entity.restktaxgrp = row.IsNull("restktaxgrp") ? 0 : row.Field <int>("restktaxgrp");
entity.restktaxgrpenabled = row.Field <bool>("restktaxgrpenabled");
entity.restockamt = row.IsNull("restockamt") ? decimal.Zero : row.Field <decimal>("restockamt");
entity.restockfl = row.Field <bool>("restockfl");
entity.retlineno = row.IsNull("retlineno") ? 0 : row.Field <int>("retlineno");
entity.retlinenoenabled = row.Field <bool>("retlinenoenabled");
entity.retorderno = row.IsNull("retorderno") ? 0 : row.Field <int>("retorderno");
entity.retordernoenabled = row.Field <bool>("retordernoenabled");
entity.retordersuf = row.IsNull("retordersuf") ? 0 : row.Field <int>("retordersuf");
entity.retordersufenabled = row.Field <bool>("retordersufenabled");
entity.returntype = row.IsNull("returntype") ? string.Empty : row.Field <string>("returntype");
entity.stkunit = row.IsNull("stkunit") ? string.Empty : row.Field <string>("stkunit");
entity.usagefl = row.Field <bool>("usagefl");
entity.warrantymsg = row.IsNull("warrantymsg") ? string.Empty : row.Field <string>("warrantymsg");
entity.warrexchgfl = row.Field <bool>("warrexchgfl");
entity.warrtag = row.IsNull("warrtag") ? string.Empty : row.Field <string>("warrtag");
entity.ehfaddonno = row.IsNull("ehfaddonno") ? 0 : row.Field <int>("ehfaddonno");
entity.ehfamt = row.IsNull("ehfamt") ? decimal.Zero : row.Field <decimal>("ehfamt");
entity.ehfexemptamt = row.IsNull("ehfexemptamt") ? decimal.Zero : row.Field <decimal>("ehfexemptamt");
entity.userfield = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield");
entity.addswoptprodfl = row.Field <bool>("addswoptprodfl");
entity.cCallMode = row.IsNull("cCallMode") ? string.Empty : row.Field <string>("cCallMode");
entity.cCoreRtnTy = row.IsNull("cCoreRtnTy") ? string.Empty : row.Field <string>("cCoreRtnTy");
entity.cMaintModeL = row.IsNull("cMaintModeL") ? string.Empty : row.Field <string>("cMaintModeL");
entity.cProd = row.IsNull("cProd") ? string.Empty : row.Field <string>("cProd");
entity.cSerLotType = row.IsNull("cSerLotType") ? string.Empty : row.Field <string>("cSerLotType");
entity.cSpecNSType = row.IsNull("cSpecNSType") ? string.Empty : row.Field <string>("cSpecNSType");
entity.cUnit = row.IsNull("cUnit") ? string.Empty : row.Field <string>("cUnit");
entity.cWarrantyCd = row.IsNull("cWarrantyCd") ? string.Empty : row.Field <string>("cWarrantyCd");
entity.dConv = row.IsNull("dConv") ? decimal.Zero : row.Field <decimal>("dConv");
entity.dQtyOrd = row.IsNull("dQtyOrd") ? decimal.Zero : row.Field <decimal>("dQtyOrd");
entity.dVendno = row.IsNull("dVendno") ? decimal.Zero : row.Field <decimal>("dVendno");
entity.iOrderAltNo = row.IsNull("iOrderAltNo") ? 0 : row.Field <int>("iOrderAltNo");
entity.iRepLineNo = row.IsNull("iRepLineNo") ? 0 : row.Field <int>("iRepLineNo");
entity.iRepOrdno = row.IsNull("iRepOrdno") ? 0 : row.Field <int>("iRepOrdno");
entity.iRepOrdSuf = row.IsNull("iRepOrdSuf") ? 0 : row.Field <int>("iRepOrdSuf");
entity.iShipfmno = row.IsNull("iShipfmno") ? 0 : row.Field <int>("iShipfmno");
entity.lKitfl = row.Field <bool>("lKitfl");
entity.lRemanCore = row.Field <bool>("lRemanCore");
entity.lRetOrdLkupfl = row.Field <bool>("lRetOrdLkupfl");
entity.lTallyfl = row.Field <bool>("lTallyfl");
entity.dVVendno = row.IsNull("dVVendno") ? decimal.Zero : row.Field <decimal>("dVVendno");
entity.cVShipfmno = row.IsNull("cVShipfmno") ? string.Empty : row.Field <string>("cVShipfmno");
entity.cVName = row.IsNull("cVName") ? string.Empty : row.Field <string>("cVName");
entity.cVAddr1 = row.IsNull("cVAddr1") ? string.Empty : row.Field <string>("cVAddr1");
entity.cVAddr2 = row.IsNull("cVAddr2") ? string.Empty : row.Field <string>("cVAddr2");
entity.cVAddr3 = row.IsNull("cVAddr3") ? string.Empty : row.Field <string>("cVAddr3");
entity.cVCity = row.IsNull("cVCity") ? string.Empty : row.Field <string>("cVCity");
entity.cVState = row.IsNull("cVState") ? string.Empty : row.Field <string>("cVState");
entity.cVZipcd = row.IsNull("cVZipcd") ? string.Empty : row.Field <string>("cVZipcd");
entity.lVFOBfl = row.Field <bool>("lVFOBfl");
entity.lVConfirmfl = row.Field <bool>("lVConfirmfl");
entity.cVShipviaty = row.IsNull("cVShipviaty") ? string.Empty : row.Field <string>("cVShipviaty");
entity.dVDuedt = row.Field <DateTime?>("dVDuedt");
entity.lVPOWTIntfl = row.Field <bool>("lVPOWTIntfl");
entity.cVOrderType = row.IsNull("cVOrderType") ? string.Empty : row.Field <string>("cVOrderType");
entity.vCommentfl = row.Field <bool>("v-commentfl");
entity.vendretauth = row.IsNull("vendretauth") ? string.Empty : row.Field <string>("vendretauth");
return(entity);
}