public void Save(RoleInfo item) { if(item.IsNew) { Insert(item); } else { Update(item); } }
public void Update(RoleInfo item) { if(item.ChangedPropertyCount>0) { StringBuilder sqlbuilder = new StringBuilder(); sqlbuilder.Append("UPDATE [RoleInfos] SET "); Dictionary<string,string> cols =new Dictionary<string,string>(); cols.Add("RoleCode","[RoleCode]"); cols.Add("RoleName","[RoleName]"); cols.Add("Remark","[Remark]"); cols.Add("ParentID","[ParentID]"); cols.Add("IsSystem","[IsSystem]"); cols.Add("RolePath","[RolePath]"); cols.Add("LastUpdateUserUID","[LastUpdateUserUID]"); cols.Add("LastUpdateUserName","[LastUpdateUserName]"); cols.Add("LastUpdateTime","[LastUpdateTime]"); int i = 0; //UPDATE COLUMNS foreach (string p in item.ChangedPropertyList) { if(!cols.ContainsKey(p)) { continue; } if (i > 0) { sqlbuilder.Append(","); } sqlbuilder.AppendFormat("{0}=@{1}", cols[p], p); i++; } //WHERE; sqlbuilder.Append(" WHERE [RoleID]=@RoleID"); List<SqlParameter> SPParams = new List<SqlParameter>(); SPParams.Add(new SqlParameter("@RoleID",item.RoleID)); if(item.IsChanged("RoleCode")) { SPParams.Add(new SqlParameter("@RoleCode",item.RoleCode)); } if(item.IsChanged("RoleName")) { SPParams.Add(new SqlParameter("@RoleName",item.RoleName)); } if(item.IsChanged("Remark")) { SPParams.Add(new SqlParameter("@Remark",item.Remark)); } if(item.IsChanged("ParentID")) { SPParams.Add(new SqlParameter("@ParentID",item.ParentID)); } if(item.IsChanged("IsSystem")) { SPParams.Add(new SqlParameter("@IsSystem",item.IsSystem)); } if(item.IsChanged("RolePath")) { SPParams.Add(new SqlParameter("@RolePath",item.RolePath)); } if(item.IsChanged("LastUpdateUserUID")) { SPParams.Add(new SqlParameter("@LastUpdateUserUID",item.LastUpdateUserUID)); } if(item.IsChanged("LastUpdateUserName")) { SPParams.Add(new SqlParameter("@LastUpdateUserName",item.LastUpdateUserName)); } if(item.IsChanged("LastUpdateTime")) { SPParams.Add(new SqlParameter("@LastUpdateTime",item.LastUpdateTime)); } base.ExecuteNonQuery(sqlbuilder.ToString(), SPParams.ToArray()); } }
public List<RoleInfo> QueryAll() { string sql ="SELECT [RoleID],[RoleCode],[RoleName],[Remark],[ParentID],[IsSystem],[RolePath],[LastUpdateUserUID],[LastUpdateUserName],[LastUpdateTime] FROM [RoleInfos]"; List<RoleInfo> list =new List<RoleInfo>(); using(IDataReader reader = base.ExcuteDataReader(sql)) { while(reader.Read()) { RoleInfo item =new RoleInfo(); item.RoleID = reader.GetInt32(0); item.RoleCode = reader.GetString(1); item.RoleName = reader.GetString(2); if(!reader.IsDBNull(3)) { item.Remark = reader.GetString(3); } if(!reader.IsDBNull(4)) { item.ParentID = reader.GetInt32(4); } item.IsSystem = reader.GetBoolean(5); if(!reader.IsDBNull(6)) { item.RolePath = reader.GetString(6); } item.LastUpdateUserUID = reader.GetString(7); item.LastUpdateUserName = reader.GetString(8); item.LastUpdateTime = reader.GetDateTime(9); list.Add(item); } } return list; }
public void Insert(RoleInfo item) { string sql="INSERT INTO [RoleInfos] ([RoleCode],[RoleName],[Remark],[ParentID],[IsSystem],[RolePath],[LastUpdateUserUID],[LastUpdateUserName],[LastUpdateTime]) VALUES (@RoleCode,@RoleName,@Remark,@ParentID,@IsSystem,@RolePath,@LastUpdateUserUID,@LastUpdateUserName,@LastUpdateTime)"; List<SqlParameter> SPParams = new List<SqlParameter>(); SPParams.Add(new SqlParameter("@RoleCode",item.RoleCode)); SPParams.Add(new SqlParameter("@RoleName",item.RoleName)); SPParams.Add(new SqlParameter("@Remark",item.Remark)); SPParams.Add(new SqlParameter("@ParentID",item.ParentID)); SPParams.Add(new SqlParameter("@IsSystem",item.IsSystem)); SPParams.Add(new SqlParameter("@RolePath",item.RolePath)); SPParams.Add(new SqlParameter("@LastUpdateUserUID",item.LastUpdateUserUID)); SPParams.Add(new SqlParameter("@LastUpdateUserName",item.LastUpdateUserName)); SPParams.Add(new SqlParameter("@LastUpdateTime",item.LastUpdateTime)); sql +=";SELECT Scope_Identity()"; object o = base.ExecuteScalar(sql, SPParams.ToArray()); if(o!=null){ item.RoleID =Convert.ToInt32(o); } }
public RoleInfo Get(int key) { string sql = "SELECT [RoleID],[RoleCode],[RoleName],[Remark],[ParentID],[IsSystem],[RolePath],[LastUpdateUserUID],[LastUpdateUserName],[LastUpdateTime] FROM [RoleInfos] WHERE [RoleID]=@RoleID"; SqlParameter p =new SqlParameter("@RoleID",key); RoleInfo item =null; using(IDataReader reader = base.ExcuteDataReader(sql,p)) { if(reader.Read()) { item =new RoleInfo(); item.RoleID = reader.GetInt32(0); item.RoleCode = reader.GetString(1); item.RoleName = reader.GetString(2); if(!reader.IsDBNull(3)) { item.Remark = reader.GetString(3); } if(!reader.IsDBNull(4)) { item.ParentID = reader.GetInt32(4); } item.IsSystem = reader.GetBoolean(5); if(!reader.IsDBNull(6)) { item.RolePath = reader.GetString(6); } item.LastUpdateUserUID = reader.GetString(7); item.LastUpdateUserName = reader.GetString(8); item.LastUpdateTime = reader.GetDateTime(9); } } return item; }
public ActionResult EditRole(int? id, int? ParentID, string ParentName) { RoleInfo ri; if (id.HasValue) { ri = sysManageService.GetRoleInfo(id.Value); if (ri == null) { throw new ArgumentException("参数错误,不存在对应的角色", "RoleID"); } else { if (ri.IsSystem) { throw new NoPermissionExecption("您无法编辑系统角色"); } } } else { ri = new RoleInfo(); if (ParentID.HasValue) { ri.ParentID = ParentID; ri.ParentName = ParentName; } else { ri.ParentName = "根角色"; } } return View(ri); }
public JsonResult SaveRoleInfo(int? id, RoleInfo ri) { JsonReturnMessages msg = new JsonReturnMessages(); try { if (id.HasValue && id.Value > 0) { ri.IsNew = false; ri.RoleID = id.Value; } else { ri.IsNew = true; } ri.LastUpdateUserUID = base.UserId; ri.LastUpdateUserName = base.CurrentUser.FullName; ri.LastUpdateTime = DateTime.Now; ri.IsSystem = false; sysManageService.SaveRoleInfo(ri); msg.IsSuccess = true; msg.Msg = "操作成功"; } catch (BizException ex) { msg.IsSuccess = false; msg.Msg = ex.Message; } catch (Exception ex) { msg.IsSuccess = false; msg.Msg = "操作失败:" + ex.Message; } return Json(msg); }