Пример #1
0
 private IDbNetScope GetScope(IDbNetScope scope, DbNetCommand command)
 {
     if (scope != null && scope is SqlServerDbNetScope)
     {
         return(scope);
     }
     else
     {
         return(new SqlServerDbNetScope(command.ConnectionString, command.IsolationLevel));
     }
 }
Пример #2
0
        public DbNetResult ExecuteCommand(DbNetCommand command, ref IDbNetScope scope, ExecuteType executetype)
        {
            StringBuilder sqlBulider = new StringBuilder(PARAMTER_REPLACE.Replace(command.SqlText, "@${pName} OR @${pName} IS NULL"));
            string        sql        = sqlBulider.ToString();

            foreach (Match m in FORMAT_PARAMTER_REPLACE.Matches(sql))
            {
                if (m.Success)
                {
                    var name     = m.Groups[P_NAME].Value;
                    var paramter = command.Paramters.Get(name);
                    if (paramter == null)
                    {
                        //如果本身不存在参数集合里面则跳过
                        continue;
                    }
                    var    val  = paramter.Value;
                    string res  = val == null ? string.Empty : val.ToString();
                    var    code = string.Format(FORMAT_CODE, name);
                    sqlBulider = sqlBulider.Replace(code, res);
                }
            }
            sql             = sqlBulider.ToString();
            command.SqlText = sql;
            //封装数据库执行
            object result = null;

            scope = GetScope(scope, command);
            scope.Open();
            var        s   = scope as SqlServerDbNetScope;
            SqlCommand com = new SqlCommand(command.SqlText, s.Connection);

            if (s.Transaction != null)
            {
                com.Transaction = s.Transaction;
            }
            com.CommandTimeout = 30;
            switch (command.CommandType)
            {
            default:
            case "Text":
                com.CommandType = CommandType.Text;
                break;

            case "StoredProcedure":
                com.CommandType = CommandType.StoredProcedure;
                break;

            case "TableDirect":
                com.CommandType = CommandType.TableDirect;
                break;
            }
            foreach (var p in command.Paramters)
            {
                var sql_p = new SqlParameter(string.Format(PARAMTERFORAMT, p.Name), p.Value);
                if (p.Value == null)
                {
                    sql_p.Value = DBNull.Value;
                }
                switch (p.Direction)
                {
                case DbNetParamterDirection.Input:
                    sql_p.Direction = ParameterDirection.Input;
                    break;

                case DbNetParamterDirection.InputAndOutPut:
                    sql_p.Direction = ParameterDirection.InputOutput;
                    break;

                case DbNetParamterDirection.Output:
                    sql_p.Direction = ParameterDirection.Output;
                    break;
                }
                com.Parameters.Add(sql_p);
            }
            switch (executetype)
            {
            case ExecuteType.ExecuteDateTable:
                using (SqlDataAdapter adapter = new SqlDataAdapter(com))
                {
                    DataSet set = new DataSet();
                    adapter.Fill(set);
                    result = set;
                }
                break;

            case ExecuteType.ExecuteNoQuery:
                result = com.ExecuteNonQuery();
                break;

            case ExecuteType.ExecuteObject:
                result = com.ExecuteScalar();
                break;
            }
            scope.Close();
            foreach (var p in command.Paramters)
            {
                string pName = string.Format(PARAMTERFORAMT, p.Name);
                if (com.Parameters[pName] != null)
                {
                    object pv = com.Parameters[pName].Value;
                    if (pv == DBNull.Value)
                    {
                        p.Value = null;
                    }
                    else
                    {
                        p.Value = com.Parameters[pName].Value;
                    }
                }
            }
            return(new DbNetResult(result));
        }
Пример #3
0
 public SQLCacheItem(DbNetCommand command, T result)
 {
     _dbNetCommand = command;
     _result       = result;
 }