private void fillTable(ResultOpLogItem data, bool css)
{
TableRow tr = new TableRow();
if (css)
{
tr.CssClass = "alt";
}
m_content[0] = data.m_id.ToString();
m_content[1] = data.m_opAcc;
m_content[2] = data.m_opAccIP;
m_content[3] = data.m_opName;
m_content[4] = data.m_opDateTime;
m_content[5] = data.m_opDesc;
m_content[6] = data.m_comment;
LogTable.Rows.Add(tr);
int col = s_head.Length;
for (int i = 0; i < col; i++)
{
TableCell td = new TableCell();
tr.Cells.Add(td);
td.Text = m_content[i];
}
}
public override OpRes doQuery(object param, GMUser user)
{
ParamQueryOpLog p = (ParamQueryOpLog)param;
string cond = null;
OpRes res = genQueryCond(p, user, ref cond);
if (res != OpRes.opres_success)
{
return(res);
}
m_result.Clear();
string sqlCount = string.Format(SQL_COUNT,
TableName.OPLOG,
TableName.GM_ACCOUNT,
cond);
// 查看满足条件的记当个数
user.totalRecord = user.sqlDb.getRecordCount(sqlCount,
user.getMySqlServerID(),
MySqlDbName.DB_XIANXIA);
string cmd = string.Format(SQL_QUERY_LOG,
TableName.OPLOG,
TableName.GM_ACCOUNT,
cond,
(p.m_curPage - 1) * p.m_countEachPage,
p.m_countEachPage);
List <Dictionary <string, object> > dataList = user.sqlDb.queryList(cmd,
user.getMySqlServerID(),
MySqlDbName.DB_XIANXIA);
if (dataList == null)
{
return(OpRes.op_res_failed);
}
for (int i = 0; i < dataList.Count; i++)
{
ResultOpLogItem info = new ResultOpLogItem();
m_result.Add(info);
Dictionary <string, object> data = dataList[i];
info.m_id = Convert.ToInt64(data["opId"]);
info.m_opAcc = Convert.ToString(data["opAcc"]);
info.m_opAccIP = Convert.ToString(data["opAccIP"]);
info.m_opDateTime = Convert.ToDateTime(data["opTime"]).ToString();
info.m_comment = Convert.ToString(data["opComment"]);
OpInfo opInfo = OpLogMgr.getInstance().getOpInfo(Convert.ToInt32(data["opType"]));
if (opInfo != null)
{
info.m_opName = opInfo.m_opName;
info.m_opDesc = opInfo.m_param.getDescription(opInfo, Convert.ToString(data["opParam"]));
}
else
{
info.m_opName = info.m_opDesc = "";
}
}
return(OpRes.opres_success);
}
