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; }
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; } } }
/// <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); }
/// <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); }
/// <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()); }
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()); }
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()); }
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()); }
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); } }
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); } }
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()); }
/// <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()); }
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); } }
/// <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; } }
/// <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); }
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); }
/// <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); } }
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); }
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; } }
/// <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(""); }
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()); }
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); }
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("上传完成"); }
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); } }
/// <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); }
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); } }
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; }
/// <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); }
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); }
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); }
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); }
public DBOperator(IDBHelper helper) { DBH = helper; }
public DBOperator() { DBH = new DBHelper(); }
public static bool RunBat(IDBHelper db, string sql) { return RunBat(db, sql, true, null); }