/// <summary> /// Update a database row from a class /// </summary> public static void UpdateRowFromSasbrresults(ref DataRow row, Sasbrresults entity) { row.SetField("ruledescrip", entity.ruledescrip); row.SetField("ruletype", entity.ruletype); row.SetField("level", entity.level); row.SetField("edipartner", entity.edipartner); row.SetField("custno", entity.custno); row.SetField("custnotesfl", entity.custnotesfl); row.SetField("custname", entity.custname); row.SetField("shipto", entity.shipto); row.SetField("shiptoname", entity.shiptoname); row.SetField("shiptonotesfl", entity.shiptonotesfl); row.SetField("vendno", entity.vendno); row.SetField("vendnotesfl", entity.vendnotesfl); row.SetField("shipfmno", entity.shipfmno); row.SetField("vendname", entity.vendname); row.SetField("cono", entity.cono); row.SetField("conm", entity.conm); row.SetField("docHandler", entity.docHandler); row.SetField("nodeNm", entity.nodeNm); row.SetField("AttrNm", entity.attrNm); row.SetField("rulevalue", entity.rulevalue); row.SetField("tradingpartner", entity.tradingpartner); row.SetField("direction", entity.direction); row.SetField("extdescrip", entity.extdescrip); row.SetField("categorylist", entity.categorylist); row.SetField("sxxmlrule-rowid", entity.sxxmlruleRowid.ToByteArray()); row.SetField("userfield", entity.userfield); }
public static Sasbrresults BuildSasbrresultsFromRow(DataRow row) { Sasbrresults entity = new Sasbrresults(); entity.ruledescrip = row.IsNull("ruledescrip") ? string.Empty : row.Field <string>("ruledescrip"); entity.ruletype = row.IsNull("ruletype") ? string.Empty : row.Field <string>("ruletype"); entity.level = row.IsNull("level") ? string.Empty : row.Field <string>("level"); entity.edipartner = row.IsNull("edipartner") ? string.Empty : row.Field <string>("edipartner"); entity.custno = row.IsNull("custno") ? decimal.Zero : row.Field <decimal>("custno"); entity.custnotesfl = row.IsNull("custnotesfl") ? string.Empty : row.Field <string>("custnotesfl"); entity.custname = row.IsNull("custname") ? string.Empty : row.Field <string>("custname"); entity.shipto = row.IsNull("shipto") ? string.Empty : row.Field <string>("shipto"); entity.shiptoname = row.IsNull("shiptoname") ? string.Empty : row.Field <string>("shiptoname"); entity.shiptonotesfl = row.IsNull("shiptonotesfl") ? string.Empty : row.Field <string>("shiptonotesfl"); entity.vendno = row.IsNull("vendno") ? decimal.Zero : row.Field <decimal>("vendno"); entity.vendnotesfl = row.IsNull("vendnotesfl") ? string.Empty : row.Field <string>("vendnotesfl"); entity.shipfmno = row.IsNull("shipfmno") ? 0 : row.Field <int>("shipfmno"); entity.vendname = row.IsNull("vendname") ? string.Empty : row.Field <string>("vendname"); entity.cono = row.IsNull("cono") ? 0 : row.Field <int>("cono"); entity.conm = row.IsNull("conm") ? string.Empty : row.Field <string>("conm"); entity.docHandler = row.IsNull("docHandler") ? string.Empty : row.Field <string>("docHandler"); entity.nodeNm = row.IsNull("nodeNm") ? string.Empty : row.Field <string>("nodeNm"); entity.attrNm = row.IsNull("AttrNm") ? string.Empty : row.Field <string>("AttrNm"); entity.rulevalue = row.IsNull("rulevalue") ? string.Empty : row.Field <string>("rulevalue"); entity.tradingpartner = row.IsNull("tradingpartner") ? string.Empty : row.Field <string>("tradingpartner"); entity.direction = row.IsNull("direction") ? string.Empty : row.Field <string>("direction"); entity.extdescrip = row.IsNull("extdescrip") ? string.Empty : row.Field <string>("extdescrip"); entity.categorylist = row.IsNull("categorylist") ? string.Empty : row.Field <string>("categorylist"); entity.sxxmlruleRowid = row.Field <byte[]>("sxxmlrule-rowid").ToStringEncoded(); entity.userfield = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield"); return(entity); }