/// <summary> /// Build a minimal row from a class (key fields only) /// </summary> public static void BuildMinimalRow(ref DataRow row, SwehBase entity) { row.SetField("cono", entity.cono); row.SetField("repairordno", entity.repairordno); row.SetField("repairordsuf", entity.repairordsuf); row.SetField("swehRowID", entity.rowID.ToByteArray()); }
/// <summary> /// Update a database row from a class /// </summary> public static void UpdateRowFromSwehBase(ref DataRow row, SwehBase entity) { row.SetField("cono", entity.cono); 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("openinit", entity.openinit); row.SetField("whse", entity.whse); row.SetField("repairordno", entity.repairordno); row.SetField("ordtype", entity.ordtype); row.SetField("custno", entity.custno); row.SetField("shipto", entity.shipto); row.SetField("typecd", entity.typecd); row.SetField("pickupfl", entity.pickupfl); row.SetField("schdpickupdt", entity.schdpickupdt); row.SetField("pickupdt", entity.pickupdt); row.SetField("pickuptech", entity.pickuptech); row.SetField("cancelcd", entity.cancelcd); row.SetField("quotereqfl", entity.quotereqfl); row.SetField("quoteamt", entity.quoteamt); row.SetField("prioritycd", entity.prioritycd); row.SetField("stagecd", entity.stagecd); row.SetField("svcloccd", entity.svcloccd); row.SetField("contactname", entity.contactname); row.SetField("contactphone", entity.contactphone); row.SetField("compdt", entity.compdt); row.SetField("vendno", entity.vendno); row.SetField("statcomment", entity.statcomment); row.SetField("schdstartdt", entity.schdstartdt); row.SetField("srttotminutes", entity.srttotminutes); row.SetField("esttotminutes", entity.esttotminutes); row.SetField("mstrtickno", entity.mstrtickno); row.SetField("leadtech", entity.leadtech); row.SetField("slsrep", entity.slsrep); row.SetField("svcprintdt", entity.svcprintdt); row.SetField("startdt", entity.startdt); row.SetField("repairordsuf", entity.repairordsuf); row.SetField("orderno", entity.orderno); row.SetField("ordersuf", entity.ordersuf); row.SetField("billtype", entity.billtype); row.SetField("bulletinno", entity.bulletinno); row.SetField("jobtype", entity.jobtype); row.SetField("setupfl", entity.setupfl); row.SetField("splitfl", entity.splitfl); row.SetField("printdt", entity.printdt); row.SetField("delivertech", entity.delivertech); row.SetField("deliverdt", entity.deliverdt); row.SetField("deliverfl", entity.deliverfl); row.SetField("schddeliverdt", entity.schddeliverdt); row.SetField("assigntech", entity.assigntech); row.SetField("assigndt", entity.assigndt); row.SetField("user10", entity.user10); row.SetField("user11", entity.user11); row.SetField("user12", entity.user12); row.SetField("user13", entity.user13); row.SetField("user14", entity.user14); row.SetField("user15", entity.user15); row.SetField("schdcompdt", entity.schdcompdt); row.SetField("comptech", entity.comptech); row.SetField("user16", entity.user16); row.SetField("user17", entity.user17); row.SetField("user18", entity.user18); row.SetField("user19", entity.user19); row.SetField("acttotminutes", entity.acttotminutes); row.SetField("notesfl", entity.notesfl); row.SetField("oeprintfl", entity.oeprintfl); row.SetField("textfl", entity.textfl); row.SetField("problemtxt", entity.problemtxt); row.SetField("causetxt", entity.causetxt); row.SetField("workperftxt", entity.workperftxt); row.SetField("transproc", entity.transproc); row.SetField("vehicleid", entity.vehicleid); row.SetField("canceldt", entity.canceldt); row.SetField("swexaddfl1", entity.swexaddfl1); row.SetField("swexaddfl2", entity.swexaddfl2); row.SetField("swexaddfl3", entity.swexaddfl3); row.SetField("swexaddfl4", entity.swexaddfl4); row.SetField("user20", entity.user20); row.SetField("user21", entity.user21); row.SetField("user22", entity.user22); row.SetField("user23", entity.user23); row.SetField("user24", entity.user24); row.SetField("swehRowID", entity.rowID.ToByteArray()); }