/// <summary>
/// 直接运行SQL语句
/// </summary>
/// <param name="ConnectionName">连接名</param>
/// <param name="sql">sql语句</param>
/// <param name="opType">操作类型</param>
/// <returns></returns>
public static object RunSQL(string connectionName, string sql, emOperationType opType)
{
string wrongMessage = "";
object obj = null;
DBLInit _DBLInit = new DBLInit(connectionName);
switch (opType)
{
case emOperationType.select:
obj = _DBLInit.GetDataTable(sql, out wrongMessage);
break;
case emOperationType.delete:
case emOperationType.insert:
case emOperationType.update:
obj = _DBLInit.ProcessSql(sql, opType, out wrongMessage);
break;
}
MyORM.Log.WriteInfo(connectionName + "-" + opType.ToString() + "-" + sql);
if (!string.IsNullOrEmpty(wrongMessage))
{
MyORM.Log.WriteError(wrongMessage);
}
return(obj);
}
/// <summary>
/// 删除记录
/// </summary>
/// <param name="_PrimaryKeyValue">主键值</param>
/// <param name="tp">对象类型</param>
/// <returns></returns>
public int Remove(int _PrimaryKeyValue, Type tp)
{
string WrongMessage = null;
string sql = String.Format("delete from {0} where {1}={2}", _TableName, _PrimaryKey, _PrimaryKeyValue);
int ret = _DBLInit.ProcessSql(sql, emOperationType.delete, out WrongMessage);
Log.WriteInfo("删除数据，表：" + _TableName + "，流水号：" + _PrimaryKeyValue);
if (string.IsNullOrEmpty(WrongMessage))
{
//删除缓存
string key = tp.ToString() + "." + _PrimaryKeyValue;
MyCache.Caching cache = new MyCache.Caching();
cache.Remove(key);
return(ret);
}
ret = -1;
MyORM.Log.WriteError(WrongMessage);
return(ret);
}
