Dashboard/Default.aspx.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Text;
using System.Collections;

public partial class Dashboard_Default : MojoCube.Api.UI.MyPage
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            string date = DateTime.Now.ToString("yyyy-MM-dd");

            #region  连接数据层
            StringBuilder strSql = new StringBuilder();
            //0：考勤
            strSql.Append(" select top 1 * from Attendance_List where fk_User=" + Session["UserID"].ToString() + " and CreateDate>='" + date + " 00:00:00' and CreateDate<='" + date + " 23:59:59' order by pk_Attendance desc");
            //1：文件
            strSql.Append(" select count(pk_Document) as TotalCount from View_Document_List where (fk_User=" + Session["UserID"].ToString() + " or UserList2 like '%|" + Session["UserID"].ToString() + "|%' or TypeID=1)");
            //2：通讯录
            strSql.Append(" select count(pk_Address) as TotalCount from View_Address_List where (fk_User=" + Session["UserID"].ToString() + " or UserList2 like '%|" + Session["UserID"].ToString() + "|%' or TypeID=1) and IsFolder=0");
            //3：讨论区
            strSql.Append(" select count(pk_Forum) as TotalCount from View_Forum_List where ParentID=0 and (fk_User=" + Session["UserID"].ToString() + " or UserList2 like '%|" + Session["UserID"].ToString() + "|%' or UserList='')");
            //4：公告通知
            strSql.Append(" select top 5 * from View_Notice_Receiver where fk_User=" + Session["UserID"].ToString() + " order by IsTop desc,CreateDate desc");
            //5：流程管理
            strSql.Append(" select top 5 * from View_Process_List where fk_User=" + Session["UserID"].ToString() + " order by pk_Process desc");
            //6：工作计划
            strSql.Append(" select top 5 * from View_Plan_List where fk_User=" + Session["UserID"].ToString() + " order by pk_Plan desc");
            //7：我的便签
            strSql.Append(" select top 5 * from Memo_List where fk_User=" + Session["UserID"].ToString() + " order by IsStar desc,ModifyDate desc");

            DataSet ds = MojoCube.Office.Sql.SqlQueryDS(strSql.ToString());
            #endregion

            //考勤
            AttendanceDiv.InnerHtml = CreateAttendance(ds.Tables[0]);

            //文件
            DocumentDiv.InnerHtml = CreateDocument(ds.Tables[1]);

            //通讯录
            AddressDiv.InnerHtml = CreateAddress(ds.Tables[2]);

            //讨论区
            ForumDiv.InnerHtml = CreateForum(ds.Tables[3]);

            //公告通知
            NoticeDiv.InnerHtml = CreateNotice(ds.Tables[4]);

            //流程管理
            ProcessDiv.InnerHtml = CreateProcess(ds.Tables[5]);

            //工作计划
            PlanDiv.InnerHtml = CreatePlan(ds.Tables[6]);