/// <summary> /// Update a database row from a class /// </summary> public static void UpdateRowFromSaeaaction(ref DataRow row, Saeaaction entity) { row.SetField("actionseqno", entity.actionseqno); row.SetField("actionsubjectty", entity.actionsubjectty); row.SetField("actionsubjectval", entity.actionsubjectval); row.SetField("actiontype", entity.actiontype); row.SetField("camactivitycd", entity.camactivitycd); row.SetField("cmactivitycd", entity.cmactivitycd); row.SetField("comment", entity.comment); row.SetField("cono", entity.cono); row.SetField("contactid", entity.contactid); row.SetField("custnobeg", entity.custnobeg); row.SetField("custnoend", entity.custnoend); row.SetField("custnorangety", entity.custnorangety); row.SetField("emailsubject", entity.emailsubject); row.SetField("emailtext", entity.emailtext); row.SetField("eventname", entity.eventname); row.SetField("expiredt", entity.expiredt); row.SetField("operinit", entity.operinit); row.SetField("prodbeg", entity.prodbeg); row.SetField("prodcatbeg", entity.prodcatbeg); row.SetField("prodcatend", entity.prodcatend); row.SetField("prodcatrangety", entity.prodcatrangety); row.SetField("prodend", entity.prodend); row.SetField("prodrangety", entity.prodrangety); row.SetField("programtorun", entity.programtorun); row.SetField("prosno", entity.prosno); row.SetField("regionbeg", entity.regionbeg); row.SetField("regionend", entity.regionend); row.SetField("regionrangety", entity.regionrangety); row.SetField("slctamountary", entity.slctamountary); row.SetField("slctamountty", entity.slctamountty); row.SetField("slctamountval", entity.slctamountval); row.SetField("slctcharary", entity.slctcharary); row.SetField("slctcharty", entity.slctcharty); row.SetField("slctcharval", entity.slctcharval); row.SetField("slctdateary", entity.slctdateary); row.SetField("slctdatety", entity.slctdatety); row.SetField("slctdateval", entity.slctdateval); row.SetField("slctpriceary", entity.slctpriceary); row.SetField("slctpricety", entity.slctpricety); row.SetField("slctpriceval", entity.slctpriceval); row.SetField("statustype", entity.statustype); row.SetField("transdt", entity.transdt); row.SetField("transproc", entity.transproc); row.SetField("transtm", entity.transtm); row.SetField("vendnobeg", entity.vendnobeg); row.SetField("vendnoend", entity.vendnoend); row.SetField("vendnorangety", entity.vendnorangety); row.SetField("whsebeg", entity.whsebeg); row.SetField("whseend", entity.whseend); row.SetField("whserangety", entity.whserangety); row.SetField("whooper", entity.whooper); row.SetField("whogroup", entity.whogroup); row.SetField("whoemail", entity.whoemail); row.SetField("whopos", entity.whopos); row.SetField("whocontact", entity.whocontact); row.SetField("custenabled", entity.custenabled); row.SetField("regenabled", entity.regenabled); row.SetField("prodenabled", entity.prodenabled); row.SetField("pcatenabled", entity.pcatenabled); row.SetField("vendenabled", entity.vendenabled); row.SetField("whseenabled", entity.whseenabled); row.SetField("amtenabled", entity.amtenabled); row.SetField("charenabled", entity.charenabled); row.SetField("prcenabled", entity.prcenabled); row.SetField("dateenabled", entity.dateenabled); row.SetField("actionrowid", entity.actionrowid.ToByteArray()); row.SetField("userfield", entity.userfield); }
public static Saeaaction BuildSaeaactionFromRow(DataRow row) { Saeaaction entity = new Saeaaction(); entity.actionseqno = row.IsNull("actionseqno") ? 0 : row.Field <int>("actionseqno"); entity.actionsubjectty = row.IsNull("actionsubjectty") ? string.Empty : row.Field <string>("actionsubjectty"); entity.actionsubjectval = row.IsNull("actionsubjectval") ? string.Empty : row.Field <string>("actionsubjectval"); entity.actiontype = row.IsNull("actiontype") ? string.Empty : row.Field <string>("actiontype"); entity.camactivitycd = row.IsNull("camactivitycd") ? string.Empty : row.Field <string>("camactivitycd"); entity.cmactivitycd = row.IsNull("cmactivitycd") ? string.Empty : row.Field <string>("cmactivitycd"); entity.comment = row.IsNull("comment") ? string.Empty : row.Field <string>("comment"); entity.cono = row.IsNull("cono") ? 0 : row.Field <int>("cono"); entity.contactid = row.IsNull("contactid") ? decimal.Zero : row.Field <decimal>("contactid"); entity.custnobeg = row.IsNull("custnobeg") ? decimal.Zero : row.Field <decimal>("custnobeg"); entity.custnoend = row.IsNull("custnoend") ? decimal.Zero : row.Field <decimal>("custnoend"); entity.custnorangety = row.IsNull("custnorangety") ? string.Empty : row.Field <string>("custnorangety"); entity.emailsubject = row.IsNull("emailsubject") ? string.Empty : row.Field <string>("emailsubject"); entity.emailtext = row.IsNull("emailtext") ? string.Empty : row.Field <string>("emailtext"); entity.eventname = row.IsNull("eventname") ? string.Empty : row.Field <string>("eventname"); entity.expiredt = row.Field <DateTime?>("expiredt"); entity.operinit = row.IsNull("operinit") ? string.Empty : row.Field <string>("operinit"); entity.prodbeg = row.IsNull("prodbeg") ? string.Empty : row.Field <string>("prodbeg"); entity.prodcatbeg = row.IsNull("prodcatbeg") ? string.Empty : row.Field <string>("prodcatbeg"); entity.prodcatend = row.IsNull("prodcatend") ? string.Empty : row.Field <string>("prodcatend"); entity.prodcatrangety = row.IsNull("prodcatrangety") ? string.Empty : row.Field <string>("prodcatrangety"); entity.prodend = row.IsNull("prodend") ? string.Empty : row.Field <string>("prodend"); entity.prodrangety = row.IsNull("prodrangety") ? string.Empty : row.Field <string>("prodrangety"); entity.programtorun = row.IsNull("programtorun") ? string.Empty : row.Field <string>("programtorun"); entity.prosno = row.IsNull("prosno") ? decimal.Zero : row.Field <decimal>("prosno"); entity.regionbeg = row.IsNull("regionbeg") ? string.Empty : row.Field <string>("regionbeg"); entity.regionend = row.IsNull("regionend") ? string.Empty : row.Field <string>("regionend"); entity.regionrangety = row.IsNull("regionrangety") ? string.Empty : row.Field <string>("regionrangety"); entity.slctamountary = row.IsNull("slctamountary") ? 0 : row.Field <int>("slctamountary"); entity.slctamountty = row.IsNull("slctamountty") ? string.Empty : row.Field <string>("slctamountty"); entity.slctamountval = row.IsNull("slctamountval") ? decimal.Zero : row.Field <decimal>("slctamountval"); entity.slctcharary = row.IsNull("slctcharary") ? 0 : row.Field <int>("slctcharary"); entity.slctcharty = row.IsNull("slctcharty") ? string.Empty : row.Field <string>("slctcharty"); entity.slctcharval = row.IsNull("slctcharval") ? string.Empty : row.Field <string>("slctcharval"); entity.slctdateary = row.IsNull("slctdateary") ? 0 : row.Field <int>("slctdateary"); entity.slctdatety = row.IsNull("slctdatety") ? string.Empty : row.Field <string>("slctdatety"); entity.slctdateval = row.IsNull("slctdateval") ? 0 : row.Field <int>("slctdateval"); entity.slctpriceary = row.IsNull("slctpriceary") ? 0 : row.Field <int>("slctpriceary"); entity.slctpricety = row.IsNull("slctpricety") ? string.Empty : row.Field <string>("slctpricety"); entity.slctpriceval = row.IsNull("slctpriceval") ? decimal.Zero : row.Field <decimal>("slctpriceval"); entity.statustype = row.IsNull("statustype") ? string.Empty : row.Field <string>("statustype"); entity.transdt = row.Field <DateTime?>("transdt"); entity.transproc = row.IsNull("transproc") ? string.Empty : row.Field <string>("transproc"); entity.transtm = row.IsNull("transtm") ? string.Empty : row.Field <string>("transtm"); entity.vendnobeg = row.IsNull("vendnobeg") ? decimal.Zero : row.Field <decimal>("vendnobeg"); entity.vendnoend = row.IsNull("vendnoend") ? decimal.Zero : row.Field <decimal>("vendnoend"); entity.vendnorangety = row.IsNull("vendnorangety") ? string.Empty : row.Field <string>("vendnorangety"); entity.whsebeg = row.IsNull("whsebeg") ? string.Empty : row.Field <string>("whsebeg"); entity.whseend = row.IsNull("whseend") ? string.Empty : row.Field <string>("whseend"); entity.whserangety = row.IsNull("whserangety") ? string.Empty : row.Field <string>("whserangety"); entity.whooper = row.IsNull("whooper") ? string.Empty : row.Field <string>("whooper"); entity.whogroup = row.IsNull("whogroup") ? string.Empty : row.Field <string>("whogroup"); entity.whoemail = row.IsNull("whoemail") ? string.Empty : row.Field <string>("whoemail"); entity.whopos = row.IsNull("whopos") ? string.Empty : row.Field <string>("whopos"); entity.whocontact = row.IsNull("whocontact") ? decimal.Zero : row.Field <decimal>("whocontact"); entity.custenabled = row.Field <bool>("custenabled"); entity.regenabled = row.Field <bool>("regenabled"); entity.prodenabled = row.Field <bool>("prodenabled"); entity.pcatenabled = row.Field <bool>("pcatenabled"); entity.vendenabled = row.Field <bool>("vendenabled"); entity.whseenabled = row.Field <bool>("whseenabled"); entity.amtenabled = row.Field <bool>("amtenabled"); entity.charenabled = row.Field <bool>("charenabled"); entity.prcenabled = row.Field <bool>("prcenabled"); entity.dateenabled = row.Field <bool>("dateenabled"); entity.actionrowid = row.Field <byte[]>("actionrowid").ToStringEncoded(); entity.userfield = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield"); return(entity); }