main.aspx.cs

贸易有限公司项目管理系统(C#.NET2003),供学习参考！

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class Main : System.Web.UI.Page
{
    /// <summary>
    /// 第一次加载时的设置
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["Name"] == null)
        {
            JS.Alert("您还未登陆或登陆超时！");
            Response.Redirect("Default.aspx");
        }
        if (!IsPostBack)
        {
            inial();
            lbUser.Text = Session["Name"].ToString();
            DateTime now = DateTime.Now;
            DayOfWeek week = now.DayOfWeek;
            string weektime = "";
            switch (week)
            {
                case System.DayOfWeek.Friday:
                    lbTime.Text = "星期五"; weektime = "星期五";
                    break;
                case System.DayOfWeek.Monday:
                    lbTime.Text = "星期一"; weektime = "星期一";
                    break;
                case System.DayOfWeek.Saturday:
                    lbTime.Text = "星期六"; weektime = "星期六";
                    break;
                case System.DayOfWeek.Sunday:
                    lbTime.Text = "星期日"; weektime = "星期日";
                    break;
                case System.DayOfWeek.Thursday:
                    lbTime.Text = "星期四"; weektime = "星期四";
                    break;
                case System.DayOfWeek.Tuesday:
                    lbTime.Text = "星期二"; weektime = "星期二";
                    break;
                case System.DayOfWeek.Wednesday:
                    lbTime.Text = "星期三"; weektime = "星期三";
                    break;
            }
            string name = Session["Name"].ToString();
            string time = DateTime.Now.ToShortDateString();
            int hour = DateTime.Now.Hour;
            int minute = DateTime.Now.Minute;
            int second = DateTime.Now.Second;
            string status = "";
            if (hour > 8)
            {
                status = "上班迟到";
            }
            else
            {
                status = "正常上班";
            }
            string detailtime = hour + "时" + minute + "分" + second + "秒";
            try
            {
                if (!Evaluate.CheckDiary(name, time))
                {
                    Evaluate.InsertEvaluateInfo(name, weektime, DateTime.Now.ToShortDateString(), status, detailtime);
                }

            }
            catch (Exception e3)
            {
                Response.Write(e3);
            }
        }
    }
    /// <summary>
    /// 初始化页面设置
    /// </summary>
    protected void inial()
    {
        try
        {
            string name=Session["Name"].ToString();
            SqlConnection con = DB.createCon();
            con.Open();
            SqlCommand cmd = new SqlCommand("select count(*) from Message where To_User='" + name + "'and IfRead='还未阅读'", con);
            int NotRead = Convert.ToInt32(cmd.ExecuteScalar());
            lbMessage.Text = NotRead.ToString() + "封";

            SqlCommand com = new SqlCommand("select * from WorkDiary where Employee='" + name + "'and Pub_Time='" + DateTime.Now.ToShortDateString() + "'", con);
            int count = Convert.ToInt32(com.ExecuteScalar());
            lbTask.Text= "您今天还没些工作日志！";
            

            SqlCommand resource = new SqlCommand("select count(*) from Resource where Publisher='" + name + "'", con);
            int number = Convert.ToInt32(resource.ExecuteScalar());
            lbSource.Text = number.ToString() + "个";

            SqlCommand ifWrite = new SqlCommand("select * from Diary where Employee='" + name + "'and Diary_Date='" + DateTime.Now.ToShortDateString() + "'", con);
            SqlDataReader dr = ifWrite.ExecuteReader();
            if (!dr.Read())
            {
                lbDiary.Text = "您今天还没写日记！";
            }
            else
            {
                lbDiary.Text = "";
            }

        }
        catch (Exception e3)
        {
            Response.Write(e3);
        }
    }
    protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
    {
        
        JS.OpenWebForm("Help.aspx");
    }
 
    
}