/// <summary> /// 加载所有的查询Sql /// </summary> /// <returns></returns> public int LoadSql() { string strSQL = "select sqlindex, sqlcontent, memo from hdis_com_sql"; try { this.ExecSQLQuery(strSQL); while (this.Reader.Read()) { HdisModels.Object objValue = new HdisModels.Object(); objValue.Id = this.Reader[0].ToString(); objValue.Name = this.Reader[1].ToString(); objValue.Name = objValue.Name.Replace("\r", " "); objValue.Name = objValue.Name.Replace("\t", " "); htSql.Add(objValue.Id, objValue.Name); } } catch { this.Reader.Close(); return(-1); } this.Reader.Close(); return(0); }
/// <summary> /// 获取数据字典(不包括停用项) /// </summary> /// <param name="typeId"></param> /// <returns></returns> public List <HdisModels.Object> GetDictionary(string typeId) { List <HdisModels.Object> infoList = new List <HdisModels.Object>(); HdisModels.Object obj = null; string sql = string.Empty; try { sql = @"select * from hdis_sys_dictionary a where a.typeid='{0}' and a.isshow='1' order by a.showorder"; sql = string.Format(sql, typeId); if (this.ExecSQLQuery(sql) < 0) { return(null); } while (this.Reader.Read()) { obj = new HdisModels.Object(); obj.Id = Reader["DICID"].ToString(); obj.Name = Reader["DICNAME"].ToString(); obj.strMemo1 = Reader["MEMO1"].ToString(); obj.strMemo2 = Reader["MEMO2"].ToString(); obj.strMemo3 = Reader["MEMO3"].ToString(); infoList.Add(obj); } return(infoList); } catch { return(infoList); } finally { this.oracleDb.CloseReader(); this.oracleDb.CloseDB(); } }
/// <summary> /// 通过ID查找Sql /// </summary> /// <param name="SqlID"></param> /// <param name="Sql"></param> /// <returns></returns> public int LoadSql(string SqlID, ref string Sql) { string strSQL = "select sqlindex, sqlcontent, memo from hdis_com_sql where sqlindex = '{0}'"; strSQL = string.Format(strSQL, SqlID); this.ExecSQLQuery(strSQL); if (this.Reader.Read()) { HdisModels.Object objValue = new HdisModels.Object(); objValue.Id = this.Reader[0].ToString(); objValue.Name = this.Reader[1].ToString(); objValue.Name = objValue.Name.Replace("\r", " "); objValue.Name = objValue.Name.Replace("\t", " "); Sql = objValue.Name; htSql.Add(objValue.Id, objValue.Name); this.Reader.Close(); return(0); } else { this.Reader.Close(); return(-1); } }