/// <summary>
/// 更新一条数据
/// </summary>
public void Update(SysPrivileges model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update SysPrivileges set ");
strSql.Append("roleId=@roleId,");
strSql.Append("departmentId=@departmentId,");
strSql.Append("levelNo=@levelNo,");
strSql.Append("parentLevelNo=@parentLevelNo");
strSql.Append(" where id=@id ");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4),
new SqlParameter("@roleId", SqlDbType.Int, 4),
new SqlParameter("@departmentId", SqlDbType.Int, 4),
new SqlParameter("@levelNo", SqlDbType.Int, 4),
new SqlParameter("@parentLevelNo", SqlDbType.Int, 4)
};
parameters[0].Value = model.id;
parameters[1].Value = model.roleId;
parameters[2].Value = model.departmentId;
parameters[3].Value = model.levelNo;
parameters[4].Value = model.parentLevelNo;
DBHelperSQL.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// 增加一条数据
/// </summary>
public static int Add(SysPrivileges model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into SysPrivileges(");
strSql.Append("roleId,departmentId,levelNo,parentLevelNo)");
strSql.Append(" values (");
strSql.Append("@roleId,@departmentId,@levelNo,@parentLevelNo)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@roleId", SqlDbType.Int, 4),
new SqlParameter("@departmentId", SqlDbType.Int, 4),
new SqlParameter("@levelNo", SqlDbType.Int, 4),
new SqlParameter("@parentLevelNo", SqlDbType.Int, 4)
};
parameters[0].Value = model.roleId;
parameters[1].Value = model.departmentId;
parameters[2].Value = model.levelNo;
parameters[3].Value = model.parentLevelNo;
object obj = DBHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(1);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 权限更新
/// </summary>
private void UpdatePrivilege()
{
//先Delete已有的重新添加
string sql = "delete from SysPrivileges where roleId = " + roleId;
int rows = DBHelperSQL.ExecuteSql(sql);
if (strLevelNo.Length == 0 && rows > 0)
{
Response.Write("success");
}
else
{
string[] arr = strLevelNo.TrimEnd(',').Split(',');
int num = 5;
SysPrivileges item = null;
StringBuilder sb = new StringBuilder();
if (arr.Length > 0)
{
for (int i = 0; i < arr.Length; i++)
{
item = new SysPrivileges();
item.roleId = roleId;
item.departmentId = departId;
if (arr[i] != "on")
{
item.levelNo = Convert.ToInt32(arr[i]);
}
item.parentLevelNo = OALevelService.GetparentLevelNoByLevelNo(item.levelNo);
if (!SysPrivilegesService.Exists(item.roleId, item.departmentId, item.levelNo))
{
num = SysPrivilegesService.Add(item);
if (num == 0)
{
sb.Append("权限编号：" + item.levelNo + "添加失败，");
}
}
}
}
if (num == 0)
{
Response.Write(sb.ToString());
}
else
{
Response.Write("success");
}
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public SysPrivileges GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id,roleId,departmentId,levelNo,parentLevelNo from SysPrivileges ");
strSql.Append(" where id=@id ");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
SysPrivileges model = new SysPrivileges();
DataSet ds = DBHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["id"].ToString() != "")
{
model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString());
}
if (ds.Tables[0].Rows[0]["roleId"].ToString() != "")
{
model.roleId = int.Parse(ds.Tables[0].Rows[0]["roleId"].ToString());
}
if (ds.Tables[0].Rows[0]["departmentId"].ToString() != "")
{
model.departmentId = int.Parse(ds.Tables[0].Rows[0]["departmentId"].ToString());
}
model.levelNo = int.Parse(ds.Tables[0].Rows[0]["levelNo"].ToString());
model.parentLevelNo = int.Parse(ds.Tables[0].Rows[0]["parentLevelNo"].ToString());
return(model);
}
else
{
return(null);
}
}
