public static Poordercopy BuildPoordercopyFromRow(DataRow row) { Poordercopy entity = new Poordercopy(); entity.btncancelSensitive = row.Field <bool>("btncancel-sensitive"); entity.btncopySensitive = row.Field <bool>("btncopy-sensitive"); entity.btnexitlabel = row.IsNull("btnexitlabel") ? string.Empty : row.Field <string>("btnexitlabel"); entity.btncontinueSensitive = row.Field <bool>("btncontinue-sensitive"); entity.billtowhseSensitive = row.Field <bool>("billtowhse-sensitive"); entity.buyerSensitive = row.Field <bool>("buyer-sensitive"); entity.cpycommentsflSensitive = row.Field <bool>("cpycommentsfl-sensitive"); entity.cpyncnrflSensitive = row.Field <bool>("cpyncnrfl-sensitive"); entity.cpynotesflSensitive = row.Field <bool>("cpynotesfl-sensitive"); entity.ponoSensitive = row.Field <bool>("pono-sensitive"); entity.prodlineSensitive = row.Field <bool>("prodline-sensitive"); entity.repriceflSensitive = row.Field <bool>("repricefl-sensitive"); entity.saveflSensitive = row.Field <bool>("savefl-sensitive"); entity.shipfmnoSensitive = row.Field <bool>("shipfmno-sensitive"); entity.shiptowhseSensitive = row.Field <bool>("shiptowhse-sensitive"); entity.converttoSensitive = row.Field <bool>("convertto-sensitive"); entity.vendnoSensitive = row.Field <bool>("vendno-sensitive"); entity.saveflHidden = row.Field <bool>("savefl-hidden"); entity.billtowhse = row.IsNull("billtowhse") ? string.Empty : row.Field <string>("billtowhse"); entity.buyer = row.IsNull("buyer") ? string.Empty : row.Field <string>("buyer"); entity.cpycommentsfl = row.Field <bool>("cpycommentsfl"); entity.cpyncnrfl = row.Field <bool>("cpyncnrfl"); entity.cpynotesfl = row.Field <bool>("cpynotesfl"); entity.convertto = row.IsNull("convertto") ? string.Empty : row.Field <string>("convertto"); entity.crreasonty = row.IsNull("crreasonty") ? string.Empty : row.Field <string>("crreasonty"); entity.newpono = row.IsNull("newpono") ? 0 : row.Field <int>("newpono"); entity.newponodesc = row.IsNull("newponodesc") ? string.Empty : row.Field <string>("newponodesc"); entity.newponorowid = row.Field <byte[]>("newponorowid").ToStringEncoded(); entity.newponotesfl = row.IsNull("newponotesfl") ? string.Empty : row.Field <string>("newponotesfl"); entity.pono = row.IsNull("pono") ? 0 : row.Field <int>("pono"); entity.posuf = row.IsNull("posuf") ? 0 : row.Field <int>("posuf"); entity.prodline = row.IsNull("prodline") ? string.Empty : row.Field <string>("prodline"); entity.refer = row.IsNull("refer") ? string.Empty : row.Field <string>("refer"); entity.repricefl = row.Field <bool>("repricefl"); entity.savefl = row.Field <bool>("savefl"); entity.shipfmno = row.IsNull("shipfmno") ? 0 : row.Field <int>("shipfmno"); entity.shiptowhse = row.IsNull("shiptowhse") ? string.Empty : row.Field <string>("shiptowhse"); entity.stagedesc = row.IsNull("stagedesc") ? string.Empty : row.Field <string>("stagedesc"); entity.transtype = row.IsNull("transtype") ? string.Empty : row.Field <string>("transtype"); entity.vendno = row.IsNull("vendno") ? decimal.Zero : row.Field <decimal>("vendno"); entity.cCountry = row.IsNull("cCountry") ? string.Empty : row.Field <string>("cCountry"); entity.cHomeWhse = row.IsNull("cHomeWhse") ? string.Empty : row.Field <string>("cHomeWhse"); entity.cTaxInterfaceTy = row.IsNull("cTaxInterfaceTy") ? string.Empty : row.Field <string>("cTaxInterfaceTy"); entity.cTaxMethodTy = row.IsNull("cTaxMethodTy") ? string.Empty : row.Field <string>("cTaxMethodTy"); entity.iSecure = row.IsNull("iSecure") ? 0 : row.Field <int>("iSecure"); entity.lGLDivFl = row.Field <bool>("lGLDivFl"); entity.lHomeWhseFl = row.Field <bool>("lHomeWhseFl"); entity.lPOResaleFl = row.Field <bool>("lPOResaleFl"); entity.lVendPostFl = row.Field <bool>("lVendPostFl"); entity.userfield = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield"); return(entity); }
/// <summary> /// Update a database row from a class /// </summary> public static void UpdateRowFromPoordercopy(ref DataRow row, Poordercopy entity) { row.SetField("btncancel-sensitive", entity.btncancelSensitive); row.SetField("btncopy-sensitive", entity.btncopySensitive); row.SetField("btnexitlabel", entity.btnexitlabel); row.SetField("btncontinue-sensitive", entity.btncontinueSensitive); row.SetField("billtowhse-sensitive", entity.billtowhseSensitive); row.SetField("buyer-sensitive", entity.buyerSensitive); row.SetField("cpycommentsfl-sensitive", entity.cpycommentsflSensitive); row.SetField("cpyncnrfl-sensitive", entity.cpyncnrflSensitive); row.SetField("cpynotesfl-sensitive", entity.cpynotesflSensitive); row.SetField("pono-sensitive", entity.ponoSensitive); row.SetField("prodline-sensitive", entity.prodlineSensitive); row.SetField("repricefl-sensitive", entity.repriceflSensitive); row.SetField("savefl-sensitive", entity.saveflSensitive); row.SetField("shipfmno-sensitive", entity.shipfmnoSensitive); row.SetField("shiptowhse-sensitive", entity.shiptowhseSensitive); row.SetField("convertto-sensitive", entity.converttoSensitive); row.SetField("vendno-sensitive", entity.vendnoSensitive); row.SetField("savefl-hidden", entity.saveflHidden); row.SetField("billtowhse", entity.billtowhse); row.SetField("buyer", entity.buyer); row.SetField("cpycommentsfl", entity.cpycommentsfl); row.SetField("cpyncnrfl", entity.cpyncnrfl); row.SetField("cpynotesfl", entity.cpynotesfl); row.SetField("convertto", entity.convertto); row.SetField("crreasonty", entity.crreasonty); row.SetField("newpono", entity.newpono); row.SetField("newponodesc", entity.newponodesc); row.SetField("newponorowid", entity.newponorowid.ToByteArray()); row.SetField("newponotesfl", entity.newponotesfl); row.SetField("pono", entity.pono); row.SetField("posuf", entity.posuf); row.SetField("prodline", entity.prodline); row.SetField("refer", entity.refer); row.SetField("repricefl", entity.repricefl); row.SetField("savefl", entity.savefl); row.SetField("shipfmno", entity.shipfmno); row.SetField("shiptowhse", entity.shiptowhse); row.SetField("stagedesc", entity.stagedesc); row.SetField("transtype", entity.transtype); row.SetField("vendno", entity.vendno); row.SetField("cCountry", entity.cCountry); row.SetField("cHomeWhse", entity.cHomeWhse); row.SetField("cTaxInterfaceTy", entity.cTaxInterfaceTy); row.SetField("cTaxMethodTy", entity.cTaxMethodTy); row.SetField("iSecure", entity.iSecure); row.SetField("lGLDivFl", entity.lGLDivFl); row.SetField("lHomeWhseFl", entity.lHomeWhseFl); row.SetField("lPOResaleFl", entity.lPOResaleFl); row.SetField("lVendPostFl", entity.lVendPostFl); row.SetField("userfield", entity.userfield); }