public DataTable[] ExecuteSetSchema(DbAccessInformation accessInfo)
{
if (accessInfo == null)
{
return(null);
}
DataTable[] result = null;
this.DbCommand.AttachAccessInfo(accessInfo);
result = this.DbCommand.ExecuteSetSchema();
this.DbCommand.PickupParameteValues(accessInfo);
return(result);
}
public int UpdateDataRow(DbAccessInformation accessInfo, params DataRow[] dataRows)
{
if (accessInfo == null)
{
return(-1);
}
int result = -1;
this.DbCommand.AttachAccessInfo(accessInfo);
result = this.DbCommand.UpdateDataRow(dataRows);
this.DbCommand.PickupParameteValues(accessInfo);
return(result);
}
public XmlReader ExecuteXmlReader(DbAccessInformation accessInfo, bool isTransaction)
{
if (accessInfo == null)
{
return(null);
}
XmlReader result = null;
this.DbCommand.AttachAccessInfo(accessInfo);
result = this.DbCommand.ExecuteXmlReader();
this.DbCommand.PickupParameteValues(accessInfo);
return(result);
}
public object ExecuteScalar(DbAccessInformation accessInfo)
{
if (accessInfo == null)
{
return(null);
}
object result = null;
this.DbCommand.AttachAccessInfo(accessInfo);
result = this.DbCommand.ExecuteScalar();
this.DbCommand.PickupParameteValues(accessInfo);
return(result);
}
public int ExecuteNonQuery(DbAccessInformation accessInfo)
{
if (accessInfo == null)
{
return(-1);
}
int result = 0;
this.DbCommand.AttachAccessInfo(accessInfo);
result = this.DbCommand.ExecuteNonQuery();
this.DbCommand.PickupParameteValues(accessInfo);
return(result);
}
public DataTable ExecuteDataTable(DbAccessInformation accessInfo, int startRecord, int maxRecords)
{
if (accessInfo == null)
{
return(null);
}
DataTable result = null;
this.DbCommand.AttachAccessInfo(accessInfo);
result = this.DbCommand.ExecuteDataTable(startRecord, maxRecords);
this.DbCommand.PickupParameteValues(accessInfo);
return(result);
}
public int ExecuteDataTable(DbAccessInformation accessInfo, DataTable dataTable, int startRecord, int maxRecords)
{
if (accessInfo == null)
{
return(-1);
}
int result = -1;
this.DbCommand.AttachAccessInfo(accessInfo);
result = this.DbCommand.ExecuteDataTable(dataTable, startRecord, maxRecords);
this.DbCommand.PickupParameteValues(accessInfo);
return(result);
}
public int ExecuteDataSet(DbAccessInformation accessInfo, DataSet dataSet, int startRecord, int maxRecords, string srcTable)
{
if (accessInfo == null)
{
return(0);
}
int result = 0;
this.DbCommand.AttachAccessInfo(accessInfo);
result = this.DbCommand.ExecuteDataSet(dataSet, startRecord, maxRecords, srcTable);
this.DbCommand.PickupParameteValues(accessInfo);
return(result);
}
public int ExecuteDataSet(DbAccessInformation accessInfo, DataSet dataSet)
{
if (accessInfo == null)
{
return(-1);
}
int result = -1;
this.DbCommand.AttachAccessInfo(accessInfo);
result = this.DbCommand.ExecuteDataSet(dataSet);
this.DbCommand.PickupParameteValues(accessInfo);
return(result);
}
public int UpdateDataTable(DbAccessInformation accessInfo, DataTable dataTable)
{
if (accessInfo == null)
{
return(-1);
}
int result = -1;
this.DbCommand.AttachAccessInfo(accessInfo);
result = this.DbCommand.UpdateDataTable(dataTable);
this.DbCommand.PickupParameteValues(accessInfo);
return(result);
}
public DataRow ExecuteDataRow(DbAccessInformation accessInfo)
{
if (accessInfo == null)
{
return(null);
}
DataRow result = null;
this.DbCommand.AttachAccessInfo(accessInfo);
result = this.DbCommand.ExecuteDataRow();
this.DbCommand.PickupParameteValues(accessInfo);
return(result);
}
public void AttachAccessInfo(DbAccessInformation accessInfo, DbParameter[] parameters)
{
if (accessInfo != null)
{
this.DbCommand.CommandText = accessInfo.CommandText;
this.DbCommand.CommandType = accessInfo.CommandType;
this.DbCommand.CommandTimeout = accessInfo.CommandTimeout;
this.DbCommand.Parameters.Clear();
if ((parameters == null) && (accessInfo.CommandType == System.Data.CommandType.StoredProcedure))
{
parameters = this.GetCachedParameters(accessInfo.CommandText);
}
if (parameters == null)
{
if (accessInfo.Parameters != null)
{
foreach (DbAccessParameter accParameter in accessInfo.Parameters)
{
if (accParameter.ProvideType >= 0)
{
this.DbCommand.Parameters.Add(this.CreateParameter(accParameter.ParameterName, accParameter.ProvideType, accParameter.Size, accParameter.Direction, accParameter.IsNullable, accParameter.Precision, accParameter.Scale, accParameter.SourceColumn, accParameter.SourceVersion, accParameter.Value));
}
else
{
this.DbCommand.Parameters.Add(accParameter.ConvertParameter(base.CreateParameter()));
}
}
}
}
else
{
this.DbCommand.Parameters.AddRange(parameters);
if (accessInfo.Parameters != null)
{
this.AssignParameterValues(accessInfo.Parameters);
}
}
foreach (DbParameter parameter in this.DbCommand.Parameters)
{
if (parameter.Value == null)
{
parameter.Value = DBNull.Value;
}
}
}
}
public void PickupParameteValues(DbAccessInformation accessInfo)
{
foreach (DbParameter parameter in this.DbCommand.Parameters)
{
if (parameter.Direction != ParameterDirection.Input)
{
if (accessInfo.Parameters.Contains(parameter.ParameterName))
{
accessInfo.Parameters[parameter.ParameterName].Value = parameter.Value;
}
else
{
accessInfo.AddParameter(parameter.ParameterName, parameter.Value);
}
}
}
}
public XmlDocument ExecuteXml(XmlNode input)
{
XmlNodeList accessNodes = input.SelectNodes("DbAccessInformation");
DbExcuteType[] exeTypes = new DbExcuteType[accessNodes.Count];
DbAccessInformation[] accessInfos = new DbAccessInformation[accessNodes.Count];
int i = 0;
int j = accessNodes.Count;
while (i < j)
{
XmlNode accessNode = accessNodes[i].CloneNode(true);
DbExcuteType exeType = (DbExcuteType)DataConvert.ParseEnum(XmlHelper.GetAttributeValue(accessNode, "excuteType"), DbExcuteType.ExecuteNonQuery);
DbAccessInformation accessInfo = SerializeHelper.XmlDeserialize(accessNode, typeof(DbAccessInformation)) as DbAccessInformation;
exeTypes[i] = exeType;
accessInfos[i] = accessInfo;
i++;
}
XmlDocument doc = XmlHelper.CreateXmlDocument("ActionItems", null);
bool needOpen = this.DbCommand.Connection.State != ConnectionState.Open;
if (needOpen)
{
this.DbCommand.Open();
}
bool isFailed = true;
try
{
this.InnerExecuteXml(doc, this.DbCommand, exeTypes, accessInfos);
isFailed = false;
}
finally
{
if (isFailed && (this.DbCommand.Transaction != null))
{
this.DbCommand.RollbackTransaction();
}
if (needOpen || isFailed)
{
this.DbCommand.Close();
}
}
return(doc);
}
private void InnerExecuteXml(XmlDocument doc, DbAccessCommand dbCommand, DbExcuteType[] exeTypes, DbAccessInformation[] accessInfos)
{
int i = 0;
int j = exeTypes.Length;
while (i < j)
{
DbAccessInformation accessInfo = accessInfos[i];
XmlNode itemNode = XmlHelper.SetInnerText(doc.DocumentElement, "ActionItem", string.Empty);
XmlHelper.SetAttribute(itemNode, "sequence", (i + 1).ToString());
dbCommand.AttachAccessInfo(accessInfo);
XmlNode resultNode = XmlHelper.SetInnerText(itemNode, "Result", string.Empty);
this.FillResultNode(resultNode, dbCommand, exeTypes[i]);
dbCommand.PickupParameteValues(accessInfo);
XmlHelper.AddNode(itemNode, SerializeHelper.XmlSerialize(accessInfo));
i++;
}
}
public object ExecuteReader(DbAccessInformation accessInfo, Func <DbDataReader, object> readerHandler, int startRecord)
{
if ((accessInfo == null) || (readerHandler == null))
{
return(null);
}
object result = null;
this.DbCommand.AttachAccessInfo(accessInfo);
DbDataReader reader = this.DbCommand.ExecuteReader(startRecord);
if (readerHandler != null)
{
result = readerHandler(reader);
}
if (!reader.IsClosed)
{
reader.Close();
}
this.DbCommand.PickupParameteValues(accessInfo);
return(result);
}
public void AttachAccessInfo(DbAccessInformation accessInfo)
{
this.AttachAccessInfo(accessInfo, null);
}