workplan.cs

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

using System;
using System.Data;
using System.Configuration;
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;
/// <summary>
/// 黄建华（2007.9）
/// 工作计划实体类
/// </summary>
/// <summary>
/// WorkPlan 的摘要说明
/// </summary>
public class WorkPlan
{
    public static SqlConnection MyConnection;
    public static SqlCommand MyCommand;
	public WorkPlan()
	{
		//
		// TODO: 在此处添加构造函数逻辑
		//
	}
    /// <summary>
    /// 写入工作计划方法
    /// </summary>
    /// <param name="s1"></param>
    /// <param name="s2"></param>
    /// <param name="time"></param>
    /// <returns></returns>
    public static bool InsertWorkPlanInfo(string s1, string s2, DateTime time)
    {
        MyConnection = DB.createCon();
        MyCommand = new SqlCommand("Insert_WorkPlan_Info", MyConnection);
        MyCommand.CommandType = CommandType.StoredProcedure;

        SqlParameter Emp_Name = new SqlParameter("@Emp_Name", SqlDbType.VarChar);
        Emp_Name.Value = s1;
        MyCommand.Parameters.Add(Emp_Name);

        SqlParameter Task_Content = new SqlParameter("@Task_Content", SqlDbType.VarChar);
        Task_Content.Value = s2;
        MyCommand.Parameters.Add(Task_Content);

        SqlParameter Start_Time = new SqlParameter("@Start_Time", SqlDbType.DateTime);
        Start_Time.Value = time;
        MyCommand.Parameters.Add(Start_Time);

        
        MyConnection.Open();
        int result;
        result = MyCommand.ExecuteNonQuery();
        MyConnection.Close();
        if (result > 0)
        {
            return true;
        }
        else
        {
            return false;
        }
    }
    /// <summary>
    /// 写入完成工作任务的方法
    /// </summary>
    /// <param name="i"></param>
    /// <param name="time"></param>
    /// <param name="s1"></param>
    /// <param name="s2"></param>
    /// <param name="s3"></param>
    /// <returns></returns>
    public static bool UpdateWorkPlanInfo(int i,DateTime time,string s1, string s2,string  s3)
    {
        MyConnection = DB.createCon();
        MyCommand = new SqlCommand("Update_WorkPlan_Info", MyConnection);
        MyCommand.CommandType = CommandType.StoredProcedure;

        SqlParameter ID = new SqlParameter("@ID", SqlDbType.Int);
        ID.Value = i;
        MyCommand.Parameters.Add(ID);

        SqlParameter Finish_Time = new SqlParameter("@Finish_Time", SqlDbType.DateTime);
        Finish_Time.Value = time;
        MyCommand.Parameters.Add(Finish_Time);

        SqlParameter Status = new SqlParameter("@Status", SqlDbType.VarChar);
        Status.Value = s1;
        MyCommand.Parameters.Add(Status);

        SqlParameter Document = new SqlParameter("@Document", SqlDbType.VarChar);
        Document.Value = s2;
        MyCommand.Parameters.Add(Document);


        SqlParameter Gain = new SqlParameter("@Gain", SqlDbType.VarChar);
        Gain.Value = s3;
        MyCommand.Parameters.Add(Gain);

        MyConnection.Open();
        int result;
        result = MyCommand.ExecuteNonQuery();
        MyConnection.Close();
        if (result > 0)
        {
            return true;
        }
        else
        {
            return false;
        }
    }
    /// <summary>
    /// 对工作任务评价的方法
    /// </summary>
    /// <param name="i"></param>
    /// <param name="s1"></param>
    /// <returns></returns>
    public static bool EvaWorkPlanInfo(int i, string s1)
    {
        MyConnection = DB.createCon();
        MyCommand = new SqlCommand("Eva_WorkPlan_Info", MyConnection);
        MyCommand.CommandType = CommandType.StoredProcedure;

        SqlParameter ID = new SqlParameter("@ID", SqlDbType.Int);
        ID.Value = i;
        MyCommand.Parameters.Add(ID);

        SqlParameter Evaluate = new SqlParameter("@Evaluate", SqlDbType.VarChar);
        Evaluate.Value = s1;
        MyCommand.Parameters.Add(Evaluate);

        


        MyConnection.Open();
        int result;
        result = MyCommand.ExecuteNonQuery();
        MyConnection.Close();
        if (result > 0)
        {
            return true;
        }
        else
        {
            return false;
        }
    }
}