/// <summary>
/// Update a database row from a class
/// </summary>
public static void UpdateRowFromOesourcing(ref DataRow row, Oesourcing entity)
{
row.SetField("orderno", entity.orderno);
row.SetField("ordersuf", entity.ordersuf);
row.SetField("lineno", entity.lineno);
row.SetField("runmode", entity.runmode);
row.SetField("vendno", entity.vendno);
row.SetField("ordertype", entity.ordertype);
row.SetField("shipfmno", entity.shipfmno);
row.SetField("poduedate", entity.poduedate);
row.SetField("poshipvia", entity.poshipvia);
row.SetField("pofrttermscd", entity.pofrttermscd);
row.SetField("potransferloc", entity.potransferloc);
row.SetField("pofrtbillacct", entity.pofrtbillacct);
row.SetField("fob", entity.fob);
row.SetField("orderaltno", entity.orderaltno);
row.SetField("confirm", entity.confirm);
row.SetField("backordertype", entity.backordertype);
row.SetField("wtwhse", entity.wtwhse);
row.SetField("wtduedate", entity.wtduedate);
row.SetField("wtshipvia", entity.wtshipvia);
row.SetField("copycommentfl", entity.copycommentfl);
row.SetField("vawhse", entity.vawhse);
row.SetField("vano", entity.vano);
row.SetField("vasuf", entity.vasuf);
row.SetField("manualname", entity.manualname);
row.SetField("manualaddr1", entity.manualaddr1);
row.SetField("manualaddr2", entity.manualaddr2);
row.SetField("manualaddr3", entity.manualaddr3);
row.SetField("manualcity", entity.manualcity);
row.SetField("manualstate", entity.manualstate);
row.SetField("manualzipcd", entity.manualzipcd);
}
public static Oesourcing BuildOesourcingFromRow(DataRow row)
{
Oesourcing entity = new Oesourcing();
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.runmode = row.IsNull("runmode") ? string.Empty : row.Field <string>("runmode");
entity.vendno = row.IsNull("vendno") ? decimal.Zero : row.Field <decimal>("vendno");
entity.ordertype = row.IsNull("ordertype") ? string.Empty : row.Field <string>("ordertype");
entity.shipfmno = row.IsNull("shipfmno") ? 0 : row.Field <int>("shipfmno");
entity.poduedate = row.Field <DateTime?>("poduedate");
entity.poshipvia = row.IsNull("poshipvia") ? string.Empty : row.Field <string>("poshipvia");
entity.pofrttermscd = row.IsNull("pofrttermscd") ? string.Empty : row.Field <string>("pofrttermscd");
entity.potransferloc = row.IsNull("potransferloc") ? string.Empty : row.Field <string>("potransferloc");
entity.pofrtbillacct = row.IsNull("pofrtbillacct") ? string.Empty : row.Field <string>("pofrtbillacct");
entity.fob = row.Field <bool>("fob");
entity.orderaltno = row.IsNull("orderaltno") ? 0 : row.Field <int>("orderaltno");
entity.confirm = row.Field <bool>("confirm");
entity.backordertype = row.IsNull("backordertype") ? string.Empty : row.Field <string>("backordertype");
entity.wtwhse = row.IsNull("wtwhse") ? string.Empty : row.Field <string>("wtwhse");
entity.wtduedate = row.Field <DateTime?>("wtduedate");
entity.wtshipvia = row.IsNull("wtshipvia") ? string.Empty : row.Field <string>("wtshipvia");
entity.copycommentfl = row.Field <bool>("copycommentfl");
entity.vawhse = row.IsNull("vawhse") ? string.Empty : row.Field <string>("vawhse");
entity.vano = row.IsNull("vano") ? 0 : row.Field <int>("vano");
entity.vasuf = row.IsNull("vasuf") ? 0 : row.Field <int>("vasuf");
entity.manualname = row.IsNull("manualname") ? string.Empty : row.Field <string>("manualname");
entity.manualaddr1 = row.IsNull("manualaddr1") ? string.Empty : row.Field <string>("manualaddr1");
entity.manualaddr2 = row.IsNull("manualaddr2") ? string.Empty : row.Field <string>("manualaddr2");
entity.manualaddr3 = row.IsNull("manualaddr3") ? string.Empty : row.Field <string>("manualaddr3");
entity.manualcity = row.IsNull("manualcity") ? string.Empty : row.Field <string>("manualcity");
entity.manualstate = row.IsNull("manualstate") ? string.Empty : row.Field <string>("manualstate");
entity.manualzipcd = row.IsNull("manualzipcd") ? string.Empty : row.Field <string>("manualzipcd");
return(entity);
}