/// <summary>
/// Update a database row from a class
/// </summary>
public static void UpdateRowFromOeifsearchresults(ref DataRow row, Oeifsearchresults entity)
{
row.SetField("orderno", entity.orderno);
row.SetField("ordersuf", entity.ordersuf);
row.SetField("fulfillmentstgcd", entity.fulfillmentstgcd);
row.SetField("stagecd", entity.stagecd);
row.SetField("custno", entity.custno);
row.SetField("custnonm", entity.custnonm);
row.SetField("shipto", entity.shipto);
row.SetField("shiptonm", entity.shiptonm);
row.SetField("reqshipdt", entity.reqshipdt);
row.SetField("promisedt", entity.promisedt);
row.SetField("fulfillmentbillcd", entity.fulfillmentbillcd);
row.SetField("totqtyord", entity.totqtyord);
row.SetField("totqtyship", entity.totqtyship);
row.SetField("qtypercent", entity.qtypercent);
row.SetField("totinvord", entity.totinvord);
row.SetField("totinvship", entity.totinvship);
row.SetField("invpercent", entity.invpercent);
row.SetField("releasefl", entity.releasefl);
row.SetField("consolorderno", entity.consolorderno);
row.SetField("whse", entity.whse);
row.SetField("oeehrowid", entity.oeehrowid.ToByteArray());
row.SetField("errormsg", entity.errormsg);
row.SetField("userfield", entity.userfield);
}
public static Oeifsearchresults BuildOeifsearchresultsFromRow(DataRow row)
{
Oeifsearchresults entity = new Oeifsearchresults();
entity.orderno = row.IsNull("orderno") ? 0 : row.Field <int>("orderno");
entity.ordersuf = row.IsNull("ordersuf") ? 0 : row.Field <int>("ordersuf");
entity.fulfillmentstgcd = row.IsNull("fulfillmentstgcd") ? string.Empty : row.Field <string>("fulfillmentstgcd");
entity.stagecd = row.IsNull("stagecd") ? 0 : row.Field <int>("stagecd");
entity.custno = row.IsNull("custno") ? decimal.Zero : row.Field <decimal>("custno");
entity.custnonm = row.IsNull("custnonm") ? string.Empty : row.Field <string>("custnonm");
entity.shipto = row.IsNull("shipto") ? string.Empty : row.Field <string>("shipto");
entity.shiptonm = row.IsNull("shiptonm") ? string.Empty : row.Field <string>("shiptonm");
entity.reqshipdt = row.Field <DateTime?>("reqshipdt");
entity.promisedt = row.Field <DateTime?>("promisedt");
entity.fulfillmentbillcd = row.IsNull("fulfillmentbillcd") ? string.Empty : row.Field <string>("fulfillmentbillcd");
entity.totqtyord = row.IsNull("totqtyord") ? decimal.Zero : row.Field <decimal>("totqtyord");
entity.totqtyship = row.IsNull("totqtyship") ? decimal.Zero : row.Field <decimal>("totqtyship");
entity.qtypercent = row.IsNull("qtypercent") ? decimal.Zero : row.Field <decimal>("qtypercent");
entity.totinvord = row.IsNull("totinvord") ? decimal.Zero : row.Field <decimal>("totinvord");
entity.totinvship = row.IsNull("totinvship") ? decimal.Zero : row.Field <decimal>("totinvship");
entity.invpercent = row.IsNull("invpercent") ? decimal.Zero : row.Field <decimal>("invpercent");
entity.releasefl = row.Field <bool>("releasefl");
entity.consolorderno = row.IsNull("consolorderno") ? 0 : row.Field <int>("consolorderno");
entity.whse = row.IsNull("whse") ? string.Empty : row.Field <string>("whse");
entity.oeehrowid = row.Field <byte[]>("oeehrowid").ToStringEncoded();
entity.errormsg = row.IsNull("errormsg") ? string.Empty : row.Field <string>("errormsg");
entity.userfield = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield");
return(entity);
}
