/// <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;
}
