/// <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);
}
}
