Example #1
0
 public void Save(RoleInfo item)
 {
     if(item.IsNew)
         {
             Insert(item);
         }
         else
         {
             Update(item);
         }
 }
Example #2
0
        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());
                }
        }
Example #3
0
 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;
 }
Example #4
0
 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);
         }
 }
Example #5
0
        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;
        }
Example #6
0
 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);
 }
Example #7
0
        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);
        }