private List <Sys_Contract> Load_Contact()
{
List <Sys_Contract> result = new List <Sys_Contract>();
OracleConnection con = Get_Connection();
string sql = Config["Sql"]["Load_Contract"].Value;
if (con != null)
{
try
{
using (OracleDataReader sr = DB_BLL.OraHelp.ExecuteReader(con, CommandType.Text, sql, null))
{
while (sr.Read())
{
Sys_Contract s = new Sys_Contract(Config["Generic"]["Sys_Name"].Value);
s.Cust_Name = sr["客户名称"].ToString().Trim();
s.ContractCode = sr["合同编号"].ToString().Trim();
s.Add_id = sr["资源编号"].ToString().Trim();
s.Add_name = sr["租用单元"].ToString().Trim();
result.Add(s);
}
}
return(result);
}
catch
{
return(null);
}
}
return(null);
}
private List <Sys_Contract> Load_Contact()
{
List <Sys_Contract> result = new List <Sys_Contract>();
DbConnection con = null;
DbDataReader sr = null;
string sql = Config["Sql"]["Load_Contract"].Value;
if (Config["Connection"]["Type"].Value == "Sqlserver")
{
con = DB2 <SqlConnection> .GetConnection(Config["Connection"]["Conn"].Value);//Get_SqlConnection();
sr = DB_BLL.SQLHelp.ExecuteReader((SqlConnection)con, CommandType.Text, sql, null);
}
if (Config["Connection"]["Type"].Value == "Oracle")
{
con = DB2 <OracleConnection> .GetConnection(Config["Connection"]["Conn"].Value);//Get_OracleConnection();
sr = DB_BLL.OraHelp.ExecuteReader((OracleConnection)con, CommandType.Text, sql, null);
}
if (con != null)
{
try
{
while (sr.Read())
{
Sys_Contract s = new Sys_Contract(Config["Generic"]["Sys_Name"].Value);
s.Cust_Name = sr["客户名称"].ToString().Trim();
s.ContractCode = sr["合同编号"].ToString().Trim();
s.Add_id = sr["资源编号"].ToString().Trim();
s.Add_name = sr["租用单元"].ToString().Trim();
result.Add(s);
}
sr.Close();
con.Close();
con.Dispose();
return(result);
}
catch
{
return(null);
}
finally
{
sr.Close();
con.Close();
con.Dispose();
}
}
return(null);
}
