/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.role_permission model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update role_permission set ");
strSql.Append("roleid=@roleid,");
strSql.Append("permissionid=@permissionid");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@roleid", SqlDbType.Int, 4),
new SqlParameter("@permissionid", SqlDbType.Int, 4),
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = model.roleid;
parameters[1].Value = model.permissionid;
parameters[2].Value = model.id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool DeleteUser(int id)
{
Model.t_user model = userbll.GetModel(id);
Model.user_role urmodel = user_rolebll.GetModels(model.id);
Model.t_role rolemodel = rolebll.GetModel(urmodel.roleid);
Model.role_permission rolepemodel = role_permissionbll.GetModels(rolemodel.id);
Model.t_permission permmodel = t_permissionbll.GetModel(rolepemodel.permissionid);
if (urmodel != null)
{
user_rolebll.Delete(urmodel.id);
}
if (rolepemodel != null)
{
role_permissionbll.Delete(rolepemodel.id);
}
if (model != null)
{
userbll.Delete(model.id);
}
//if (rolemodel != null)
//{
// rolebll.Delete(rolemodel.id);
//}
if (permmodel != null)
{
t_permissionbll.Delete(permmodel.id);
}
return(true);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Model.role_permission model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into role_permission(");
strSql.Append("roleid,permissionid)");
strSql.Append(" values (");
strSql.Append("@roleid,@permissionid)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@roleid", SqlDbType.Int, 4),
new SqlParameter("@permissionid", SqlDbType.Int, 4)
};
parameters[0].Value = model.roleid;
parameters[1].Value = model.permissionid;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
private string AddUserCon(string username, string name, string pwd, string zhiwu, string jurisdiction)
{
Model.t_user model = new Model.t_user();
Model.t_role model1 = new Model.t_role();
Model.user_role model2 = new Model.user_role();
Model.t_permission model3 = new Model.t_permission();
Model.role_permission model4 = new Model.role_permission();
if (username == null && name == null && pwd == null && zhiwu == null && jurisdiction == null)
{
return("{\"status\": 0,\"msg\":\"添加失败！\"}");
}
if (username != null && name != null && pwd != null)
{
model.username = username;
model.employeename = name;
model.pwd = DESEncrypt.Encrypt(pwd);
model.adddate = (DateTime.Now).ToString();
userbll.Add(model);
}
if (jurisdiction != null)
{
model3.pename = jurisdiction;
model3.adddate = (DateTime.Now).ToString();
t_permissionbll.Add(model3);
}
Model.t_user tmodel = new Model.t_user();
tmodel = userbll.GetModels();
Model.t_role tmodel1 = new Model.t_role();
tmodel1 = rolebll.GetModelss(zhiwu);
Model.t_permission tmodel3 = new Model.t_permission();
tmodel3 = t_permissionbll.GetModels();
if (tmodel != null)
{
//用户ID
model2.userid = tmodel.id;
//角色id
model2.roleid = tmodel1.id;
user_rolebll.Add(model2);
}
if (tmodel3 != null)
{
model4.permissionid = tmodel3.id;
model4.roleid = tmodel1.id;
role_permissionbll.Add(model4);
}
return("{\"status\": 1,\"msg\":\"添加成功！\"}");
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.role_permission DataRowToModel(DataRow row)
{
Model.role_permission model = new Model.role_permission();
if (row != null)
{
if (row["id"] != null && row["id"].ToString() != "")
{
model.id = int.Parse(row["id"].ToString());
}
if (row["roleid"] != null && row["roleid"].ToString() != "")
{
model.roleid = int.Parse(row["roleid"].ToString());
}
if (row["permissionid"] != null && row["permissionid"].ToString() != "")
{
model.permissionid = int.Parse(row["permissionid"].ToString());
}
}
return(model);
}
private string UpdateUserss(string username, string name, string pwd, string zhiwu, string jurisdiction)
{
if (username == null && name == null && pwd == null && zhiwu == null && jurisdiction == null)
{
return("{\"status\": 0,\"msg\":\"修改失败！\"}");
}
Model.t_user model = userbll.GetModelss(username);
if (model != null)
{
model.username = username;
model.employeename = name;
if (model.pwd != pwd)
{
model.pwd = DESEncrypt.Encrypt(pwd);
}
userbll.Update(model);
}
Model.user_role urmodel = user_rolebll.GetModels(model.id);
Model.t_role rolemodel = rolebll.GetModelss(zhiwu);
if (rolemodel != null)
{
urmodel.roleid = rolemodel.id;
user_rolebll.Update(urmodel);
}
//if (rolemodel!=null)
//{
// rolemodel.name = zhiwu;
// rolebll.Update(rolemodel);
//}
Model.role_permission rolepemodel = role_permissionbll.GetModels(rolemodel.id);
Model.t_permission permmodel = t_permissionbll.GetModel(rolepemodel.permissionid);
if (permmodel != null)
{
permmodel.pename = jurisdiction;
t_permissionbll.Update(permmodel);
}
return("{\"status\": 1,\"msg\":\"修改成功！\"}");
}
public ActionResult UpdateUser(int id)
{
Bll.t_role bllrole = new Bll.t_role();
Model.t_user model1 = GetUserInfo();
Model.t_user model = userbll.GetModel(id);
ViewBag.username = model.username; //账号
ViewBag.employeename = model1.employeename; //姓名
ViewBag.employeename1 = model.employeename;
ViewBag.pwd = model.pwd;
if (model != null)
{
Model.user_role urmodel = user_rolebll.GetModels(model.id);
Model.t_role rolemodel = rolebll.GetModel(urmodel.roleid);
ViewBag.zhiwu = rolemodel.name;
if (rolemodel != null)
{
Model.role_permission rolepemodel = role_permissionbll.GetModels(rolemodel.id);
Model.t_permission permmodel = t_permissionbll.GetModel(rolepemodel.permissionid);
ViewBag.pername = permmodel.pename;
}
ViewData["zhiwu1"] = bllrole.GetModelList("1=1");
}
return(View());
}
/// <summary>
/// 根据角色id得到一个对象实体
/// </summary>
public Model.role_permission GetModels(int roleid)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id,roleid,permissionid from role_permission ");
strSql.Append(" where roleid=@roleid");
SqlParameter[] parameters =
{
new SqlParameter("@roleid", SqlDbType.Int, 4)
};
parameters[0].Value = roleid;
Model.role_permission model = new Model.role_permission();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.role_permission model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Model.role_permission model)
{
return(dal.Add(model));
}
