public static void Log(int publishmentSystemID, int applyID, EGovPublicApplyLogType logType, string administratorName, int departmentId)
{
var logInfo = new GovPublicApplyLogInfo(0, publishmentSystemID, applyID, departmentId, administratorName, logType, PageUtils.GetIpAddress(), DateTime.Now, string.Empty);
var departmentName = DepartmentManager.GetDepartmentName(departmentId);
if (logType == EGovPublicApplyLogType.Accept)
{
logInfo.Summary = $"{departmentName}({administratorName})受理申请";
}
else if (logType == EGovPublicApplyLogType.Deny)
{
logInfo.Summary = $"{departmentName}({administratorName})拒绝受理申请";
}
else if (logType == EGovPublicApplyLogType.Reply)
{
logInfo.Summary = $"{departmentName}({administratorName})回复申请";
}
else if (logType == EGovPublicApplyLogType.Comment)
{
logInfo.Summary = $"{departmentName}({administratorName})批示申请";
}
else if (logType == EGovPublicApplyLogType.Redo)
{
logInfo.Summary = $"{departmentName}({administratorName})要求返工";
}
else if (logType == EGovPublicApplyLogType.Check)
{
logInfo.Summary = $"{departmentName}({administratorName})审核通过";
}
DataProvider.GovPublicApplyLogDao.Insert(logInfo);
}
public static void LogSwitchTo(int publishmentSystemID, int applyID, string switchToDepartmentName, string administratorName, int departmentId)
{
var logInfo = new GovPublicApplyLogInfo(0, publishmentSystemID, applyID, departmentId, administratorName, EGovPublicApplyLogType.SwitchTo, PageUtils.GetIpAddress(), DateTime.Now,
$"{DepartmentManager.GetDepartmentName(departmentId)}({administratorName})转办申请至{switchToDepartmentName} ");
DataProvider.GovPublicApplyLogDao.Insert(logInfo);
}
public static void LogNew(int publishmentSystemID, int applyID, string fromName, string toDepartmentName)
{
var logInfo = new GovPublicApplyLogInfo(0, publishmentSystemID, applyID, 0, string.Empty, EGovPublicApplyLogType.New, PageUtils.GetIpAddress(), DateTime.Now,
$"前台{fromName}提交申请{toDepartmentName}");
DataProvider.GovPublicApplyLogDao.Insert(logInfo);
}
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 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);
}
