.net人事考勤管理系统新版源码

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using framework;
using System.Data.SqlClient;
using System.Data;

namespace BLL
{
    public class BLLAttLog
    {
        public static ReturnValue AddAttLog（string UserID string VerifyMode string InOutMode string AttDate string WorkCode string Reserved）
        {
            int iReturnValue = -10;
            string strErrInfo = “No Return Info!“;
            SqlCommand cmd = new SqlCommand（）;
            try
            {
                string cmdText = “AddAttLog“;
                cmd.Connection = new SqlConnection（AppSettings.GetConString（））;
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.CommandText = cmdText;
                cmd.Parameters.Add（new SqlParameter（“@RETURN_VALUE“ SqlDbType.Int））;
                cmd.Parameters[“@RETURN_VALUE“].Direction = ParameterDirection.ReturnValue;
                cmd.Parameters.Add（new SqlParameter（“@UserID“ UserID））;
                cmd.Parameters.Add（new SqlParameter（“@VerifyMode“ VerifyMode））;
                cmd.Parameters.Add（new SqlParameter（“@InOutMode“ InOutMode））;
                cmd.Parameters.Add（new SqlParameter（“@AttDate“ AttDate））;
                cmd.Parameters.Add（new SqlParameter（“@WorkCode“ WorkCode））;
                cmd.Parameters.Add（new SqlParameter（“@Reserved“ Reserved））;
                cmd.Parameters.Add（new SqlParameter（“@strErrInfo“ SqlDbType.NVarChar 512））;
                cmd.Parameters[“@strErrInfo“].Direction = ParameterDirection.Output;
                cmd.Connection.Open（）;
                cmd.ExecuteNonQuery（）;
                iReturnValue = （int）cmd.Parameters[“@RETURN_VALUE“].Value;
                strErrInfo = （string）cmd.Parameters[“@strErrInfo“].Value;
            }
            catch （Exception ex）
            {
                iReturnValue = -11;
                strErrInfo = “未设置姓名“;
                LogManager.WriteTextLog（“SQLServerDAL“ ““ “AddAttLog“ ex.Message + ex.StackTrace）;
            }
            finally
            {
                cmd.Connection.Close（）;
                cmd.Dispose（）;
            }

            return new ReturnValue（iReturnValue strErrInfo）;
        }

        public static ReturnValue AddDownUserInfo（string UserID string Name string AttNumber string Privilege string MverifyPass string Enabled）
        {
            int iReturnValue = -10;
            string strErrInfo = “No Return Info!“;
            SqlCommand cmd = new SqlCommand（）;
            try
            {
                if （Name.Contains（““））
                {
                    Name = Name.Substring（0 Name.IndexOf（““））;
                }
                string cmdText = “AddDownUserInfo“;
                cmd.Connection = new SqlConnection（AppSettings.GetConString（））;
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.CommandT

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----

     文件      52224  2011-03-18 14:59  BLLinDebugBLL.dll

     文件      83456  2011-03-18 14:59  BLLinDebugBLL.pdb

     文件      10240  2011-03-18 14:59  BLLinDebugDataAccess.dll

     文件      24064  2011-03-18 14:59  BLLinDebugDataAccess.pdb

     文件     946176  2007-08-29 19:37  BLLinDebugExcel.dll

     文件      23040  2011-03-18 14:59  BLLinDebugframework.dll

     文件      65024  2011-03-18 14:59  BLLinDebugframework.pdb

     文件      64088  2007-10-10 09:48  BLLinDebugMicrosoft.Vbe.Interop.dll

     文件      25600  2011-03-18 14:59  BLLinDebugModel.dll

     文件     108032  2011-03-18 14:59  BLLinDebugModel.pdb

     文件     223800  2007-10-10 09:48  BLLinDebugoffice.dll

     文件      49664  2011-01-11 22:18  BLLinReleaseBLL.dll

     文件      85504  2011-01-11 22:18  BLLinReleaseBLL.pdb

     文件       9216  2011-01-09 23:29  BLLinReleaseDataAccess.dll

     文件      22016  2011-01-09 23:29  BLLinReleaseDataAccess.pdb

     文件     946176  2007-08-29 19:37  BLLinReleaseExcel.dll

     文件      21504  2011-01-09 23:27  BLLinReleaseframework.dll

     文件      58880  2011-01-09 23:27  BLLinReleaseframework.pdb

     文件      64088  2007-10-10 09:48  BLLinReleaseMicrosoft.Vbe.Interop.dll

     文件      23040  2011-01-09 23:29  BLLinReleaseModel.dll

     文件     105984  2011-01-09 23:29  BLLinReleaseModel.pdb

     文件     223800  2007-10-10 09:48  BLLinReleaseoffice.dll

     文件       3648  2010-12-18 17:15  BLLBLL.csproj

     文件      26433  2011-01-12 22:02  BLLBLLAttLog.cs

     文件       1254  2010-10-23 21:32  BLLBLLAttparam.cs

     文件       2846  2010-10-18 22:07  BLLBLLCompany.cs

     文件       3627  2010-10-18 22:07  BLLBLLDepartments.cs

     文件       2972  2010-12-18 14:40  BLLBLLHolidays.cs

     文件       5640  2010-12-29 21:03  BLLBLLLeaveClass.cs

     文件       6624  2010-12-26 14:47  BLLBLLMachines.cs

............此处省略696个文件信息