Example #1
0
        public static bool ConnectDataBase()
        {
            if (DBHelper == null) {
                string ip = IniHelper.ReadINI("database", "ip");
                string port = IniHelper.ReadINI("database", "port");
                string database = IniHelper.ReadINI("database", "database");
                string username = IniHelper.ReadINI("database", "username");
                string password = IniHelper.ReadINI("database", "password");
                string type = IniHelper.ReadINI("database", "type");

                switch (type.ToLower()) {
                    case "access":
                        DBHelper = new AccessHelper();
                        database = Environment.CurrentDirectory + "\\" + database;
                        break;
                    case "sqlserver":
                    default:
                        DBHelper = new SqlserverHelper();
                        break;
                }
                DBHelper.SetConnInfoString(ip, port, database, username, password);
            }

            return DBHelper.TestConnect();
        }
 public static bool RunBat(IDBHelper db, string sql, bool throwException, DbTransaction trans)
 {
     db.CommandTimeout = 60 * 30;
     string[] arr = sql.Split(
         new string[] { " go ", Environment.NewLine + "go ", " go" + Environment.NewLine, Environment.NewLine + "go" + Environment.NewLine,
         " GO ", Environment.NewLine + "GO ", " GO" + Environment.NewLine, Environment.NewLine + "GO" + Environment.NewLine,
         " Go ", Environment.NewLine + "Go ", " Go" + Environment.NewLine, Environment.NewLine + "Go" + Environment.NewLine,
         " gO ", Environment.NewLine + "gO ", " gO" + Environment.NewLine, Environment.NewLine + "gO" + Environment.NewLine}
         , StringSplitOptions.RemoveEmptyEntries);
     foreach (string s in arr)
     {
         if (string.IsNullOrEmpty(s) || s.Trim().Length == 0)
             continue;
         if (throwException)
             db.ExecuteNonQuery(db.GetSqlCommand(s), trans);
         else
         {
             try
             {
                 db.ExecuteNonQuery(db.GetSqlCommand(s), trans);
             }
             catch (Exception e)
             {
                 ErrorLog.Add(e.Message + "=========>" + s);
             }
         }
     }
     return true;
 }
Example #3
0
 public static bool ConnectCJDB(string ip, string port, string database, string username, string password, string type)
 {
     switch (type.ToLower()) {
         case "oracle":
             DBHelperCJ = new OracleHelper();
             break;
         case "sqlserver":
         default:
             DBHelperCJ = new SqlserverHelper();
             break;
     }
     DBHelperCJ.SetConnInfoString(ip, port, database, username, password);
     return DBHelperCJ.TestConnect();
 }
 public static DataSet Run(IDBHelper db, string sql)
 {
     using(DbConnection conn = db.CreateConnection())
     {
         conn.Open();
         DbCommand cmd = conn.CreateCommand();
         cmd.CommandText = sql;
         using (DbDataAdapter adapter = db.CreateDataAdapter())
         {
             DataSet ds = new DataSet();
             adapter.SelectCommand = cmd;
             adapter.Fill(ds);
             return ds;
         }
     }
 }
Example #5
0
        /// <summary>
        /// Executes the rowmappers
        /// </summary>
        /// <typeparam name="T"></typeparam>
        /// <param name="dbHelper">Database helper</param>
        /// <param name="commandText">Store procedure name. E.g. "Posts_GetPostsByUser</param>
        /// <param name="commandType">StoredProcedure</param>
        /// <param name="rowMapper">The mapper that maps a record to an object.</param>
        /// <param name="dbParameters">Array of parameters for the query.</param>
        /// <returns></returns>
        public static IList <T> Query <T>(this IDBHelper dbHelper, string commandText, CommandType commandType, DbParameter[] dbParameters, IRowMapper <IDataReader, T> rowMapper)
        {
            DbCommand command = dbHelper.BuildCommand(commandText, commandType, dbParameters);

            IList <T> items = null;

            using (command.Connection)
            {
                command.Connection.Open();
                IDataReader reader = command.ExecuteReader();

                // Map the workshops.
                items = rowMapper.MapRows(reader);

                reader.Close();
                command.Dispose();
            }
            return(items);
        }
Example #6
0
        /// <summary>
        /// 执行某个指定连接的所有存储语句只能是非select的DML
        /// </summary>
        /// <param name="key">要执行sql语句的链接</param>
        /// <returns></returns>
        public bool ExecuteSql(string key)
        {
            if (!this.connectionList.ContainsKey(key))
            {
                return(false);
            }
            IDBHelper helper = this.connectionList[key];

            Queue <ISqlScript> list = this.sqlScripts[key];

            while (list.Count > 0)
            {
                ISqlScript sqlscript = list.Dequeue();
                if (sqlscript.IsSqlStringOnly)
                {
                    try
                    {
                        helper.ExecSqlReInt(sqlscript.SqlString);
                    }
                    catch (Exception ex)
                    {
                        string errDescribe = ex.Message + " 异常: " + ex.InnerException + "位置:" + ex.StackTrace + "对象名称:" + ex.Source + "引发异常的方法:" + ex.TargetSite;
                        this.errorMessage += errDescribe;
                        return(false);
                    }
                }
                else
                {
                    try
                    {
                        helper.ExecSqlReInt(sqlscript.SqlString, sqlscript.SqlParams);
                    }
                    catch (Exception ex)
                    {
                        string errDescribe = ex.Message + " 异常: " + ex.InnerException + "位置:" + ex.StackTrace + "对象名称:" + ex.Source + "引发异常的方法:" + ex.TargetSite;
                        this.errorMessage += errDescribe;
                        return(false);
                    }
                }
            }
            return(true);
        }
Example #7
0
        /// <summary>获取服务器下所有库的表/视图/存储过程/函数 的名称,内容,类型等信息表
        ///  获取服务器下所有库的表/视图/存储过程/函数 的名称,内容,类型等信息表
        /// </summary>
        /// <param name="dbType">dbType</param>
        /// <param name="strConn">strConn</param>
        /// <param name="dtDbNames">dtDBNames</param>
        /// <param name="objType">objType</param>
        /// <returns>DataSet</returns>
        public static DataSet GetAllDbObject(SqlType dbType, string strConn, DataTable dtDbNames, DatabaseObjectType objType)
        {
            IDBHelper dbHelper = GetDbHelper(dbType, strConn);
            string    strSql   = string.Empty;

            switch (dbType)
            {
            case SqlType.SqlServer:
                strSql = GetSqlServerObjectSqls(dtDbNames, objType);
                break;

            case SqlType.MySql:
                break;

            case SqlType.Oracle:
                break;
            }
            dbHelper.CreateCommand(strSql);
            return(dbHelper.ExecuteQueryDataSet());
        }
Example #8
0
        public static DataTable GetTriggerss(SqlType dbType, string strConn, string strDbName)
        {
            IDBHelper dbHelper = GetDbHelper(dbType, strConn);
            string    strSql   = string.Empty;

            switch (dbType)
            {
            case SqlType.SqlServer:
                strSql = " USE [" + strDbName + "]  SELECT '" + strDbName + "' as DBName NAME ,object_definition(ID) AS  ObjectContent, 'TRIGGER' AS Type FROM sysobjects WHERE TYPE='TR' ORDER BY Name  ";
                break;

            case SqlType.MySql:
                break;

            case SqlType.Oracle:
                break;
            }
            dbHelper.CreateCommand(strSql);
            return(dbHelper.ExecuteQuery());
        }
Example #9
0
        public static DataTable GetTables(SqlType dbType, string strConn, string strDbName)
        {
            IDBHelper dbHelper = GetDbHelper(dbType, strConn);
            string    strSql   = string.Empty;

            switch (dbType)
            {
            case SqlType.SqlServer:
                strSql = " USE [" + strDbName + "] SELECT   '" + strDbName + "' as DBName,   name , 'Table' as Type  FROM  dbo.sysobjects where OBJECTPROPERTY(id, N'IsUserTable') = 1  ORDER BY Name   ";
                break;

            case SqlType.MySql:
                break;

            case SqlType.Oracle:
                break;
            }
            dbHelper.CreateCommand(strSql);
            return(dbHelper.ExecuteQuery());
        }
Example #10
0
        public static DataTable GetFunctions(SqlType dbType, string strConn, string strDbName)
        {
            IDBHelper dbHelper = GetDbHelper(dbType, strConn);
            string    strSql   = string.Empty;

            switch (dbType)
            {
            case SqlType.SqlServer:
                strSql = " USE [" + strDbName + "]  SELECT '" + strDbName + "' as DBName,name , object_definition(ID) AS ObjectContent,'FUNCTION' as Type FROM sysobjects WHERE [type] IN (N'FN', N'IF', N'TF', N'FS', N'FT') AND category = 0  ORDER BY name    ";
                break;

            case SqlType.MySql:
                break;

            case SqlType.Oracle:
                break;
            }
            dbHelper.CreateCommand(strSql);
            return(dbHelper.ExecuteQuery());
        }
Example #11
0
        public void Delete01(DataTable dt)
        {
            if (dt == null)
            {
                return;
            }

            foreach (DataRow row in dt.Rows)
            {
                ParameterPackageCollection parameters = new ParameterPackageCollection();
                parameters.AddParameter("MENU_ID", row["MENU_ID", DataRowVersion.Original]);

                IDBHelper helper = DbHelperFactory.CreateDbHelper("MES_DB");
                helper.ExecuteNonQuery(
                    @"DELETE FROM TB_MENU_INFO
                   WHERE MENU_ID = @MENU_ID"
                    , CommandType.Text
                    , parameters);
            }
        }
Example #12
0
        public void Insert02(DataTable dt)
        {
            if (dt == null)
            {
                return;
            }

            foreach (DataRow row in dt.Rows)
            {
                ParameterPackageCollection parameters = new ParameterPackageCollection();
                parameters.AddParameter("MCODE", row["MCODE"]);
                parameters.AddParameter("CODE", row["CODE"]);
                parameters.AddParameter("NAME", row["NAME"]);
                parameters.AddParameter("ORDER_SEQ", row["ORDER_SEQ"]);
                parameters.AddParameter("USE_YN", row["USE_YN"]);
                parameters.AddParameter("LOGIN_ID", SharedCache.UserId);

                IDBHelper helper = DbHelperFactory.CreateDbHelper("MES_DB");
                helper.ExecuteNonQuery(
                    @"INSERT 
                        INTO TB_CODE_D 
                             ( MCODE
                              ,CODE    
                              ,NAME    
                              ,ORDER_SEQ
                              ,USE_YN    
                              ,INSERT_USER
                              ,INSERT_TIME  
                             )
                      VALUES ( @MCODE
                              ,@CODE      
                              ,@NAME      
                              ,@ORDER_SEQ
                              ,@USE_YN    
                              ,@LOGIN_ID  
                              ,GETDATE()  
                             )"
                    , CommandType.Text
                    , parameters);
            }
        }
Example #13
0
        public static DataTable GetViews(SqlType dbType, string strConn, string strDbName)
        {
            IDBHelper dbHelper = GetDbHelper(dbType, strConn);
            string    strSql   = string.Empty;

            switch (dbType)
            {
            case SqlType.SqlServer:
                //strSql = " USE [" + strDBName + "] SELECT  *  FROM  dbo.sysobjects where OBJECTPROPERTY(id, N'IsView') = 1    ";
                strSql = " USE [" + strDbName + "]  SELECT '" + strDbName + "' as DBName,  Name ,object_definition(OBJECT_ID) AS ObjectContent,'VIEW' as Type FROM sys.views ORDER BY Name      ";
                break;

            case SqlType.MySql:
                break;

            case SqlType.Oracle:
                break;
            }
            dbHelper.CreateCommand(strSql);
            return(dbHelper.ExecuteQuery());
        }
Example #14
0
        /// <summary>根据类型获取服务器的所有数据库
        /// 根据类型获取服务器的所有数据库
        /// </summary>
        /// <param name="dbType">strDBType</param>
        /// <param name="strConn">strConn</param>
        /// <returns>表结构</returns>
        public static DataTable GetDataBase(SqlType dbType, string strConn)
        {
            IDBHelper dbHelper = GetDbHelper(dbType, strConn);
            string    strSql   = string.Empty;

            switch (dbType)
            {
            case SqlType.SqlServer:
                strSql = "SELECT name FROM  Master.dbo.SysDatabases Where name not in ('master','model','msdb','tempdb')  ";
                break;

            case SqlType.MySql:
                strSql = " SELECT `SCHEMA_NAME` as name  FROM `information_schema`.`SCHEMATA` where  `SCHEMA_NAME` not in('information_schema','mysql','test')";
                break;

            case SqlType.Oracle:
                break;
            }
            dbHelper.CreateCommand(strSql);
            return(dbHelper.ExecuteQuery());
        }
Example #15
0
        public void Update02(DataTable dt)
        {
            if (dt == null)
            {
                return;
            }

            foreach (DataRow row in dt.Rows)
            {
                ParameterPackageCollection parameters = new ParameterPackageCollection();
                parameters.AddParameter("USER_ID", row["USER_ID"]);
                parameters.AddParameter("USER_GROUP", row["USER_GROUP"]);

                IDBHelper helper = DbHelperFactory.CreateDbHelper("MES_DB");
                var       query  = @"UPDATE TB_USER_INFO 
                                 SET USER_GROUP = @USER_GROUP
                               WHERE USER_ID    = @USER_ID";

                helper.ExecuteNonQuery(query, CommandType.Text, parameters);
            }
        }
Example #16
0
        /// <summary>
        /// 查询某表空间中的所有未分区表和分区表
        /// </summary>
        /// <param name="dbHelper"></param>
        /// <param name="tablespaceName"></param>
        /// <returns></returns>
        public static List <string> QueryTotalTable(IDBHelper dbHelper, string tablespaceName)
        {
            try
            {
                List <string> nomalTableSet = QueryNomalTable(dbHelper, tablespaceName);

                List <string> partitionedTableSet = QueryPartitionedTable(dbHelper, tablespaceName);

                List <string> tableSet = nomalTableSet;

                tableSet.AddRange(partitionedTableSet);

                return(tableSet);
            }
            catch (Exception ex)
            {
                LogHelper.Error.Append(ex);

                throw ex;
            }
        }
Example #17
0
        /// <summary>
        /// 查询操作
        /// </summary>
        /// <param name="sql"></param>
        /// <returns></returns>
        public static DataTable ExecuteQuery(string sql)
        {
            IDBHelper _DBHelper = null;

            try
            {
                _DBHelper = CreateHelper();
                return(_DBHelper.ExecuteQuery(sql));
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                if (_DBHelper != null && !InTransaction)
                {
                    _DBHelper.Close();
                }
            }
        }
        // 防止承诺事项重复对接
        // H修正逻辑 由于申遗承诺 每年11-12录入一次   对接的时候发现承诺事项已经对接的 将不再对接 查询元数据做为关联ID
        private Dictionary <string, Guid> SetSYCNDic(IDBHelper dbContext)
        {
            var dic = new Dictionary <string, Guid>();
            var sql = string.Format("select ID,YCDSJID from HPF_SYCN_CNSX  where GLYCBTID='{0}'", this.HeritageId);// and YCDSJID='{1}'";
            var dt  = dbContext.getDataTableResult(sql);

            if (dt == null)
            {
                return(dic);
            }
            foreach (DataRow dr in dt.Rows)
            {
                var gid     = new Guid(dr["ID"] + "");//
                var ycdsjid = dr["YCDSJID"] + "";
                if (!dic.Keys.Contains(ycdsjid))
                {
                    dic.Add(dr["YCDSJID"] + "", gid);
                }
            }
            return(dic);
        }
Example #19
0
        public bool IsExists(string Where = null, ORMParameter[] Parameters = null, string DBEx = null)
        {
            IDBHelper        objHelper        = DBFactory.CreateDBHelper();
            StringBuilder    sbSQL            = new StringBuilder();
            List <Parameter> lstDALParameters = new List <Parameter>();
            bool             blHasValue       = false;
            string           strTableName     = _dt_ClassDef.TableName;

            sbSQL.Append(" SELECT TOP 1 ");
            if (_dt_ClassDef != null)
            {
                sbSQL.Append(_dt_ClassDef.Columns[0].ColumnName);
            }
            else
            {
                sbSQL.Append(" * ");
            }
            sbSQL.Append(" FROM ");
            sbSQL.Append(_cad_TableDef.GetFullTableName(DBEx));
            sbSQL.Append(" WHERE ");
            if (!string.IsNullOrEmpty(Where))
            {
                sbSQL.Append("(" + Where + ")");
            }
            if (Parameters != null && string.IsNullOrEmpty(Where))
            {
                foreach (ORMParameter objParameter in Parameters)
                {
                    Parameter objDALParam = new Parameter(objParameter.Name, objParameter.Value);
                    lstDALParameters.Add(objDALParam);
                }
            }
            DataTable dtModel = objHelper.GetTableWithSQL(sbSQL.ToString(), lstDALParameters.ToArray());

            if (dtModel != null && dtModel.Rows.Count > 0)
            {
                blHasValue = true;
            }
            return(blHasValue);
        }
Example #20
0
    /// <summary>
    /// 作用:初始化全局数据库帮助类
    /// 日期:2018-12-27
    /// </summary>
    public static void InitGlobalDBHelper(string dncfgPath)
    {
        try
        {
            if (RequestUtil.GlobalDBHelper == null)
            {
                Dictionary <string, string> dicDBConfig = XmlHelper.ReaderXML(dncfgPath);//RequestUtil.ConfigFolderPath + @"dbOracle.xml"
                LogManager.WriteToDebug("读取数据库配置文件成功!", RequestUtil.LogsFolderPath);
                _db               = new OracleDBHelper();
                _db.DBServer      = dicDBConfig.Where(q => q.Key.Equals("server")).First().Value;
                _db.DBPort        = dicDBConfig.Where(q => q.Key.Equals("port")).First().Value;
                _db.DBServiceName = dicDBConfig.Where(q => q.Key.Equals("servicename")).First().Value;
                _db.DBName        = dicDBConfig.Where(q => q.Key.Equals("name")).First().Value;
                _db.DBUser        = dicDBConfig.Where(q => q.Key.Equals("user")).First().Value;
                _db.DBPwd         = dicDBConfig.Where(q => q.Key.Equals("pwd")).First().Value;
            }
            else
            {
                _db = RequestUtil.GlobalDBHelper;
            }

            if (_db.TryConnect())
            {
                LogManager.WriteToDebug("数据库连接成功", RequestUtil.LogsFolderPath);
            }
            else
            {
                LogManager.WriteToDebug("数据库连接失败", RequestUtil.LogsFolderPath);
            }
            DataTable dt      = _db.DoQueryEx("select SDE.ST_ASTEXT(t.shape) from SDEGCPOLYGONS t");
            string    strTest = dt.Rows[0][0].ToString();
            LogManager.WriteToDebug("数据库读取空间数据测试成功", RequestUtil.LogsFolderPath);
            RequestUtil.GlobalDBHelper = _db;
        }
        catch (Exception ex)
        {
            LogManager.WriteToError(ex.Message);
            LogManager.WriteToError("数据库连接失败!", RequestUtil.LogsFolderPath);
        }
    }
Example #21
0
        private ConsumeConcurrentlyStatus Producer_ConsumeMessage(object obj, ConsumeEventArgs args)
        {
            IDBHelper helper = DBFactory.CreateDBHelper();
            //存储队列
            var generator = IDGeneratorFactory.Create(GeneratorType.SnowFlak);

            foreach (var m in args.Messages)
            {
                try
                {
                    StringBuilder sql       = new StringBuilder();
                    string        ID        = generator.Generate();
                    string        body      = Encoding.UTF8.GetString(m.getBody());
                    string        tableName = m.getKeys();
                    string        tag       = m.getTags();

                    sql.Append("INSERT INTO MQCache([ID],[Key],[Tag],[Body],[CreateTime]) VALUES(@ID, @Key, @Tag, @Body, GETDATE())");
                    List <Parameter> parameters = new List <Parameter>
                    {
                        new Parameter("@ID", ID),
                        new Parameter("@Key", tableName),
                        new Parameter("@Tag", tag),
                        new Parameter("@Body", body),
                    };
                    lock (this)
                    {
                        helper.ExecNoneQueryWithSQL(sql.ToString(), parameters.ToArray());
                    }
                    _logger.Write("插入数据库成功,json:" + body);
                }
                catch (Exception ex)
                {
                    _logger.WriteException(ex);
                    throw ex;
                }
            }


            return(ConsumeConcurrentlyStatus.CONSUME_SUCCESS);
        }
Example #22
0
        private IDBHelper GetDBHelper(string providerName, string connectionString)
        {
            try
            {
                Type     provider = typeof(IDBHelper);
                Assembly assem    = Assembly.GetAssembly(provider);
                if (assem == null)
                {
                    return(null);
                }

                object[]  args     = new object[] { connectionString };
                IDBHelper dBHelper = assem.CreateInstance(providerName, true, BindingFlags.Default, null, args, null, null) as IDBHelper;

                return(dBHelper);
            }
            catch (Exception e)
            {
                Console.WriteLine(e);
                throw e;
            }
        }
Example #23
0
        /// <summary>
        /// 获取遗产地编码  根据权限
        public static string GetYCDBMWhere(IDBHelper dbContext)
        {
            var o = SessionHelper.GetUser();

            if (o == null)
            {
                return("");
            }
            var sql = $@"select b.BM,DEPARTMENTID,USERID,ROLEID,Province,ROLETYPE from v_PRIVS_USER a

left join (
select BM,XZQBM as SF from HPF_YCJCXX_SJWHYC) b on a.Province=b.SF
  where USERID='{o.ID}' and ROLETYPE='省级' ";
            var dt  = dbContext.getDataTableResult(sql);

            if (dt != null && dt.Rows.Count > 0)
            {
                var bmList = dt.Rows.Cast <DataRow>().Select(e => e["BM"] + "").ToList();
                return(bmList.ChangeListToString(""));
            }
            return("");
        }
Example #24
0
        public string PasswordCheck(string id, string password)
        {
            ParameterPackageCollection parameters = new ParameterPackageCollection();

            parameters.AddParameter("USER_ID", id);
            parameters.AddParameter("PASSWD", password);

            IDBHelper helper      = DbHelperFactory.CreateDbHelper("MES_DB");
            var       resultTable = helper.FillTable(
                cmdText: @"SELECT USER_ID
                             FROM TB_USER_INFO       A
                            WHERE A.USER_ID = @USER_ID
                              AND A.PASSWD  = @PASSWD"
                , cmdType: CommandType.Text
                , parameters: parameters);

            if (resultTable.Rows.Count == 0)
            {
                return(null);
            }
            return((resultTable.Rows[0] as DataRow)["USER_ID"].ToString());
        }
Example #25
0
        public DataTable Select02(string code)
        {
            ParameterPackageCollection parameters = new ParameterPackageCollection();

            parameters.AddParameter("CODE", code);

            IDBHelper helper      = DbHelperFactory.CreateDbHelper("MES_DB");
            var       query       = @"SELECT USER_ID
                                ,USER_NAME
                                ,USER_GROUP
                                ,INSERT_USER
                                ,INSERT_TIME
                                ,UPDATE_USER
                                ,UPDATE_TIME
                                ,ROW_ID
                            FROM TB_USER_INFO
                           WHERE USER_GROUP = @CODE
                           ORDER BY USER_ID";
            var       resultTable = helper.FillTable(query, CommandType.Text, parameters);

            return(resultTable);
        }
Example #26
0
        private void button1_Click(object sender, EventArgs e)
        {
            var           path      = txbPath.Text;
            var           type      = txbType.Text;
            var           prefix    = txbPrefix.Text;
            var           version   = "1.0.0.0";
            DirectoryInfo directory = new DirectoryInfo(path);
            var           files     = directory.GetFiles("*.*", SearchOption.AllDirectories);
            IDBHelper     helper    = DBFactory.CreateDBHelper(DBType.Oracle);

            for (int i = 0; i < files.Length; i++)
            {
                var           file = files[i];
                var           name = file.FullName.Replace(path, "").TrimStart('\\').Replace("modules", "").TrimStart('\\');
                var           id   = string.Format("{0}_{1}", prefix, i);
                StringBuilder sql  = new StringBuilder();
                sql.Append("INSERT INTO TAB_FILEVERSION (FID,FILENAME,VERSION,LASTUPDATEDATE,SYSTYPE) VALUES(:FID,:FILENAME,:VERSION,:LASTUPDATETIME,:SYSTYPE)");
                List <Parameter> parameters = new List <Parameter>();
                parameters.Add(new Parameter {
                    Name = ":FID", Value = id
                });
                parameters.Add(new Parameter {
                    Name = ":FILENAME", Value = name
                });
                parameters.Add(new Parameter {
                    Name = ":VERSION", Value = version
                });
                parameters.Add(new Parameter {
                    Name = ":LASTUPDATETIME", Value = DateTime.Now
                });
                parameters.Add(new Parameter {
                    Name = ":SYSTYPE", Value = type
                });
                helper.ExecNoneQueryWithSQL(sql.ToString(), parameters.ToArray());
            }

            MessageBox.Show("上传完成");
        }
Example #27
0
        public void Insert01(DataTable dt)
        {
            if (dt == null)
            {
                return;
            }

            foreach (DataRow row in dt.Rows)
            {
                ParameterPackageCollection parameters = new ParameterPackageCollection();
                parameters.AddParameter("USER_ID", row["USER_ID"]);
                parameters.AddParameter("VIEW_ID", row["VIEW_ID"]);
                parameters.AddParameter("AUTH_KIND", row["AUTH_KIND"]);
                parameters.AddParameter("AUTH_YN", row["AUTH_YN"]);
                parameters.AddParameter("LOGIN_ID", SharedCache.UserId);

                IDBHelper helper = DbHelperFactory.CreateDbHelper("MES_DB");
                helper.ExecuteNonQuery(
                    @"INSERT 
                        INTO TB_VIEW_AUTH 
                             ( USER_ID
                              ,VIEW_ID    
                              ,AUTH_KIND    
                              ,AUTH_YN    
                              ,INSERT_USER
                              ,INSERT_TIME  
                             )
                      VALUES ( @USER_ID
                              ,@VIEW_ID    
                              ,@AUTH_KIND    
                              ,@AUTH_YN    
                              ,@LOGIN_ID
                              ,GETDATE()  
                             )"
                    , CommandType.Text
                    , parameters);
            }
        }
Example #28
0
        ///  <summary>获取数据库帮助类
        ///
        ///  </summary>
        /// <param name="dbType">数据库类型</param>
        /// <param name="strConn">数据库连接字符串</param>
        ///  <returns>数据库帮助类</returns>
        public static IDBHelper GetDbHelper(SqlType dbType, string strConn)
        {
            IDBHelper dbHelper = null;

            switch (dbType)
            {
            case SqlType.SqlServer:
                dbHelper = new MSSQLHelper(strConn);
                break;

            case SqlType.MySql:
                dbHelper = new MySQLHelper(strConn);
                break;

            case SqlType.SQLite:
                dbHelper = new SQLiteHelper(strConn);
                break;

            case SqlType.Oracle:
                break;
            }
            return(dbHelper);
        }
Example #29
0
        public void Insert01(DataTable dt)
        {
            if (dt == null)
            {
                return;
            }

            foreach (DataRow row in dt.Rows)
            {
                ParameterPackageCollection parameters = new ParameterPackageCollection();
                parameters.AddParameter("USER_ID", row["USER_ID"]);
                parameters.AddParameter("USER_NAME", row["USER_NAME"]);
                parameters.AddParameter("LOGIN_ID", SharedCache.UserId);


                IDBHelper helper = DbHelperFactory.CreateDbHelper("MES_DB");
                helper.ExecuteNonQuery(
                    @"INSERT TB_USER_INFO (USER_ID, USER_NAME, PASSWD, REMARK, INSERT_USER, INSERT_TIME)
                              VALUES (@USER_ID, @USER_NAME, @PASSWD, @REMARK, @LOGIN_ID, GETDATE())"
                    , CommandType.Text
                    , parameters);
            }
        }
Example #30
0
 public UserAppService(
     IRepository <User, long> repository,
     UserManager userManager,
     RoleManager roleManager,
     IRepository <Role> roleRepository,
     IPasswordHasher <User> passwordHasher,
     IAbpSession abpSession,
     LogInManager logInManager,
     IRepository <User, long> userRepository,
     IObjectMapper objectMapper,
     IDBHelper helper)
     : base(repository)
 {
     _userManager    = userManager;
     _roleManager    = roleManager;
     _roleRepository = roleRepository;
     _passwordHasher = passwordHasher;
     _abpSession     = abpSession;
     _logInManager   = logInManager;
     _helper         = helper;
     _userRepository = userRepository;
     _objectMapper   = objectMapper;
 }
Example #31
0
        /// <summary>
        /// 展示关键字结点
        /// </summary>
        /// <returns></returns>
        public static List <DbtuneInfo> ListKeyWord(IDBHelper dbHelper = null, string filePath = null)
        {
            if (!File.Exists(string.Format("{0}\\{1}.xml", Environment.CurrentDirectory, UtilityConst.XML_NAME)))
            {
                CreateXml(dbHelper, filePath);
            }

            List <DbtuneInfo> dbtuneInfoSet = new List <DbtuneInfo>();

            DbtuneInfo dbtuneInfo = new DbtuneInfo();

            XDocument xml = XDocument.Load(string.Format("{0}\\{1}.xml", Environment.CurrentDirectory, UtilityConst.XML_NAME));

            foreach (var keyword in xml.Element(ROOT_NAME).Elements())
            {
                dbtuneInfo            = new DbtuneInfo();
                dbtuneInfo.KeyWord    = keyword.Attribute("Name").Value.ToString();
                dbtuneInfo.ParamName  = keyword.Element("ParamName").Attribute("Name").Value.ToString();
                dbtuneInfo.ParamValue = keyword.Element("ParamName").Element("ParamValue").Attribute("Value").Value.ToString();
                dbtuneInfoSet.Add(dbtuneInfo);
            }
            return(dbtuneInfoSet);
        }
Example #32
0
        public DataTable Select01()
        {
            IDBHelper helper      = DbHelperFactory.CreateDbHelper("MES_DB");
            DataTable resultTable = helper.FillTable
                                    (
                cmdText: @"SELECT A.USER_ID
                                 ,A.VIEW_ID
                                 ,B.MENU_DESC
                                 ,A.AUTH_KIND
                                 ,A.AUTH_YN
                                 ,A.INSERT_USER
                                 ,A.INSERT_TIME
                                 ,A.UPDATE_USER
                                 ,A.UPDATE_TIME
                                 ,A.ROW_ID
                            FROM TB_VIEW_AUTH       A
                            LEFT JOIN TB_MENU_INFO  B ON A.VIEW_ID = B.VIEW_ID",
                cmdType: CommandType.Text,
                parameters: null
                                    );

            return(resultTable);
        }
Example #33
0
 public bool RollbackTran(string key)
 {
     if (this.connectionList.ContainsKey(key))
     {
         IDBHelper helper = this.connectionList[key];
         if (helper.IsOnTransaction)
         {
             try
             {
                 helper.RollbackTran();
             }
             catch (Exception ex)
             {
                 string errDescribe = ex.Message + " 异常: " + ex.InnerException + "位置:" + ex.StackTrace + "对象名称:" + ex.Source + "引发异常的方法:" + ex.TargetSite;
                 this.errorMessage += errDescribe;
                 return(false);
             }
             return(true);
         }
         return(true);//如果没有事务则返回成功
     }
     return(false);
 }
Example #34
0
        private static void AddGeno(IDBHelper dBHelper, string id, string geneIndexid, string server)
        {
            string sqlindex = @"select g.id,g.server,g.idsampling,g.idper  from geneindex g,sampling s,per p,commitment c  
                                    where g.idsampling<> 0 and g.idper<> 0 and s.perid<> 0 and s.commitid<> 0 and p.category<>98 
                                    and g.deleted = 0 and p.deleted = 0 and c.deleted = 0 and s.deleted = 0 
                                    and c.`server`= g.`server` and p.`server`= g.`server`and s.`server`= g.`server` 
                                    and s.perid = p.id and s.id = g.idsampling and c.id = s.commitid and g.id='" + geneIndexid + "' and g.`server`='" + server + "'";
            var    dtIndex  = dBHelper.getDataTable(sqlindex);

            if (dtIndex.Rows.Count > 0)
            {
                //log.Log($"获取基因信息成功 compareId:{id} server:{server} 开始同步");
                for (int k = 0; k < dtIndex.Rows.Count; k++)
                {
                    var sampId = dtIndex.Rows[k]["idsampling"].ToString();
                    var perId  = dtIndex.Rows[k]["idper"].ToString();

                    string sqlType    = "select * from genotype where id =" + geneIndexid + " and `server`=" + server;
                    var    limsGenedt = dBHelper.getDataTable(sqlType);
                    var    drList     = limsGenedt.Select("id=" + geneIndexid + " and server=" + server);

                    //添加进mongo
                    GenoWork.GetGeneInfo(null, null, SyncManage.Marker, drList, 1, 0, perId, sampId);

                    string updSql = "UPDATE comparedatatask SET  `ex8` = 1 WHERE `id` = " + id + " AND `server` = " + server + ";";
                    dBHelper.execSql(updSql);
                    Console.WriteLine($"{id} 同步成功");
                }
            }
            else
            {
                Console.WriteLine($"{id} 为脏数据");
                //脏数据
                string updSql = "UPDATE comparedatatask SET  `ex8` = 3 WHERE `id` = " + id + " AND `server` = " + server + ";";
                dBHelper.execSql(updSql);
            }
        }
 public static bool RunBat(IDBHelper db, string sql, DbTransaction trans)
 {
     return RunBat(db, sql, true, trans);
 }
Example #36
0
 public DBOperator(IDBHelper helper)
 {
     DBH = helper;
 }
Example #37
0
 public DBOperator()
 {
     DBH = new DBHelper();
 }
 public static bool RunBat(IDBHelper db, string sql)
 {
     return RunBat(db, sql, true, null);
 }