public static Icsecretrieveresults BuildIcsecretrieveresultsFromRow(DataRow row) { Icsecretrieveresults entity = new Icsecretrieveresults(); entity.addprtinfo = row.IsNull("addprtinfo") ? string.Empty : row.Field <string>("addprtinfo"); entity.altprod = row.IsNull("altprod") ? string.Empty : row.Field <string>("altprod"); entity.custglacctno = row.IsNull("custglacctno") ? string.Empty : row.Field <string>("custglacctno"); entity.custno = row.IsNull("custno") ? decimal.Zero : row.Field <decimal>("custno"); entity.extprod = row.IsNull("extprod") ? string.Empty : row.Field <string>("extprod"); entity.extproddescrip1 = row.IsNull("extproddescrip1") ? string.Empty : row.Field <string>("extproddescrip1"); entity.extproddescrip2 = row.IsNull("extproddescrip2") ? string.Empty : row.Field <string>("extproddescrip2"); entity.keyno = row.IsNull("keyno") ? decimal.Zero : row.Field <decimal>("keyno"); entity.operinit = row.IsNull("operinit") ? string.Empty : row.Field <string>("operinit"); entity.orderqty = row.IsNull("orderqty") ? decimal.Zero : row.Field <decimal>("orderqty"); entity.price = row.IsNull("price") ? decimal.Zero : row.Field <decimal>("price"); entity.prod = row.IsNull("prod") ? string.Empty : row.Field <string>("prod"); entity.rectype = row.IsNull("rectype") ? string.Empty : row.Field <string>("rectype"); entity.shipto = row.IsNull("shipto") ? string.Empty : row.Field <string>("shipto"); entity.sellfirsttype = row.IsNull("sellfirsttype") ? string.Empty : row.Field <string>("sellfirsttype"); entity.unitbuy = row.IsNull("unitbuy") ? string.Empty : row.Field <string>("unitbuy"); entity.unitsell = row.IsNull("unitsell") ? string.Empty : row.Field <string>("unitsell"); entity.unitstnd = row.IsNull("unitstnd") ? string.Empty : row.Field <string>("unitstnd"); entity.icsecRowID = row.Field <byte[]>("icsecRowID").ToStringEncoded(); 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 UpdateRowFromIcsecretrieveresults(ref DataRow row, Icsecretrieveresults entity) { row.SetField("addprtinfo", entity.addprtinfo); row.SetField("altprod", entity.altprod); row.SetField("custglacctno", entity.custglacctno); row.SetField("custno", entity.custno); row.SetField("extprod", entity.extprod); row.SetField("extproddescrip1", entity.extproddescrip1); row.SetField("extproddescrip2", entity.extproddescrip2); row.SetField("keyno", entity.keyno); row.SetField("operinit", entity.operinit); row.SetField("orderqty", entity.orderqty); row.SetField("price", entity.price); row.SetField("prod", entity.prod); row.SetField("rectype", entity.rectype); row.SetField("shipto", entity.shipto); row.SetField("sellfirsttype", entity.sellfirsttype); row.SetField("unitbuy", entity.unitbuy); row.SetField("unitsell", entity.unitsell); row.SetField("unitstnd", entity.unitstnd); row.SetField("icsecRowID", entity.icsecRowID.ToByteArray()); row.SetField("userfield", entity.userfield); }