private static List <TruckCamRecord> GetTruckRecordsByCamSource(CameraSource cam)
{
IUserLog log = new UserLog();
var list = new List <TruckCamRecord>();
// access 时间字段查询需要在两边加上#，通过oledb parameter传入会报错
var sql = $"SELECT * FROM {cam.ViewName} WHERE PICTIME > #{cam.LastSyncTime}# ORDER BY PICTIME";
var ds = AccessHelper.ExecuteDataset(cam.ConnString, CommandType.Text, sql);
if (ds.Tables[0].Rows.Count > 0)
{
var dt = ds.Tables[0];
// 如果记录中的摄像头编号与配置中不同，则记录warn日志，返回默认集合
if (dt.Rows[0]["CamNo"] != null && !dt.Rows[0]["CamNo"].ToString().Equals(cam.CamNo))
{
log.Warn($"{cam.CamNo}的数据源同步记录中字段CamNo不匹配");
}
else
{
// 构造TruckCamRecord, 填充list
foreach (DataRow dr in dt.Rows)
{
list.Add(new TruckCamRecord(dr, cam.CamNo));
}
}
}
return(list);
}
protected void Page_Load(object sender, EventArgs e)
{
//DataSet a = DataAccess.dataSet("select * from OtherRecord order by ID");
DataSet a = AccessHelper.ExecuteDataset(CommandType.Text, "select * from OtherRecord order by ID");
OtherRepeater.DataSource = a;
OtherRepeater.DataBind();
}
public string SearchDefectRecord(string StationName, string time)
{
DataSet a = new DataSet();
string strSql = "select * from DefectRecord where StationName='" + StationName + "'";
a = AccessHelper.ExecuteDataset(CommandType.Text, strSql);//暂不考虑时间
//update DefectRecord set [Time]=#2015/2/13 18:00:00#
string re = ConvertJson.ToJson(a);
return(re);
}
private void InitTable()
{
try
{
string strCommandText1 = "select name from MSysObjects where type=1 and flags=0";
accessHelper = new AccessHelper("Interference.mdb");
accessHelper.OpenConnection();
m_Table = accessHelper.ExecuteDataset(strCommandText1, null);
}
finally
{
accessHelper.CloseConnection();
}
}
/// <summary>
/// 从数据库读取速度信道字典
/// </summary>
public void GetChannelTypeInfo()
{
lock (m_Object)
{
string strCommondText = "select * from ChannelType";
//AccessHelper.DefineUserConnectionString("BUPT data.mdb");//定义北邮读的数据库
//DataTable tempDataTable = AccessHelper.ExecuteDataset(strCommondText,AccessType.UserDefine, null);
//华为要求所做的修改
AccessHelper accessHelper = new AccessHelper("BUPT data.mdb");
accessHelper.OpenConnection();
DataTable tempDataTable = accessHelper.ExecuteDataset(strCommondText, null);
accessHelper.CloseConnection();
InitialSpeedChannelDic(tempDataTable);
}
}
public void AccessDbHelperTest()
{
const string conStr = @"Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=C:\Projects\ShsictPeccancy\Shsict.Peccancy.Mvc\App_Data\ITCClient2.mdb;
Persist Security Info=False";
var sql = @"SELECT * FROM [MVC_DATA] WHERE [ABSTIME] > #2018/01/01 01:01:01# ";
var ds = AccessHelper.ExecuteDataset(conStr, CommandType.Text, sql);
if (ds.Tables[0].Rows.Count > 0)
{
DataTable dt = ds.Tables[0];
Assert.IsTrue(dt.Rows.Count > 0);
}
}
public static string SearchDailyWork(string Date)
{
DatePre dp = new DatePre(Date);
DataSet a = new DataSet();
try
{
string strSql = "select id,StationName,Content from WeekRule where [WeekTime]='" + dp.WeekTime + "' UNION select id,StationName,Content from MonthRule where [MonthTime]=" + dp.MouthTime + " UNION select id,StationName,Content from YearRule where [MonthTime]=" + dp.Mouth + " and [Day]=" + dp.Day;//暂不考虑时间
a = AccessHelper.ExecuteDataset(CommandType.Text, strSql);
//update DefectRecord set [Time]=#2015/2/13 18:00:00#
}
catch (Exception e)
{
throw new Exception(e.Message);
}
string re = ConvertJson.ToJson(a);
return(re);
}
private void Init()
{
try
{
AccessHelper accessHelper = new AccessHelper("Interference.mdb");
accessHelper.OpenConnection();
foreach (DataRow row in m_Table.Rows)
{
string name = row[0].ToString();
string strCommandText = "SELECT * FROM " + name;
DataTable tempDataTable = accessHelper.ExecuteDataset(strCommandText, null);
m_TableDIC.Add(name, tempDataTable);
}
}
finally
{
accessHelper.CloseConnection();
}
}
private Dictionary<string, List<ReceiverCI>> ReadUmtsReceiveCITable(AccessHelper accessHelper)
{
Dictionary<string, List<ReceiverCI>> receiveDic = new Dictionary<string, List<ReceiverCI>>();
string commandText = "SELECT * FROM UMTSServicesQuality ";
using (DataTable table = accessHelper.ExecuteDataset(commandText, null))
{
for (int i = 0; i < table.Rows.Count; i++)
{
this.AddReceCIToDic(receiveDic, this.GenerateUMTSReceiverCI(table.Rows[i]));
}
}
return receiveDic;
}
