public ActionResult ExportCompleteExample()
        {
            try
            {
                QuerySuite querySuite = new QuerySuite(this, "ExampleName desc");
                querySuite.Select("select a.*,b.userName,c.departmentName from GeneralExample a left join SysUser b on a.UserPicker=b.UserID left join SysDepartment c on a.OUPicker=c.DepartmentID");

                querySuite.AddParam("ExampleName", "like");
                querySuite.AddParam("PlainText", "=");
                querySuite.AddParam("DateTimePicker", ">=");

                DataSet ds = SqlHelper.Query(querySuite.ExportSql, querySuite.Params);

                string fileName = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, string.Format("export/{0:yyyyMMdd}/{1}.xlsx", DateTime.Now, Guid.NewGuid()));
                if (!Directory.Exists(Path.GetDirectoryName(fileName)))
                {
                    Directory.CreateDirectory(Path.GetDirectoryName(fileName));
                }

                ExcelHelper.DataTableToExcel(ds.Tables[0], fileName, "导出Sheet");
                FileStream fs = new FileStream(fileName, FileMode.Open);
                return(File(fs, "application/vnd.ms-excel", "export.xlsx"));
            }
            catch (Exception ex)
            {
                LogHelper.SaveLog(ex);
                return(Json(new { Code = 1, Msg = "服务器异常,请联系管理员!" }));
            }
        }
        /// <summary>
        /// 获取页面操作数据
        /// </summary>
        /// <returns></returns>
        public JsonResult QueryUserData(Guid?parentId)
        {
            try
            {
                QuerySuite querySuite = new QuerySuite(this, "orderNo asc");
                querySuite.Select("select * from SysUser");

                querySuite.AddParam(" and departmentId=@departmentId", new SqlParameter("departmentId", parentId));
                querySuite.AddParam("userName", "like");

                DataSet ds = SqlHelper.Query(querySuite.QuerySql, querySuite.Params);
                return(Json(new { Code = 0, Total = ds.Tables[0].Rows[0][0], Data = QuerySuite.ToDictionary(ds.Tables[1]) }));
            }
            catch (Exception ex)
            {
                LogHelper.SaveLog(ex);
                return(Json(new { Code = 1, Msg = "服务器异常,请联系管理员!" }));
            }
        }
        public ActionResult QueryCompleteExample()
        {
            try
            {
                QuerySuite querySuite = new QuerySuite(this, "exampleName desc");
                querySuite.Select("select a.*,b.userName,c.departmentName from GeneralExample a left join SysUser b on a.UserPicker=b.UserID left join SysDepartment c on a.OUPicker=c.DepartmentID");

                querySuite.AddParam("ExampleName", "like");
                querySuite.AddParam("PlainText", "=");
                querySuite.AddParam("DateTimePicker", ">=");

                DataSet ds = SqlHelper.Query(querySuite.QuerySql, querySuite.Params);

                return(Json(new { Code = 0, Total = ds.Tables[0].Rows[0][0], Data = QuerySuite.ToDictionary(ds.Tables[1]) }));
            }
            catch (Exception ex)
            {
                LogHelper.SaveLog(ex);
                return(Json(new { Code = 1, Msg = "服务器异常,请联系管理员!" }));
            }
        }
Esempio n. 4
0
        public FileResult ExportCompleteExample()
        {
            try
            {
                QuerySuite querySuite = new QuerySuite(this, "ExampleName desc");
                querySuite.Select("select a.*,b.userName,c.departmentName from GeneralExample a left join SysUser b on a.UserPicker=b.UserID left join SysDepartment c on a.OUPicker=c.DepartmentID");

                querySuite.AddParam("ExampleName", "like");
                querySuite.AddParam("PlainText", "=");
                querySuite.AddParam("DateTimePicker", ">=");

                DataSet ds = SqlHelper.Query(querySuite.ExportSql, querySuite.Params);

                return(null);
            }
            catch (Exception ex)
            {
                LogHelper.SaveLog(ex);
                return(null);
            }
        }
Esempio n. 5
0
        /// <summary>
        /// 获取数据字典数据
        /// </summary>
        /// <returns></returns>
        public JsonResult QueryDictionary()
        {
            try
            {
                QuerySuite querySuite = new QuerySuite(this, "orderNo asc");

                querySuite.Select("select * from SysDictionary");

                querySuite.AddParam("Type", "like");
                querySuite.AddParam("Member", "like");
                querySuite.AddParam("MemberName", "like");

                DataSet ds = SqlHelper.Query(querySuite.QuerySql, querySuite.Params);
                return(Json(new { Code = 0, Total = ds.Tables[0].Rows[0][0], Data = QuerySuite.ToDictionary(ds.Tables[1]) }));
            }
            catch (Exception ex)
            {
                LogHelper.SaveLog(ex);
                return(Json(new { Code = 1, Msg = "服务器异常,请联系管理员!" }));
            }
        }
        /// <summary>
        /// 根据父级id获取 部门数据
        /// </summary>
        /// <returns></returns>
        public JsonResult QueryDepartmentData()
        {
            try
            {
                QuerySuite querySuite = new QuerySuite(this, "createTime desc");

                querySuite.Select("select departmentId,departmentCode,departmentName,departmentFullName,createTime from SysDepartment");

                querySuite.AddParam("parentId", "=");
                querySuite.AddParam("departmentName", "like");
                querySuite.AddParam("departmentCode", "like");

                DataSet ds = SqlHelper.Query(querySuite.QuerySql, querySuite.Params);

                return(Json(new { Code = 0, Total = ds.Tables[0].Rows[0][0], Data = QuerySuite.ToDictionary(ds.Tables[1]) }));
            }
            catch (Exception ex)
            {
                LogHelper.SaveLog(ex);
                return(Json(new { Code = 1, Msg = "服务器异常,请联系管理员!" }));
            }
        }
        /// <summary>
        /// 获取日志数据
        /// </summary>
        /// <returns></returns>
        public JsonResult GetLogData()
        {
            try
            {
                QuerySuite querySuite = new QuerySuite(this, "createTime desc");
                querySuite.Select("select * from SysLog");

                querySuite.AddParam("userName", "like");
                querySuite.AddParam("departmentName", "like");
                querySuite.AddParam("title", "like");
                querySuite.AddParam("type", "like");
                querySuite.AddParam("description", "like");

                DataSet ds = SqlHelper.Query(querySuite.QuerySql, querySuite.Params);

                return(Json(new { Code = 0, Total = ds.Tables[0].Rows[0][0], Data = QuerySuite.ToDictionary(ds.Tables[1]) }));
            }
            catch (Exception ex)
            {
                LogHelper.SaveLog(ex);
                return(Json(new { Code = 1, Msg = "服务器异常,请联系管理员!" }));
            }
        }
        /// <summary>
        /// 获取项目信息数据
        /// </summary>
        /// <returns></returns>
        public JsonResult QueryProjectData()
        {
            try
            {
                QuerySuite querySuite = new QuerySuite(this, "CreateTime desc");
                querySuite.Select("select * from PmProject");

                querySuite.AddParam("ProjectName", "like");

                DataSet ds = SqlHelper.Query(querySuite.QuerySql, querySuite.Params);
                return(Json(new { Code = 0, Total = ds.Tables[0].Rows[0][0], Data = QuerySuite.ToDictionary(ds.Tables[1]) }));
            }
            catch (Exception ex)
            {
                LogHelper.SaveLog(ex);
                return(Json(new { Code = 1, Msg = "服务器异常,请联系管理员!" }));
            }
        }