public List<CrmMemberScore> SelCrmMemberScoreInfo(string Uid) { List<CrmMemberScore> list = null; try { IParameterMapper ipmapper = new SelCrmMemberScoreInfoParameterMapper(); DataAccessor<CrmMemberScore> tableAccessor; string strSql = @"select * from CrmMemberScore n where n.Uid=@Uid"; tableAccessor = db.CreateSqlStringAccessor(strSql, ipmapper, MapBuilder<CrmMemberScore>.MapAllProperties() // .Map(t => t.Uid).ToColumn("Uid") .Map(t => t.TotalScore).ToColumn("TotalScore") .Map(t => t.LastScore).ToColumn("LastScore") .Map(t => t.LastScoredDate).ToColumn("LastScoredDate") .Map(t => t.Score).ToColumn("Score") .Map(t => t.UseMoney).ToColumn("UseMoney") .Map(t => t.UseScore).ToColumn("UseScore") .Build()); list = tableAccessor.Execute(new string[] { Uid }).ToList(); return list; } catch (Exception ex) { Logger.Log(ex); return null; } }
public List <CrmMemberScore> SelCrmMemberScoreInfo(string Uid) { List <CrmMemberScore> list = null; try { IParameterMapper ipmapper = new SelCrmMemberScoreInfoParameterMapper(); DataAccessor <CrmMemberScore> tableAccessor; string strSql = @"select * from CrmMemberScore n where n.Uid=@Uid"; tableAccessor = db.CreateSqlStringAccessor(strSql, ipmapper, MapBuilder <CrmMemberScore> .MapAllProperties() // .Map(t => t.Uid).ToColumn("Uid") .Map(t => t.TotalScore).ToColumn("TotalScore") .Map(t => t.LastScore).ToColumn("LastScore") .Map(t => t.LastScoredDate).ToColumn("LastScoredDate") .Map(t => t.Score).ToColumn("Score") .Map(t => t.UseMoney).ToColumn("UseMoney") .Map(t => t.UseScore).ToColumn("UseScore") .Build()); list = tableAccessor.Execute(new string[] { Uid }).ToList(); return(list); } catch (Exception ex) { Logger.Log(ex); return(null); } }