/// <summary> /// /// </summary> /// <param name="info"></param> /// <returns></returns> public int Delete(PowerLevelClass3 info) { string strSql = ""; if (this.Sql.GetSql("Manager.PowerLevelClass3ManagerImpl.DeletePowerLevelClass3", ref strSql) == -1) { return(-1); } try { strSql = string.Format(strSql, info.Class2Code, info.Class3Code); } catch (Exception ex) { this.ErrCode = ex.Message; this.Err = ex.Message; return(-1); } try { return(this.ExecNoQuery(strSql)); } catch (Exception ex) { this.ErrCode = ex.Message; this.Err = ex.Message; return(-1); } }
/// <summary> /// /// </summary> /// <param name="info"></param> /// <returns></returns> public int UpdatePowerLevelClass3(PowerLevelClass3 info) { string strSql = ""; if (this.Sql.GetSql("Manager.PowerLevelClass3ManagerImpl.UpdatePowerLevelClass3", ref strSql) == -1) { return(-1); } try { strSql = string.Format(strSql, info.Class2Code, info.Class3Code, info.Class3Name, info.Class3MeaningCode, info.Class3MeaningName, info.FinFlag, info.DelFlag, info.GrantFlag, info.Class3JoinCode, info.JoinGroupCode, info.JoinGroupOrder, info.CheckFlag, info.Memo, this.Operator.ID); } catch (Exception ex) { this.ErrCode = ex.Message; this.Err = ex.Message; return(-1); } try { return(this.ExecNoQuery(strSql)); } catch (Exception ex) { this.ErrCode = ex.Message; this.Err = ex.Message; return(-1); } }
/// <summary> /// 根据二级权限编码,取所有三级权限信息 /// </summary> /// <returns></returns> public ArrayList LoadLevel3ByLevel2(string class2) { ArrayList levels = new ArrayList(); //取sql语句 string sqlstring = PrepareSQL("Manager.PowerLevelManager.LoadLevel3ByLevel2", class2); if (sqlstring == string.Empty) { return(levels); } try { //执行sql语句,取数据 this.ExecQuery(sqlstring); PowerLevelClass3 level3 = null; while (this.Reader.Read()) { level3 = PrepareLevel3Data(); levels.Add(level3); } this.Reader.Close(); } catch (Exception ex) { this.ErrCode = ex.Message; this.Err = ex.Message; return(null); } return(levels); }
/// <summary> /// 根据一级权限编码,取所有2、3级权限信息 /// </summary> /// <returns></returns> public ArrayList LoadLevel3ByLevel1(string class1) { ArrayList levels = new ArrayList(); //取sql语句 string sqlstring = PrepareSQL("Manager.PowerLevelManager.LoadLevel3ByLevel1", class1); if (sqlstring == string.Empty) { return(levels); } try { //执行sql语句,取数据 this.ExecQuery(sqlstring); PowerLevelClass3 level3 = null; while (this.Reader.Read()) { // PowerLevelClass3 level3 = new PowerLevelClass3(); // level3.Class2Code = this.Reader[0].ToString(); // level3.Class3Code = this.Reader[1].ToString(); // level3.Class3Name = this.Reader[2].ToString(); // level3.Class3MeaningCode = this.Reader[3].ToString(); // level3.Class3MeaningName = this.Reader[4].ToString(); // level3.FinFlag = FrameWork.Function.NConvert.ToBoolean(this.Reader[5].ToString()); // level3.DelFlag = FrameWork.Function.NConvert.ToBoolean(this.Reader[6].ToString()); // level3.GrantFlag = FrameWork.Function.NConvert.ToBoolean(this.Reader[7].ToString()); // level3.Class3JoinCode = this.Reader[8].ToString(); // level3.JoinGroupCode = this.Reader[9].ToString(); // level3.JoinGroupOrder = FrameWork.Function.NConvert.ToInt32(this.Reader[10].ToString()); // level3.CheckFlag = FrameWork.Function.NConvert.ToBoolean(this.Reader[11].ToString()); // level3.Memo = this.Reader[12].ToString(); // level3.PowerLevelClass2.Class2Name = this.Reader[13].ToString(); // level3.PowerLevelClass2.Class1Code = this.Reader[14].ToString(); level3 = PrepareLevel3Data(); levels.Add(level3); } this.Reader.Close(); } catch (Exception ex) { this.ErrCode = ex.Message; this.Err = ex.Message; return(null); } return(levels); }
/// <summary> /// /// </summary> /// <returns></returns> /// public PowerLevelClass3 LoadLevel3ByPrimaryKey(string class2Code, string class3Code, bool lazy) { string sqlstring = PrepareSQL("Manager.PowerLevelManager.LoadLevel3ByPrimaryKey", new string[] { class2Code, class3Code }); if (sqlstring == string.Empty) { return(null); } try { this.ExecQuery(sqlstring); PowerLevelClass3 level3 = new PowerLevelClass3(); if (this.Reader.Read()) { level3.Class2Code = this.Reader[0].ToString(); level3.Class3Code = this.Reader[1].ToString(); level3.Class3Name = this.Reader[2].ToString(); level3.Class3MeaningCode = this.Reader[3].ToString(); level3.Class3MeaningName = this.Reader[4].ToString(); level3.FinFlag = FrameWork.Function.NConvert.ToBoolean(this.Reader[5].ToString()); level3.DelFlag = FrameWork.Function.NConvert.ToBoolean(this.Reader[6].ToString()); level3.GrantFlag = FrameWork.Function.NConvert.ToBoolean(this.Reader[7].ToString()); level3.Class3JoinCode = this.Reader[8].ToString(); level3.JoinGroupCode = this.Reader[9].ToString(); level3.JoinGroupOrder = FrameWork.Function.NConvert.ToInt32(this.Reader[10].ToString()); level3.CheckFlag = FrameWork.Function.NConvert.ToBoolean(this.Reader[11].ToString()); level3.Memo = this.Reader[12].ToString(); if (!lazy) { PowerLevel2Manager level2Mgr = new PowerLevel2Manager(); level3.PowerLevelClass2 = level2Mgr.LoadLevel2ByPrimaryKey(level3.Class2Code, lazy); } } this.Reader.Close(); return(level3); } catch (Exception ex) { this.ErrCode = ex.Message; this.Err = ex.Message; return(null); } }
/// <summary> /// 根据项目类别、分类内容获取描述信息 /// </summary> /// <param name="customType">分类</param> /// <param name="typeItem">分类内容</param> /// <returns></returns> protected string GetDescriptionFromTypeItem(EnumMSCustomType customType, string typeItem, TransTypes trans) { switch (customType) { case Neusoft.HISFC.Models.Base.EnumMSCustomType.入库: //根据入库类型检索 case Neusoft.HISFC.Models.Base.EnumMSCustomType.出库: //根据出库类型检索 Neusoft.HISFC.BizLogic.Manager.PowerLevelManager powerManager = new Neusoft.HISFC.BizLogic.Manager.PowerLevelManager(); PowerLevelClass3 pIn3 = powerManager.LoadLevel3ByPrimaryKey(Neusoft.HISFC.Models.Base.EnumMSCustomTypeService.GetNameFromEnum(customType), typeItem); return(customType.ToString() + " - " + pIn3.Name); case Neusoft.HISFC.Models.Base.EnumMSCustomType.科室: //科室 根据入出库科室选择 Neusoft.HISFC.BizLogic.Manager.PrivInOutDept privInOutManager = new Neusoft.HISFC.BizLogic.Manager.PrivInOutDept(); return("科室 - " + this.deptHelper.GetName(typeItem)); case Neusoft.HISFC.Models.Base.EnumMSCustomType.调价: if (typeItem == "00") { return(this.strAdjustCollection[0]); } else { return(this.strAdjustCollection[1]); } case Neusoft.HISFC.Models.Base.EnumMSCustomType.盘点: //根据盘点盈亏 if (typeItem == "00") { return(this.strCheckCollection[0]); } else { return(this.strCheckCollection[1]); } default: return(customType.ToString()); } }
/// <summary> /// /// </summary> /// <returns></returns> private PowerLevelClass3 PrepareLevel3Data() { PowerLevelClass3 level3 = new PowerLevelClass3(); level3.Class2Code = this.Reader[0].ToString(); level3.Class3Code = this.Reader[1].ToString(); level3.Class3Name = this.Reader[2].ToString(); level3.Class3MeaningCode = this.Reader[3].ToString(); level3.Class3MeaningName = this.Reader[4].ToString(); level3.FinFlag = FrameWork.Function.NConvert.ToBoolean(this.Reader[5].ToString()); level3.DelFlag = FrameWork.Function.NConvert.ToBoolean(this.Reader[6].ToString()); level3.GrantFlag = FrameWork.Function.NConvert.ToBoolean(this.Reader[7].ToString()); level3.Class3JoinCode = this.Reader[8].ToString(); level3.JoinGroupCode = this.Reader[9].ToString(); level3.JoinGroupOrder = FrameWork.Function.NConvert.ToInt32(this.Reader[10].ToString()); level3.CheckFlag = FrameWork.Function.NConvert.ToBoolean(this.Reader[11].ToString()); level3.Memo = this.Reader[12].ToString(); level3.PowerLevelClass2.Class2Name = this.Reader[13].ToString(); level3.PowerLevelClass2.Class1Code = this.Reader[14].ToString(); return(level3); }