public void Insert(GovPublicApplyLogInfo logInfo)
{
var sqlString = "INSERT INTO wcm_GovPublicApplyLog(PublishmentSystemID, ApplyID, DepartmentID, UserName, LogType, IPAddress, AddDate, Summary) VALUES (@PublishmentSystemID, @ApplyID, @DepartmentID, @UserName, @LogType, @IPAddress, @AddDate, @Summary)";
var parms = new IDataParameter[]
{
GetParameter(ParmPublishmentsystemid, EDataType.Integer, logInfo.PublishmentSystemID),
GetParameter(ParmApplyId, EDataType.Integer, logInfo.ApplyID),
GetParameter(ParmDepartmentId, EDataType.Integer, logInfo.DepartmentID),
GetParameter(ParmUserName, EDataType.VarChar, 50, logInfo.UserName),
GetParameter(ParmLogType, EDataType.VarChar, 50, EGovPublicApplyLogTypeUtils.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;
}
_applyId = TranslateUtils.ToInt(Request.QueryString["ApplyID"]);
if (!IsPostBack)
{
if (_applyId > 0)
{
var logInfoArrayList = DataProvider.GovPublicApplyLogDao.GetLogInfoArrayList(_applyId);
var builder = new StringBuilder();
var count = logInfoArrayList.Count;
var i = 1;
foreach (GovPublicApplyLogInfo logInfo in logInfoArrayList)
{
if (logInfo.DepartmentID > 0)
{
builder.Append(
$@"<tr class=""info""><td class=""center""> {DepartmentManager.GetDepartmentName(
logInfo.DepartmentID)} {EGovPublicApplyLogTypeUtils.GetText(logInfo.LogType)}<br />{DateUtils
.GetDateAndTimeString(logInfo.AddDate)} </td></tr>");
}
else
{
builder.Append(
$@"<tr class=""info""><td class=""center""> {EGovPublicApplyLogTypeUtils.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 applyId)
{
var arraylist = new ArrayList();
string sqlString =
$"SELECT LogID, PublishmentSystemID, ApplyID, DepartmentID, UserName, LogType, IPAddress, AddDate, Summary FROM wcm_GovPublicApplyLog WHERE ApplyID = {applyId}";
using (var rdr = ExecuteReader(sqlString))
{
while (rdr.Read())
{
var i = 0;
var logInfo = new GovPublicApplyLogInfo(GetInt(rdr, i++), GetInt(rdr, i++), GetInt(rdr, i++), GetInt(rdr, i++), GetString(rdr, i++), EGovPublicApplyLogTypeUtils.GetEnumType(GetString(rdr, i++)), GetString(rdr, i++), GetDateTime(rdr, i++), GetString(rdr, i));
arraylist.Add(logInfo);
}
rdr.Close();
}
return(arraylist);
}
