8,497
社区成员
发帖
与我相关
我的任务
分享
var query=db.acct_info.Select(
(x,index)=>new
{
row_num=index+1,
acct_seq=x.acct_seq,
acct_id=x.acct_id,
acct_img_path=x.acct_img_path,
acct_sname=x.acct_sname,
acct_pwd=x.acct_pwd,
acct_ccoins=x.acct_ccoins,
acct_pcoins=x.acct_pcoins
})
.Where(x=>x.acct_id == "333"&&acct_pwd == "333");
试试这样
var query=db.acct_info.Select(
(x,index)=>new
{
row_num=index++,
acct_seq=x.acct_seq,
acct_id=x.acct_id,
acct_img_path=x.acct_img_path,
acct_sname=x.acct_sname,
acct_pwd=x.acct_pwd,
acct_ccoins=x.acct_ccoins,
acct_pcoins=x.acct_pcoins
})
.Where(x=>x.acct_id == '333'&&acct_pwd == '333');
var query=db.acct_info.Select((x,index)=>new {row_num=index++;acct_seq=x.acct_seq,acct_id=x.acct_id,acct_img_path=x.acct_img_path,acct_sname=x.acct_sname,acct_pwd=x.acct_pwd,acct_ccoins=x.acct_ccoins,acct_pcoins=x.acct_pcoins}).Where(x=>x.acct_id == '333'&&acct_pwd ==
'333');
select acct_seq,acct_id,acct_img_path,acct_sname,acct_ccoins,acct_pcoins,(select a.row_num from
(SELECT Row_Number() OVER (ORDER BY [acct_ccoins] desc) row_num,acct_id,acct_pwd,acct_ccoins FROM [dbo].[acct_info])
a where a.acct_id = '333' and a.acct_pwd = '333') as acct_rank from acct_info
where acct_id = '333' and acct_pwd = '333'