ucwriteweekly.ascx.cs

简单项目管理系统源码 该源码为某公司的项目管理系统Demo版

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 projmanager;
using System.Data.Common;

/// <summary>
/// 写个人周报
/// </summary>
public partial class userControls_ucWriteSchedule : System.Web.UI.UserControl
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            int week = (int)DateTime.Now.DayOfWeek;
            if (week != 1 && week != 2 && week != 4 && week != 5)
            {
                string temp = " 星期" + ((int)DateTime.Now.DayOfWeek).ToString() + ",不在周报提交期。";
                this.lbDate.Text = DateTime.Now.ToShortDateString() + temp;
                this.btnSubmit.Enabled = false;
                this.rblSetWeek.Enabled = false;
                return;
            }

            string departmentid = Session["DepartmentID"].ToString();
            string sql = "select projectname,projectid from project where departmentid=" + departmentid +
                         " and isactive=1";
            DataTable dt = DataAccess.ExecuteDataTable(sql);
            
            Utilities.BindingDropDownList(ddlActiveProjectName, dt, "projectname", "projectid");
            if (ddlActiveProjectName.Items.Count == 0)
            {
                this.lbMsg.Text = "没有可选活动项目，无法提交周报";
                
                return;
            }
            this.lbDate.Text = DateTime.Now.ToShortDateString() + " 星期" + ((int)DateTime.Now.DayOfWeek).ToString();
        }
    }
    protected void btnSubmit_Click(object sender, EventArgs e)
    {
        #region 检查能否提交本周或下周周报
        
        string projectid = ddlActiveProjectName.SelectedValue;
        if (projectid == "")
        {
            return;
        }
        int week = (int)DateTime.Now.DayOfWeek;
        string weekflag = this.rblSetWeek.SelectedValue;//-1上周，1本周
        string weekname = "本周";
        //选择填写上周
        if (weekflag == "-1")
        {
            weekname = "上周";
            //不是周一和周二
            if (week != 1 && week != 2)
            {
                this.lbMsg.Text = "今天是星期" + week.ToString() + ",不能提交上周周报";
                return;
            }
        }

        //选择填写本周
        if (weekflag == "1")
        {

            //不是周四和周五
            if (week != 5 && week != 4)
            {
                this.lbMsg.Text = "今天是星期" + week.ToString() + ",不能提交本周周报";
                return;
            }
        }
        #endregion


        string submitdate = DateTime.Now.ToString();
        string employeeid = Session["LoginEmployeeID"].ToString();
        string costtime = this.tbCostTime.Text;
        string workdetail = this.tbWeeklyWork.Text.Trim();
        string nextweekplan = this.tbNextWeekWorkPlan.Text.Trim();
        string isdelayed = "0";

        #region 检查是否已提交过相同项目中的周报

        DateTime priorweek1 ;
        DateTime priorweek2 ;
        DateTime p1 = DateTime.Now;
        DateTime p2 = DateTime.Now;
        //今天是周一，则看前七天和前六天有没有提交过
        if (week == 1)
        {
            priorweek1 = DateTime.Now.AddDays(-7);
            priorweek2 = DateTime.Now.AddDays(-5);
            p1 = new DateTime(priorweek1.Year, priorweek1.Month, priorweek1.Day);
            p2 = new DateTime(priorweek2.Year, priorweek2.Month, priorweek2.Day);
            isdelayed = "1";
            submitdate = DateTime.Now.AddDays(-7).ToString();
        }
        else if (week == 2)
        {
            priorweek1 = DateTime.Now.AddDays(-8);
            priorweek2 = DateTime.Now.AddDays(-6);
            p1 = new DateTime(priorweek1.Year, priorweek1.Month, priorweek1.Day);
            p2 = new DateTime(priorweek2.Year, priorweek2.Month, priorweek2.Day);
            isdelayed = "1";
            submitdate = DateTime.Now.AddDays(-8).ToString();
        }

        //今天是周四
        else if (week == 4)
        {
            priorweek1 = DateTime.Now;
            priorweek2 = DateTime.Now.AddDays(1);
            p1 = new DateTime(priorweek1.Year, priorweek1.Month, priorweek1.Day);
            p2 = new DateTime(priorweek2.Year, priorweek2.Month, priorweek2.Day);
            
        }
        else if (week == 5)
        {
            priorweek1 = DateTime.Now.AddDays(-1);
            priorweek2 = DateTime.Now.AddDays(1);
            p1 = new DateTime(priorweek1.Year, priorweek1.Month, priorweek1.Day);
            p2 = new DateTime(priorweek2.Year, priorweek2.Month, priorweek2.Day);
            
        }

        
        string sql1 = "select weeklyid from weekly where projectid=" + projectid +
                      " and (submitdate between'" + p1.ToString() + "' and '" + p2.ToString() +
                      "')" + " and employeeid=" + Session["LoginEmployeeID"].ToString();
        #endregion

        if (DataAccess.ExecuteScalar(sql1) != null)
        {
            this.lbMsg.Text = "你所选择项目的周报在" + weekname + "已提交过,不能重复提交";
            return;
        }

        string sql = "insert into weekly(employeeid,submitdate,costtime,costtime_effect,workdetail,nextweekworkplan,projectid,isdelayed) " +
                    " values(" + employeeid +
                     ",'" + submitdate + "'," + costtime + "," + costtime + ",'" + workdetail + "','" +
                     nextweekplan + "'," +  projectid + "," + isdelayed + ")";
        if (DataAccess.ExecuteNonQuery(sql) == 1)
        {
            this.lbMsg.Text = "周报提交成功";
        }
        else
        {
            this.lbMsg.Text = "周报提交失败";
        }
    }
}