/// <summary> /// Update a database row from a class /// </summary> public static void UpdateRowFromOelinemovemultiple(ref DataRow row, Oelinemovemultiple entity) { row.SetField("internalseqno", entity.internalseqno); row.SetField("selectedfl", entity.selectedfl); row.SetField("actlnewlineno", entity.actlnewlineno); row.SetField("actlnewcommintseq", entity.actlnewcommintseq); row.SetField("actlnewcommseq", entity.actlnewcommseq); row.SetField("actlprice", entity.actlprice); row.SetField("actlnetord", entity.actlnetord); row.SetField("actldiscamt", entity.actldiscamt); row.SetField("actldisctype", entity.actldisctype); row.SetField("actlqtyord", entity.actlqtyord); row.SetField("actlprintpricefl", entity.actlprintpricefl); row.SetField("actltotalcost", entity.actltotalcost); row.SetField("actlmarginamt", entity.actlmarginamt); row.SetField("actlmarginnet", entity.actlmarginnet); row.SetField("actlcustrebamt", entity.actlcustrebamt); row.SetField("actlvendrebamt", entity.actlvendrebamt); row.SetField("actlcost", entity.actlcost); row.SetField("actlnetcost", entity.actlnetcost); row.SetField("dsplnewlineno", entity.dsplnewlineno); row.SetField("dsploriglineno", entity.dsploriglineno); row.SetField("dsplqtyord", entity.dsplqtyord); row.SetField("dsplprice", entity.dsplprice); row.SetField("dspldiscamt", entity.dspldiscamt); row.SetField("dspldisctype", entity.dspldisctype); row.SetField("dsplnetord", entity.dsplnetord); row.SetField("dsplprintpricefl", entity.dsplprintpricefl); row.SetField("dsplcost", entity.dsplcost); row.SetField("dsplnetcost", entity.dsplnetcost); row.SetField("subtotalrecordfl", entity.subtotalrecordfl); row.SetField("specnstype", entity.specnstype); row.SetField("origcommln", entity.origcommln); row.SetField("origcommintseq", entity.origcommintseq); row.SetField("origcommseq", entity.origcommseq); row.SetField("origshipprod", entity.origshipprod); row.SetField("origdescrip", entity.origdescrip); row.SetField("deletefl", entity.deletefl); row.SetField("botype", entity.botype); row.SetField("shipprod", entity.shipprod); row.SetField("descrip", entity.descrip); row.SetField("lastupdate", entity.lastupdate); row.SetField("oeelrecid", entity.oeelrecid); row.SetField("csunperstk", entity.csunperstk); row.SetField("specconv", entity.specconv); row.SetField("prccostper", entity.prccostper); row.SetField("speccostty", entity.speccostty); row.SetField("icspecrecno", entity.icspecrecno); row.SetField("commentfl", entity.commentfl); row.SetField("notesfl", entity.notesfl); row.SetField("lineorderno", entity.lineorderno); row.SetField("lineordersuf", entity.lineordersuf); row.SetField("priceclty", entity.priceclty); row.SetField("pricecd", entity.pricecd); row.SetField("manprice", entity.manprice); row.SetField("pricelevel", entity.pricelevel); row.SetField("priceover", entity.priceover); row.SetField("pricereset", entity.pricereset); row.SetField("pdrecno", entity.pdrecno); row.SetField("hardpricefl", entity.hardpricefl); row.SetField("costoverfl", entity.costoverfl); row.SetField("costtype", entity.costtype); row.SetField("overridetype", entity.overridetype); row.SetField("hightolprice", entity.hightolprice); row.SetField("lowtolprice", entity.lowtolprice); row.SetField("userfield", entity.userfield); }
public static Oelinemovemultiple BuildOelinemovemultipleFromRow(DataRow row) { Oelinemovemultiple entity = new Oelinemovemultiple(); entity.internalseqno = row.IsNull("internalseqno") ? decimal.Zero : row.Field <decimal>("internalseqno"); entity.selectedfl = row.Field <bool>("selectedfl"); entity.actlnewlineno = row.IsNull("actlnewlineno") ? 0 : row.Field <int>("actlnewlineno"); entity.actlnewcommintseq = row.IsNull("actlnewcommintseq") ? 0 : row.Field <int>("actlnewcommintseq"); entity.actlnewcommseq = row.IsNull("actlnewcommseq") ? 0 : row.Field <int>("actlnewcommseq"); entity.actlprice = row.IsNull("actlprice") ? decimal.Zero : row.Field <decimal>("actlprice"); entity.actlnetord = row.IsNull("actlnetord") ? decimal.Zero : row.Field <decimal>("actlnetord"); entity.actldiscamt = row.IsNull("actldiscamt") ? decimal.Zero : row.Field <decimal>("actldiscamt"); entity.actldisctype = row.Field <bool>("actldisctype"); entity.actlqtyord = row.IsNull("actlqtyord") ? decimal.Zero : row.Field <decimal>("actlqtyord"); entity.actlprintpricefl = row.Field <bool>("actlprintpricefl"); entity.actltotalcost = row.IsNull("actltotalcost") ? decimal.Zero : row.Field <decimal>("actltotalcost"); entity.actlmarginamt = row.IsNull("actlmarginamt") ? decimal.Zero : row.Field <decimal>("actlmarginamt"); entity.actlmarginnet = row.IsNull("actlmarginnet") ? decimal.Zero : row.Field <decimal>("actlmarginnet"); entity.actlcustrebamt = row.IsNull("actlcustrebamt") ? decimal.Zero : row.Field <decimal>("actlcustrebamt"); entity.actlvendrebamt = row.IsNull("actlvendrebamt") ? decimal.Zero : row.Field <decimal>("actlvendrebamt"); entity.actlcost = row.IsNull("actlcost") ? decimal.Zero : row.Field <decimal>("actlcost"); entity.actlnetcost = row.IsNull("actlnetcost") ? decimal.Zero : row.Field <decimal>("actlnetcost"); entity.dsplnewlineno = row.IsNull("dsplnewlineno") ? string.Empty : row.Field <string>("dsplnewlineno"); entity.dsploriglineno = row.IsNull("dsploriglineno") ? string.Empty : row.Field <string>("dsploriglineno"); entity.dsplqtyord = row.IsNull("dsplqtyord") ? string.Empty : row.Field <string>("dsplqtyord"); entity.dsplprice = row.IsNull("dsplprice") ? string.Empty : row.Field <string>("dsplprice"); entity.dspldiscamt = row.IsNull("dspldiscamt") ? string.Empty : row.Field <string>("dspldiscamt"); entity.dspldisctype = row.IsNull("dspldisctype") ? string.Empty : row.Field <string>("dspldisctype"); entity.dsplnetord = row.IsNull("dsplnetord") ? string.Empty : row.Field <string>("dsplnetord"); entity.dsplprintpricefl = row.IsNull("dsplprintpricefl") ? string.Empty : row.Field <string>("dsplprintpricefl"); entity.dsplcost = row.IsNull("dsplcost") ? string.Empty : row.Field <string>("dsplcost"); entity.dsplnetcost = row.IsNull("dsplnetcost") ? string.Empty : row.Field <string>("dsplnetcost"); entity.subtotalrecordfl = row.Field <bool>("subtotalrecordfl"); entity.specnstype = row.IsNull("specnstype") ? string.Empty : row.Field <string>("specnstype"); entity.origcommln = row.IsNull("origcommln") ? 0 : row.Field <int>("origcommln"); entity.origcommintseq = row.IsNull("origcommintseq") ? 0 : row.Field <int>("origcommintseq"); entity.origcommseq = row.IsNull("origcommseq") ? 0 : row.Field <int>("origcommseq"); entity.origshipprod = row.IsNull("origshipprod") ? string.Empty : row.Field <string>("origshipprod"); entity.origdescrip = row.IsNull("origdescrip") ? string.Empty : row.Field <string>("origdescrip"); entity.deletefl = row.Field <bool>("deletefl"); entity.botype = row.IsNull("botype") ? string.Empty : row.Field <string>("botype"); entity.shipprod = row.IsNull("shipprod") ? string.Empty : row.Field <string>("shipprod"); entity.descrip = row.IsNull("descrip") ? string.Empty : row.Field <string>("descrip"); entity.lastupdate = row.IsNull("lastupdate") ? string.Empty : row.Field <string>("lastupdate"); entity.oeelrecid = row.IsNull("oeelrecid") ? 0 : row.Field <long>("oeelrecid"); entity.csunperstk = row.IsNull("csunperstk") ? decimal.Zero : row.Field <decimal>("csunperstk"); entity.specconv = row.IsNull("specconv") ? 0 : row.Field <int>("specconv"); entity.prccostper = row.IsNull("prccostper") ? string.Empty : row.Field <string>("prccostper"); entity.speccostty = row.IsNull("speccostty") ? string.Empty : row.Field <string>("speccostty"); entity.icspecrecno = row.IsNull("icspecrecno") ? 0 : row.Field <int>("icspecrecno"); entity.commentfl = row.Field <bool>("commentfl"); entity.notesfl = row.IsNull("notesfl") ? string.Empty : row.Field <string>("notesfl"); entity.lineorderno = row.IsNull("lineorderno") ? 0 : row.Field <int>("lineorderno"); entity.lineordersuf = row.IsNull("lineordersuf") ? 0 : row.Field <int>("lineordersuf"); entity.priceclty = row.IsNull("priceclty") ? string.Empty : row.Field <string>("priceclty"); entity.pricecd = row.IsNull("pricecd") ? decimal.Zero : row.Field <decimal>("pricecd"); entity.manprice = row.Field <bool>("manprice"); entity.pricelevel = row.IsNull("pricelevel") ? decimal.Zero : row.Field <decimal>("pricelevel"); entity.priceover = row.IsNull("priceover") ? decimal.Zero : row.Field <decimal>("priceover"); entity.pricereset = row.Field <bool>("pricereset"); entity.pdrecno = row.IsNull("pdrecno") ? 0 : row.Field <int>("pdrecno"); entity.hardpricefl = row.Field <bool>("hardpricefl"); entity.costoverfl = row.Field <bool>("costoverfl"); entity.costtype = row.IsNull("costtype") ? string.Empty : row.Field <string>("costtype"); entity.overridetype = row.IsNull("overridetype") ? string.Empty : row.Field <string>("overridetype"); entity.hightolprice = row.IsNull("hightolprice") ? decimal.Zero : row.Field <decimal>("hightolprice"); entity.lowtolprice = row.IsNull("lowtolprice") ? decimal.Zero : row.Field <decimal>("lowtolprice"); entity.userfield = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield"); return(entity); }