public static Icamusingle BuildIcamusingleFromRow(DataRow row) { Icamusingle entity = new Icamusingle(); entity.statustype = row.IsNull("statustype") ? string.Empty : row.Field <string>("statustype"); entity.whse = row.IsNull("whse") ? string.Empty : row.Field <string>("whse"); entity.whsename = row.IsNull("whsename") ? string.Empty : row.Field <string>("whsename"); entity.buyeroroperator = row.IsNull("buyeroroperator") ? string.Empty : row.Field <string>("buyeroroperator"); entity.buyername = row.IsNull("buyername") ? string.Empty : row.Field <string>("buyername"); entity.frozenreason = row.IsNull("frozenreason") ? string.Empty : row.Field <string>("frozenreason"); entity.vendno = row.IsNull("vendno") ? decimal.Zero : row.Field <decimal>("vendno"); entity.vendorname = row.IsNull("vendorname") ? string.Empty : row.Field <string>("vendorname"); entity.vendornotesfl = row.IsNull("vendornotesfl") ? string.Empty : row.Field <string>("vendornotesfl"); entity.prodline = row.IsNull("prodline") ? string.Empty : row.Field <string>("prodline"); entity.productlinedesc = row.IsNull("productlinedesc") ? string.Empty : row.Field <string>("productlinedesc"); entity.fmprodcat = row.IsNull("fmprodcat") ? string.Empty : row.Field <string>("fmprodcat"); entity.fromprodcatdesc = row.IsNull("fromprodcatdesc") ? string.Empty : row.Field <string>("fromprodcatdesc"); entity.toprodcat = row.IsNull("toprodcat") ? string.Empty : row.Field <string>("toprodcat"); entity.toprodcatdesc = row.IsNull("toprodcatdesc") ? string.Empty : row.Field <string>("toprodcatdesc"); entity.fmclass = row.IsNull("fmclass") ? 0 : row.Field <int>("fmclass"); entity.toclass = row.IsNull("toclass") ? 0 : row.Field <int>("toclass"); entity.fmrank = row.IsNull("fmrank") ? string.Empty : row.Field <string>("fmrank"); entity.torank = row.IsNull("torank") ? string.Empty : row.Field <string>("torank"); entity.numranks = row.IsNull("numranks") ? 0 : row.Field <int>("numranks"); entity.homewhsefl = row.Field <bool>("homewhsefl"); entity.homewhse = row.IsNull("homewhse") ? string.Empty : row.Field <string>("homewhse"); entity.superfl = row.Field <bool>("superfl"); entity.icmanlistty = row.IsNull("icmanlistty") ? string.Empty : row.Field <string>("icmanlistty"); entity.icmanlistoverfl = row.Field <bool>("icmanlistoverfl"); entity.icmassmaintfl = row.Field <bool>("icmassmaintfl"); entity.icswstchgfl = row.Field <bool>("icswstchgfl"); entity.countryoforigin = row.IsNull("countryoforigin") ? string.Empty : row.Field <string>("countryoforigin"); entity.linehitsHidden = row.Field <bool>("linehits-hidden"); entity.oorderptHidden = row.Field <bool>("oorderpt-hidden"); entity.olineptHidden = row.Field <bool>("olinept-hidden"); entity.whserankHidden = row.Field <bool>("whserank-hidden"); entity.safetyqtyHidden = row.Field <bool>("safetyqty-hidden"); entity.usageHidden = row.Field <bool>("usage-hidden"); entity.rsStatusSensitive = row.Field <bool>("rsStatus-sensitive"); entity.txtBuyerorOperator = row.IsNull("txtBuyerorOperator") ? string.Empty : row.Field <string>("txtBuyerorOperator"); entity.fiBuyerorOperatorSensitive = row.Field <bool>("fiBuyerorOperator-sensitive"); entity.cbFrozenReasonSensitive = row.Field <bool>("cbFrozenReason-sensitive"); entity.cbFromRankHidden = row.Field <bool>("cbFromRank-hidden"); entity.cbFromRankSensitive = row.Field <bool>("cbFromRank-sensitive"); entity.cbToRankHidden = row.Field <bool>("cbToRank-hidden"); entity.cbToRankSensitive = row.Field <bool>("cbToRank-sensitive"); entity.btnExceptionsHidden = row.Field <bool>("btnExceptions-hidden"); entity.btnExceptionsSensitive = row.Field <bool>("btnExceptions-sensitive"); entity.exceptlist = row.IsNull("exceptlist") ? string.Empty : row.Field <string>("exceptlist"); entity.recordcountlimit = row.IsNull("recordcountlimit") ? 0 : row.Field <int>("recordcountlimit"); entity.morerecords = row.Field <bool>("morerecords"); entity.paramdata = row.IsNull("paramdata") ? string.Empty : row.Field <string>("paramdata"); 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 UpdateRowFromIcamusingle(ref DataRow row, Icamusingle entity) { row.SetField("statustype", entity.statustype); row.SetField("whse", entity.whse); row.SetField("whsename", entity.whsename); row.SetField("buyeroroperator", entity.buyeroroperator); row.SetField("buyername", entity.buyername); row.SetField("frozenreason", entity.frozenreason); row.SetField("vendno", entity.vendno); row.SetField("vendorname", entity.vendorname); row.SetField("vendornotesfl", entity.vendornotesfl); row.SetField("prodline", entity.prodline); row.SetField("productlinedesc", entity.productlinedesc); row.SetField("fmprodcat", entity.fmprodcat); row.SetField("fromprodcatdesc", entity.fromprodcatdesc); row.SetField("toprodcat", entity.toprodcat); row.SetField("toprodcatdesc", entity.toprodcatdesc); row.SetField("fmclass", entity.fmclass); row.SetField("toclass", entity.toclass); row.SetField("fmrank", entity.fmrank); row.SetField("torank", entity.torank); row.SetField("numranks", entity.numranks); row.SetField("homewhsefl", entity.homewhsefl); row.SetField("homewhse", entity.homewhse); row.SetField("superfl", entity.superfl); row.SetField("icmanlistty", entity.icmanlistty); row.SetField("icmanlistoverfl", entity.icmanlistoverfl); row.SetField("icmassmaintfl", entity.icmassmaintfl); row.SetField("icswstchgfl", entity.icswstchgfl); row.SetField("countryoforigin", entity.countryoforigin); row.SetField("linehits-hidden", entity.linehitsHidden); row.SetField("oorderpt-hidden", entity.oorderptHidden); row.SetField("olinept-hidden", entity.olineptHidden); row.SetField("whserank-hidden", entity.whserankHidden); row.SetField("safetyqty-hidden", entity.safetyqtyHidden); row.SetField("usage-hidden", entity.usageHidden); row.SetField("rsStatus-sensitive", entity.rsStatusSensitive); row.SetField("txtBuyerorOperator", entity.txtBuyerorOperator); row.SetField("fiBuyerorOperator-sensitive", entity.fiBuyerorOperatorSensitive); row.SetField("cbFrozenReason-sensitive", entity.cbFrozenReasonSensitive); row.SetField("cbFromRank-hidden", entity.cbFromRankHidden); row.SetField("cbFromRank-sensitive", entity.cbFromRankSensitive); row.SetField("cbToRank-hidden", entity.cbToRankHidden); row.SetField("cbToRank-sensitive", entity.cbToRankSensitive); row.SetField("btnExceptions-hidden", entity.btnExceptionsHidden); row.SetField("btnExceptions-sensitive", entity.btnExceptionsSensitive); row.SetField("exceptlist", entity.exceptlist); row.SetField("recordcountlimit", entity.recordcountlimit); row.SetField("morerecords", entity.morerecords); row.SetField("paramdata", entity.paramdata); row.SetField("userfield", entity.userfield); }