/// <summary>
/// Update a database row from a class
/// </summary>
public static void UpdateRowFromPdecupdpricecostcriteria(ref DataRow row, Pdecupdpricecostcriteria entity)
{
row.SetField("prod", entity.prod);
row.SetField("notesfl", entity.notesfl);
row.SetField("descrip1", entity.descrip1);
row.SetField("descrip2", entity.descrip2);
row.SetField("whse", entity.whse);
row.SetField("homewhsefl", entity.homewhsefl);
row.SetField("homewhse", entity.homewhse);
row.SetField("pricetxt", entity.pricetxt);
row.SetField("effectdt", entity.effectdt);
row.SetField("basetype", entity.basetype);
row.SetField("basetypedesc", entity.basetypedesc);
row.SetField("baseprice", entity.baseprice);
row.SetField("basepricenew", entity.basepricenew);
row.SetField("basepriceorig", entity.basepriceorig);
row.SetField("basedt", entity.basedt);
row.SetField("listtype", entity.listtype);
row.SetField("listtypedesc", entity.listtypedesc);
row.SetField("listprice", entity.listprice);
row.SetField("listpricenew", entity.listpricenew);
row.SetField("listpriceorig", entity.listpriceorig);
row.SetField("listdt", entity.listdt);
row.SetField("repltype", entity.repltype);
row.SetField("repltypedesc", entity.repltypedesc);
row.SetField("replcost", entity.replcost);
row.SetField("replcostnew", entity.replcostnew);
row.SetField("replcostorig", entity.replcostorig);
row.SetField("repldt", entity.repldt);
row.SetField("stndtype", entity.stndtype);
row.SetField("stndtypedesc", entity.stndtypedesc);
row.SetField("stndcost", entity.stndcost);
row.SetField("stndcostnew", entity.stndcostnew);
row.SetField("stndcostorig", entity.stndcostorig);
row.SetField("stnddt", entity.stnddt);
row.SetField("lastcost", entity.lastcost);
row.SetField("th1", entity.th1);
row.SetField("th2", entity.th2);
row.SetField("th3", entity.th3);
row.SetField("pround", entity.pround);
row.SetField("prounddesc", entity.prounddesc);
row.SetField("ptarget", entity.ptarget);
row.SetField("ptargetdesc", entity.ptargetdesc);
row.SetField("pexactrnd", entity.pexactrnd);
row.SetField("pricetype", entity.pricetype);
row.SetField("newdt", entity.newdt);
row.SetField("icglcost", entity.icglcost);
row.SetField("icglbsty", entity.icglbsty);
row.SetField("updglty", entity.updglty);
row.SetField("calcord1", entity.calcord1);
row.SetField("calcord2", entity.calcord2);
row.SetField("calcord3", entity.calcord3);
row.SetField("msgtxt1", entity.msgtxt1);
row.SetField("msgtxt2", entity.msgtxt2);
row.SetField("msgtxt3", entity.msgtxt3);
row.SetField("msgtxt4", entity.msgtxt4);
row.SetField("ourproc", entity.ourproc);
row.SetField("callproc", entity.callproc);
row.SetField("secure", entity.secure);
row.SetField("gldivfl", entity.gldivfl);
row.SetField("divno", entity.divno);
row.SetField("icincaddsm", entity.icincaddsm);
row.SetField("icincaddgl", entity.icincaddgl);
row.SetField("icscupdt", entity.icscupdt);
row.SetField("jrnlno", entity.jrnlno);
row.SetField("userfield", entity.userfield);
}
public static Pdecupdpricecostcriteria BuildPdecupdpricecostcriteriaFromRow(DataRow row)
{
Pdecupdpricecostcriteria entity = new Pdecupdpricecostcriteria();
entity.prod = row.IsNull("prod") ? string.Empty : row.Field <string>("prod");
entity.notesfl = row.IsNull("notesfl") ? string.Empty : row.Field <string>("notesfl");
entity.descrip1 = row.IsNull("descrip1") ? string.Empty : row.Field <string>("descrip1");
entity.descrip2 = row.IsNull("descrip2") ? string.Empty : row.Field <string>("descrip2");
entity.whse = row.IsNull("whse") ? string.Empty : row.Field <string>("whse");
entity.homewhsefl = row.Field <bool>("homewhsefl");
entity.homewhse = row.IsNull("homewhse") ? string.Empty : row.Field <string>("homewhse");
entity.pricetxt = row.IsNull("pricetxt") ? string.Empty : row.Field <string>("pricetxt");
entity.effectdt = row.Field <DateTime?>("effectdt");
entity.basetype = row.IsNull("basetype") ? string.Empty : row.Field <string>("basetype");
entity.basetypedesc = row.IsNull("basetypedesc") ? string.Empty : row.Field <string>("basetypedesc");
entity.baseprice = row.IsNull("baseprice") ? decimal.Zero : row.Field <decimal>("baseprice");
entity.basepricenew = row.IsNull("basepricenew") ? decimal.Zero : row.Field <decimal>("basepricenew");
entity.basepriceorig = row.IsNull("basepriceorig") ? decimal.Zero : row.Field <decimal>("basepriceorig");
entity.basedt = row.Field <DateTime?>("basedt");
entity.listtype = row.IsNull("listtype") ? string.Empty : row.Field <string>("listtype");
entity.listtypedesc = row.IsNull("listtypedesc") ? string.Empty : row.Field <string>("listtypedesc");
entity.listprice = row.IsNull("listprice") ? decimal.Zero : row.Field <decimal>("listprice");
entity.listpricenew = row.IsNull("listpricenew") ? decimal.Zero : row.Field <decimal>("listpricenew");
entity.listpriceorig = row.IsNull("listpriceorig") ? decimal.Zero : row.Field <decimal>("listpriceorig");
entity.listdt = row.Field <DateTime?>("listdt");
entity.repltype = row.IsNull("repltype") ? string.Empty : row.Field <string>("repltype");
entity.repltypedesc = row.IsNull("repltypedesc") ? string.Empty : row.Field <string>("repltypedesc");
entity.replcost = row.IsNull("replcost") ? decimal.Zero : row.Field <decimal>("replcost");
entity.replcostnew = row.IsNull("replcostnew") ? decimal.Zero : row.Field <decimal>("replcostnew");
entity.replcostorig = row.IsNull("replcostorig") ? decimal.Zero : row.Field <decimal>("replcostorig");
entity.repldt = row.Field <DateTime?>("repldt");
entity.stndtype = row.IsNull("stndtype") ? string.Empty : row.Field <string>("stndtype");
entity.stndtypedesc = row.IsNull("stndtypedesc") ? string.Empty : row.Field <string>("stndtypedesc");
entity.stndcost = row.IsNull("stndcost") ? decimal.Zero : row.Field <decimal>("stndcost");
entity.stndcostnew = row.IsNull("stndcostnew") ? decimal.Zero : row.Field <decimal>("stndcostnew");
entity.stndcostorig = row.IsNull("stndcostorig") ? decimal.Zero : row.Field <decimal>("stndcostorig");
entity.stnddt = row.Field <DateTime?>("stnddt");
entity.lastcost = row.IsNull("lastcost") ? decimal.Zero : row.Field <decimal>("lastcost");
entity.th1 = row.IsNull("th1") ? string.Empty : row.Field <string>("th1");
entity.th2 = row.IsNull("th2") ? string.Empty : row.Field <string>("th2");
entity.th3 = row.IsNull("th3") ? string.Empty : row.Field <string>("th3");
entity.pround = row.IsNull("pround") ? string.Empty : row.Field <string>("pround");
entity.prounddesc = row.IsNull("prounddesc") ? string.Empty : row.Field <string>("prounddesc");
entity.ptarget = row.IsNull("ptarget") ? 0 : row.Field <int>("ptarget");
entity.ptargetdesc = row.IsNull("ptargetdesc") ? string.Empty : row.Field <string>("ptargetdesc");
entity.pexactrnd = row.IsNull("pexactrnd") ? decimal.Zero : row.Field <decimal>("pexactrnd");
entity.pricetype = row.IsNull("pricetype") ? string.Empty : row.Field <string>("pricetype");
entity.newdt = row.Field <DateTime?>("newdt");
entity.icglcost = row.IsNull("icglcost") ? string.Empty : row.Field <string>("icglcost");
entity.icglbsty = row.IsNull("icglbsty") ? 0 : row.Field <int>("icglbsty");
entity.updglty = row.IsNull("updglty") ? string.Empty : row.Field <string>("updglty");
entity.calcord1 = row.IsNull("calcord1") ? string.Empty : row.Field <string>("calcord1");
entity.calcord2 = row.IsNull("calcord2") ? string.Empty : row.Field <string>("calcord2");
entity.calcord3 = row.IsNull("calcord3") ? string.Empty : row.Field <string>("calcord3");
entity.msgtxt1 = row.IsNull("msgtxt1") ? string.Empty : row.Field <string>("msgtxt1");
entity.msgtxt2 = row.IsNull("msgtxt2") ? string.Empty : row.Field <string>("msgtxt2");
entity.msgtxt3 = row.IsNull("msgtxt3") ? string.Empty : row.Field <string>("msgtxt3");
entity.msgtxt4 = row.IsNull("msgtxt4") ? string.Empty : row.Field <string>("msgtxt4");
entity.ourproc = row.IsNull("ourproc") ? string.Empty : row.Field <string>("ourproc");
entity.callproc = row.IsNull("callproc") ? string.Empty : row.Field <string>("callproc");
entity.secure = row.IsNull("secure") ? 0 : row.Field <int>("secure");
entity.gldivfl = row.Field <bool>("gldivfl");
entity.divno = row.IsNull("divno") ? 0 : row.Field <int>("divno");
entity.icincaddsm = row.Field <bool>("icincaddsm");
entity.icincaddgl = row.Field <bool>("icincaddgl");
entity.icscupdt = row.Field <bool>("icscupdt");
entity.jrnlno = row.IsNull("jrnlno") ? 0 : row.Field <int>("jrnlno");
entity.userfield = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield");
return(entity);
}