private void CreateSqlParam(System.Data.Odbc.OdbcCommand oCmd, object[] SqlParams)
{
if (SqlParams == null || SqlParams.Length == 0)
{
return;
}
for (int i = 0; i < SqlParams.Length; i++)
{
System.Data.Odbc.OdbcParameter oParam = new System.Data.Odbc.OdbcParameter();
oParam.ParameterName = (i + 1).ToString();
oParam.Value = SqlParams[i];
oCmd.Parameters.Add(oParam);
}
}
public static System.Data.IDbDataParameter GetParameter(string parameterName, object value)
{
System.Data.IDbDataParameter result = null;
// شناسايی می کنيم که بانک اطلاعاتی ما چسيت؟
string providerName =
System.Configuration.ConfigurationManager.AppSettings["PROVIDER"];
switch (providerName.ToUpper())
{
case "SQLSERVER":
{
// اگر اس کيو ال سرور بود
result =
new System.Data.SqlClient.SqlParameter(parameterName: parameterName, value: value);
break;
}
case "OLEDB":
{
result =
new System.Data.OleDb.OleDbParameter(name: parameterName, value: value);
break;
}
case "ODBC":
{
result =
new System.Data.Odbc.OdbcParameter(name: parameterName, value: value);
break;
}
}
return(result);
}
public void Remove(System.Data.Odbc.OdbcParameter value)
{
}
public void Insert(int index, System.Data.Odbc.OdbcParameter value)
{
}
public int IndexOf(System.Data.Odbc.OdbcParameter value)
{
throw null;
}
public bool Contains(System.Data.Odbc.OdbcParameter value)
{
throw null;
}
public System.Data.Odbc.OdbcParameter Add(System.Data.Odbc.OdbcParameter value)
{
throw null;
}
public override int FSFileUpdate(int? id, byte[] databuffer)
{
System.Data.Odbc.OdbcConnection rawconn = this._dbObj.GetDatabaseConnector().GetRawConnectionObject();
System.Data.Odbc.OdbcCommand ocomm = new System.Data.Odbc.OdbcCommand();
string sqlStr = "update #__filesys_filenode set data=? where id=?";
sqlStr = this._dbObj.GetDatabaseConnector().DoTopLevelSqlTranslations(ref sqlStr);
ocomm.CommandText = sqlStr;
ocomm.Connection = rawconn;
System.Data.Odbc.OdbcParameter idParam = new System.Data.Odbc.OdbcParameter("@dataid", System.Data.Odbc.OdbcType.Int);
idParam.Value = id;
System.Data.Odbc.OdbcParameter dataParam = new System.Data.Odbc.OdbcParameter("@databit", System.Data.Odbc.OdbcType.Image);
dataParam.Value = databuffer;
ocomm.Parameters.Add(dataParam);
ocomm.Parameters.Add(idParam);
try
{
ocomm.ExecuteNonQuery();
}
catch (Exception e)
{
System.Diagnostics.Debug.Print(e.Message);
return -1;
}
return 1;
}
public static IDataParameter CreateParameter(EnumProviders provider)
{
IDataParameter param;
switch (provider)
{
case EnumProviders.SqlServer:
param = new System.Data.SqlClient.SqlParameter();
break;
case EnumProviders.OleDb:
param = new System.Data.OleDb.OleDbParameter();
break;
case EnumProviders.Odbc:
param = new System.Data.Odbc.OdbcParameter();
break;
case EnumProviders.Oracle:
throw new NotImplementedException("Provider not implemented");
break;
default:
param = new System.Data.SqlClient.SqlParameter();
break;
}
return param;
}
public virtual IDataParameter[] GetCachedParameters(string cacheKey)
{
if (parmCache.ContainsKey(cacheKey))
{
IDataParameter[] cachedParms = parmCache[cacheKey];
if (this.dbType == DBType.MSSQL)
{
IDataParameter[] clonedParms = new IDataParameter[cachedParms.Length];
if (cachedParms == null)
{
return(null);
}
for (int i = 0; i < cachedParms.Length; i++)
{
clonedParms[i] = new System.Data.SqlClient.SqlParameter(cachedParms[i].ParameterName, cachedParms[i].DbType);
clonedParms[i].Direction = cachedParms[i].Direction;
//if (clonedParms[i] is System.Data.SqlClient.SqlParameter)
// ((System.Data.SqlClient.SqlParameter)clonedParms[i]).Size = 100;
}
return(clonedParms);
}
else if (this.dbType == DBType.ODBC)
{
IDataParameter[] clonedParms = new IDataParameter[cachedParms.Length];
if (cachedParms == null)
{
return(null);
}
for (int i = 0; i < cachedParms.Length; i++)
{
clonedParms[i] = new System.Data.Odbc.OdbcParameter(cachedParms[i].ParameterName, Convert.DBNull);
clonedParms[i].Direction = cachedParms[i].Direction;
}
return(clonedParms);
}
else if (this.dbType == DBType.OLEDB)
{
IDataParameter[] clonedParms = new IDataParameter[cachedParms.Length];
if (cachedParms == null)
{
return(null);
}
for (int i = 0; i < cachedParms.Length; i++)
{
clonedParms[i] = new System.Data.OleDb.OleDbParameter(cachedParms[i].ParameterName, Convert.DBNull);
clonedParms[i].Direction = cachedParms[i].Direction;
}
return(clonedParms);
}
//else if (this.dbType == DBType.ORACLE)
//{
// IDataParameter[] clonedParms = new IDataParameter[cachedParms.Length];
// if (cachedParms == null) return null;
// for (int i = 0; i < cachedParms.Length; i++)
// {
// clonedParms[i] = new System.Data.OracleClient.OracleParameter(cachedParms[i].ParameterName, Convert.DBNull);
// clonedParms[i].Direction = cachedParms[i].Direction;
// }
// return clonedParms;
//}
else
{
return(null);
}
}
else
{
return(null);
}
}
