/// <summary> /// Update a database row from a class /// </summary> public static void UpdateRowFromCreateictransttresults(ref DataRow row, Createictransttresults entity) { row.SetField("cICETRowId", entity.cICETRowId); row.SetField("cModule", entity.cModule); row.SetField("cName", entity.cName); row.SetField("cProd", entity.cProd); row.SetField("cSign", entity.cSign); row.SetField("cTransDesc", entity.cTransDesc); row.SetField("cTransType", entity.cTransType); row.SetField("Custno", entity.custno); row.SetField("cWhse", entity.cWhse); row.SetField("dQtyOnHand", entity.dQtyOnHand); row.SetField("dStkQtyShip", entity.dStkQtyShip); row.SetField("dtPosted", entity.dtPosted); row.SetField("iJrnlNo", entity.iJrnlNo); row.SetField("iOrderNo", entity.iOrderNo); row.SetField("iOrderSuf", entity.iOrderSuf); row.SetField("iSetNo", entity.iSetNo); row.SetField("cOrderNotes", entity.cOrderNotes); row.SetField("cCustVendNotes", entity.cCustVendNotes); row.SetField("cProdNotes", entity.cProdNotes); row.SetField("cTransNotes", entity.cTransNotes); row.SetField("cICETNotes", entity.cICETNotes); row.SetField("iICETNotesID", entity.iICETNotesID); row.SetField("cTransDtTmSort", entity.cTransDtTmSort); row.SetField("dVendNo", entity.dVendNo); row.SetField("rRowid", entity.rRowid.ToByteArray()); row.SetField("dtReqShipDt", entity.dtReqShipDt); row.SetField("ilineno", entity.ilineno); row.SetField("archive", entity.archive); row.SetField("countryoforigin", entity.countryoforigin); row.SetField("tariffcd", entity.tariffcd); row.SetField("userfield", entity.userfield); }
public static Createictransttresults BuildCreateictransttresultsFromRow(DataRow row) { Createictransttresults entity = new Createictransttresults(); entity.cICETRowId = row.IsNull("cICETRowId") ? string.Empty : row.Field <string>("cICETRowId"); entity.cModule = row.IsNull("cModule") ? string.Empty : row.Field <string>("cModule"); entity.cName = row.IsNull("cName") ? string.Empty : row.Field <string>("cName"); entity.cProd = row.IsNull("cProd") ? string.Empty : row.Field <string>("cProd"); entity.cSign = row.IsNull("cSign") ? string.Empty : row.Field <string>("cSign"); entity.cTransDesc = row.IsNull("cTransDesc") ? string.Empty : row.Field <string>("cTransDesc"); entity.cTransType = row.IsNull("cTransType") ? string.Empty : row.Field <string>("cTransType"); entity.custno = row.IsNull("Custno") ? string.Empty : row.Field <string>("Custno"); entity.cWhse = row.IsNull("cWhse") ? string.Empty : row.Field <string>("cWhse"); entity.dQtyOnHand = row.IsNull("dQtyOnHand") ? decimal.Zero : row.Field <decimal>("dQtyOnHand"); entity.dStkQtyShip = row.IsNull("dStkQtyShip") ? decimal.Zero : row.Field <decimal>("dStkQtyShip"); entity.dtPosted = row.Field <DateTime?>("dtPosted"); entity.iJrnlNo = row.IsNull("iJrnlNo") ? 0 : row.Field <int>("iJrnlNo"); entity.iOrderNo = row.IsNull("iOrderNo") ? 0 : row.Field <int>("iOrderNo"); entity.iOrderSuf = row.IsNull("iOrderSuf") ? 0 : row.Field <int>("iOrderSuf"); entity.iSetNo = row.IsNull("iSetNo") ? 0 : row.Field <int>("iSetNo"); entity.cOrderNotes = row.IsNull("cOrderNotes") ? string.Empty : row.Field <string>("cOrderNotes"); entity.cCustVendNotes = row.IsNull("cCustVendNotes") ? string.Empty : row.Field <string>("cCustVendNotes"); entity.cProdNotes = row.IsNull("cProdNotes") ? string.Empty : row.Field <string>("cProdNotes"); entity.cTransNotes = row.IsNull("cTransNotes") ? string.Empty : row.Field <string>("cTransNotes"); entity.cICETNotes = row.IsNull("cICETNotes") ? string.Empty : row.Field <string>("cICETNotes"); entity.iICETNotesID = row.IsNull("iICETNotesID") ? 0 : row.Field <int>("iICETNotesID"); entity.cTransDtTmSort = row.IsNull("cTransDtTmSort") ? string.Empty : row.Field <string>("cTransDtTmSort"); entity.dVendNo = row.IsNull("dVendNo") ? decimal.Zero : row.Field <decimal>("dVendNo"); entity.rRowid = row.Field <byte[]>("rRowid").ToStringEncoded(); entity.dtReqShipDt = row.Field <DateTime?>("dtReqShipDt"); entity.ilineno = row.IsNull("ilineno") ? 0 : row.Field <int>("ilineno"); entity.archive = row.IsNull("archive") ? string.Empty : row.Field <string>("archive"); entity.countryoforigin = row.IsNull("countryoforigin") ? string.Empty : row.Field <string>("countryoforigin"); entity.tariffcd = row.IsNull("tariffcd") ? string.Empty : row.Field <string>("tariffcd"); entity.userfield = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield"); return(entity); }