77 lines
2.1 KiB
C#
77 lines
2.1 KiB
C#
|
using System;
|
|||
|
|
using System.Collections.Generic;
|
|||
|
|
using System.Linq;
|
|||
|
|
using System.Text;
|
|||
|
|
using CRVM.Utility;
|
|||
|
|
using System.Data;
|
|||
|
|
using System.Collections;
|
|||
|
|
|
|||
|
|
using System.Data.OleDb;
|
|||
|
|
|
|||
|
|
namespace CRVM.CIDExcuter
|
|||
|
|
{
|
|||
|
|
public class LogicConnect
|
|||
|
|
{
|
|||
|
|
private IDBAccess projDB = null;
|
|||
|
|
private StringConnectItem connstrItem = null;
|
|||
|
|
public EDBItem dbItem;
|
|||
|
|
private string connstr = "";
|
|||
|
|
private string tablestr;
|
|||
|
|
|
|||
|
|
public LogicConnect(EDBItem dbItem, string tablestr)
|
|||
|
|
{
|
|||
|
|
|
|||
|
|
this.dbItem = dbItem;
|
|||
|
|
this.tablestr = tablestr;
|
|||
|
|
ConnectStrs(dbItem);
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
public void ConnectStrs(EDBItem dbItem)
|
|||
|
|
{
|
|||
|
|
// dbItem = connstrItem.dbItem;
|
|||
|
|
|
|||
|
|
if (dbItem != null)
|
|||
|
|
{
|
|||
|
|
connstrItem = new StringConnectItem();
|
|||
|
|
connstr = StringConnectItem.InitialStrConn(dbItem);
|
|||
|
|
projDB = DBFactory.CreateAccess(dbItem.DataType);
|
|||
|
|
}
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
throw new Exception("请配置数据库数据！");
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
public DataTable SelTableData(string tablename)
|
|||
|
|
{
|
|||
|
|
DataTable dt = new DataTable();
|
|||
|
|
dt = projDB.SelTableData(tablename, connstr);
|
|||
|
|
return dt;
|
|||
|
|
}
|
|||
|
|
public DataTable SelTableData(string tablename,string sql)
|
|||
|
|
{
|
|||
|
|
DataTable dt = new DataTable();
|
|||
|
|
dt = projDB.SelTableData(tablename,connstr,sql );
|
|||
|
|
return dt;
|
|||
|
|
}
|
|||
|
|
public DataTable DataBase(string sql)
|
|||
|
|
{
|
|||
|
|
DataTable dt = new DataTable();
|
|||
|
|
dt = projDB.DataBase(connstr, sql);
|
|||
|
|
return dt;
|
|||
|
|
}
|
|||
|
|
/// <summary>
|
|||
|
|
/// 获取事件信息
|
|||
|
|
/// </summary>
|
|||
|
|
/// <returns></returns>
|
|||
|
|
public DataTable GetEventInfo(ShowStyle style)
|
|||
|
|
{
|
|||
|
|
string sql = "select seq, eventname, field,datavalue,status,tom from T_BPC_TRIGGER order by seq asc";
|
|||
|
|
DataTable dt = new DataTable();
|
|||
|
|
dt = projDB.GetData(connstr, sql, style);
|
|||
|
|
return dt;
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
|