/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(tb_role model)
{
StringBuilder strSql = new StringBuilder();
StringBuilder setSql = new StringBuilder();
strSql.Append("update tb_role set ");
if (!String.IsNullOrEmpty(model.name))
{
setSql.Append("name=@name,");
}
strSql.Append(setSql.ToString().TrimEnd(','));
strSql.Append(" where id=@id ");
using (IDbConnection conn = DapperHelper.OpenConnection())
{
int count = conn.Execute(strSql.ToString(), model);
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
}
public bool Add(RoleModel model)
{
var temp = false;
using (var context = new db_cmaEntities())
{
//DOBase<tb_role> tRole = new DOBase<tb_role>(context);
//tRole.Add(GetModel(model));
tb_role dbmodel = new tb_role()
{
Name = model.Name,
Description = model.Description
};
context.tb_role.Add(dbmodel);
context.SaveChanges();
if (model.ActionList.Count() > 0)
{
dbmodel.tb_action.Clear();
dbmodel.tb_action = context.tb_action.Where(n => model.ActionList.Contains(n.Id)).ToList();
}
//context.Configuration.ValidateOnSaveEnabled = false;
temp = context.SaveChanges() > 0 ? true : false;
//context.Configuration.ValidateOnSaveEnabled = true;
}
return(temp);
}
/// <summary>
/// 角色 列表
/// </summary>
public ActionResult roleList(tb_role model)
{
int count = 0;
ViewBag.roleList = drole.GetList(model, ref count);
ViewBag.page = Utils.ShowPage(count, model.PageSize, model.PageIndex, 5);
return(View());
}
private RoleModel GetModel(tb_role dbModel)
{
return(new RoleModel()
{
Id = dbModel.Id,
Name = dbModel.Name,
Description = dbModel.Description,
cFree = dbModel.cFree,
iFree = dbModel.iFree
});
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public tb_role GetInfo(tb_role model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * from tb_role");
strSql.Append(" where id=@id ");
using (IDbConnection conn = DapperHelper.OpenConnection())
{
model = conn.Query <tb_role>(strSql.ToString(), model)?.FirstOrDefault();
}
return(model);
}
/// <summary>
/// 角色 保存
/// </summary>
public JsonResult roleSave(tb_role model)
{
if (model == null)
{
return(ResultTool.jsonResult(false, "参数错误！"));
}
if (!String.IsNullOrEmpty(model.id))
{
bool boolResult = drole.Update(model);
return(ResultTool.jsonResult(boolResult, boolResult ? "成功！" : "更新失败！"));
}
else
{
model.id = Guid.NewGuid().ToString("N");
bool boolResult = drole.Add(model);
return(ResultTool.jsonResult(boolResult, boolResult ? "成功！" : "添加失败！"));
}
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(tb_role model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from tb_role");
strSql.Append(" where id=@id ");
using (IDbConnection conn = DapperHelper.OpenConnection())
{
int count = conn.Execute(strSql.ToString(), model);
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
}
private RoleModel GetModel(tb_role dbModel, List <tb_action> actionList)
{
var actionModelList = new List <long>();
foreach (var item in actionList)
{
actionModelList.Add(item.Id);
}
return(new RoleModel()
{
Id = dbModel.Id,
Name = dbModel.Name,
Description = dbModel.Description,
cFree = dbModel.cFree,
iFree = dbModel.iFree,
ActionList = actionModelList
});
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(tb_role model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tb_role(");
strSql.Append("id,name)");
strSql.Append(" values (");
strSql.Append("@id,@name)");
using (IDbConnection conn = DapperHelper.OpenConnection())
{
int count = conn.Execute(strSql.ToString(), model);
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
}
/// <summary>
/// 获得数据列表
/// </summary>
public List <tb_role> GetList(tb_role model, ref int total)
{
List <tb_role> list;
StringBuilder strSql = new StringBuilder();
StringBuilder whereSql = new StringBuilder(" where 1 = 1 ");
strSql.Append(" select ROW_NUMBER() OVER(ORDER BY id desc) AS RID, * from tb_role ");
if (!String.IsNullOrEmpty(model.name))
{
whereSql.Append(" and name=@name");
}
strSql.Append(whereSql);
string CountSql = "SELECT COUNT(1) as RowsCount FROM (" + strSql.ToString() + ") AS CountList";
string pageSqlStr = "select * from ( " + strSql.ToString() + " ) as Temp_PageData where Temp_PageData.RID BETWEEN {0} AND {1}";
pageSqlStr = string.Format(pageSqlStr, (model.PageSize * (model.PageIndex - 1) + 1).ToString(), (model.PageSize * model.PageIndex).ToString());
using (IDbConnection conn = DapperHelper.OpenConnection())
{
list = conn.Query <tb_role>(pageSqlStr, model)?.ToList();
total = conn.ExecuteScalar <int>(CountSql, model);
}
return(list);
}
/// <summary>
/// 角色 详情
/// </summary>
public ActionResult roleInfo(tb_role model)
{
model = drole.GetInfo(model);
return(View(model ?? new tb_role()));
}
/// <summary>
/// 角色 删除
/// </summary>
public JsonResult roleDelete(tb_role model)
{
bool boolResult = drole.Delete(model);
return(ResultTool.jsonResult(boolResult, boolResult ? "成功！" : "删除失败！"));
}
