/// <summary>
/// 批查询完成时的事件触发处理过程
/// </summary>
/// <param name="e"></param>
private void raiseevent_sqlec(SQLExecuteCompleteArgs e)
{
if (ExecuteCompleted != null)
{
if (_sc != null)
{
SendOrPostCallback sd = delegate(object data)
{
ExecuteCompleted.Invoke(this, e);
};
//线程同步处理
_sc.Send(sd, e);
}
else
{
ExecuteCompleted.Invoke(this, e);
}
}
}
public void GetData(string sqlstr, int pageindex, int pagesize, long sid, string tablename = "")
{
if (_Idbcmd == null)
{
raiseevent_sqlec(new SQLExecuteCompleteArgs(sid, new DataTable(), false));
return;
}
Action<object> objA = delegate(object data)
{
DataTable dt = new DataTable() { TableName = string.IsNullOrEmpty(tablename) ? "Table" : tablename };
bool comp = false;
try
{
_Idbcmd.CommandText = sqlstr;
if (_Idbcmd.Connection.State != ConnectionState.Open)
{
_Idbcmd.Connection.Open();
}
if (pagesize < 1)
{
_DA.Fill(dt);
}
else
{
_DA.Fill(pagesize * pageindex, pagesize, dt);
}
comp = true;
}
catch (Exception ex)
{
RaiseEvent(new DataOperationErrorMessageArgs(sqlstr, ex.Message));
}
SQLExecuteCompleteArgs sqlec = new SQLExecuteCompleteArgs(sid, dt, comp);
raiseevent_sqlec(sqlec);
};
ThreadPool.QueueUserWorkItem(new WaitCallback(objA));
}
public void ExecuteQuery(string sqlstr, long sid)
{
Action<object> objA = delegate(object data)
{
int count = 0;
bool comp = false;
if (_Idbcmd != null)
{
try
{
_Idbcmd.CommandText = sqlstr;
if (_Idbcmd.Connection.State != ConnectionState.Open)
{
_Idbcmd.Connection.Open();
}
//实物处理开始
_Idbcmd.Transaction = _Idbcmd.Connection.BeginTransaction();
count = _Idbcmd.ExecuteNonQuery();
if (_Idbcmd.Transaction != null)
{
//提交事务
_Idbcmd.Transaction.Commit();
}
comp = true;
}
catch (Exception ex)
{
if (_Idbcmd.Transaction != null)
{
//回滚事务
_Idbcmd.Transaction.Rollback();
}
RaiseEvent(new DataOperationErrorMessageArgs(sqlstr, ex.Message));
comp = false;
}
}
SQLExecuteCompleteArgs sqlec = new SQLExecuteCompleteArgs(sid, count, comp);
raiseevent_sqlec(sqlec);
};
ThreadPool.QueueUserWorkItem(new WaitCallback(objA));
}
public void GetData(string sqlstr, long sid)
{
if (_Idbcmd == null)
{
raiseevent_sqlec(new SQLExecuteCompleteArgs(sid, new DataSet(), false));
return;
}
Action<object> objA = delegate(object data)
{
DataSet ds = new DataSet();
bool comp = false;
try
{
_Idbcmd.CommandText = sqlstr;
if (_Idbcmd.Connection.State != ConnectionState.Open)
{
_Idbcmd.Connection.Open();
}
_DA.Fill(ds);
comp = true;
}
catch (Exception ex)
{
RaiseEvent(new DataOperationErrorMessageArgs(sqlstr, ex.Message));
}
SQLExecuteCompleteArgs sqlec = new SQLExecuteCompleteArgs(sid, ds, comp);
raiseevent_sqlec(sqlec);
};
ThreadPool.QueueUserWorkItem(new WaitCallback(objA));
}
private void _GDC_public_ExecuteCompleted(object sender, SQLExecuteCompleteArgs e)
{
//switch (e.SessionID)
//{
// case 8888: //查询分析
// default:
// break;
//}
}