public object ExecuteScalar(BaseQuery q)
        {
            string message = "SQL语句:" + q.CommandText + ";Parameters:{";

            if (q.Parameters != null)
            {
                for (int i = 0; i < q.Parameters.Count; i++)
                {
                    message += "\"" + q.Parameters[i].ParameterName + "\"" + ":";
                    message += "\"" + q.Parameters[i].Value + "\"" + ";";
                }
            }
            message += "}";
            try
            {
                LogService.Default.Info(message);
                IDbCommand sqlCommand = DbProvider.GetDbCommand(this.dbtype);
                this.PrepareCommand(sqlCommand, q);
                object result = sqlCommand.ExecuteScalar();
                this.SyncParameter(sqlCommand, q);
                sqlCommand.Parameters.Clear();
                return(result);
            }
            catch (Exception e)
            {
                LogService.Default.Fatal(e);
                LogService.Default.Fatal((message + "\n" + Assembly.GetExecutingAssembly().Location.ToLower()));
                throw e;
            }
        }
Пример #2
0
        private static Int32 GetSubmit(BaseQuery o, string targetdb, out Exception outex)
        {
            //先判断是否是新增,如果不是新增就修改

            outex = null;
            o.Convert(targetdb);
            Int32 affectedCount = -1;

            try
            {
                if (o.excutParBag.excutEnum == ExcutEnum.Insert && ((ExcutParBag_Insert)o.excutParBag).isOutIdentity)
                {
                    affectedCount = DataAccess.ExecuteScalarToWriterOnlyForInsertRentrunIdentity(o, o.databaseProperty).ToSafeInt32(-1);
                }
                else
                {
                    affectedCount = DataAccess.ExecuteNonQuery(o, o.databaseProperty).ToSafeInt32(-1);
                }
            }
            catch (Exception ex)
            {
                outex = ex;
                LogService.Default.Fatal("执行失败:" + ex.Message, ex);
                affectedCount = -1;
            }
            finally
            {
            }
            return(affectedCount);
        }
        public DataSet ExecuteDataset(BaseQuery q)
        {
            string message = "SQL语句:" + q.CommandText + ";Parameters:{";

            if (q.Parameters != null)
            {
                for (int i = 0; i < q.Parameters.Count; i++)
                {
                    message += "\"" + q.Parameters[i].ParameterName + "\"" + ":";
                    message += "\"" + q.Parameters[i].Value + "\"" + ";";
                }
            }
            message += "}";

            try
            {
                LogService.Default.Info(message);
                DataSet    dataSet    = new DataSet();
                IDbCommand sqlCommand = DbProvider.GetDbCommand(this.dbtype);
                this.PrepareCommand(sqlCommand, q);
                IDbDataAdapter sqlDataAdapter = DbProvider.GetDbDataAdapter(dbtype, sqlCommand);

                sqlDataAdapter.Fill(dataSet);
                this.SyncParameter(sqlCommand, q);
                sqlCommand.Parameters.Clear();
                return(dataSet);
            }
            catch (Exception e)
            {
                LogService.Default.Fatal(message + "\n" + Assembly.GetExecutingAssembly().Location.ToLower());
                LogService.Default.Fatal(e);
                throw e;
            }
        }
        public static XmlReader ExecuteXmlReader(BaseQuery q, DatabaseProperty dp)
        {
            DataAccess sqlDataAccess = new DataAccess(dp.Reader.ConnectionString, dp.Reader.DatabaseType);

            sqlDataAccess.Open();
            return(sqlDataAccess.ExecuteXmlReader(q));
        }
        public static int ExecuteNonQuery(BaseQuery q, DatabaseProperty dp)
        {
            string message = "SQL语句:" + q.CommandText + ";Parameters:{";

            if (q.Parameters != null)
            {
                for (int i = 0; i < q.Parameters.Count; i++)
                {
                    message += "\"" + q.Parameters[i].ParameterName + "\"" + ":";
                    message += "\"" + q.Parameters[i].Value + "\"" + ";";
                }
            }
            message += "}";

            try
            {
                LogService.Default.Info(message);
                DataAccess sqlDataAccess = new DataAccess(dp.Writer.ConnectionString, dp.Writer.DatabaseType);
                sqlDataAccess.Open();
                int result = sqlDataAccess.ExecuteNonQuery(q);
                sqlDataAccess.Close();
                return(result);
            }
            catch (Exception e)
            {
                LogService.Default.Fatal(e);
                LogService.Default.Fatal((message + "\n" + Assembly.GetExecutingAssembly().Location.ToLower()));
                throw e;
            }
        }
        private static object ExecuteScalar(BaseQuery q, DataAccess da)
        {
            da.Open();
            object result = da.ExecuteScalar(q);

            da.Close();
            return(result);
        }
        public bool TransationBulkCopy(DataAccess dataAccess, IDbConnection connection, IDbTransaction dbTransaction, List <DataTable> dtList, bool bl)
        {
            //处理大批量语句

            if (dtList != null && dtList.Count > 0 && bl)
            {
                foreach (var item in dtList)
                {
                    if (item != null && item.Rows.Count > 0)
                    {
                        StringBuilder sb = new StringBuilder();
                        sb.Append("INSERT INTO " + item.TableName + "(");
                        for (int i = 0; i < item.Columns.Count; i++)
                        {
                            sb.Append(item.Columns[i].ColumnName + ",");
                        }
                        sb.Remove(sb.ToString().LastIndexOf(','), 1);
                        sb.Append(") VALUES ");
                        for (int i = 0; i < item.Rows.Count; i++)
                        {
                            sb.Append("(");
                            for (int j = 0; j < item.Columns.Count; j++)
                            {
                                sb.Append("'" + item.Rows[i][j] + "',");
                            }
                            sb.Remove(sb.ToString().LastIndexOf(','), 1);
                            sb.Append("),");
                        }
                        sb.Remove(sb.ToString().LastIndexOf(','), 1);
                        sb.Append(";");
                        BaseQuery sql = new BaseQuery();
                        sql.CommandText = sb.ToString();
                        int res = -1;
                        try
                        {
                            res = dataAccess.ExecuteNonQuery(sql);
                        }
                        catch (Exception ex)
                        {
                            res = -1;
                            // Unknown column 'names' in 'field list'
                            LogService.Default.Fatal("操作失败!" + ex.Message.Replace("Unknown column", "未知列").Replace("in 'field list'", "存在字段集合中!"));
                        }
                        if (res >= 0)
                        {
                            return(true);
                        }
                        else
                        {
                            return(false);
                        }
                    }
                }
            }


            return(bl);
        }
        public static XmlDocument ExecuteXmlDoc(BaseQuery q, DatabaseProperty dp)
        {
            DataAccess sqlDataAccess = new DataAccess(dp.Reader.ConnectionString, dp.Reader.DatabaseType);

            sqlDataAccess.Open();
            XmlDocument result = sqlDataAccess.ExecuteXmlDoc(q);

            sqlDataAccess.Close();
            return(result);
        }
        public XmlReader ExecuteXmlReader(BaseQuery q)
        {
            SqlCommand sqlCommand = (SqlCommand)DbProvider.GetDbCommand(this.dbtype);

            this.PrepareCommand(sqlCommand, q);
            XmlReader result = sqlCommand.ExecuteXmlReader();

            this.SyncParameter(sqlCommand, q);
            sqlCommand.Parameters.Clear();
            return(result);
        }
        public static object ExecuteScalar(BaseQuery q, DatabaseProperty dp, bool isWritable)
        {
            DataAccess da;

            if (isWritable)
            {
                da = new DataAccess(dp.Writer.ConnectionString, dp.Writer.DatabaseType);
            }
            else
            {
                da = new DataAccess(dp.Reader.ConnectionString, dp.Reader.DatabaseType);
            }
            return(DataAccess.ExecuteScalar(q, da));
        }
Пример #11
0
        internal static bool  Excut(this BaseQuery o)
        {
            o.Convert(o.Targetdb);
            int i = DataAccess.ExecuteNonQuery(o, o.databaseProperty);

            if (i >= 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
        internal static void SelectPageData(BaseQuery baseQuery)
        {
            var bag = ((ExcutParBag_Page)(baseQuery).excutParBag);

            baseQuery.CommandText = string.Empty;
            baseQuery.Parameters.Clear();
            if (bag._pageMode == PageMode.SelectCount)
            {
                GetPageDataBySelect(baseQuery);
            }
            else
            {
                GetPageDataByCount(baseQuery);
            }
        }
Пример #13
0
        /// <summary>
        /// 查询数据
        /// </summary>
        /// <param name="property"></param>
        /// <returns></returns>
        internal static DataTable ReturnDataTable(this BaseQuery o, int tableIndex = 0)
        {
            o.Convert(o.Targetdb);
            DataSet Ds = DataAccess.ExecuteDataset(o, o.databaseProperty);

            if (Ds != null && Ds.Tables.Count > 0)
            {
                if (tableIndex > 0)
                {
                    return(Ds.Tables[tableIndex]);
                }
                else
                {
                    return(Ds.Tables[0]);
                }
            }
            return(null);
        }
        //关键代码 转换实体,用于支持多数据库类型的操作
        internal void Convert(string targetdb)
        {
            try
            {
                this.SetTargetDb(targetdb);
                qQeryy = this.MapToExutQuery();
            }
            catch (Exception ex)
            {
                LogService.Default.Fatal(
                    "core 映射失败:"
                    + "执行类型:"
                    + this.excutParBag.excutEnum.ToString()
                    + "异常信息:"
                    + ex.Message
                    + "TableName:" + this.excutParBag.tableName
                    + ";"
                    + "|Stack:"
                    + ex.StackTrace);
                throw ex;
            }


            try
            {
                qQeryy.SetCommadText(); //构建对应的SQL语句
                this.Parameters  = qQeryy.Parameters;
                this.CommandText = qQeryy.CommandText;
            }
            catch (Exception ex)
            {
                LogService.Default.Fatal(
                    "构建SQL语句出错:"
                    + "执行类型:"
                    + this.excutParBag.excutEnum.ToString()
                    + "异常信息:"
                    + ex.Message
                    + "TableName:" + this.excutParBag.tableName

                    + ";"
                    + "|Stack:"
                    + ex.StackTrace);
            }
        }
        internal static BaseQuery MapToExutQuery(this BaseQuery o)
        {
            BaseQuery vdb = new BaseQuery();

            switch (o.databaseType)
            {
            case DatabaseType.MSSQLServer:
                vdb = o.MapTo <MsSqlQuery>(new Action <AutoMapper.IMapperConfigurationExpression>(cfg => { cfg.ShouldMapProperty = pi => pi.CanWrite; }));
                break;

            case DatabaseType.MySql:
                vdb = o.MapTo <MySqlQuery>(new Action <AutoMapper.IMapperConfigurationExpression>(cfg => { cfg.ShouldMapProperty = pi => pi.CanWrite; }));
                break;

            default:
                vdb = o.MapTo <MsSqlQuery>(new Action <AutoMapper.IMapperConfigurationExpression>(cfg => { cfg.ShouldMapProperty = pi => pi.CanWrite; }));
                break;
            }

            return(vdb);
        }
        private void PrepareCommand(IDbCommand cmd, BaseQuery q)
        {
            cmd.CommandType    = q.CommandType;
            cmd.CommandText    = q.CommandText;
            cmd.Connection     = this.m_Connection;
            cmd.CommandTimeout = q.CommandTimeout;
            cmd.Transaction    = this.m_Trans;

            if (q.CommandType == CommandType.Text)
            {
                //if (HttpContext.Current != null && HttpContext.Current.Request != null && HttpContext.Current.Request.Url != null)
                //{
                //    string text = HttpContext.Current.Request.Url.ToString();
                //    if (text.Contains("?"))
                //    {
                //        text = text.Remove(text.IndexOf("?"));
                //    }
                //    cmd.CommandText = cmd.CommandText + "/* URL:" + text + " */";
                //}
                //else
                //{
                //    cmd.CommandText = cmd.CommandText + "/* Location:" + Assembly.GetExecutingAssembly().Location.ToLower() + " */";
                //}
                cmd.CommandText = cmd.CommandText + "/* Location:" + Assembly.GetExecutingAssembly().Location.ToLower() + " */";
            }
            if (q.Parameters.Count > 0)
            {
                int count = q.Parameters.Count;
                for (int i = 0; i < count; i++)
                {
                    var par = cmd.CreateParameter();
                    par.ParameterName = q.Parameters[i].ParameterName;
                    par.Size          = q.Parameters[i].Size;
                    par.Value         = q.Parameters[i].Value;
                    par.Direction     = q.Parameters[i].Direction;
                    par.DbType        = q.Parameters[i].DbType;//Utils.SqlTypeToDbType( q.Parameters[i].SqlDbType);
                    cmd.Parameters.Add(par);
                }
            }
        }
Пример #17
0
        public static BaseQuery ConvertOneQuery(this List <BaseQuery> list)
        {
            StringBuilder builder = new StringBuilder();

            SqlQueryParameterCollection lp = new SqlQueryParameterCollection();
            Int32 index = 0;

            try
            {
                list.ForEach(sq =>
                {
                    builder.Append("\n---------SQL语句-------\n");
                    for (Int32 i = 0; i < sq.Parameters.Count; i++)
                    {
                        var parmName   = "@sp" + index.ToString();
                        var orParmName = sq.Parameters[i].ParameterName;
                        if (orParmName.IndexOf("@") == -1)
                        {
                            orParmName = "@" + orParmName;
                        }
                        var parm           = sq.Parameters[i];
                        sq.CommandText     = sq.CommandText.Replace(orParmName, parmName);
                        parm.ParameterName = parmName;
                        lp.Add(parm);
                        index++;
                    }
                    builder.Append(sq.CommandText);
                    builder.Append(";");
                });
                BaseQuery q = new BaseQuery();
                q.CommandText = builder.ToString();
                q.Parameters  = lp;
                return(q);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        /// <summary>
        /// 实例化数据
        /// </summary>
        void  InitCommadInfo()
        {
            bool bl = true;

            if (_list == null || _list.Count == 0)
            {
                bl = true;
            }
            else
            {
                try
                {
                    BaseQuery q = _list.ConvertOneQuery();
                    finalSqlQuery = q;
                    _comaCommandInfo.Parameters = q.Parameters;
                    _comaCommandInfo.SqlCommand = q.CommandText;
                }
                catch (Exception ex)
                {
                    DistributedEx = ex;
                    LogService.Default.Fatal("处理事务语句时出现异常:" + ex.Message);
                }
            }
        }
Пример #19
0
        /// <summary>
        /// 提交到数据库执行,成功:返回受影响的行数,如果执行不成功,返回-1
        /// </summary>
        /// <param name="o">执行的SqlQuery:成功:返回受影响的行数,如果执行不成功,返回-1</param>
        /// <returns>返回受影响的行数</returns>
        public static Int32 Submit(this BaseQuery o, string targetdb)
        {
            Exception ex = null;

            return(GetSubmit(o, targetdb, out ex));
        }
        private static void GetPageDataByCount(BaseQuery baseQuery)
        {
            var bag           = (ExcutParBag_Page)(baseQuery.excutParBag);
            var sql           = string.Empty;
            var selectTable   = bag.pageTableName;
            var selectColumns = bag.pageColumns;
            var len           = bag.commandText.ToLower().IndexOf("select") + 6;

            baseQuery.SetDynamicParameters((bag.dynamics));
            BaseQuery sqlTemp = new BaseQuery();

            sqlTemp.CommandText = bag.commandText;
            sqlTemp.CommandType = CommandType.Text;

            for (int i = 0; i < baseQuery.Parameters.Count; i++)
            {
                SqlParameter sqlpa = baseQuery.Parameters[i];
                SqlParameter par   = new SqlParameter();
                par.DbType        = sqlpa.DbType;
                par.Direction     = sqlpa.Direction;
                par.ParameterName = sqlpa.ParameterName;
                par.Value         = sqlpa.Value;
                sqlTemp.Parameters.Add(par);
            }
            if (!bag.isPage)
            {
                bag.pageIndex = 1;
                bag.pageSize  = 1;
            }
            if (bag.pageIndex == 1)
            {
                #region  //最新改动

                sqlTemp.CommandText = sqlTemp.CommandText.Insert(len, " TOP(@num) COUNT(0) over() CHEOKTOTALCOUNT,");
                if (!string.IsNullOrEmpty(bag.whereBuiler.ToString()))
                {
                    sqlTemp.CommandText = sqlTemp.CommandText + (string.IsNullOrWhiteSpace(bag.whereBuiler.ToString()) ? string.Empty : string.Format(" WHERE {0} ", bag.whereBuiler.ToString()));
                }
                if (!string.IsNullOrEmpty(bag.orderBy.ToString()))
                {
                    sqlTemp.CommandText = sqlTemp.CommandText + (string.IsNullOrWhiteSpace(bag.orderBy.ToString()) ? string.Empty : string.Format(" ORDER BY {0} ", bag.orderBy.ToString()));
                }
                #endregion
                sqlTemp.Parameters.Add("@num", bag.pageSize, SqlDbType.Int, 4);
            }
            else
            {
                sqlTemp.CommandText = sqlTemp.CommandText.Insert(len, string.Format("  ROW_NUMBER() OVER(ORDER BY {0}) as [num] ,COUNT(0) over() CHEOKTOTALCOUNT, ", string.IsNullOrEmpty(bag.orderBy.ToString()) ? "(SELECT 0)" : bag.orderBy.ToString()));
                if (!string.IsNullOrEmpty(bag.whereBuiler.ToString()))
                {
                    sqlTemp.CommandText = sqlTemp.CommandText +
                                          (string.IsNullOrWhiteSpace(bag.whereBuiler.ToString()) ? string.Empty : string.Format(" WHERE {0} ", bag.whereBuiler.ToString()));
                }
                sqlTemp.CommandText = "SELECT * FROM (" + sqlTemp.CommandText + ") as [tab] where [num] between @Start and @End";
                sqlTemp.Parameters.Add("@Start", ((bag.pageIndex - 1) * bag.pageSize + 1), SqlDbType.Int, 4);
                sqlTemp.Parameters.Add("@End", (bag.pageIndex * bag.pageSize), SqlDbType.Int, 4);
            }


            try
            {
                if (!string.IsNullOrEmpty(bag._preWith))
                {
                    sqlTemp.CommandText =
                        bag._preWith + @"
                                        --With 子句已经完毕
                                        " + sqlTemp.CommandText;
                }
                baseQuery.CommandText = sqlTemp.CommandText;
                baseQuery.Parameters  = sqlTemp.Parameters;
            }
            finally
            {
            }
        }
        private static void GetPageDataBySelect(BaseQuery baseQuery)
        {
            //SET @a = 0;
            //select(@a:= count(0)) as cheokcount  from t_user;
            //select *,@a as cheokcount from T_User limit 1,10;

            var bag           = (ExcutParBag_Page)(baseQuery.excutParBag);
            var sql           = string.Empty;
            var selectTable   = bag.pageTableName;
            var selectColumns = bag.pageColumns;
            var len           = bag.commandText.ToLower().IndexOf(" from") + 1;

            baseQuery.SetDynamicParameters((bag.dynamics));
            BaseQuery sqlTemp = new BaseQuery();

            sqlTemp.CommandText = bag.commandText;
            sqlTemp.CommandType = CommandType.Text;

            for (int i = 0; i < baseQuery.Parameters.Count; i++)
            {
                SqlParameter sqlpa = baseQuery.Parameters[i];
                SqlParameter par   = new SqlParameter();
                par.DbType        = sqlpa.DbType;
                par.Direction     = sqlpa.Direction;
                par.ParameterName = sqlpa.ParameterName;
                par.Value         = sqlpa.Value;
                sqlTemp.Parameters.Add(par);
            }
            //构建取总数的数据
            StringBuilder sqlReal = new StringBuilder();

            sqlReal.AppendLine("/*******查询TotalCount*******/");
            //sqlReal.AppendLine("SET @totalcountcheok=0;");
            sqlReal.AppendLine("select");
            sqlReal.AppendLine("(@totalcountcheok:= count(0))");
            sqlReal.AppendLine("from");
            sqlReal.AppendLine(selectTable);

            if (!string.IsNullOrEmpty(bag.whereBuiler.ToString()))
            {
                sqlReal = sqlReal.AppendLine(string.IsNullOrWhiteSpace(bag.whereBuiler.ToString()) ? string.Empty : string.Format(" WHERE {0}; ", bag.whereBuiler.ToString()));
            }
            else
            {
                sqlReal.Append(";");
            }
            sqlReal.AppendLine("/*******SQL查询数据*******/");
            sqlReal.AppendLine("");
            if (!bag.isPage)
            {
                bag.pageIndex = 1;
                bag.pageSize  = 1;
            }
            if (bag.pageIndex == 1)
            {
                #region  //最新改动


                sqlTemp.CommandText = sqlTemp.CommandText.Insert(len, ",@totalcountcheok  as CHEOKTOTALCOUNT ");
                if (!string.IsNullOrEmpty(bag.whereBuiler.ToString()))
                {
                    sqlTemp.CommandText = sqlTemp.CommandText + (string.IsNullOrWhiteSpace(bag.whereBuiler.ToString()) ? string.Empty : string.Format(" WHERE {0} ", bag.whereBuiler.ToString()));
                }
                if (!string.IsNullOrEmpty(bag.orderBy.ToString()))
                {
                    sqlTemp.CommandText = sqlTemp.CommandText + (string.IsNullOrWhiteSpace(bag.orderBy.ToString()) ? string.Empty : string.Format(" ORDER BY {0} ", bag.orderBy.ToString()));
                }
                sqlTemp.CommandText = sqlTemp.CommandText + " LIMIT " + "0" + "," + bag.pageSize;
                #endregion
            }
            else
            {
                sqlTemp.CommandText = sqlTemp.CommandText.Insert(len, ",@totalcountcheok  as CHEOKTOTALCOUNT ");

                if (!string.IsNullOrEmpty(bag.whereBuiler.ToString()))
                {
                    sqlTemp.CommandText = sqlTemp.CommandText + (string.IsNullOrWhiteSpace(bag.whereBuiler.ToString()) ? string.Empty : string.Format(" WHERE {0} ", bag.whereBuiler.ToString()));
                }
                if (!string.IsNullOrEmpty(bag.orderBy.ToString()))
                {
                    sqlTemp.CommandText = sqlTemp.CommandText + (string.IsNullOrWhiteSpace(bag.orderBy.ToString()) ? string.Empty : string.Format(" ORDER BY {0} ", bag.orderBy.ToString()));
                }
                sqlTemp.CommandText = sqlTemp.CommandText + " LIMIT " + (((bag.pageIndex - 1) * bag.pageSize) - 1) + "," + bag.pageSize;
            }


            try
            {
                sqlTemp.CommandText = sqlReal.ToString() + sqlTemp.CommandText;
                if (!string.IsNullOrEmpty(bag._preWith))
                {
                    sqlTemp.CommandText =
                        bag._preWith + @"
                                        /**With 子句已经完毕**/

                                        " + sqlTemp.CommandText;
                }
                //sqlTemp.Parameters.Add(new SqlParameter() { DbType = DbType.String, Value = "@totalcountcheok", ParameterName= "@totalcountcheok" });
                baseQuery.CommandText = sqlTemp.CommandText;
                baseQuery.Parameters  = sqlTemp.Parameters;
            }
            finally
            {
            }
        }
Пример #22
0
        /// <summary>
        /// 执行的SqlQuery:成功:返回受影响的行数,如果执行不成功,返回-1;如果是执行的是新增提交:模型中主键为自增长IDENTITY时,成功返回新增主键ID, 不成功 则返回-1; 当新增模型主键是非自增长ID时:成功返回 1 ,不成功返回 -1;
        /// </summary>
        /// <param name="o">执行的SQL</param>
        /// <returns>返回受影响的行数</returns>
        public static Int32 Submit(this BaseQuery o)
        {
            Exception ex = null;

            return(GetSubmit(o, null, out ex));
        }
 private void SyncParameter(IDbCommand cmd, BaseQuery q)
 {
 }
Пример #24
0
 /// <summary>
 /// 提交到数据库执行,成功:返回受影响的行数,如果执行不成功,返回-1
 /// </summary>
 /// <param name="o">执行的SqlQuery:成功:返回受影响的行数,如果执行不成功,返回-1</param>
 /// <returns>返回受影响的行数</returns>
 internal static Int32 Submit(this BaseQuery o, out Exception exception)
 {
     return(GetSubmit(o, null, out exception));
 }
 private static IDataReader ExecuteReader(BaseQuery q, DataAccess da)
 {
     da.Open();
     return(da.ExecuteReader(q));
 }
Пример #26
0
 /// <summary>
 /// 提交到数据库执行,成功:返回受影响的行数,如果执行不成功,返回-1
 /// </summary>
 /// <param name="o">执行的SqlQuery:成功:返回受影响的行数,如果执行不成功,返回-1</param>
 /// <returns>返回受影响的行数</returns>
 public static Int32 Submit(this BaseQuery o, string targetdb, out Exception exception)
 {
     return(GetSubmit(o, targetdb, out exception));
 }
 public XmlDocument ExecuteXmlDoc(BaseQuery q)
 {
     throw new NotImplementedException();
 }
Пример #28
0
        internal static bool GetSubmit(List <BaseQuery> list, ScopeCommandInfo scopecommandInfo, out Exception Ex,
                                       List <BulkCopyModel> bulkModels, List <DataTable> bulkTablies, string targetdb)
        {
            bool bl = true;

            Ex = null;
            if ((list == null || list.Count == 0) && (bulkModels == null || bulkModels.Count == 0))
            {
                bl = true;
            }
            else
            {
                try
                {
                    var pty   = dc.conn(targetdb);
                    var index = 0;
                    list.ForEach(p =>
                    {
                        if (p.excutParBag == null)
                        {
                            string error = "错误:core-excutParBag为null.事务语句索引:请检查业务执行语句." + index.ToSafeString();
                            LogService.Default.Fatal(error);
                            throw new  Exception(error);
                        }
                        p.Convert(targetdb);
                        index++;
                    });


                    if (bulkModels != null && bulkModels.Count > 0)
                    {
                        bulkTablies = bulkModels.ConvertBulkTable(targetdb);
                    }

                    if (scopecommandInfo == null)
                    {
                        scopecommandInfo = default(ScopeCommandInfo);
                    }

                    BaseQuery q = null;
                    if (list != null && list.Count > 0)
                    {
                        q = list.ConvertOneQuery();
                        scopecommandInfo.Parameters = q.Parameters;

                        scopecommandInfo.SqlCommand = q.CommandText;
                    }


                    List <BaseQuery> ql = null;
                    if (q != null)
                    {
                        ql = new List <BaseQuery>()
                        {
                            q
                        };
                    }

                    bl = ModelOpretion.ExecuteBacheNonQuery(ql, out Ex, bulkTablies, targetdb);
                }
                catch (Exception ex)
                {
                    bl = false;
                    Ex = ex;
                    LogService.Default.Fatal("处理事务语句时出现异常:" + ex.Message);
                }
            }
            return(bl);
        }
        public static object ExecuteScalar(BaseQuery q, DatabaseProperty dp)
        {
            DataAccess da = new DataAccess(dp.Reader.ConnectionString, dp.Reader.DatabaseType);

            return(DataAccess.ExecuteScalar(q, da));
        }
        /// <summary>
        /// 供新增的时候使用,新增并且取出Identity
        /// </summary>
        /// <param name="q"></param>
        /// <param name="dp"></param>
        /// <returns></returns>
        internal static object ExecuteScalarToWriterOnlyForInsertRentrunIdentity(BaseQuery q, DatabaseProperty dp)
        {
            DataAccess da = new DataAccess(dp.Writer.ConnectionString, dp.Writer.DatabaseType);

            return(DataAccess.ExecuteScalar(q, da));
        }