/// <summary>
/// 插入操作日志
/// </summary>
/// <param name="opLog"></param>
/// <returns></returns>
public bool InsertOprLog(OprLog opLog)
{
List <string> strSqlList = new List <string>();
string strSql = string.Format("insert into oprlog values('{0}',{1},{2},datetime('now'),'{3}','{4}');", opLog.Sn, opLog.Type, opLog.Source, opLog.Content, opLog.Condition);
strSqlList.Add(strSql);
return(_idbWrite.ExecuteNonQueryTrans(strSqlList));
}
private void WriteLog()
{
OprLog opLog = new OprLog();
for (int i = 0; i < comboBox.SelectedIndex + 1; i++)
{
opLog.Sn = "sn_" + i;
opLog.Type = i;
opLog.Source = i + 2;
opLog.Updatetime = DateTime.UtcNow.AddHours(i);
opLog.Content = "content" + i;
opLog.Condition = "condition" + i;
if (!_accessor.InsertOprLog(opLog))
{
toolStripStatusLabel1.Text = "填写日志失败";
return;
}
}
toolStripStatusLabel1.Text = "填写日志成功";
}
/// <summary>
/// 插入操作日志
/// </summary>
/// <param name="opLog"></param>
/// <returns></returns>
public bool InsertOprLog(OprLog opLog)
{
List<string> strSqlList = new List<string>();
string strSql = string.Format("insert into oprlog values('{0}',{1},{2},datetime('now'),'{3}','{4}');", opLog.Sn, opLog.Type, opLog.Source, opLog.Content, opLog.Condition);
strSqlList.Add(strSql);
return _idbWrite.ExecuteNonQueryTrans(strSqlList);
}
/// <summary>
/// 查询操作日志
/// </summary>
/// <param name="ledSN">显示屏SN号，空串代表不限制</param>
/// <param name="type">操作类型，<0代表不限制</param>
/// <param name="source">操作源，<0代表不限制</param>
/// <param name="minDT">时段起始时间</param>
/// <param name="maxDT">时段结束时间</param>
/// <returns></returns>
public List<OprLog> GetOprLog(string ledSN, int type, int source, long minDT, long maxDT)
{
List<OprLog> oprList = new List<OprLog>();
string strTmp = "select sn,type,source,updatetime,content,condition from oprlog where";
string strSql = "select sn,type,source,updatetime,content,condition from oprlog where";
if (ledSN != string.Empty) strSql += " sn=" + "'" + ledSN + "'";
if (type >= 0)
{
if (strTmp == strSql) strSql += " type=" + type;
else strSql += " and type=" + type;
}
if (source >= 0)
{
if (strTmp == strSql) strSql += " source=" + source;
else strSql += " and source=" + source;
}
if (strTmp == strSql) strSql += " updatetime between " + minDT + " and " + maxDT;
else strSql += " and updatetime between " + minDT + " and " + maxDT;
strSql += ";";
DataTable dt = _idbRead.ExecuteDataTable(strSql);
if (dt == null || dt.Rows.Count == 0) return oprList;
OprLog opLog;
for (int i = 0; i < dt.Rows.Count; i++)
{
opLog = new OprLog();
opLog.Sn = (string)dt.Rows[i][0];
opLog.Type = (int)dt.Rows[i][1];
opLog.Source = (int)dt.Rows[i][2];
opLog.Updatetime = SystemHelper.GetTimeByUtcTicks((long)dt.Rows[i][3]);
opLog.Content = (string)dt.Rows[i][4];
opLog.Condition = (string)dt.Rows[i][5];
oprList.Add(opLog);
}
return oprList;
}
/// <summary>
/// 查询操作日志
/// </summary>
/// <param name="ledSN">显示屏SN号，空串代表不限制</param>
/// <param name="type">操作类型，<0代表不限制</param>
/// <param name="source">操作源，<0代表不限制</param>
/// <param name="minDT">时段起始时间</param>
/// <param name="maxDT">时段结束时间</param>
/// <returns></returns>
public List <OprLog> GetOprLog(string ledSN, int type, int source, long minDT, long maxDT)
{
List <OprLog> oprList = new List <OprLog>();
string strTmp = "select sn,type,source,updatetime,content,condition from oprlog where";
string strSql = "select sn,type,source,updatetime,content,condition from oprlog where";
if (ledSN != string.Empty)
{
strSql += " sn=" + "'" + ledSN + "'";
}
if (type >= 0)
{
if (strTmp == strSql)
{
strSql += " type=" + type;
}
else
{
strSql += " and type=" + type;
}
}
if (source >= 0)
{
if (strTmp == strSql)
{
strSql += " source=" + source;
}
else
{
strSql += " and source=" + source;
}
}
if (strTmp == strSql)
{
strSql += " updatetime between " + minDT + " and " + maxDT;
}
else
{
strSql += " and updatetime between " + minDT + " and " + maxDT;
}
strSql += ";";
DataTable dt = _idbRead.ExecuteDataTable(strSql);
if (dt == null || dt.Rows.Count == 0)
{
return(oprList);
}
OprLog opLog;
for (int i = 0; i < dt.Rows.Count; i++)
{
opLog = new OprLog();
opLog.Sn = (string)dt.Rows[i][0];
opLog.Type = (int)dt.Rows[i][1];
opLog.Source = (int)dt.Rows[i][2];
opLog.Updatetime = SystemHelper.GetTimeByUtcTicks((long)dt.Rows[i][3]);
opLog.Content = (string)dt.Rows[i][4];
opLog.Condition = (string)dt.Rows[i][5];
oprList.Add(opLog);
}
return(oprList);
}