evaluate.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）
/// 考勤实体类//5_1_a_s_p_x.c_o_m

/// </summary>
public class Evaluate
{
    public static SqlConnection MyConnection;
    public static SqlCommand MyCommand;
	public Evaluate()
	{
		//
		// TODO: 在此处添加构造函数逻辑
		//
	}
    /// <summary>
    /// 判断当天考勤是否已经记录
    /// </summary>
    /// <param name="s1"></param>
    /// <param name="s2"></param>
    /// <returns></returns>
    public static bool CheckDiary(string s1, string s2)
    {
        MyConnection = DB.createCon();
        MyCommand = new SqlCommand("Get_Evaluate_Info", MyConnection);
        MyCommand.CommandType = CommandType.StoredProcedure;

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

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

        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="time"></param>
    /// <param name="s3"></param>
    /// <param name="s4"></param>
    public static void  InsertEvaluateInfo(string s1, string s2,string  time, string s3, string s4)
    {
        MyConnection = DB.createCon();
        MyCommand = new SqlCommand("Insert_Evaluate_Info", MyConnection);
        MyCommand.CommandType = CommandType.StoredProcedure;

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

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

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

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

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


        MyConnection.Open();
        
        MyCommand.ExecuteNonQuery();
        MyConnection.Close();
       
    }
}