// public static int sleep = 1;
/// <summary>
/// 第二版本的V2
/// </summary>
/// <returns></returns>
public ConnOfOra GetOneV2()
{
while (isLocalConns)
{
;
}
if (this.Count == 0)
{
this.Init();
//throw new Exception("Error 没有出世化连接。");
}
foreach (ConnOfOra conn in this)
{
if (conn.IsUsing == false)
{
conn.IsUsing = true;
if (conn.Conn == null)
{
conn.Conn = new OracleConnection(SystemConfig.AppCenterDSN);
}
conn.Times++;
return(conn);
}
}
isLocalConns = true; // 锁住它。
string str = SystemConfig.AppSettings["InitConnMaxNum"];
if (str == null || str == "")
{
str = "3";
}
int maxNum = int.Parse(str);
if (this.Count > maxNum)
{
isLock = false;
BP.DA.Log.DebugWriteWarning("出现了链接数超出了" + maxNum + "个的案例，如果多次出现这种情况应该，考虑多设置最大链接数，以减少系统等待。");
return(this.GetOneV2());
}
else
{
BP.DA.Log.DebugWriteWarning("创建：第[" + this.Count + "]个数据链接。");
}
// 如果没有新的连接。
ConnOfOra nconn = new ConnOfOra();
nconn.IsUsing = true;
nconn.IDX = this.Count;
nconn.Conn = new OracleConnection(SystemConfig.AppCenterDSN);
this.InnerList.Add(nconn);
isLocalConns = false; //释放它。
return(nconn);
}
public ConnOfOra GetOneV3_del()
{
////if (this.Count == 0)
//// this.Init();
int sltimes = 0;
while (isLock || sltimes >= 500)
{
;
System.Threading.Thread.Sleep(1);
sltimes++;
}
isLock = true;
foreach (ConnOfOra conn in this)
{
if (conn.IsUsing == false)
{
if (conn.Conn == null)
{
conn.Conn = new OracleConnection(SystemConfig.AppCenterDSN);
}
conn.Times++;
conn.IsUsing = true;
//conn.Close();
isLock = false;
return(conn);
}
}
// 如果没有新的连接。
ConnOfOra nconn = new ConnOfOra();
nconn.IDX = this.Count;
nconn.Conn = new OracleConnection(SystemConfig.AppCenterDSN);
nconn.IsUsing = true;
this.InnerList.Add(nconn);
isLock = false;
return(nconn);
//throw new Exception("没有可用的连接了，请报告给管理员。");
}
/// <summary>
/// 初始化
/// </summary>
public void Init()
{
string str = SystemConfig.AppSettings["InitConnNum"];
if (str == null)
{
str = "3";
}
int num = int.Parse(str);
for (int i = 0; i <= num; i++)
{
ConnOfOra conn = new ConnOfOra();
conn.Conn = new OracleConnection(SystemConfig.AppCenterDSN);
conn.IDX = i;
conn.IsUsing = false;
this.Add(conn);
}
}
public void Add(ConnOfOra conn)
{
this.InnerList.Add(conn);
}
