/// <summary> /// Update a database row from a class /// </summary> public static void UpdateRowFromLoadexcptreceiptsttresults(ref DataRow row, Loadexcptreceiptsttresults entity) { row.SetField("receiptdt", entity.receiptdt); row.SetField("pono", entity.pono); row.SetField("posuf", entity.posuf); row.SetField("lineno", entity.lineno); row.SetField("rcvnetavl", entity.rcvnetavl); row.SetField("rcvsafety", entity.rcvsafety); row.SetField("leadtime", entity.leadtime); row.SetField("ignoreltfl", entity.ignoreltfl); row.SetField("safetypct", entity.safetypct); row.SetField("qtyord", entity.qtyord); row.SetField("qtyrcv", entity.qtyrcv); row.SetField("unit", entity.unit); row.SetField("qtycosted", entity.qtycosted); row.SetField("netamt", entity.netamt); row.SetField("netrcv", entity.netrcv); row.SetField("enterdt", entity.enterdt); row.SetField("userfield", entity.userfield); }
public static Loadexcptreceiptsttresults BuildLoadexcptreceiptsttresultsFromRow(DataRow row) { Loadexcptreceiptsttresults entity = new Loadexcptreceiptsttresults(); entity.receiptdt = row.Field <DateTime?>("receiptdt"); entity.pono = row.IsNull("pono") ? 0 : row.Field <int>("pono"); entity.posuf = row.IsNull("posuf") ? 0 : row.Field <int>("posuf"); entity.lineno = row.IsNull("lineno") ? 0 : row.Field <int>("lineno"); entity.rcvnetavl = row.IsNull("rcvnetavl") ? decimal.Zero : row.Field <decimal>("rcvnetavl"); entity.rcvsafety = row.IsNull("rcvsafety") ? decimal.Zero : row.Field <decimal>("rcvsafety"); entity.leadtime = row.IsNull("leadtime") ? 0 : row.Field <int>("leadtime"); entity.ignoreltfl = row.Field <bool>("ignoreltfl"); entity.safetypct = row.IsNull("safetypct") ? decimal.Zero : row.Field <decimal>("safetypct"); entity.qtyord = row.IsNull("qtyord") ? decimal.Zero : row.Field <decimal>("qtyord"); entity.qtyrcv = row.IsNull("qtyrcv") ? decimal.Zero : row.Field <decimal>("qtyrcv"); entity.unit = row.IsNull("unit") ? string.Empty : row.Field <string>("unit"); entity.qtycosted = row.IsNull("qtycosted") ? decimal.Zero : row.Field <decimal>("qtycosted"); entity.netamt = row.IsNull("netamt") ? decimal.Zero : row.Field <decimal>("netamt"); entity.netrcv = row.IsNull("netrcv") ? decimal.Zero : row.Field <decimal>("netrcv"); entity.enterdt = row.Field <DateTime?>("enterdt"); entity.userfield = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield"); return(entity); }