我在controller中自己写了一个简单的Session,在dal层中我想用到这个session,Session["name"]="1";
strSql.Append("select Location from Archives_Location where CompanyID=Session['name']");但是我不能直接写死,所以这样,但是这样写有报错,求教MVCsession
strSql.Append("select Location from Archives_Location where CompanyID=Session['name']");但是我不能直接写死,所以这样,但是这样写有报错,求教MVCsession
System.Web.HttpContext.Current.Session["name"]
一楼是正解,DAL层不应该和session产生什么关系,这是设计原则
{
//string CompanyID =System.Web.HttpContext.Current.Session["CopmpanyID"].ToString();
//System.Web.HttpContext.Current.Session["CompanyID"] = CompanyID;
StringBuilder strSql = new StringBuilder();
strSql.Append("select Location from Location where CompanyID=" );
return DbHelperSQL.Query(strSql.ToString()).Tables[0];
}
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select Location from Archives_Location where CompanyID=" + CompanyID + "");
return DbHelperSQL.Query(strSql.ToString()).Tables[0];
}