setwork.cs

oa办公系统

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;
using System.Collections;

/// <summary>
/// SetWork 的摘要说明
/// </summary>
public class SetWork
{
	public SetWork()
	{
		//
		// TODO: 在此处添加构造函数逻辑
		//
	}

    /// <summary>
    /// 设置上下班的时间及有效期
    /// </summary>
    /// <param name="SetWork">数组，获取设置上下班的时间及有效期</param>
    public void swork(ArrayList SetWork)
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["office"].ConnectionString);
        con.Open();
        SqlCommand cmd = new SqlCommand("setwork", con);
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.Add("@onStateTime", SqlDbType.VarChar,20).Value = SetWork[0];
        cmd.Parameters.Add("@onEndTime", SqlDbType.VarChar, 20).Value = SetWork[1];
        cmd.Parameters.Add("@ondutytime", SqlDbType.VarChar, 20).Value = SetWork[2];
        cmd.Parameters.Add("@offdutytime", SqlDbType.VarChar, 20).Value = SetWork[3];
        try
        {
            cmd.ExecuteNonQuery();
        }
        catch (Exception err)
        {
            throw new System.Exception(err.Message);
        }
        finally
        {
            con.Close();
        }
    }

    //读取设置的上班时间
    public SqlDataReader sel_worktime()
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["office"].ConnectionString);
        con.Open();
        SqlCommand cmd = new SqlCommand("select_worktime", con);
        cmd.CommandType = CommandType.StoredProcedure;
        try
        {
            SqlDataReader readtime = cmd.ExecuteReader();
            return readtime;
        }
        catch (Exception err)
        {
            throw new System.Exception(err.Message);
        }
    }

    //
    /// <summary>
    /// 上班考勤
    /// </summary>
    /// <param name="arrwork">获取员工上班时间及状态等</param>
    public void onwork(ArrayList arrwork)
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["office"].ConnectionString);
        con.Open();
        SqlCommand cmd = new SqlCommand("onwork", con);
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.Add("@s_id", SqlDbType.Int).Value = arrwork[0];
        cmd.Parameters.Add("@ondutyStatus",SqlDbType.Int).Value=arrwork[1];
        cmd.Parameters.Add("@ondudydate",SqlDbType.VarChar,20).Value=arrwork[2];
        cmd.Parameters.Add("@workDate", SqlDbType.DateTime).Value = arrwork[3];
        cmd.Parameters.Add("@Later_message", SqlDbType.Text).Value = arrwork[4];
        try
        {
            cmd.ExecuteNonQuery();
        }
        catch (Exception err)
        {
            throw new System.Exception(err.Message);
        }
    }

    //判断是否已经长班
    public int sel_YesOrNoWork(int id,string time)
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["office"].ConnectionString);
        con.Open();
        SqlCommand cmd = new SqlCommand("Checkagainwork", con);
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.Add("@s_id", SqlDbType.Int).Value = id;
        cmd.Parameters.Add("@workDate", SqlDbType.DateTime).Value = time;
        try
        {
            int num =Convert.ToInt32(cmd.ExecuteScalar());
            return num;
        }
        catch (Exception err)
        {
            throw new System.Exception(err.Message);
        }
    }



    /// <summary>
    /// 下班考勤
    /// </summary>
    /// <param name="arrlist">获取下班的时间及状态等</param>
    public void offwork(ArrayList arrlist)
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["office"].ConnectionString);
        con.Open();
        SqlCommand cmd = new SqlCommand("offwork", con);
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.Add("@s_id", SqlDbType.Int).Value = arrlist[0];
        cmd.Parameters.Add("@offdutyStatus", SqlDbType.Int).Value = arrlist[1];
        cmd.Parameters.Add("@offdudydate", SqlDbType.VarChar,20).Value = arrlist[2];
        cmd.Parameters.Add("@workDate", SqlDbType.DateTime).Value =arrlist[3] ;
        cmd.Parameters.Add("@leaver_message", SqlDbType.Text).Value = arrlist[4];
        try
        {
            cmd.ExecuteNonQuery();
        }
        catch (Exception err)
        {
            throw new System.Exception(err.Message);
        }
    }

    public void offwork_insert(ArrayList arrlist)
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["office"].ConnectionString);
        con.Open();
        SqlCommand cmd = new SqlCommand("offwork_insert", con);
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.Add("@s_id", SqlDbType.Int).Value = arrlist[0];
        cmd.Parameters.Add("@offdutyStatus", SqlDbType.Int).Value = arrlist[1];
        cmd.Parameters.Add("@offdudydate", SqlDbType.VarChar, 20).Value = arrlist[2];
        cmd.Parameters.Add("@workDate", SqlDbType.DateTime).Value = arrlist[3];
        cmd.Parameters.Add("@leaver_message", SqlDbType.Text).Value = arrlist[4];
        try
        {
            cmd.ExecuteNonQuery();
        }
        catch (Exception err)
        {
            throw new System.Exception(err.Message);
        }
    }

    //判断是否已经下班
    public SqlDataReader checkoffwork(int id, string time)
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["office"].ConnectionString);
        con.Open();
        SqlCommand cmd = new SqlCommand("checkoffwork", con);
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.Add("@s_id", SqlDbType.Int).Value = id;
        cmd.Parameters.Add("@workDate", SqlDbType.DateTime).Value = time; 
        
        try
        {
            SqlDataReader dr = cmd.ExecuteReader();
            return dr;
            //while(dr.Read())
            //{
            //    string offstatus=dr["offdutyStatus"].ToString();
            //    string offtime=dr["offdudydate"].ToString();
            //    int num=1;
            //    if ( offstatus!= "" || offtime != "")
            //    {   
            //        return num=1;
            //    }
            //    else
            //    {
                    
            //        return  num = 1;
            //    }
            //}
        }
        catch (Exception err)
        {
            throw new System.Exception(err.Message);
        }
    }

}