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); }