/// <summary> /// Sqlite加载TableStatusStru /// </summary> /// <param name="options"></param> /// <param name="sqlDic"></param> /// <returns></returns> public List <TableStatusStru> GetTableStatus(CommConf options, int pageClick, ref Dictionary <string, string> sqlDic) { // 查询数据总数 List <TableStatusStru> tempDataList = new List <TableStatusStru>(); string errorMsg = string.Empty; CommonMethod comm = new CommonMethod(); string sql = @"select a.taskid,a.UserName,b.laststarttime,b.TotalDataPacketNum, b.TotalRecordNum,b.FinishDataPacketNum,b.FinishRecordNum,b.TaskStatus from taskinfo a left join taskstatus b on a.ID = b.id " + SqlStr(sqlDic) + "order by laststarttime desc"; //string sql = @"SELECT * FROM TableStatus " + SqlStr(sqlDic); DbConnStru SqlitePath = options.DbConnList.FirstOrDefault(o => o.key == "SqliteConn_1"); var list = comm.Select <TableStatusStru>(sql, SqlitePath); if (!string.IsNullOrEmpty(errorMsg)) { return(null); } foreach (TableStatusStru item in list) { tempDataList.Add(item); } sqlDic["PageShowNum"] = options.AttriList.FirstOrDefault(o => o.key == "PageShowNum").value; sqlDic["allowPageNum"] = options.AttriList.FirstOrDefault(l => l.key == "allowPageNum").value; sqlDic["clickpagenow"] = pageClick.ToString(); table = comm.TablePage <TableStatusStru>(tempDataList, ref sqlDic); return(table); }
/// <summary> /// Sqlite加载显示的数据 /// </summary> /// <param name="options"></param> /// <param name="pageclick">当前点击页</param> /// <param name="sqlDic">过滤器条件</param> /// <returns></returns> public List <DbTableColConfigStru> GetDataInfo(CommConf options, int pageClick, ref Dictionary <string, string> sqlDic) { //查询数据总数 List <DbTableColConfigStru> tempDataInfo = new List <DbTableColConfigStru>(); CommonMethod comm = new CommonMethod(); string errorMsg = string.Empty; string sql = @"SELECT * FROM DbTableColConfig"; DbConnStru SqlitePath = options.DbConnList.FirstOrDefault(o => o.key == "SqliteConn_1"); var list = comm.Select <DbTableColConfigStru>(sql, SqlitePath); if (!string.IsNullOrEmpty(errorMsg)) { return(null); } foreach (DbTableColConfigStru item in list) { tempDataInfo.Add(item); } sqlDic["PageShowNum"] = options.AttriList.FirstOrDefault(o => o.key == "PageShowNum").value; sqlDic["allowPageNum"] = options.AttriList.FirstOrDefault(l => l.key == "allowPageNum").value; sqlDic["clickpagenow"] = pageClick.ToString(); dataInfo = comm.TablePage <DbTableColConfigStru>(tempDataInfo, ref sqlDic); return(dataInfo); }
/// <summary> /// 获取数据库链接 /// </summary> /// <param name="connConfig">数据库链接配置结构</param> /// <returns></returns> public static IDbConnection GetConnection(DbConnStru connConfig) { IDbConnection conn = null; if (string.IsNullOrEmpty(connConfig.connStr)) { return(null); } try { switch (connConfig.dbType.ToLower().Trim()) { case "sqlserver": conn = new SqlConnection(connConfig.connStr); break; case "oracle": conn = new OracleConnection(connConfig.connStr); break; case "mysql": conn = new MySqlConnection(connConfig.connStr); break; case "sqlite": conn = new SQLiteConnection(connConfig.connStr); break; default: conn = new SqlConnection(connConfig.connStr); break; } //打开数据库链接 conn.Open(); } catch (Exception ex) { Log4NetUtil.Error(typeof(DapperAcc), "ConnStr:" + connConfig.connStr + " ErrorMsg:" + ex.ToString()); } return(conn); }
/// <summary> /// ORM数据映射 /// </summary> /// <param name="ID"></param> /// <param name="connConfig"></param> /// <returns></returns> public IEnumerable <T> Select <T>(string sql, DbConnStru connConfig) { IEnumerable <T> list = null; using (IDbConnection conn = DapperAcc.GetConnection(connConfig)) { try { //传统sql in (1, 2, 3)写法 //conn.Query<TestTable>("SELECT * FROM TestTable WHERE id IN (@ids) ",new { ids = IDs.ToArray()}) list = conn.Query <T>(sql); //list = conn.Query<DataInfoStru>(sql, new { id = ID }); } catch (Exception ex) { Log4NetUtil.Error(this, "Select->" + ex.ToString()); } } return(list); }
/// <summary> /// 构造函数 /// </summary> /// <param name="connConfig">数据库链接配置结构</param> public OrclAccess(DbConnStru connConfig) { connStr = connConfig.isEncrypt ? EncryptUtil.DesDecrypt_Default(connConfig.connStr) : connConfig.connStr; }