工作流待辦事項消息提醒 - s0611163－IT工程師數位筆記本

文章出處

web頁面提醒的缺點：不可能一直開著瀏覽器；郵件提醒的缺點：領導工作繁忙哪有時間看郵件，即便像我這樣不忙的，也懶得看郵件，所以郵件提醒其實很雞肋。所以需要做個桌面提醒，每個辦公人員都有自己的電腦，只要電腦開著，就能收到提醒。

所用到的技術：WebService、線程

功能：1、桌面消息提醒器開機自動啟動；2、根據設置的間隔自動提醒；3、點擊消息，即可打開瀏覽器處理待辦；4、首次使用需要登錄一次，以后不需要每次登錄，可以切換賬號登錄；

主要代碼：

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Configuration;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading;
using System.Threading.Tasks;
using System.Web.Services.Protocols;
using System.Windows.Forms;
using Microsoft.Win32;
using Utils;

namespace MessageReminder
{
    /// <summary>
    /// 桌面消息提醒器
    /// </summary>
    public partial class Form1 : Form
    {
        #region 變量
        /// <summary>
        /// 桌面消息提醒WebService
        /// </summary>
        public DesktopMsgService.Service m_DesktopMsgService = new DesktopMsgService.Service();
        /// <summary>
        /// 服務器url
        /// </summary>
        public string m_Url = ConfigurationManager.AppSettings["url"];
        /// <summary>
        /// 消息提醒框
        /// </summary>
        public MsgForm m_msgForm;
        /// <summary>
        /// 用戶名
        /// </summary>
        public string m_UserName;
        /// <summary>
        /// 密碼
        /// </summary>
        public string m_Pwd;
        /// <summary>
        /// 時間單位
        /// </summary>
        private int timeUnit = ConfigurationManager.AppSettings["testFlag"] == "1" ? 1000 : 1000 * 60;
        /// <summary>
        /// 待審閱
        /// </summary>
        private int m_dsyCount = 0;
        /// <summary>
        /// 待審閱輔審
        /// </summary>
        private int m_dsyFsCount = 0;
        /// <summary>
        /// 待審核
        /// </summary>
        private int m_dshCount = 0;
        /// <summary>
        /// 待審核輔審
        /// </summary>
        private int m_dshFsCount = 0;
        /// <summary>
        /// 待批準
        /// </summary>
        private int m_dpzCount = 0;
        /// <summary>
        /// 未通過
        /// </summary>
        private int m_wtgCount = 0;
        /// <summary>
        /// 是否可以退出
        /// </summary>
        private bool canExit = false;
        #endregion

        #region Form1
        public Form1()
        {
            InitializeComponent();

            #region 隱藏主窗體
            //隱藏主窗體
            this.ShowInTaskbar = false;
            this.WindowState = FormWindowState.Minimized;
            this.Visible = false;
            #endregion

            #region 開機自動啟動
            //開機自動啟動
            string path = Application.ExecutablePath;
            RegistryKey rk = Registry.LocalMachine;
            RegistryKey rk2 = rk.OpenSubKey(@"Software\Microsoft\Windows\CurrentVersion\Run", true);
            if (rk2 == null)
            {
                rk.CreateSubKey(@"Software\Microsoft\Windows\CurrentVersion\Run");
            }
            if (rk2.GetValue("技術報告消息提醒器") == null
                || rk2.GetValue("技術報告消息提醒器").ToString() != path)
            {
                rk2.SetValue("技術報告消息提醒器", path);
            }
            rk2.Close();
            rk.Close();
            #endregion

            #region 記錄用戶名密碼
            //記錄用戶名密碼
            m_UserName = MessageReminder.Properties.Settings.Default.userName;
            m_Pwd = MessageReminder.Properties.Settings.Default.pwd;
            #endregion

            #region 菜單顯示
            //菜單顯示
            if (MessageReminder.Properties.Settings.Default.userName != "")
            {
                this.登錄ToolStripMenuItem.Text = "用戶信息";
            }
            #endregion

            #region 提醒間隔
            if (Properties.Settings.Default.reminderInterval == timeUnit * 1)
            {
                this.reminderInterval1分鐘.Checked = true;
            }
            else if (Properties.Settings.Default.reminderInterval == timeUnit * 2)
            {
                this.reminderInterval2分鐘.Checked = true;
            }
            else if (Properties.Settings.Default.reminderInterval == timeUnit * 5)
            {
                this.reminderInterval5分鐘.Checked = true;
            }
            else if (Properties.Settings.Default.reminderInterval == timeUnit * 10)
            {
                this.reminderInterval10分鐘.Checked = true;
            }
            else if (Properties.Settings.Default.reminderInterval == timeUnit * 20)
            {
                this.reminderInterval20分鐘.Checked = true;
            }
            else if (Properties.Settings.Default.reminderInterval == timeUnit * 30)
            {
                this.reminderInterval30分鐘.Checked = true;
            }
            else if (Properties.Settings.Default.reminderInterval == timeUnit * 60 * 1)
            {
                this.reminderInterval1小時.Checked = true;
            }
            else if (Properties.Settings.Default.reminderInterval == timeUnit * 60 * 2)
            {
                this.reminderInterval2小時.Checked = true;
            }
            else if (Properties.Settings.Default.reminderInterval == timeUnit * 60 * 4)
            {
                this.reminderInterval4小時.Checked = true;
            }
            else if (Properties.Settings.Default.reminderInterval == timeUnit * 60 * 6)
            {
                this.reminderInterval6小時.Checked = true;
            }
            else if (Properties.Settings.Default.reminderInterval == timeUnit * 60 * 8)
            {
                this.reminderInterval8小時.Checked = true;
            }
            else if (Properties.Settings.Default.reminderInterval == timeUnit * 60 * 12)
            {
                this.reminderInterval12小時.Checked = true;
            }
            else if (Properties.Settings.Default.reminderInterval == timeUnit * 60 * 24)
            {
                this.reminderInterval24小時.Checked = true;
            }
            else
            {
                Properties.Settings.Default.reminderInterval = timeUnit * 10;
                Properties.Settings.Default.Save();
                this.reminderInterval10分鐘.Checked = true;
            }
            #endregion

            #region 設置WebService地址
            m_DesktopMsgService.Url = m_Url + "/WebService/DesktopMsgService/Service.asmx";
            #endregion

        }
        #endregion

        #region Form1_Load
        private void Form1_Load(object sender, EventArgs e)
        {
            if (!string.IsNullOrWhiteSpace(Properties.Settings.Default.userName))
            {
                timerCheckReport.Interval = Properties.Settings.Default.reminderInterval;
                timerCheckReport.Start();
            }
        }
        #endregion

        #region 登錄服務器
        /// <summary>
        /// 登錄窗體
        /// </summary>
        private Login m_Login;
        /// <summary>
        /// 登錄窗體
        /// </summary>
        private void CreateLogin()
        {
            if (m_Login == null || m_Login.IsDisposed)
            {
                m_Login = new Login();
                m_Login.Show(this);
            }
            else
            {
                m_Login.Focus();
            }
        }
        /// <summary>
        /// 用戶信息窗體
        /// </summary>
        private LoginInfo m_LoginInfo;
        /// <summary>
        /// 用戶信息窗體
        /// </summary>
        private void CreateLoginInfo()
        {
            if (m_LoginInfo == null || m_LoginInfo.IsDisposed)
            {
                m_LoginInfo = new LoginInfo();
                m_LoginInfo.Show(this);
            }
            else
            {
                m_LoginInfo.Focus();
            }
        }
        private void 登錄ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            if (Properties.Settings.Default.userName == "")
            {
                CreateLogin();
            }
            else
            {
                CreateLoginInfo();
            }
        }
        #endregion

        #region 關閉程序
        private void 關閉ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            if (MessageBox.Show("退出后無法接收到技術報告提醒消息，確定要退出桌面提醒嗎？", "提示", MessageBoxButtons.OKCancel) == DialogResult.OK)
            {
                canExit = true;
                Application.Exit();
            }
        }
        #endregion

        #region GetMsgForm
        /// <summary>
        /// GetMsgForm
        /// </summary>
        private MsgForm GetMsgForm()
        {
            if (m_msgForm == null || m_msgForm.IsDisposed)
            {
                m_msgForm = new MsgForm();
            }
            return m_msgForm;
        }
        #endregion

        #region 提醒間隔
        //1分鐘提示一次
        private void 分鐘提示一次ToolStripMenuItem_Click_1(object sender, EventArgs e)
        {
            Properties.Settings.Default.reminderInterval = timeUnit * 1;
            UncheckReminder();
            this.reminderInterval1分鐘.Checked = true;
            Properties.Settings.Default.Save();
            timerCheckReport.Interval = Properties.Settings.Default.reminderInterval;
            timerCheckReport.Stop();
            timerCheckReport.Start();
        }
        //2分鐘提示一次
        private void 分鐘提示一次ToolStripMenuItem1_Click_1(object sender, EventArgs e)
        {
            Properties.Settings.Default.reminderInterval = timeUnit * 2;
            UncheckReminder();
            this.reminderInterval2分鐘.Checked = true;
            Properties.Settings.Default.Save();
            timerCheckReport.Interval = Properties.Settings.Default.reminderInterval;
            timerCheckReport.Stop();
            timerCheckReport.Start();
        }
        //5分鐘提示一次
        private void 分鐘提示一次ToolStripMenuItem3_Click(object sender, EventArgs e)
        {
            Properties.Settings.Default.reminderInterval = timeUnit * 5;
            UncheckReminder();
            this.reminderInterval5分鐘.Checked = true;
            Properties.Settings.Default.Save();
            timerCheckReport.Interval = Properties.Settings.Default.reminderInterval;
            timerCheckReport.Stop();
            timerCheckReport.Start();
        }

        //10分鐘提示一次
        private void 分鐘提示一次ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            Properties.Settings.Default.reminderInterval = timeUnit * 10;
            UncheckReminder();
            this.reminderInterval10分鐘.Checked = true;
            Properties.Settings.Default.Save();
            timerCheckReport.Interval = Properties.Settings.Default.reminderInterval;
            timerCheckReport.Stop();
            timerCheckReport.Start();
        }

        //20分鐘提示一次
        private void 分鐘提示一次ToolStripMenuItem1_Click(object sender, EventArgs e)
        {
            Properties.Settings.Default.reminderInterval = timeUnit * 20;
            UncheckReminder();
            this.reminderInterval20分鐘.Checked = true;
            Properties.Settings.Default.Save();
            timerCheckReport.Interval = Properties.Settings.Default.reminderInterval;
            timerCheckReport.Stop();
            timerCheckReport.Start();
        }

        //30分鐘提示一次
        private void 分鐘提示一次ToolStripMenuItem2_Click(object sender, EventArgs e)
        {
            Properties.Settings.Default.reminderInterval = timeUnit * 30;
            UncheckReminder();
            this.reminderInterval30分鐘.Checked = true;
            Properties.Settings.Default.Save();
            timerCheckReport.Interval = Properties.Settings.Default.reminderInterval;
            timerCheckReport.Stop();
            timerCheckReport.Start();
        }

        //1小時提示一次
        private void toolStripMenuItem2_Click(object sender, EventArgs e)
        {
            Properties.Settings.Default.reminderInterval = timeUnit * 60;
            UncheckReminder();
            this.reminderInterval1小時.Checked = true;
            Properties.Settings.Default.Save();
            timerCheckReport.Interval = Properties.Settings.Default.reminderInterval;
            timerCheckReport.Stop();
            timerCheckReport.Start();
        }

        //2小時提示一次
        private void 小時提示一次ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            Properties.Settings.Default.reminderInterval = timeUnit * 60 * 2;
            UncheckReminder();
            this.reminderInterval2小時.Checked = true;
            Properties.Settings.Default.Save();
            timerCheckReport.Interval = Properties.Settings.Default.reminderInterval;
            timerCheckReport.Stop();
            timerCheckReport.Start();
        }

        //4小時提示一次
        private void 小時提示一次ToolStripMenuItem1_Click(object sender, EventArgs e)
        {
            Properties.Settings.Default.reminderInterval = timeUnit * 60 * 4;
            UncheckReminder();
            this.reminderInterval4小時.Checked = true;
            Properties.Settings.Default.Save();
            timerCheckReport.Interval = Properties.Settings.Default.reminderInterval;
            timerCheckReport.Stop();
            timerCheckReport.Start();
        }

        //6小時提示一次
        private void 小時提示一次ToolStripMenuItem2_Click(object sender, EventArgs e)
        {
            Properties.Settings.Default.reminderInterval = timeUnit * 60 * 6;
            UncheckReminder();
            this.reminderInterval6小時.Checked = true;
            Properties.Settings.Default.Save();
            timerCheckReport.Interval = Properties.Settings.Default.reminderInterval;
            timerCheckReport.Stop();
            timerCheckReport.Start();
        }

        //8小時提示一次
        private void 小時提示一次ToolStripMenuItem3_Click(object sender, EventArgs e)
        {
            Properties.Settings.Default.reminderInterval = timeUnit * 60 * 8;
            UncheckReminder();
            this.reminderInterval8小時.Checked = true;
            Properties.Settings.Default.Save();
            timerCheckReport.Interval = Properties.Settings.Default.reminderInterval;
            timerCheckReport.Stop();
            timerCheckReport.Start();
        }

        //12小時提示一次
        private void 小時提示一次ToolStripMenuItem4_Click(object sender, EventArgs e)
        {
            Properties.Settings.Default.reminderInterval = timeUnit * 60 * 12;
            UncheckReminder();
            this.reminderInterval12小時.Checked = true;
            Properties.Settings.Default.Save();
            timerCheckReport.Interval = Properties.Settings.Default.reminderInterval;
            timerCheckReport.Stop();
            timerCheckReport.Start();
        }

        //24小時提示一次
        private void 小時提示一次ToolStripMenuItem5_Click(object sender, EventArgs e)
        {
            Properties.Settings.Default.reminderInterval = timeUnit * 60 * 24;
            UncheckReminder();
            this.reminderInterval24小時.Checked = true;
            Properties.Settings.Default.Save();
            timerCheckReport.Interval = Properties.Settings.Default.reminderInterval;
            timerCheckReport.Stop();
            timerCheckReport.Start();
        }

        /// <summary>
        /// 取消勾選
        /// </summary>
        private void UncheckReminder()
        {
            this.reminderInterval1分鐘.Checked = false;
            this.reminderInterval2分鐘.Checked = false;
            this.reminderInterval5分鐘.Checked = false;
            this.reminderInterval10分鐘.Checked = false;
            this.reminderInterval20分鐘.Checked = false;
            this.reminderInterval30分鐘.Checked = false;
            this.reminderInterval1小時.Checked = false;
            this.reminderInterval2小時.Checked = false;
            this.reminderInterval4小時.Checked = false;
            this.reminderInterval6小時.Checked = false;
            this.reminderInterval8小時.Checked = false;
            this.reminderInterval12小時.Checked = false;
            this.reminderInterval24小時.Checked = false;
        }
        #endregion

        #region timerCheckReport_Tick 消息提醒間隔定時器
        private void timerCheckReport_Tick(object sender, EventArgs e)
        {
            try
            {
                new Thread(new ThreadStart(delegate()
                {
                    try
                    {
                        if (!string.IsNullOrWhiteSpace(Properties.Settings.Default.userName)) //已登錄
                        {
                            CheckReportCount();
                            ShowReminder();
                        }
                    }
                    catch (Exception ex)
                    {
                    }
                })).Start();
            }
            catch (Exception ex)
            {
            }
        }
        #endregion

        #region 立即檢測
        private void 立即檢測ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            new Thread(new ThreadStart(delegate()
            {
                try
                {
                    if (!string.IsNullOrWhiteSpace(Properties.Settings.Default.userName)) //已登錄
                    {
                        CheckReportCount();
                        if (m_dsyCount + m_dsyFsCount + m_dshCount + m_dshFsCount + m_dpzCount + m_wtgCount > 0)
                        {
                            ShowReminder();
                            InvokeUtil.Invoke(this, new InvokeDelegate(delegate()
                            {
                                timerCheckReport.Stop();
                                timerCheckReport.Start();
                            }));
                        }
                        else
                        {
                            MessageBox.Show("沒有待辦工作！");
                        }
                    }
                    else
                    {
                        InvokeUtil.Invoke(this, new InvokeDelegate(delegate()
                        {
                            CreateLogin();
                        }));
                    }
                }
                catch (SoapException ex)
                {
                    MessageBox.Show("檢測失敗，請檢查是否斷網");
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                }
            })).Start();
        }
        #endregion

        #region CheckReportCount 檢測報告
        /// <summary>
        /// 檢測報告
        /// </summary>
        private void CheckReportCount()
        {
            if (!string.IsNullOrWhiteSpace(Properties.Settings.Default.userName)) //已登錄
            {
                m_dsyCount = m_DesktopMsgService.GetDsyReportCount(Properties.Settings.Default.deptCode);
                m_dsyFsCount = m_DesktopMsgService.GetDsyFsReportCount(Properties.Settings.Default.userName);
                m_dshCount = m_DesktopMsgService.GetDshReportCount(Properties.Settings.Default.userName);
                m_dshFsCount = m_DesktopMsgService.GetDshFsReportCount(Properties.Settings.Default.userName);
                m_dpzCount = m_DesktopMsgService.GetDpzReportCount(Properties.Settings.Default.userName);
                m_wtgCount = m_DesktopMsgService.GetWtgReportCount(Properties.Settings.Default.userName);
            }
        }
        #endregion

        #region ShowReminder 彈出提醒
        /// <summary>
        /// 彈出提醒
        /// </summary>
        private void ShowReminder()
        {
            if (m_dsyCount + m_dsyFsCount + m_dshCount + m_dshFsCount + m_dpzCount + m_wtgCount > 0)
            {
                InvokeUtil.Invoke(this, new InvokeDelegate(delegate()
                {
                    m_msgForm = GetMsgForm();
                    m_msgForm.Controls.Clear();

                    #region 加載link
                    //待審閱
                    if (m_dsyCount > 0)
                    {
                        string text = string.Format("您有 {0} 條待審閱報告", m_dsyCount);
                        CreateMsgLine("dsy", text, "/MultilevelAudit/CheckReport/Index");
                    }

                    //待審閱輔審
                    if (m_dsyFsCount > 0)
                    {
                        string text = string.Format("您有 {0} 條待審閱輔審報告", m_dsyFsCount);
                        CreateMsgLine("dsyfs", text, "/MultilevelAudit/AssistCheckReport/Index");
                    }

                    //待審核
                    if (m_dshCount > 0)
                    {
                        string text = string.Format("您有 {0} 條待審核報告", m_dshCount);
                        CreateMsgLine("dsh", text, "/MultilevelAudit/AuditingReport/Index");
                    }

                    //待審核輔審
                    if (m_dshFsCount > 0)
                    {
                        string text = string.Format("您有 {0} 條待審核輔審報告", m_dshFsCount);
                        CreateMsgLine("dshfs", text, "/MultilevelAudit/AssistAuditingReport/Index");
                    }

                    //待批準
                    if (m_dpzCount > 0)
                    {
                        string text = string.Format("您有 {0} 條待批準報告", m_dpzCount);
                        CreateMsgLine("dpz", text, "/MultilevelAudit/AuthorizeReport/Index");
                    }

                    //審批未通過
                    if (m_wtgCount > 0)
                    {
                        string text = string.Format("您有 {0} 條審批未通過報告", m_wtgCount);
                        CreateMsgLine("wtg", text, "/Tech/CompletedReportManage/Index?wtg=true");
                    }
                    #endregion

                    #region 顯示消息窗體
                    m_msgForm.Height = m_msgForm.Controls.Count * 30 + 60;
                    m_msgForm.Left = Screen.PrimaryScreen.WorkingArea.Width - m_msgForm.Width;
                    m_msgForm.Top = Screen.PrimaryScreen.Bounds.Height;
                    m_msgForm.TopLevel = true;
                    m_msgForm.TopMost = true;
                    m_msgForm.ShowInTaskbar = false;
                    m_msgForm.Show();

                    new Thread(new ThreadStart(delegate()
                    {
                        while (m_msgForm.Top > Screen.PrimaryScreen.WorkingArea.Height - m_msgForm.Height)
                        {
                            InvokeUtil.Invoke(m_msgForm, new InvokeDelegate(delegate()
                            {
                                m_msgForm.Top = m_msgForm.Top - 1;
                                m_msgForm.Refresh();
                            }));
                            Thread.Sleep(10);
                        }
                    })).Start();
                    #endregion
                }));
            }
        }

        /// <summary>
        /// 創建一條消息
        /// </summary>
        private void CreateMsgLine(string name, string text, string url)
        {
            LinkLabel link = CreateLink(name, text, 15 + m_msgForm.Controls.Count * 30);
            byte[] bArr = ASCIIEncoding.UTF8.GetBytes(m_Url + url);
            url = Convert.ToBase64String(bArr);
            link.Links.Clear();
            link.Links.Add(0, link.Text.Length,
                string.Format("{0}/Auth/Account/MessageReminderLoginIn?userName={1}&pwd={2}&url={3}"
                , m_Url, m_UserName, m_Pwd, url));
            link.LinkClicked += new LinkLabelLinkClickedEventHandler(delegate(object obj, LinkLabelLinkClickedEventArgs ea)
            {
                System.Diagnostics.Process.Start(ea.Link.LinkData.ToString());
            });
        }
        #endregion

        #region CreateLink
        /// <summary>
        /// 創建Link
        /// </summary>
        /// <param name="name">name屬性</param>
        /// <param name="topPos">位置</param>
        public LinkLabel CreateLink(string name, string text, int topPos)
        {
            Control[] ctrls = this.Controls.Find(name, false);
            if (ctrls.Length > 0)
            {
                return ctrls[0] as LinkLabel;
            }
            else
            {
                LinkLabel link = new LinkLabel();
                link.AutoSize = true;
                link.LinkColor = System.Drawing.Color.Red;
                link.Location = new System.Drawing.Point(12, topPos);
                link.Name = name;
                link.Size = new System.Drawing.Size(65, 12);
                link.TabIndex = 0;
                link.TabStop = true;
                link.Text = text;
                m_msgForm.Controls.Add(link);
                return link;
            }
        }
        #endregion

        #region 關于
        /// <summary>
        /// 關于窗體
        /// </summary>
        private AboutBox m_AboutBox;
        /// <summary>
        /// 關于窗體
        /// </summary>
        private void CreateAboutBox()
        {
            if (m_AboutBox == null || m_AboutBox.IsDisposed)
            {
                m_AboutBox = new AboutBox();
                m_AboutBox.Show(this);
            }
            else
            {
                m_AboutBox.Focus();
            }
        }
        private void 關于ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            CreateAboutBox();
        }
        #endregion

        #region 雙擊托盤圖標
        private void notifyIcon_MouseDoubleClick(object sender, MouseEventArgs e)
        {
            立即檢測ToolStripMenuItem_Click(sender, e);
        }
        #endregion

        #region 阻止關閉窗體
        private void Form1_FormClosing(object sender, FormClosingEventArgs e)
        {
            if (!canExit)
            {
                this.WindowState = FormWindowState.Minimized;
                this.Visible = false;
            }
            e.Cancel = !canExit;
        }
        #endregion

        #region 設置
        /// <summary>
        /// 設置窗體
        /// </summary>
        private SettingsForm m_SettingsForm;
        /// <summary>
        /// 設置窗體
        /// </summary>
        private void CreateSettingsForm()
        {
            if (m_SettingsForm == null || m_SettingsForm.IsDisposed)
            {
                m_SettingsForm = new SettingsForm();
                m_SettingsForm.Show(this);
            }
            else
            {
                m_SettingsForm.Focus();
            }
        }

        private void 設置ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            CreateSettingsForm();
        }
        #endregion

    }
}

View Code

代碼下載：點擊下載源代碼

截圖：

WebService代碼：

using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Web;
using System.Web.Services;
using DAL;
using DBHelper;
using Models;

namespace TechReport.Web.WebService.DesktopMsg
{
    /// <summary>
    /// 桌面消息提醒WebService
    /// </summary>
    [WebService(Namespace = "http://tempuri.org/")]
    [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
    [System.ComponentModel.ToolboxItem(false)]
    // 若要允許使用 ASP.NET AJAX 從腳本中調用此 Web 服務，請取消注釋以下行。 
    // [System.Web.Script.Services.ScriptService]
    public class Service : System.Web.Services.WebService
    {
        #region 變量
        private OracleHelper dbHelper = new OracleHelper();
        #endregion

        #region HelloWorld
        [WebMethod]
        public string HelloWorld()
        {
            return "Hello World";
        }
        #endregion

        #region 獲取待審閱報告
        /// <summary>
        /// 獲取待審閱報告
        /// </summary>
        [WebMethod]
        public int GetDsyReportCount(string deptCode)
        {
            string sql = string.Format(@"
                select count(1)
                from REPORT,REPORTSTATE,sys_user 
                where report.reportstateid=reportstate.reportstateid 
                and report.empcode=sys_user.empcode
                and REPORT.REPORTSTATEID in({1}) 
                and report.DEPTCODE='{0}'"
                , deptCode, (int)Enums.ReportState.待審閱報告);

            return Convert.ToInt32(dbHelper.GetSingle(sql));
        }
        #endregion

        #region 獲取待審閱輔審報告
        /// <summary>
        /// 獲取待審閱輔審報告
        /// </summary>
        [WebMethod]
        public int GetDsyFsReportCount(string userName)
        {
            string sql = string.Format(@"
                select count(1)
                from report,reportaudit,sys_user 
                where report.reportcode=reportaudit.reportcode 
                and report.empcode=sys_user.empcode 
                and reportaudit.isfinished=0 
                and reportaudit.audittype={1} 
                and reportaudit.auditusername='{0}'"
                , userName, (int)Enums.AuditType.審閱輔審);

            return Convert.ToInt32(dbHelper.GetSingle(sql));
        }
        #endregion

        #region 獲取待審核報告
        /// <summary>
        /// 獲取待審核報告
        /// </summary>
        [WebMethod]
        public int GetDshReportCount(string userName)
        {
            string sql = string.Format(@"
                select count(1)
                from report,reportaudit,sys_user,reportstate 
                where report.reportcode=reportaudit.reportcode 
                and report.empcode=sys_user.empcode 
                and reportaudit.isfinished=0 
                and report.reportstateid=reportstate.reportstateid 
                and reportaudit.audittype={2} 
                and reportaudit.auditusername='{0}' 
                and report.reportstateid in({1}) 
                and report.reportTypeId in(1,2)"
                , userName, (int)Enums.ReportState.待審核報告, (int)Enums.AuditType.審核);

            return Convert.ToInt32(dbHelper.GetSingle(sql));
        }
        #endregion

        #region 獲取待審核輔審報告
        /// <summary>
        /// 獲取待審核輔審報告
        /// </summary>
        [WebMethod]
        public int GetDshFsReportCount(string userName)
        {
            string sql = string.Format(@"
                select count(1)
                from report,reportaudit,sys_user 
                where report.reportcode=reportaudit.reportcode 
                and report.empcode=sys_user.empcode 
                and reportaudit.isfinished=0 
                and reportaudit.audittype={1} 
                and reportaudit.auditusername='{0}'"
                , userName, (int)Enums.AuditType.審核輔審);

            return Convert.ToInt32(dbHelper.GetSingle(sql));
        }
        #endregion

        #region 獲取待批準報告
        /// <summary>
        /// 獲取待批準報告
        /// </summary>
        [WebMethod]
        public int GetDpzReportCount(string userName)
        {
            string sql = string.Format(@"
                select count(1)
                from report,reportaudit,sys_user 
                where report.reportcode=reportaudit.reportcode 
                and report.empcode=sys_user.empcode 
                and reportaudit.isfinished=0 
                and reportaudit.audittype={2} 
                and reportaudit.auditusername='{0}' 
                and report.reportstateid={1} 
                and report.reportTypeId in (1,2)"
                , userName, (int)Enums.ReportState.待批準報告, (int)Enums.AuditType.批準);

            return Convert.ToInt32(dbHelper.GetSingle(sql));
        }
        #endregion

        #region 獲取未通過報告
        /// <summary>
        /// 獲取未通過報告
        /// </summary>
        [WebMethod]
        public int GetWtgReportCount(string userName)
        {
            string sql = string.Format(@"
                select count(1)
                from REPORT,sys_user 
                where report.empcode=sys_user.empcode
                and sys_user.username='{3}'
                and REPORT.REPORTSTATEID in({0},{1},{2})"
                , (int)Enums.ReportState.審閱未通過報告, (int)Enums.ReportState.審核未通過報告
                , (int)Enums.ReportState.批準未通過報告, userName);

            return Convert.ToInt32(dbHelper.GetSingle(sql));
        }
        #endregion

    }
}

View Code

與用戶登錄相關的代碼：

#region 消息提醒器登錄
/// <summary>
/// 消息提醒器登錄
/// </summary>
/// <param name="userName">用戶名</param>
/// <param name="pwd">密碼(加密狀態)</param>
[AuthIgnore]
public ActionResult MsgReminderLoginIn(string userName, string pwd)
{
    SYS_USER empDetail = m_UserDal.Get(userName);
    if (empDetail != null && empDetail.PASSWORD == pwd)
    {
        Session["_sysAuth"] = userName;
        return Content("OK|" + empDetail.EMPNAME + "|" + empDetail.DEPTCODE);
    }
    return Content("登錄失敗！");
}
/// <summary>
/// 消息提醒器登錄
/// </summary>
/// <param name="userName">用戶名</param>
/// <param name="pwd">密碼(加密狀態)</param>
/// <param name="url">跳轉url</param>
[AuthIgnore]
public ActionResult MessageReminderLoginIn(string userName, string pwd, string url)
{
    SYS_USER empDetail = m_UserDal.Get(userName);
    if (empDetail != null && empDetail.PASSWORD == pwd)
    {
        Session["_sysAuth"] = userName;
        return new RedirectResult(ASCIIEncoding.UTF8.GetString(Convert.FromBase64String(url)));
    }
    return Content("登錄失敗，沒有權限！");
}