public ActionResult SystemLogIndex(Page <SystemLogModel> model, string orderby = "")
{
ViewBag.orderby = orderby;
if (model.CurrentPage <= 0)
{
model.CurrentPage = 1;
}
StringBuilder where = new StringBuilder("where 1=1 ");
if (model.Item != null)
{
if (model.Item.ID != null)
{
where.AppendFormat(" and ID = {0} ", model.Item.ID);
}
if (model.Item.UserID != null)
{
where.AppendFormat(" and UserID = {0} ", model.Item.UserID);
}
if (model.Item.Type != null)
{
where.AppendFormat(" and Type = {0} ", model.Item.Type);
}
if (!string.IsNullOrEmpty(model.Item.LogInfo))
{
where.AppendFormat(" and LogInfo like '%{0}%' ", model.Item.LogInfo.Trim());
}
if (model.Item.InsTime != null)
{
where.AppendFormat(" and CONVERT(varchar(100),InsTime,23) = '{0}' ", model.Item.InsTime.Value.ToString("yyyy-MM-dd"));
}
if (!string.IsNullOrEmpty(model.Item.IP))
{
where.AppendFormat(" and IP like '%{0}%' ", model.Item.IP.Trim());
}
if (!string.IsNullOrEmpty(model.Item.Parameters))
{
where.AppendFormat(" and Parameters like '%{0}%' ", model.Item.Parameters.Trim());
}
}
if (string.IsNullOrEmpty(orderby))
{
where.Append(" order by ID desc");
}
else
{
where.Append(" order by " + orderby + "");
}
var page = SystemLogModel.Page(model.CurrentPage, MTConfig.ItemsPerPage, where.ToString(), model.Item);
page.Item = model.Item;
LogDAL.AppendSQLLog(MTConfig.CurrentUserID, typeof(SystemLogModel));
return(View(page));
}
