public JsonResult addGroup(string name, string memo)
{
PowerGroup en = new PowerGroup();
en.name = name;
en.memo = memo;
DaPowerGroup dal = new DaPowerGroup();
var result = new CustomJsonResult();
result.Data = dal.add(en);
return result;
}
/// <summary>
/// 添加权限组
/// </summary>
/// <param name="en">权限组</param>
/// <returns></returns>
public int add(PowerGroup en)
{
string strSql = "insert into PowerGroup (name, memo) values (@name, @memo)";
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@name", en.name),
new SqlParameter("@memo", en.memo)
};
return SqlHelper.ExecuteNonQuery(BaseHelper.DBConnStr, CommandType.Text, strSql, param);
}
public JsonResult updateGroup(string id, string name, string memo)
{
PowerGroup en = new PowerGroup();
en.id = Convert.ToInt32(id);
en.name = name;
en.memo = memo;
DaPowerGroup dal = new DaPowerGroup();
var result = new CustomJsonResult();
result.Data = dal.update(en);
return result;
}
/// <summary>
/// 更新权限组
/// </summary>
/// <param name="en">权限组</param>
/// <returns></returns>
public int update(PowerGroup en)
{
string strSql = "update PowerGroup set name=@name, memo=@memo where id=@id";
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@id", en.id),
new SqlParameter("@name", en.name),
new SqlParameter("@memo", en.memo)
};
return SqlHelper.ExecuteNonQuery(BaseHelper.DBConnStr, CommandType.Text, strSql, param);
}
/// <summary>
/// 删除权限组
/// </summary>
/// <param name="en">权限组</param>
/// <returns></returns>
public int delete(PowerGroup en)
{
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@id", en.id)
};
string strSql = "select count(id) from UserInfo where powergroupID=@id";
DataTable dt = SqlHelper.ExecuteDataset(BaseHelper.DBConnStr, CommandType.Text, strSql, param).Tables[0];
//还有用户在使用权限组，就不能删除
if (dt != null && Convert.ToInt32(dt.Rows[0][0]) > 0)
return 0;
strSql = "delete from PowerGroup where id=@id ";
strSql += "delete from PowerGroupPower where groupID=@id ";
return SqlHelper.ExecuteNonQuery(BaseHelper.DBConnStr, CommandType.Text, strSql, param);
}
/// <summary>
/// 删除操作岗位
/// </summary>
/// <param name="id">权限组ID</param>
/// <returns></returns>
public JsonResult Group_remove(string id)
{
PowerGroup en = new PowerGroup();
en.id = Convert.ToInt32(id);
DaPowerGroup dal = new DaPowerGroup();
var result = new CustomJsonResult();
result.Data = dal.delete(en);
return result;
}