Web/Controllers/logmanagerController.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using System.Text;
using Maticsoft.DBUtility;
using System.Data;
namespace Web.Controllers
{
    public class logmanagerController : Controller
    {
        private string sql, getsql;
        #region"转向操作日志页面"
        public ActionResult workloglist()
        {
            if (Session["username"] != null && Session["username"] != "")
            {
                return View();
            }
            else
            {
                return RedirectToAction("../userlogin/userlogin");
            }
        }
        #endregion
        #region"操作日志数据"
        public string workloglistjson()
        {
            StringBuilder worklogsb = new StringBuilder();
            string worklogstr = "";
            try
            {
                if (!string.IsNullOrEmpty(Request["start"]) && !string.IsNullOrEmpty(Request["limit"]))
                {
                    int start = int.Parse(Request["start"].ToString());
                    int limit = int.Parse(Request["limit"].ToString());
                    if (Request["selecttime"] != null && Request["selecttime"] != "")
                    {
                        sql = "select * from T_worklog   where datediff(MM,worktime,'" + Request["selecttime"].ToString() + "')=0   ";
                    }
                    else
                    {
                        sql = "select * from T_worklog  where datediff(MM,worktime,getdate())=0";
                    }
                    int totilecount = int.Parse(DbHelperSQL.Query(Utils.getSqlCount(sql)).Tables[0].Rows[0][0].ToString());
                    worklogsb.Append("{worklogcount:" + totilecount + ",workloglist:[");
                    getsql = Utils.getPageSizeSql(sql, "compareid", 20, start);
                    foreach (DataRow dr in DbHelperSQL.Query(getsql).Tables[0].Rows)
                    {
                        worklogsb.Append("{compareid:'" + dr["compareid"].ToString() + "',username:'" + dr["username"].ToString() + "',worktime:'" + dr["worktime"].ToString() + "',workcontent:'" + dr["workcontent"].ToString() + "'},");
                    }
                    worklogsb.Append("]}");
                    worklogstr = worklogsb.ToString().Replace(",]}", "]}");
                }
            }
            catch (Exception ex)
            {
                Utils.WriteLog(ex.Message, "workloglistjson");
            }