/// <summary>
/// 更新权限
/// </summary>
/// <param name="myModelRole"></param>
/// <returns></returns>
public int updateRole(Model.MoRole myModelRole)
{
int paramEnable = Convert.ToInt32(myModelRole.Enable);
string sqlQuery = @"update T_Role set [Enable]=" + paramEnable
+ " where RoleID='" + myModelRole.RoleID + "' and MODULEID='" + myModelRole.ModuleID + "'";
return(mySqlconn.ExecuteNonQuery(sqlQuery));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Model.MoRole model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into T_Role(");
strSql.Append("RoleID,ModuleID,Enable,IsAdd,IsDelete,IsUpdate,IsExcel,IsRepair)");
strSql.Append(" values (");
strSql.Append("@RoleID,@ModuleID,@Enable,@IsAdd,@IsDelete,@IsUpdate,@IsExcel,@IsRepair)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@RoleID", SqlDbType.VarChar, 10),
new SqlParameter("@ModuleID", SqlDbType.VarChar, 10),
new SqlParameter("@Enable", SqlDbType.Int, 4),
new SqlParameter("@IsAdd", SqlDbType.Int, 4),
new SqlParameter("@IsDelete", SqlDbType.Int, 4),
new SqlParameter("@IsUpdate", SqlDbType.Int, 4),
new SqlParameter("@IsExcel", SqlDbType.Int, 4),
new SqlParameter("@IsRepair", SqlDbType.Int, 4)
};
parameters[0].Value = model.RoleID;
parameters[1].Value = model.ModuleID;
parameters[2].Value = model.Enable;
parameters[3].Value = model.IsAdd;
parameters[4].Value = model.IsDelete;
parameters[5].Value = model.IsUpdate;
parameters[6].Value = model.IsExcel;
parameters[7].Value = model.IsRepair;
object obj = mySqlconn.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 更新权限
/// </summary>
/// <param name="myModelRole"></param>
/// <returns></returns>
public int updateRole(Model.MoRole myModelRole)
{
return(dal.updateRole(myModelRole));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Model.MoRole model)
{
return(dal.Add(model));
}
