public void Insert(GovInteractLogInfo logInfo)
{
var sqlString = "INSERT INTO wcm_GovInteractLog(PublishmentSystemID, NodeID, ContentID, DepartmentID, UserName, LogType, IPAddress, AddDate, Summary) VALUES (@PublishmentSystemID, @NodeID, @ContentID, @DepartmentID, @UserName, @LogType, @IPAddress, @AddDate, @Summary)";
var parms = new IDataParameter[]
{
GetParameter(ParmPublishmentsystemid, EDataType.Integer, logInfo.PublishmentSystemID),
GetParameter(ParmNodeId, EDataType.Integer, logInfo.NodeID),
GetParameter(ParmContentId, EDataType.Integer, logInfo.ContentID),
GetParameter(ParmDepartmentId, EDataType.Integer, logInfo.DepartmentID),
GetParameter(ParmUserName, EDataType.VarChar, 50, logInfo.UserName),
GetParameter(ParmLogType, EDataType.VarChar, 50, EGovInteractLogTypeUtils.GetValue(logInfo.LogType)),
GetParameter(ParmIpAddress, EDataType.VarChar, 50, logInfo.IPAddress),
GetParameter(ParmAddDate, EDataType.DateTime, logInfo.AddDate),
GetParameter(ParmSummary, EDataType.NVarChar, 255, logInfo.Summary)
};
ExecuteNonQuery(sqlString, parms);
}
public void Page_Load(object sender, EventArgs e)
{
if (IsForbidden)
{
return;
}
_contentId = TranslateUtils.ToInt(Request.QueryString["ContentID"]);
if (!IsPostBack)
{
if (_contentId > 0)
{
var logInfoArrayList = DataProvider.GovInteractLogDao.GetLogInfoArrayList(PublishmentSystemId, _contentId);
var builder = new StringBuilder();
var count = logInfoArrayList.Count;
var i = 1;
foreach (GovInteractLogInfo logInfo in logInfoArrayList)
{
if (logInfo.DepartmentID > 0)
{
builder.Append(
$@"<tr class=""info""><td class=""center""> {DepartmentManager.GetDepartmentName(
logInfo.DepartmentID)} {EGovInteractLogTypeUtils.GetText(logInfo.LogType)}<br />{DateUtils
.GetDateAndTimeString(logInfo.AddDate)} </td></tr>");
}
else
{
builder.Append(
$@"<tr class=""info""><td class=""center""> {EGovInteractLogTypeUtils.GetText(
logInfo.LogType)}<br />{DateUtils.GetDateAndTimeString(logInfo.AddDate)} </td></tr>");
}
if (i++ < count)
{
builder.Append(@"<tr><td class=""center""><img src=""../pic/flow.gif"" /></td></tr>");
}
}
ltlFlows.Text = builder.ToString();
}
}
}
public ArrayList GetLogInfoArrayList(int publishmentSystemId, int contentId)
{
var arraylist = new ArrayList();
string sqlString =
$"SELECT LogID, PublishmentSystemID, NodeID, ContentID, DepartmentID, UserName, LogType, IPAddress, AddDate, Summary FROM wcm_GovInteractLog WHERE PublishmentSystemID = {publishmentSystemId} AND ContentID = {contentId} ORDER BY LogID";
using (var rdr = ExecuteReader(sqlString))
{
while (rdr.Read())
{
var i = 0;
var logInfo = new GovInteractLogInfo(GetInt(rdr, i++), GetInt(rdr, i++), GetInt(rdr, i++), GetInt(rdr, i++), GetInt(rdr, i++), GetString(rdr, i++), EGovInteractLogTypeUtils.GetEnumType(GetString(rdr, i++)), GetString(rdr, i++), GetDateTime(rdr, i++), GetString(rdr, i));
arraylist.Add(logInfo);
}
rdr.Close();
}
return(arraylist);
}
