public static Wtimportdata BuildWtimportdataFromRow(DataRow row) { Wtimportdata entity = new Wtimportdata(); entity.addoncamt = row.IsNull("addoncamt") ? decimal.Zero : row.Field <decimal>("addoncamt"); entity.addoncty = row.IsNull("addoncty") ? string.Empty : row.Field <string>("addoncty"); entity.addoneamt = row.IsNull("addoneamt") ? decimal.Zero : row.Field <decimal>("addoneamt"); entity.addonety = row.IsNull("addonety") ? string.Empty : row.Field <string>("addonety"); entity.instruct = row.IsNull("instruct") ? string.Empty : row.Field <string>("instruct"); entity.orderdt = row.Field <DateTime?>("orderdt"); entity.processfl = row.Field <bool>("processfl"); entity.refer = row.IsNull("refer") ? string.Empty : row.Field <string>("refer"); entity.reqshipdt = row.Field <DateTime?>("reqshipdt"); entity.shipviaty = row.IsNull("shipviaty") ? string.Empty : row.Field <string>("shipviaty"); entity.reasoncode = row.IsNull("reasoncode") ? string.Empty : row.Field <string>("reasoncode"); entity.tocono = row.IsNull("tocono") ? 0 : row.Field <int>("tocono"); entity.towhse = row.IsNull("towhse") ? string.Empty : row.Field <string>("towhse"); entity.whse = row.IsNull("whse") ? string.Empty : row.Field <string>("whse"); entity.prod = row.IsNull("prod") ? string.Empty : row.Field <string>("prod"); entity.descrip = row.IsNull("descrip") ? string.Empty : row.Field <string>("descrip"); entity.qtyord = row.IsNull("qtyord") ? decimal.Zero : row.Field <decimal>("qtyord"); entity.unit = row.IsNull("unit") ? string.Empty : row.Field <string>("unit"); entity.printfl = row.Field <bool>("printfl"); entity.requirefl = row.Field <bool>("requirefl"); entity.name = row.IsNull("name") ? string.Empty : row.Field <string>("name"); entity.cono2 = row.IsNull("cono2") ? 0 : row.Field <int>("cono2"); entity.duedt = row.Field <DateTime?>("duedt"); entity.ordertype = row.IsNull("ordertype") ? string.Empty : row.Field <string>("ordertype"); entity.origseqno = row.IsNull("origseqno") ? 0 : row.Field <int>("origseqno"); entity.stagecd = row.IsNull("stagecd") ? 0 : row.Field <int>("stagecd"); entity.totamt = row.IsNull("totamt") ? decimal.Zero : row.Field <decimal>("totamt"); entity.addonno = row.IsNull("addonno") ? 0 : row.Field <int>("addonno"); entity.addontype1 = row.Field <bool>("addontype1"); entity.catalogfl = row.Field <bool>("catalogfl"); entity.commentfl = row.IsNull("commentfl") ? string.Empty : row.Field <string>("commentfl"); entity.currsymbol = row.IsNull("currsymbol") ? string.Empty : row.Field <string>("currsymbol"); entity.descrip2 = row.IsNull("descrip2") ? string.Empty : row.Field <string>("descrip2"); entity.manprice = row.Field <bool>("manprice"); entity.netamt = row.IsNull("netamt") ? decimal.Zero : row.Field <decimal>("netamt"); entity.nonstockty = row.IsNull("nonstockty") ? string.Empty : row.Field <string>("nonstockty"); entity.orderaltno = row.IsNull("orderaltno") ? 0 : row.Field <int>("orderaltno"); entity.prodcat = row.IsNull("prodcat") ? string.Empty : row.Field <string>("prodcat"); entity.prodline = row.IsNull("prodline") ? string.Empty : row.Field <string>("prodline"); entity.qtyship = row.IsNull("qtyship") ? decimal.Zero : row.Field <decimal>("qtyship"); entity.reasunavty = row.IsNull("reasunavty") ? string.Empty : row.Field <string>("reasunavty"); entity.vendprod = row.IsNull("vendprod") ? string.Empty : row.Field <string>("vendprod"); entity.lineno = row.IsNull("lineno") ? 0 : row.Field <int>("lineno"); entity.seqno = row.IsNull("seqno") ? 0 : row.Field <int>("seqno"); entity.orderbreak = row.IsNull("orderbreak") ? string.Empty : row.Field <string>("orderbreak"); entity.worksheetno = row.IsNull("worksheetno") ? 0 : row.Field <int>("worksheetno"); 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 UpdateRowFromWtimportdata(ref DataRow row, Wtimportdata entity) { row.SetField("addoncamt", entity.addoncamt); row.SetField("addoncty", entity.addoncty); row.SetField("addoneamt", entity.addoneamt); row.SetField("addonety", entity.addonety); row.SetField("instruct", entity.instruct); row.SetField("orderdt", entity.orderdt); row.SetField("processfl", entity.processfl); row.SetField("refer", entity.refer); row.SetField("reqshipdt", entity.reqshipdt); row.SetField("shipviaty", entity.shipviaty); row.SetField("reasoncode", entity.reasoncode); row.SetField("tocono", entity.tocono); row.SetField("towhse", entity.towhse); row.SetField("whse", entity.whse); row.SetField("prod", entity.prod); row.SetField("descrip", entity.descrip); row.SetField("qtyord", entity.qtyord); row.SetField("unit", entity.unit); row.SetField("printfl", entity.printfl); row.SetField("requirefl", entity.requirefl); row.SetField("name", entity.name); row.SetField("cono2", entity.cono2); row.SetField("duedt", entity.duedt); row.SetField("ordertype", entity.ordertype); row.SetField("origseqno", entity.origseqno); row.SetField("stagecd", entity.stagecd); row.SetField("totamt", entity.totamt); row.SetField("addonno", entity.addonno); row.SetField("addontype1", entity.addontype1); row.SetField("catalogfl", entity.catalogfl); row.SetField("commentfl", entity.commentfl); row.SetField("currsymbol", entity.currsymbol); row.SetField("descrip2", entity.descrip2); row.SetField("manprice", entity.manprice); row.SetField("netamt", entity.netamt); row.SetField("nonstockty", entity.nonstockty); row.SetField("orderaltno", entity.orderaltno); row.SetField("prodcat", entity.prodcat); row.SetField("prodline", entity.prodline); row.SetField("qtyship", entity.qtyship); row.SetField("reasunavty", entity.reasunavty); row.SetField("vendprod", entity.vendprod); row.SetField("lineno", entity.lineno); row.SetField("seqno", entity.seqno); row.SetField("orderbreak", entity.orderbreak); row.SetField("worksheetno", entity.worksheetno); row.SetField("userfield", entity.userfield); }