/// <summary> /// 根据参数,取用户可维护的大类列表 /// </summary> /// <param name="statCode">参数</param> /// <returns></returns> public ArrayList LoadLevel1Available(string statCode) { string sqlstring = PrepareSQL("Manager.PowerLevelManager.LoadLevel1Available", statCode); ArrayList PowerLevelClass1s = new ArrayList(); if (sqlstring == string.Empty) { return(PowerLevelClass1s); } try { this.ExecQuery(sqlstring); while (this.Reader.Read()) { PowerLevelClass1 info = PrepareLevel1Data(); if (info != null) { PowerLevelClass1s.Add(info); } } this.Reader.Close(); } catch (Exception ex) { this.ErrCode = ex.Message; this.Err = ex.Message; return(null); } return(PowerLevelClass1s); }
/// <summary> /// /// </summary> /// <returns></returns> private PowerLevelClass1 PrepareLevel1Data() { PowerLevelClass1 info = new PowerLevelClass1(); info.Class1Code = this.Reader[0].ToString(); //一级权限分类码,权限类型,对应于表COM_DEPTSTAT.STAT_CODE info.Class1Name = this.Reader[1].ToString(); //一级权限分类名称 info.UniteFlag = FrameWork.Function.NConvert.ToBoolean(this.Reader[2].ToString()); //是否允许统一维护0-不允许1-允许 info.TypeProperty = FrameWork.Function.NConvert.ToInt32(this.Reader[3]); //类型属性:0不能增加分类,只能在下级增加自定义科室,1按科室分类管理(人员只能属于终极科室),2允许在科室分类下面增加人员,3只能维护科室关系,不允许增加人员,4不能添加科室和人员 info.UniteCode = this.Reader[4].ToString(); //统一维护码:相同的编码统一维护成一个 info.VocationType = this.Reader[5].ToString(); //所属业务线 info.VocationName = this.Reader[6].ToString(); //所属业务线名称 info.Memo = this.Reader[7].ToString(); //备注 info.ValidState = NConvert.ToBoolean(this.Reader[8]); //有效状态(1有效,0无效) info.ID = info.Class1Code; info.Name = info.Class1Name; return(info); }