workdiary.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>
//该源码下载自www.51aspx.com(５１ａｓｐｘ．ｃｏｍ)

public class WorkDiary
{
    public static SqlConnection MyConnection;
    public static SqlCommand MyCommand;
	public WorkDiary()
	{
		//
		// TODO: 在此处添加构造函数逻辑
		//
	}
    /// <summary>
    /// 判断当天工作日志是否已经写入
    /// </summary>
    /// <param name="s1"></param>
    /// <param name="s2"></param>
    /// <returns></returns>
    public static bool CheckWorkDiary(string s1, string s2)
    {
        MyConnection = DB.createCon();
        MyCommand = new SqlCommand("Get_WorkDiary_Info", MyConnection);
        MyCommand.CommandType = CommandType.StoredProcedure;

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

        MyConnection.Open();
        SqlDataReader dr = MyCommand.ExecuteReader(CommandBehavior.CloseConnection);
        if (dr.Read())
        {
            return true;
        }
        else
        {
            return false;
        }
    }
    /// <summary>
    /// 执行写入工作日志的存储过程
    /// </summary>
    /// <param name="s1"></param>
    /// <param name="s2"></param>
    /// <param name="s3"></param>
    /// <param name="s4"></param>
    /// <param name="s5"></param>
    /// <param name="s6"></param>
    /// <returns></returns>
    public static bool InsertWorkDiaryInfo(string s1, string s2, string s3, string s4, string s5, string s6)
    {
        MyConnection = DB.createCon();
        MyCommand = new SqlCommand("Insert_WorkDiary_Info", MyConnection);
        MyCommand.CommandType = CommandType.StoredProcedure;

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

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

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

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

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

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

        MyConnection.Open();
        int result;
        result = MyCommand.ExecuteNonQuery();
        MyConnection.Close();
        if (result > 0)
        {
            return true;
        }
        else
        {
            return false;
        }
    }
    /// <summary>
    /// 执行领导评价的存储过程
    /// </summary>
    /// <param name="s1"></param>
    /// <param name="s2"></param>
    /// <param name="s3"></param>
    /// <param name="s4"></param>
    /// <param name="s5"></param>
    /// <param name="s6"></param>
    /// <returns></returns>
    public static bool InsertAdminEvaInfo(int i, string s1,string  s2 ,DateTime time)
    {
        MyConnection = DB.createCon();
        MyCommand = new SqlCommand("Insert_AdminEva_Info", MyConnection);
        MyCommand.CommandType = CommandType.StoredProcedure;

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

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

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

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

        MyConnection.Open();
        int result;
        result = MyCommand.ExecuteNonQuery();
        MyConnection.Close();
        if (result > 0)
        {
            return true;
        }
        else
        {
            return false;
        }
    }
    public static bool CheckAdminEvaInfo(int i)
    {
        MyConnection = DB.createCon();
        MyCommand = new SqlCommand("Get_AdminEva_Info", MyConnection);
        MyCommand.CommandType = CommandType.StoredProcedure;

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

        MyConnection.Open();
        SqlDataReader dr = MyCommand.ExecuteReader(CommandBehavior.CloseConnection);
        string Evaluate = "";
        if (dr.Read())
        {
            Evaluate = dr["Evaluate"].ToString();
        }
        if (Evaluate.Length>2)
        {
            return true;
        }
        else
        {
            return false;
        }
        
            
    }
}