public string GetXmlFromArray(Array array)
{
return(SqlUtil.GetXmlFromArray(array));
}
private void AddDBParam(SqlCommand cmd, DBParameter dbParam)
{
if (dbParam.ParamValue == null)
{
AddDBParamNoValue(cmd, dbParam);
return;
}
try
{
DBParameterType paramType = dbParam.ParamType;
switch (paramType)
{
case DBParameterType.BoolParam:
SqlUtil.AddParam(cmd, dbParam.ParamName, (bool)dbParam.ParamValue); break;
case DBParameterType.DateTimeParam:
SqlUtil.AddParam(cmd, dbParam.ParamName, (DateTime)dbParam.ParamValue); break;
case DBParameterType.DoubleParam:
SqlUtil.AddParam(cmd, dbParam.ParamName, (double)dbParam.ParamValue); break;
case DBParameterType.IntParam:
SqlUtil.AddParam(cmd, dbParam.ParamName, (int)dbParam.ParamValue); break;
case DBParameterType.NullableIntParam:
SqlUtil.AddParam(cmd, dbParam.ParamName, (int?)dbParam.ParamValue); break;
case DBParameterType.StringParam:
SqlUtil.AddParam(cmd, dbParam.ParamName, (string)dbParam.ParamValue); break;
case DBParameterType.TextParam:
SqlUtil.AddParam(cmd, dbParam.ParamName, (string)dbParam.ParamValue, true); break;
case DBParameterType.XmlParam:
SqlUtil.AddParam(cmd, dbParam.ParamName, (string)dbParam.ParamValue, false, true); break;
case DBParameterType.BytesParam:
SqlUtil.AddParam(cmd, dbParam.ParamName, (byte[])dbParam.ParamValue); break;
case DBParameterType.NcharParam:
SqlUtil.AddParam(cmd, dbParam.ParamName, dbParam.ParamValue == null ? new char[0] : ((string)dbParam.ParamValue).ToCharArray()); break;
case DBParameterType.IntParamOutput:
SqlUtil.AddOutputParam(cmd, dbParam.ParamName, paramType);
ParameterNames.Add(dbParam.ParamName);
break;
case DBParameterType.StringParamOutput:
SqlUtil.AddOutputParam(cmd, dbParam.ParamName, paramType);
ParameterNames.Add(dbParam.ParamName);
break;
case DBParameterType.ByteParam:
SqlUtil.AddParam(cmd, dbParam.ParamName, (byte)dbParam.ParamValue); break;
}
}
#pragma warning disable 168
catch (System.InvalidCastException whoops)
{
// bad data, treat as null...
AddDBParamNoValue(cmd, dbParam);
}
#pragma warning restore 168
}
public void CloseReader(IDataReader dr)
{
SqlUtil.CloseReader((SqlDataReader)dr);
}
public void UpdateDataSet(string updateStatement, string deleteStatement, DataSet ds, bool queryTypeUpdateCommand, bool queryTypeDeleteCommand, params object[] allParams)
{
SqlConnection conn = null;
SqlCommand updCmd;
SqlCommand delCmd;
SqlCommand cmd = null;
SqlDataAdapter da;
try
{
conn = SqlUtil.CreateConnection(ConnectionString);
updCmd = SqlUtil.CreateCommand(conn);
updCmd.CommandText = updateStatement;
if (queryTypeUpdateCommand)
{
updCmd.CommandType = CommandType.Text;
}
else
{
updCmd.CommandType = CommandType.StoredProcedure;
}
delCmd = SqlUtil.CreateCommand(conn);
delCmd.CommandText = deleteStatement;
if (queryTypeDeleteCommand)
{
delCmd.CommandType = CommandType.Text;
}
else
{
delCmd.CommandType = CommandType.StoredProcedure;
}
if (allParams != null)
{
for (int iCount = 0; iCount < allParams.Length; iCount++)
{
if (iCount == 0)
{
cmd = updCmd;
}
else if (iCount == 1)
{
cmd = delCmd;
}
object obj = allParams[iCount];
if (obj == null)
{
continue;
}
if (obj is IList)
{
foreach (DBParameter db in (IList)obj)
{
if (db.ParamValue == null)
{
AddDBParamNoValue(cmd, (DBParameter)db);
}
else
{
AddDBParam(cmd, (DBParameter)db);
}
}
}
else
if (((DBParameter)obj).ParamValue == null)
{
AddDBParamNoValue(cmd, (DBParameter)obj);
}
else
{
AddDBParam(cmd, (DBParameter)obj);
}
}
}
da = new SqlDataAdapter();
da.UpdateCommand = updCmd;
da.InsertCommand = updCmd;
da.DeleteCommand = delCmd;
//da.UpdateBatchSize = 10;
da.Update(ds);
}
finally
{
SqlUtil.ReleaseConnection(conn);
}
}