/// <summary>
/// Update a database row from a class
/// </summary>
public static void UpdateRowFromWlitmstrresults(ref DataRow row, Wlitmstrresults entity)
{
row.SetField("cono", entity.cono);
row.SetField("statustype", entity.statustype);
row.SetField("processty", entity.processty);
row.SetField("updtype", entity.updtype);
row.SetField("wletstatus", entity.wletstatus);
row.SetField("transtype", entity.transtype);
row.SetField("ordertype", entity.ordertype);
row.SetField("vendno", entity.vendno);
row.SetField("whse", entity.whse);
row.SetField("createdt", entity.createdt);
row.SetField("createtm", entity.createtm);
row.SetField("operinit", entity.operinit);
row.SetField("setno", entity.setno);
row.SetField("errorno", entity.errorno);
row.SetField("errormsg", entity.errormsg);
row.SetField("prod", entity.prod);
row.SetField("descrip", entity.descrip);
row.SetField("function", entity.function);
row.SetField("field1", entity.field1);
row.SetField("field2", entity.field2);
row.SetField("serlotty", entity.serlotty);
row.SetField("specnstype", entity.specnstype);
row.SetField("prodvendwhse", entity.prodvendwhse);
row.SetField("wlemrecid", entity.wlemrecid);
row.SetField("wlemrowid", entity.wlemrowid.ToByteArray());
row.SetField("cWLETstatus", entity.cWLETstatus);
row.SetField("cWLETstatustype", entity.cWLETstatustype);
row.SetField("cWLETProcessty", entity.cWLETProcessty);
row.SetField("cWLETOrdertype", entity.cWLETOrdertype);
row.SetField("cWLETUpdatetype", entity.cWLETUpdatetype);
row.SetField("cWLETFunction", entity.cWLETFunction);
row.SetField("cWLETTransType", entity.cWLETTransType);
row.SetField("boxqty", entity.boxqty);
row.SetField("whzone", entity.whzone);
row.SetField("casequantity", entity.casequantity);
row.SetField("palletquantity", entity.palletquantity);
row.SetField("kitbuild", entity.kitbuild);
row.SetField("weight", entity.weight);
row.SetField("icspstattype", entity.icspstattype);
row.SetField("cicspstattype", entity.cicspstattype);
row.SetField("msdsfl", entity.msdsfl);
row.SetField("length", entity.length);
row.SetField("prodcat", entity.prodcat);
row.SetField("msdssheetno", entity.msdssheetno);
row.SetField("width", entity.width);
row.SetField("unitstock", entity.unitstock);
row.SetField("height", entity.height);
row.SetField("kittype", entity.kittype);
row.SetField("cubes", entity.cubes);
row.SetField("transdt", entity.transdt);
row.SetField("transtm", entity.transtm);
row.SetField("binloc1", entity.binloc1);
row.SetField("binloc2", entity.binloc2);
row.SetField("icswstattype", entity.icswstattype);
row.SetField("cicswstattype", entity.cicswstattype);
row.SetField("upcno", entity.upcno);
row.SetField("ccontrol", entity.ccontrol);
row.SetField("vendprod", entity.vendprod);
row.SetField("bincntr", entity.bincntr);
row.SetField("category", entity.category);
row.SetField("name", entity.name);
row.SetField("shipfmno", entity.shipfmno);
row.SetField("shipfrom", entity.shipfrom);
row.SetField("address", entity.address);
row.SetField("phoneno", entity.phoneno);
row.SetField("address2", entity.address2);
row.SetField("address3", entity.address3);
row.SetField("faxphone", entity.faxphone);
row.SetField("city", entity.city);
row.SetField("state", entity.state);
row.SetField("zipcd", entity.zipcd);
row.SetField("edicode", entity.edicode);
row.SetField("country", entity.country);
row.SetField("dunsno", entity.dunsno);
row.SetField("contact", entity.contact);
row.SetField("crossref", entity.crossref);
row.SetField("crosstype", entity.crosstype);
row.SetField("unitdesc", entity.unitdesc);
row.SetField("adjusttype", entity.adjusttype);
row.SetField("inbound", entity.inbound);
row.SetField("validtrans", entity.validtrans);
row.SetField("locationreq", entity.locationreq);
row.SetField("entrydt", entity.entrydt);
row.SetField("reasonunavty", entity.reasonunavty);
row.SetField("oreasonunavty", entity.oreasonunavty);
row.SetField("onhandlabel", entity.onhandlabel);
row.SetField("onhandqty", entity.onhandqty);
row.SetField("unavailqty", entity.unavailqty);
row.SetField("memo", entity.memo);
row.SetField("qtyadjusted", entity.qtyadjusted);
row.SetField("ohlabel", entity.ohlabel);
row.SetField("adjustdesc", entity.adjustdesc);
row.SetField("curreasondesc", entity.curreasondesc);
row.SetField("oldreasondesc", entity.oldreasondesc);
row.SetField("icsouqty", entity.icsouqty);
row.SetField("stkfunction", entity.stkfunction);
row.SetField("binupdated", entity.binupdated);
row.SetField("wtno", entity.wtno);
row.SetField("cspecnstype", entity.cspecnstype);
row.SetField("lotherrecords", entity.lotherrecords);
row.SetField("userfield", entity.userfield);
}
public static Wlitmstrresults BuildWlitmstrresultsFromRow(DataRow row)
{
Wlitmstrresults entity = new Wlitmstrresults();
entity.cono = row.IsNull("cono") ? 0 : row.Field <int>("cono");
entity.statustype = row.IsNull("statustype") ? string.Empty : row.Field <string>("statustype");
entity.processty = row.IsNull("processty") ? string.Empty : row.Field <string>("processty");
entity.updtype = row.IsNull("updtype") ? string.Empty : row.Field <string>("updtype");
entity.wletstatus = row.IsNull("wletstatus") ? string.Empty : row.Field <string>("wletstatus");
entity.transtype = row.IsNull("transtype") ? string.Empty : row.Field <string>("transtype");
entity.ordertype = row.IsNull("ordertype") ? string.Empty : row.Field <string>("ordertype");
entity.vendno = row.IsNull("vendno") ? decimal.Zero : row.Field <decimal>("vendno");
entity.whse = row.IsNull("whse") ? string.Empty : row.Field <string>("whse");
entity.createdt = row.Field <DateTime?>("createdt");
entity.createtm = row.IsNull("createtm") ? string.Empty : row.Field <string>("createtm");
entity.operinit = row.IsNull("operinit") ? string.Empty : row.Field <string>("operinit");
entity.setno = row.IsNull("setno") ? string.Empty : row.Field <string>("setno");
entity.errorno = row.IsNull("errorno") ? 0 : row.Field <int>("errorno");
entity.errormsg = row.IsNull("errormsg") ? string.Empty : row.Field <string>("errormsg");
entity.prod = row.IsNull("prod") ? string.Empty : row.Field <string>("prod");
entity.descrip = row.IsNull("descrip") ? string.Empty : row.Field <string>("descrip");
entity.function = row.IsNull("function") ? string.Empty : row.Field <string>("function");
entity.field1 = row.IsNull("field1") ? string.Empty : row.Field <string>("field1");
entity.field2 = row.IsNull("field2") ? string.Empty : row.Field <string>("field2");
entity.serlotty = row.IsNull("serlotty") ? string.Empty : row.Field <string>("serlotty");
entity.specnstype = row.IsNull("specnstype") ? string.Empty : row.Field <string>("specnstype");
entity.prodvendwhse = row.IsNull("prodvendwhse") ? string.Empty : row.Field <string>("prodvendwhse");
entity.wlemrecid = row.IsNull("wlemrecid") ? 0 : row.Field <long>("wlemrecid");
entity.wlemrowid = row.Field <byte[]>("wlemrowid").ToStringEncoded();
entity.cWLETstatus = row.IsNull("cWLETstatus") ? string.Empty : row.Field <string>("cWLETstatus");
entity.cWLETstatustype = row.IsNull("cWLETstatustype") ? string.Empty : row.Field <string>("cWLETstatustype");
entity.cWLETProcessty = row.IsNull("cWLETProcessty") ? string.Empty : row.Field <string>("cWLETProcessty");
entity.cWLETOrdertype = row.IsNull("cWLETOrdertype") ? string.Empty : row.Field <string>("cWLETOrdertype");
entity.cWLETUpdatetype = row.IsNull("cWLETUpdatetype") ? string.Empty : row.Field <string>("cWLETUpdatetype");
entity.cWLETFunction = row.IsNull("cWLETFunction") ? string.Empty : row.Field <string>("cWLETFunction");
entity.cWLETTransType = row.IsNull("cWLETTransType") ? string.Empty : row.Field <string>("cWLETTransType");
entity.boxqty = row.IsNull("boxqty") ? 0 : row.Field <int>("boxqty");
entity.whzone = row.IsNull("whzone") ? string.Empty : row.Field <string>("whzone");
entity.casequantity = row.IsNull("casequantity") ? decimal.Zero : row.Field <decimal>("casequantity");
entity.palletquantity = row.IsNull("palletquantity") ? decimal.Zero : row.Field <decimal>("palletquantity");
entity.kitbuild = row.IsNull("kitbuild") ? string.Empty : row.Field <string>("kitbuild");
entity.weight = row.IsNull("weight") ? decimal.Zero : row.Field <decimal>("weight");
entity.icspstattype = row.IsNull("icspstattype") ? string.Empty : row.Field <string>("icspstattype");
entity.cicspstattype = row.IsNull("cicspstattype") ? string.Empty : row.Field <string>("cicspstattype");
entity.msdsfl = row.Field <bool>("msdsfl");
entity.length = row.IsNull("length") ? decimal.Zero : row.Field <decimal>("length");
entity.prodcat = row.IsNull("prodcat") ? string.Empty : row.Field <string>("prodcat");
entity.msdssheetno = row.IsNull("msdssheetno") ? string.Empty : row.Field <string>("msdssheetno");
entity.width = row.IsNull("width") ? decimal.Zero : row.Field <decimal>("width");
entity.unitstock = row.IsNull("unitstock") ? string.Empty : row.Field <string>("unitstock");
entity.height = row.IsNull("height") ? decimal.Zero : row.Field <decimal>("height");
entity.kittype = row.IsNull("kittype") ? string.Empty : row.Field <string>("kittype");
entity.cubes = row.IsNull("cubes") ? decimal.Zero : row.Field <decimal>("cubes");
entity.transdt = row.Field <DateTime?>("transdt");
entity.transtm = row.IsNull("transtm") ? string.Empty : row.Field <string>("transtm");
entity.binloc1 = row.IsNull("binloc1") ? string.Empty : row.Field <string>("binloc1");
entity.binloc2 = row.IsNull("binloc2") ? string.Empty : row.Field <string>("binloc2");
entity.icswstattype = row.IsNull("icswstattype") ? string.Empty : row.Field <string>("icswstattype");
entity.cicswstattype = row.IsNull("cicswstattype") ? string.Empty : row.Field <string>("cicswstattype");
entity.upcno = row.IsNull("upcno") ? string.Empty : row.Field <string>("upcno");
entity.ccontrol = row.IsNull("ccontrol") ? string.Empty : row.Field <string>("ccontrol");
entity.vendprod = row.IsNull("vendprod") ? string.Empty : row.Field <string>("vendprod");
entity.bincntr = row.IsNull("bincntr") ? string.Empty : row.Field <string>("bincntr");
entity.category = row.IsNull("category") ? string.Empty : row.Field <string>("category");
entity.name = row.IsNull("name") ? string.Empty : row.Field <string>("name");
entity.shipfmno = row.IsNull("shipfmno") ? 0 : row.Field <int>("shipfmno");
entity.shipfrom = row.IsNull("shipfrom") ? string.Empty : row.Field <string>("shipfrom");
entity.address = row.IsNull("address") ? string.Empty : row.Field <string>("address");
entity.phoneno = row.IsNull("phoneno") ? string.Empty : row.Field <string>("phoneno");
entity.address2 = row.IsNull("address2") ? string.Empty : row.Field <string>("address2");
entity.address3 = row.IsNull("address3") ? string.Empty : row.Field <string>("address3");
entity.faxphone = row.IsNull("faxphone") ? string.Empty : row.Field <string>("faxphone");
entity.city = row.IsNull("city") ? string.Empty : row.Field <string>("city");
entity.state = row.IsNull("state") ? string.Empty : row.Field <string>("state");
entity.zipcd = row.IsNull("zipcd") ? string.Empty : row.Field <string>("zipcd");
entity.edicode = row.IsNull("edicode") ? string.Empty : row.Field <string>("edicode");
entity.country = row.IsNull("country") ? string.Empty : row.Field <string>("country");
entity.dunsno = row.IsNull("dunsno") ? string.Empty : row.Field <string>("dunsno");
entity.contact = row.IsNull("contact") ? string.Empty : row.Field <string>("contact");
entity.crossref = row.IsNull("crossref") ? string.Empty : row.Field <string>("crossref");
entity.crosstype = row.IsNull("crosstype") ? string.Empty : row.Field <string>("crosstype");
entity.unitdesc = row.IsNull("unitdesc") ? string.Empty : row.Field <string>("unitdesc");
entity.adjusttype = row.IsNull("adjusttype") ? string.Empty : row.Field <string>("adjusttype");
entity.inbound = row.IsNull("inbound") ? string.Empty : row.Field <string>("inbound");
entity.validtrans = row.IsNull("validtrans") ? string.Empty : row.Field <string>("validtrans");
entity.locationreq = row.IsNull("locationreq") ? string.Empty : row.Field <string>("locationreq");
entity.entrydt = row.Field <DateTime?>("entrydt");
entity.reasonunavty = row.IsNull("reasonunavty") ? string.Empty : row.Field <string>("reasonunavty");
entity.oreasonunavty = row.IsNull("oreasonunavty") ? string.Empty : row.Field <string>("oreasonunavty");
entity.onhandlabel = row.IsNull("onhandlabel") ? string.Empty : row.Field <string>("onhandlabel");
entity.onhandqty = row.IsNull("onhandqty") ? decimal.Zero : row.Field <decimal>("onhandqty");
entity.unavailqty = row.IsNull("unavailqty") ? decimal.Zero : row.Field <decimal>("unavailqty");
entity.memo = row.IsNull("memo") ? string.Empty : row.Field <string>("memo");
entity.qtyadjusted = row.IsNull("qtyadjusted") ? decimal.Zero : row.Field <decimal>("qtyadjusted");
entity.ohlabel = row.IsNull("ohlabel") ? string.Empty : row.Field <string>("ohlabel");
entity.adjustdesc = row.IsNull("adjustdesc") ? string.Empty : row.Field <string>("adjustdesc");
entity.curreasondesc = row.IsNull("curreasondesc") ? string.Empty : row.Field <string>("curreasondesc");
entity.oldreasondesc = row.IsNull("oldreasondesc") ? string.Empty : row.Field <string>("oldreasondesc");
entity.icsouqty = row.IsNull("icsouqty") ? decimal.Zero : row.Field <decimal>("icsouqty");
entity.stkfunction = row.IsNull("stkfunction") ? string.Empty : row.Field <string>("stkfunction");
entity.binupdated = row.IsNull("binupdated") ? string.Empty : row.Field <string>("binupdated");
entity.wtno = row.IsNull("wtno") ? string.Empty : row.Field <string>("wtno");
entity.cspecnstype = row.IsNull("cspecnstype") ? string.Empty : row.Field <string>("cspecnstype");
entity.lotherrecords = row.Field <bool>("lotherrecords");
entity.userfield = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield");
return(entity);
}
