/// <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 ? "成功!" : "删除失败!")); }