/// <summary> /// Build a minimal row from a class (key fields only) /// </summary> public static void BuildMinimalRow(ref DataRow row, SweljBase entity) { row.SetField("cono", entity.cono); row.SetField("origtech", entity.origtech); row.SetField("seqno", entity.seqno); row.SetField("systemindt", entity.systemindt); row.SetField("systemintm", entity.systemintm); row.SetField("transseqno", entity.transseqno); row.SetField("sweljRowID", entity.rowID.ToByteArray()); }
/// <summary> /// Update a database row from a class /// </summary> public static void UpdateRowFromSweljBase(ref DataRow row, SweljBase entity) { row.SetField("activefl", entity.activefl); row.SetField("closedfl", entity.closedfl); row.SetField("comment", entity.comment); row.SetField("cono", entity.cono); row.SetField("deptno", entity.deptno); row.SetField("dthrs", entity.dthrs); row.SetField("emptype", entity.emptype); row.SetField("endofdayfl", entity.endofdayfl); row.SetField("errortype1", entity.errortype1); row.SetField("errortype2", entity.errortype2); row.SetField("errortype3", entity.errortype3); row.SetField("errortype4", entity.errortype4); row.SetField("errortype5", entity.errortype5); row.SetField("errortype6", entity.errortype6); row.SetField("errortype7", entity.errortype7); row.SetField("errortype8", entity.errortype8); row.SetField("errortype9", entity.errortype9); row.SetField("errortype10", entity.errortype10); row.SetField("errortype11", entity.errortype11); row.SetField("errortype12", entity.errortype12); row.SetField("errortype13", entity.errortype13); row.SetField("errortype14", entity.errortype14); row.SetField("errortype15", entity.errortype15); row.SetField("errortype16", entity.errortype16); row.SetField("errortype17", entity.errortype17); row.SetField("errortype18", entity.errortype18); row.SetField("errortype19", entity.errortype19); row.SetField("errortype20", entity.errortype20); row.SetField("fromseqno", entity.fromseqno); row.SetField("hrstype", entity.hrstype); row.SetField("indt", entity.indt); row.SetField("intjobtype", entity.intjobtype); row.SetField("intm", entity.intm); row.SetField("lineno", entity.lineno); row.SetField("mileage", entity.mileage); row.SetField("origtech", entity.origtech); row.SetField("othrs", entity.othrs); row.SetField("ourproc", entity.ourproc); row.SetField("outdt", entity.outdt); row.SetField("outtm", entity.outtm); row.SetField("overridehrs", entity.overridehrs); row.SetField("payrollcost", entity.payrollcost); row.SetField("prsentdt", entity.prsentdt); row.SetField("rateerrorty1", entity.rateerrorty1); row.SetField("rateerrorty2", entity.rateerrorty2); row.SetField("rateerrorty3", entity.rateerrorty3); row.SetField("rateerrorty4", entity.rateerrorty4); row.SetField("rateerrorty5", entity.rateerrorty5); row.SetField("rateerrorty6", entity.rateerrorty6); row.SetField("rateerrorty7", entity.rateerrorty7); row.SetField("rateerrorty8", entity.rateerrorty8); row.SetField("rateerrorty9", entity.rateerrorty9); row.SetField("ratetype1", entity.ratetype1); row.SetField("ratetype2", entity.ratetype2); row.SetField("ratetype3", entity.ratetype3); row.SetField("ratetype4", entity.ratetype4); row.SetField("ratetype5", entity.ratetype5); row.SetField("ratetype6", entity.ratetype6); row.SetField("ratetype7", entity.ratetype7); row.SetField("ratetype8", entity.ratetype8); row.SetField("ratetype9", entity.ratetype9); row.SetField("ratetypefl1", entity.ratetypefl1); row.SetField("ratetypefl2", entity.ratetypefl2); row.SetField("ratetypefl3", entity.ratetypefl3); row.SetField("ratetypefl4", entity.ratetypefl4); row.SetField("ratetypefl5", entity.ratetypefl5); row.SetField("ratetypefl6", entity.ratetypefl6); row.SetField("ratetypefl7", entity.ratetypefl7); row.SetField("ratetypefl8", entity.ratetypefl8); row.SetField("ratetypefl9", entity.ratetypefl9); row.SetField("reasontype", entity.reasontype); row.SetField("reghrs", entity.reghrs); row.SetField("repairordno", entity.repairordno); row.SetField("repairordsuf", entity.repairordsuf); row.SetField("schedopttype", entity.schedopttype); row.SetField("seqno", entity.seqno); row.SetField("shift", entity.shift); row.SetField("statustype", entity.statustype); row.SetField("svcloc", entity.svcloc); row.SetField("systemindt", entity.systemindt); row.SetField("systemintm", entity.systemintm); row.SetField("systemoutdt", entity.systemoutdt); row.SetField("systemouttm", entity.systemouttm); row.SetField("tech", entity.tech); row.SetField("tolunchfl", entity.tolunchfl); row.SetField("tothrs", entity.tothrs); row.SetField("transseqno", entity.transseqno); row.SetField("travelhrs", entity.travelhrs); row.SetField("truckno", entity.truckno); row.SetField("whse", entity.whse); row.SetField("writeofffl", entity.writeofffl); row.SetField("operinit", entity.operinit); row.SetField("transdt", entity.transdt); row.SetField("transtm", entity.transtm); row.SetField("user1", entity.user1); row.SetField("user2", entity.user2); row.SetField("user3", entity.user3); row.SetField("user4", entity.user4); row.SetField("user5", entity.user5); row.SetField("user6", entity.user6); row.SetField("user7", entity.user7); row.SetField("user8", entity.user8); row.SetField("user9", entity.user9); row.SetField("billedtm", entity.billedtm); row.SetField("solineno", entity.solineno); row.SetField("transproc", entity.transproc); row.SetField("sweljRowID", entity.rowID.ToByteArray()); }