public DateTime?GetDate() { try { //select distinct f_date from t_newbaseball_a with (nolock) where f_sfds=0 order by f_date asc using (var ctx = new BossBallEntities()) { var result = ctx.t_newbaseball_a.Select(g => g.TransferDate).Distinct().FirstOrDefault(); return(result); } } catch (Exception ex) { throw ex; } }
public void GetGames() { //SELECT a.*,(CASE WHEN f_xh = 666 THEN 0 WHEN f_xh = 667 THEN 1 WHEN f_xh = 668 THEN 2 WHEN f_xh = 669 THEN 3 else 4 end) as sp1 from(select * FROM dbo.[t_newbaseball_a] with(nolock) where f_sfds = 0)a order by sp1, f_order, f_xh, f_alliance, f_playid, f_date, f_numbera, f_gamedate, f_gpdm, a.id OFFSET 0 ROWS FETCH NEXT 15 ROWS ONLY try { List <NewGame> results = null; using (var ctx = new BossBallEntities()) { var query = ctx.t_newbaseball_a.Where(g => g.MovedFlag == 0) .OrderBy(g => g.Orderd).ThenBy(g => g.AllienceNumber).ThenBy(g => g.AllianceName).ThenBy(g => g.PlayId) .ThenBy(g => g.TransferDate).ThenBy(g => g.GameNumA).ThenBy(g => g.GameDate).ThenBy(g => g.FollowFlag).ThenBy(g => g.Id); results = query.ToList(); } //List<BallCountry> ballCountries = null; //using (var ctx = new BaseDBContext()) //{ // ballCountries = ctx.BallCountries.ToList(); //} // list = list // .GroupJoin(BallCountryList, b => b.f_ballid, l => l.f_mainid, (s, b) => // { // var obj = b.FirstOrDefault(); // bool isnull = obj == null; // s.sp5 = isnull ? "||||" : obj.f_title.ToString(); // s.sp4 = isnull ? "0" : obj.f_sort.ToString(); // return s; // }) //.GroupJoin(BallCountryList, inew => inew.f_countryid, m => m.f_mainid, (s, b) => //{ // var obj = b.FirstOrDefault(); // s.sp3 = obj == null ? "||||" : obj.f_title.ToString(); // return s; //}) //.ToList(); //results.GroupJoin(ballCountries, ) } catch (Exception ex) { throw ex; } }