/// <summary> /// 根据USER_FID获取角色选项 /// </summary> /// <param name="userFid"></param> /// <returns></returns> public List <GuidValueDatasourceInfo> GetRolesByUserFid(Guid userFid, Guid plantFid) { //ROLE_FID string sql = "select a.[ROLE_FID],[ROLE_NAME] from dbo.[TS_SYS_USER_ROLE] a with(nolock) " + "left join dbo.[TS_SYS_ROLE] b with(nolock) on a.[ROLE_FID] = b.[FID] " + "where [USER_FID] = @USER_FID AND [PLANT_FID] = @PLANT_FID " + "and a.[VALID_FLAG] <> 0 and b.[VALID_FLAG] <> 0 GROUP BY ROLE_FID,ROLE_NAME ORDER BY ROLE_NAME"; Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(sql); db.AddInParameter(dbCommand, "@USER_FID", DbType.Guid, userFid); db.AddInParameter(dbCommand, "@PLANT_FID", DbType.Guid, plantFid); List <GuidValueDatasourceInfo> list = new List <GuidValueDatasourceInfo>(); using (IDataReader dr = db.ExecuteReader(dbCommand)) { while (dr.Read()) { GuidValueDatasourceInfo info = new GuidValueDatasourceInfo(); info.GuidValue = DBConvert.GetGuid(dr, dr.GetOrdinal("ROLE_FID"));//ROLE_FID info.StringDisplay = DBConvert.GetString(dr, dr.GetOrdinal("ROLE_NAME")); list.Add(info); } } return(list); }
/// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnYes_Click(object sender, EventArgs e) { if (_stringItems.Count > 0) { StringValueDatasourceInfo item = cbList.SelectedItem as StringValueDatasourceInfo; selectedValue = item.StringValue; } if (_guidItems.Count > 0) { GuidValueDatasourceInfo item = cbList.SelectedItem as GuidValueDatasourceInfo; selectedGuidValue = item.GuidValue; } this.DialogResult = DialogResult.Yes; this.Close(); }
public List <GuidValueDatasourceInfo> GetDataSource() { string sql = "select [FID],[ROLE_NAME] from dbo.[TS_SYS_ROLE] with(nolock) " + "where [VALID_FLAG] = @VALID_FLAG " + "order by [ROLE_NAME];"; Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(sql); db.AddInParameter(dbCommand, "@VALID_FLAG", DbType.Boolean, true); List <GuidValueDatasourceInfo> list = new List <GuidValueDatasourceInfo>(); using (IDataReader dr = db.ExecuteReader(dbCommand)) { while (dr.Read()) { GuidValueDatasourceInfo info = new GuidValueDatasourceInfo(); info.GuidValue = DBConvert.GetGuid(dr, dr.GetOrdinal("FID")); info.StringDisplay = DBConvert.GetString(dr, dr.GetOrdinal("ROLE_NAME")); list.Add(info); } } return(list); }
/// <summary> /// 根据USER_FID获取角色选项 /// </summary> /// <param name="userFid"></param> /// <returns></returns> public List <GuidValueDatasourceInfo> GetRolesByUserFid(Guid userFid) { ///可以将不同权限范围的相同角色进行合并 string sql = "select [FID],[ROLE_NAME] from dbo.[TS_SYS_ROLE] with(nolock) " + "where [FID] in (select [ROLE_FID] from dbo.[TS_SYS_USER_ROLE] with(nolock) " + "where [USER_FID] = @USER_FID and [VALID_FLAG] = 1) and [VALID_FLAG] = 1;"; Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(sql); db.AddInParameter(dbCommand, "@USER_FID", DbType.Guid, userFid); List <GuidValueDatasourceInfo> list = new List <GuidValueDatasourceInfo>(); using (IDataReader dr = db.ExecuteReader(dbCommand)) { while (dr.Read()) { GuidValueDatasourceInfo info = new GuidValueDatasourceInfo(); info.GuidValue = DBConvert.GetGuid(dr, dr.GetOrdinal("FID")); info.StringDisplay = DBConvert.GetString(dr, dr.GetOrdinal("ROLE_NAME")); list.Add(info); } } return(list); }