下面的Where条件中Session["User"].ToString()报错,错误12:当前上下文中不存在名称“Session”
sql = " select AutoID,BookingNumber,CreateTime,CreateUser,PrincipleENShName, " +
" TradeShortName,ShippENShName,TwentySize,FourtySize,HQ,FortyFiveSize, " +
" case Recevoir_flag when 1 then '已受理' else '未受理' end as Recevoir_flag,"+
" case Modify_flag when 1 then '已修改' else '未修改' end as Modify_flag,"+
" SO,BerthCreateTime,BerthCreateUser,BerthManageQuantity from " +
" where CreateUser = '" + Session["User"].ToString() + "' v_bk_BookingMain order by AutoID desc";
Session["User"]是登录用户名,我想通过登录用户名来过滤显示的记录,即哪个用户登录只能看见自己的记录?
是不是之前沒對session賦值?
" where CreateUser = '" + Session["User"].ToString() + "' v_bk_BookingMain order by AutoID desc";
这里的v_bk_BookingMain是什么意思?
不好意思,应该是这样的
sql = " select AutoID,BookingNumber,CreateTime,CreateUser,PrincipleENShName, " +
" TradeShortName,ShippENShName,TwentySize,FourtySize,HQ,FortyFiveSize, " +
" case Recevoir_flag when 1 then '已受理' else '未受理' end as Recevoir_flag,"+
" case Modify_flag when 1 then '已修改' else '未修改' end as Modify_flag,"+
" SO,BerthCreateTime,BerthCreateUser,BerthManageQuantity from v_bk_BookingMain " +
" where CreateUser = '" + Session["User"].ToString() + "' order by AutoID desc";