public static Ptxtransdetline BuildPtxtransdetlineFromRow(DataRow row) { Ptxtransdetline entity = new Ptxtransdetline(); entity.distpartnerid = row.IsNull("distpartnerid") ? string.Empty : row.Field <string>("distpartnerid"); entity.vendno = row.IsNull("vendno") ? decimal.Zero : row.Field <decimal>("vendno"); entity.vendnotesfl = row.IsNull("vendnotesfl") ? string.Empty : row.Field <string>("vendnotesfl"); entity.shipfmno = row.IsNull("shipfmno") ? 0 : row.Field <int>("shipfmno"); entity.distinvno = row.IsNull("distinvno") ? 0 : row.Field <int>("distinvno"); entity.distinvsuf = row.IsNull("distinvsuf") ? 0 : row.Field <int>("distinvsuf"); entity.distinvseqno = row.IsNull("distinvseqno") ? 0 : row.Field <int>("distinvseqno"); entity.distinvnotesfl = row.IsNull("distinvnotesfl") ? string.Empty : row.Field <string>("distinvnotesfl"); entity.distinvlineno = row.IsNull("distinvlineno") ? 0 : row.Field <int>("distinvlineno"); entity.distinvlinecommfl = row.IsNull("distinvlinecommfl") ? string.Empty : row.Field <string>("distinvlinecommfl"); entity.custpartnerid = row.IsNull("custpartnerid") ? string.Empty : row.Field <string>("custpartnerid"); entity.custno = row.IsNull("custno") ? decimal.Zero : row.Field <decimal>("custno"); entity.custnotesfl = row.IsNull("custnotesfl") ? string.Empty : row.Field <string>("custnotesfl"); entity.shipto = row.IsNull("shipto") ? string.Empty : row.Field <string>("shipto"); entity.shipnotesfl = row.IsNull("shipnotesfl") ? string.Empty : row.Field <string>("shipnotesfl"); entity.whse = row.IsNull("whse") ? string.Empty : row.Field <string>("whse"); entity.whsename = row.IsNull("whsename") ? string.Empty : row.Field <string>("whsename"); entity.specnstype = row.IsNull("specnstype") ? string.Empty : row.Field <string>("specnstype"); entity.shipprod = row.IsNull("shipprod") ? string.Empty : row.Field <string>("shipprod"); entity.shipprodnotesfl = row.IsNull("shipprodnotesfl") ? string.Empty : row.Field <string>("shipprodnotesfl"); entity.sellerprod = row.IsNull("sellerprod") ? string.Empty : row.Field <string>("sellerprod"); entity.buyerprod = row.IsNull("buyerprod") ? string.Empty : row.Field <string>("buyerprod"); entity.qtyord = row.IsNull("qtyord") ? decimal.Zero : row.Field <decimal>("qtyord"); entity.proddesc = row.IsNull("proddesc") ? string.Empty : row.Field <string>("proddesc"); entity.unit = row.IsNull("unit") ? string.Empty : row.Field <string>("unit"); entity.price = row.IsNull("price") ? decimal.Zero : row.Field <decimal>("price"); entity.prcunit = row.IsNull("prcunit") ? string.Empty : row.Field <string>("prcunit"); entity.netord = row.IsNull("netord") ? decimal.Zero : row.Field <decimal>("netord"); entity.netamt = row.IsNull("netamt") ? decimal.Zero : row.Field <decimal>("netamt"); entity.user1 = row.IsNull("user1") ? string.Empty : row.Field <string>("user1"); entity.user2 = row.IsNull("user2") ? string.Empty : row.Field <string>("user2"); entity.user3 = row.IsNull("user3") ? string.Empty : row.Field <string>("user3"); entity.user4 = row.IsNull("user4") ? string.Empty : row.Field <string>("user4"); entity.user5 = row.IsNull("user5") ? string.Empty : row.Field <string>("user5"); entity.user6 = row.Field <decimal?>("user6"); entity.user7 = row.Field <decimal?>("user7"); entity.user8 = row.Field <DateTime?>("user8"); entity.user9 = row.Field <DateTime?>("user9"); entity.user10 = row.IsNull("user10") ? string.Empty : row.Field <string>("user10"); entity.user11 = row.IsNull("user11") ? string.Empty : row.Field <string>("user11"); entity.user12 = row.IsNull("user12") ? string.Empty : row.Field <string>("user12"); entity.user13 = row.IsNull("user13") ? string.Empty : row.Field <string>("user13"); entity.user14 = row.IsNull("user14") ? string.Empty : row.Field <string>("user14"); entity.user15 = row.IsNull("user15") ? string.Empty : row.Field <string>("user15"); entity.user16 = row.IsNull("user16") ? string.Empty : row.Field <string>("user16"); entity.user17 = row.IsNull("user17") ? string.Empty : row.Field <string>("user17"); entity.user18 = row.IsNull("user18") ? string.Empty : row.Field <string>("user18"); entity.user19 = row.IsNull("user19") ? string.Empty : row.Field <string>("user19"); entity.user20 = row.IsNull("user20") ? string.Empty : row.Field <string>("user20"); entity.user21 = row.IsNull("user21") ? string.Empty : row.Field <string>("user21"); entity.user22 = row.IsNull("user22") ? string.Empty : row.Field <string>("user22"); entity.user23 = row.IsNull("user23") ? string.Empty : row.Field <string>("user23"); entity.user24 = row.IsNull("user24") ? string.Empty : row.Field <string>("user24"); entity.rwidptxtransln = row.Field <byte[]>("rwidptxtransln").ToStringEncoded(); return(entity); }
/// <summary> /// Update a database row from a class /// </summary> public static void UpdateRowFromPtxtransdetline(ref DataRow row, Ptxtransdetline entity) { row.SetField("distpartnerid", entity.distpartnerid); row.SetField("vendno", entity.vendno); row.SetField("vendnotesfl", entity.vendnotesfl); row.SetField("shipfmno", entity.shipfmno); row.SetField("distinvno", entity.distinvno); row.SetField("distinvsuf", entity.distinvsuf); row.SetField("distinvseqno", entity.distinvseqno); row.SetField("distinvnotesfl", entity.distinvnotesfl); row.SetField("distinvlineno", entity.distinvlineno); row.SetField("distinvlinecommfl", entity.distinvlinecommfl); row.SetField("custpartnerid", entity.custpartnerid); row.SetField("custno", entity.custno); row.SetField("custnotesfl", entity.custnotesfl); row.SetField("shipto", entity.shipto); row.SetField("shipnotesfl", entity.shipnotesfl); row.SetField("whse", entity.whse); row.SetField("whsename", entity.whsename); row.SetField("specnstype", entity.specnstype); row.SetField("shipprod", entity.shipprod); row.SetField("shipprodnotesfl", entity.shipprodnotesfl); row.SetField("sellerprod", entity.sellerprod); row.SetField("buyerprod", entity.buyerprod); row.SetField("qtyord", entity.qtyord); row.SetField("proddesc", entity.proddesc); row.SetField("unit", entity.unit); row.SetField("price", entity.price); row.SetField("prcunit", entity.prcunit); row.SetField("netord", entity.netord); row.SetField("netamt", entity.netamt); 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("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("user16", entity.user16); row.SetField("user17", entity.user17); row.SetField("user18", entity.user18); row.SetField("user19", entity.user19); 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("rwidptxtransln", entity.rwidptxtransln.ToByteArray()); }