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());
}
