/// <summary>
/// 获取代理系统权限模块
/// </summary>
/// <param name="roleId">角色编号</param>
/// <param name="moduleId">模块编号</param>
/// <returns>代理系统权限模块对象</returns>
public virtual TSAgentRight Get(string roleId, string moduleId)
{
TSAgentRight tsAgentRight = null;
try
{
string strSQL = "select * from TSAgentRight where roleId=@roleId and moduleId=@moduleId";
Param param = new Param();
param.Clear();
param.Add("@roleId", roleId);
param.Add("@moduleId", moduleId);
db.Open();
ComDataReader dr = db.ExecuteReader(CommandType.Text, strSQL, param);
if (dr.Read())
{
tsAgentRight = ReadData(dr);
}
dr.Close();
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
return(tsAgentRight);
}
/// <summary>
/// 读取代理系统权限模块信息
/// </summary>
/// <param name="dr">记录指针</param>
/// <returns>代理系统权限模块对象</returns>
protected virtual TSAgentRight ReadData(ComDataReader dr)
{
TSAgentRight tsAgentRight = new TSAgentRight();
tsAgentRight.roleId = dr["roleId"].ToString(); //角色编号
tsAgentRight.moduleId = dr["moduleId"].ToString(); //模块编号
return(tsAgentRight);
}
/// <summary>
/// 修改代理系统权限模块
/// </summary>
/// <param name="data">数据库连接</param>
/// <param name="tsAgentRight">代理系统权限模块</param>
public virtual void Edit(DataAccess data, TSAgentRight tsAgentRight)
{
string strSQL = "update TSAgentRight set where roleId=@roleId and moduleId=@moduleId";
Param param = new Param();
param.Clear();
param.Add("@roleId", tsAgentRight.roleId); //角色编号
param.Add("@moduleId", tsAgentRight.moduleId); //模块编号
data.ExecuteNonQuery(CommandType.Text, strSQL, param);
}
protected DataAccess db = new DataAccess(DataAccess.DBConn);//数据库连接
#region 代码生成器自动生成
/// <summary>
/// 增加代理系统权限模块
/// </summary>
/// <param name="data">数据库连接</param>
/// <param name="tsAgentRight">代理系统权限模块</param>
public virtual void Add(DataAccess data, TSAgentRight tsAgentRight)
{
string strSQL = "insert into TSAgentRight (roleId,moduleId) values (@roleId,@moduleId)";
Param param = new Param();
param.Clear();
param.Add("@roleId", tsAgentRight.roleId); //角色编号
param.Add("@moduleId", tsAgentRight.moduleId); //模块编号
data.ExecuteNonQuery(CommandType.Text, strSQL, param);
}
/// <summary>
/// 修改代理系统权限模块
/// </summary>
/// <param name="tsAgentRight">代理系统权限模块</param>
public virtual void Edit(TSAgentRight tsAgentRight)
{
try
{
db.Open();
Edit(db, tsAgentRight);
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
}
/// <summary>
/// 增加代理系统权限模块
/// <param name="tsAgentRight">代理系统权限模块</param>
/// </summary>
public void Add(TSAgentRight tsAgentRight)
{
try
{
db.Open();
Add(db, tsAgentRight);
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
}
