/// <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); }