public List <DataFromAccess> ReadRecordsWithReadTime(DateTime readFromTime, DateTime readToTime)
{
_OleDbConnection = ConfigurationManager.AppSettings["OleDbConnection"];
OleDbConnection conn = null;
OleDbDataReader readerEntryrec = null;
List <DataFromAccess> returnDataList = new List <DataFromAccess>();
try
{
conn = new OleDbConnection(@_OleDbConnection);
conn.Open();
#region modify by liudan 2009-08-13
#endregion
string queryString = "Select USERINFO.USERID,USERINFO.CardNo, CHECKINOUT.CHECKTIME, CHECKINOUT.CHECKTYPE FROM USERINFO,CHECKINOUT where CHECKINOUT.CHECKTIME>= #" +
readFromTime + "# and CHECKINOUT.CHECKTIME<=#" + readToTime + "# and USERINFO.USERID=CHECKINOUT.USERID order by CHECKINOUT.USERID";
OleDbCommand cmd =
new OleDbCommand(queryString, conn);
readerEntryrec = cmd.ExecuteReader();
while (readerEntryrec.Read())
{
DataFromAccess data = new DataFromAccess();
data.CardNo = Convert.ToString(readerEntryrec["CardNo"]);
data.IOTime = Convert.ToDateTime(readerEntryrec["CHECKTIME"]);
InOutStatusEnum statusEnum = InOutStatusEnum.Out;
string ioStatus = Convert.ToString(readerEntryrec["CHECKTYPE"]);
//进出状态 0为进 1为出
if (ioStatus.Equals("I"))
{
statusEnum = InOutStatusEnum.In;
}
data.InOrOut = statusEnum;
returnDataList.Add(data);
}
return(returnDataList);
}
catch (Exception ex)
{
// 错误信息
strErrorMsg = "异常：\n" + ex.Message;
//// 写日志
TLineEventLog el = new TLineEventLog();
el.DoWriteEventLog(strErrorMsg, EventType.Error);
return(returnDataList);
}
finally
{
if (readerEntryrec != null)
{
readerEntryrec.Close();
}
if (conn != null)
{
conn.Close();
}
}
}
public List <DataFromAccess> ReadRecords(DateTime lastReadTime)
{
_OleDbConnection = ConfigurationManager.AppSettings["OleDbConnection"];
OleDbConnection conn = null;
OleDbDataReader readerEntryrec = null;
List <DataFromAccess> returnDataList = new List <DataFromAccess>();
try
{
//User Id=staples\wang.yueqi;Password=yueqiwang;
//Jet OLEDB:Database Password=databasepw;
//ConnectionIP();
conn = new OleDbConnection(@_OleDbConnection);
conn.Open();
#region modify by liudan 2009-08-13
//OleDbCommand cmd =
// new OleDbCommand("Select * FROM entryrec where entry_dt >= #" +
// lastReadTime + "# order by Card_No", conn);
//readerEntryrec = cmd.ExecuteReader();
//while (readerEntryrec.Read())
//{
// DataFromAccess data=new DataFromAccess();
// data.CardNo = Convert.ToString(readerEntryrec[_Card_No]);
// string s = (readerEntryrec[_IO]).ToString();
// int i = Convert.ToInt32(readerEntryrec[_IO]);
// //进出状态 0为进 1为出
// if (i == 1)
// {
// data.InOrOut = InOutStatusEnum.In;
// }
// else
// {
// data.InOrOut = InOutStatusEnum.Out;
// }
// data.IOTime = Convert.ToDateTime(readerEntryrec[_IOTime]);
// returnDataList.Add(data);
//}
//return returnDataList;
#endregion
string queryString = "Select USERINFO.USERID,USERINFO.CardNo, CHECKINOUT.CHECKTIME, CHECKINOUT.CHECKTYPE FROM USERINFO,CHECKINOUT where CHECKINOUT.CHECKTIME>= #" +
lastReadTime + "# and USERINFO.USERID=CHECKINOUT.USERID order by CHECKINOUT.USERID";
OleDbCommand cmd =
new OleDbCommand(queryString, conn);
readerEntryrec = cmd.ExecuteReader();
while (readerEntryrec.Read())
{
DataFromAccess data = new DataFromAccess();
data.CardNo = Convert.ToString(readerEntryrec["CardNo"]);
data.IOTime = Convert.ToDateTime(readerEntryrec["CHECKTIME"]);
InOutStatusEnum statusEnum = InOutStatusEnum.Out;
string ioStatus = Convert.ToString(readerEntryrec["CHECKTYPE"]);
//进出状态 0为进 1为出
if (ioStatus.Equals("I"))
{
statusEnum = InOutStatusEnum.In;
}
data.InOrOut = statusEnum;
returnDataList.Add(data);
}
return(returnDataList);
}
catch (Exception ex)
{
// 错误信息
strErrorMsg = "异常：\n" + ex.Message;
//// 写日志
TLineEventLog el = new TLineEventLog();
el.DoWriteEventLog(strErrorMsg, EventType.Error);
return(returnDataList);
}
finally
{
if (readerEntryrec != null)
{
readerEntryrec.Close();
}
if (conn != null)
{
conn.Close();
}
}
}