/// <summary>
/// 增加一条数据
/// </summary>
public void Add(Entity.BASE_USER_ROLE entity)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into BASE_USER_ROLE(");
strSql.Append("USERROLEID,USERID,ROLEID,MENUID,ACTIONID");
strSql.Append(") values (");
strSql.Append(":USERROLEID,:USERID,:ROLEID,:MENUID,:ACTIONID");
strSql.Append(") ");
OracleParameter[] parameters =
{
new OracleParameter(":USERROLEID", OracleType.Number, 4),
new OracleParameter(":USERID", OracleType.Number, 4),
new OracleParameter(":ROLEID", OracleType.Number, 4),
new OracleParameter(":MENUID", OracleType.Number, 4),
new OracleParameter(":ACTIONID", OracleType.Number, 4)
};
parameters[0].Value = entity.USERROLEID;
parameters[1].Value = entity.USERID;
parameters[2].Value = entity.ROLEID;
parameters[3].Value = entity.MENUID;
parameters[4].Value = entity.ACTIONID;
OracleHelper.ExecuteNonQuery(strSql.ToString(), parameters);
}
protected Entity.BASE_USER_ROLE GetModel(decimal userid, decimal ROLEID, decimal MENUID, decimal ACTIONID)
{
Entity.BASE_USER_ROLE Model = new Entity.BASE_USER_ROLE();
Model.USERROLEID = -1; //主键，ID
Model.USERID = userid; // 用户编号；
Model.ROLEID = ROLEID; //角色编号；
Model.MENUID = MENUID; //菜单编号；
Model.ACTIONID = ACTIONID; //动作编号；
return(Model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Entity.BASE_USER_ROLE GetEntity(decimal USERROLEID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select USERROLEID, USERID, ROLEID, MENUID, ACTIONID ");
strSql.Append(" from BASE_USER_ROLE ");
strSql.Append(" where USERROLEID=:USERROLEID ");
OracleParameter[] parameters =
{
new OracleParameter(":USERROLEID", OracleType.Number, 4)
};
parameters[0].Value = USERROLEID;
Entity.BASE_USER_ROLE entity = new Entity.BASE_USER_ROLE();
DataTable dt = OracleHelper.Query(CommandType.Text, strSql.ToString(), parameters);
if (dt.Rows.Count > 0)
{
if (dt.Rows[0]["USERROLEID"].ToString() != "")
{
entity.USERROLEID = decimal.Parse(dt.Rows[0]["USERROLEID"].ToString());
}
if (dt.Rows[0]["USERID"].ToString() != "")
{
entity.USERID = decimal.Parse(dt.Rows[0]["USERID"].ToString());
}
if (dt.Rows[0]["ROLEID"].ToString() != "")
{
entity.ROLEID = decimal.Parse(dt.Rows[0]["ROLEID"].ToString());
}
if (dt.Rows[0]["MENUID"].ToString() != "")
{
entity.MENUID = decimal.Parse(dt.Rows[0]["MENUID"].ToString());
}
if (dt.Rows[0]["ACTIONID"].ToString() != "")
{
entity.ACTIONID = decimal.Parse(dt.Rows[0]["ACTIONID"].ToString());
}
return(entity);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Entity.BASE_USER_ROLE entity)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update BASE_USER_ROLE set ");
strSql.Append(" USERROLEID = :USERROLEID , ");
strSql.Append(" USERID = :USERID , ");
strSql.Append(" ROLEID = :ROLEID , ");
strSql.Append(" MENUID = :MENUID , ");
strSql.Append(" ACTIONID = :ACTIONID ");
strSql.Append(" where USERROLEID=:USERROLEID ");
OracleParameter[] parameters =
{
new OracleParameter(":USERROLEID", OracleType.Number, 4),
new OracleParameter(":USERID", OracleType.Number, 4),
new OracleParameter(":ROLEID", OracleType.Number, 4),
new OracleParameter(":MENUID", OracleType.Number, 4),
new OracleParameter(":ACTIONID", OracleType.Number, 4)
};
parameters[0].Value = entity.USERROLEID;
parameters[1].Value = entity.USERID;
parameters[2].Value = entity.ROLEID;
parameters[3].Value = entity.MENUID;
parameters[4].Value = entity.ACTIONID;
int rows = OracleHelper.ExecuteNonQuery(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 向用户授权
/// </summary>
public void Add(Entity.BASE_USER_ROLE model)
{
dal.Add(model);
}
