• 大小: 56.16MB
    文件类型: .rar
    金币: 2
    下载: 1 次
    发布日期: 2022-09-08
  • 语言: 其他
  • 标签: 源码  

资源简介

.net人事考勤管理系统新版源码 .net人事考勤管理系统新版源码 .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(“\0“))
                {
                    Name = Name.Substring(0 Name.IndexOf(“\0“));
                }
                string cmdText = “AddDownUserInfo“;
                cmd.Connection = new SqlConnection(AppSettings.GetConString());
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.CommandT

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

     文件      52224  2011-03-18 14:59  BLL\bin\Debug\BLL.dll

     文件      83456  2011-03-18 14:59  BLL\bin\Debug\BLL.pdb

     文件      10240  2011-03-18 14:59  BLL\bin\Debug\DataAccess.dll

     文件      24064  2011-03-18 14:59  BLL\bin\Debug\DataAccess.pdb

     文件     946176  2007-08-29 19:37  BLL\bin\Debug\Excel.dll

     文件      23040  2011-03-18 14:59  BLL\bin\Debug\framework.dll

     文件      65024  2011-03-18 14:59  BLL\bin\Debug\framework.pdb

     文件      64088  2007-10-10 09:48  BLL\bin\Debug\Microsoft.Vbe.Interop.dll

     文件      25600  2011-03-18 14:59  BLL\bin\Debug\Model.dll

     文件     108032  2011-03-18 14:59  BLL\bin\Debug\Model.pdb

     文件     223800  2007-10-10 09:48  BLL\bin\Debug\office.dll

     文件      49664  2011-01-11 22:18  BLL\bin\Release\BLL.dll

     文件      85504  2011-01-11 22:18  BLL\bin\Release\BLL.pdb

     文件       9216  2011-01-09 23:29  BLL\bin\Release\DataAccess.dll

     文件      22016  2011-01-09 23:29  BLL\bin\Release\DataAccess.pdb

     文件     946176  2007-08-29 19:37  BLL\bin\Release\Excel.dll

     文件      21504  2011-01-09 23:27  BLL\bin\Release\framework.dll

     文件      58880  2011-01-09 23:27  BLL\bin\Release\framework.pdb

     文件      64088  2007-10-10 09:48  BLL\bin\Release\Microsoft.Vbe.Interop.dll

     文件      23040  2011-01-09 23:29  BLL\bin\Release\Model.dll

     文件     105984  2011-01-09 23:29  BLL\bin\Release\Model.pdb

     文件     223800  2007-10-10 09:48  BLL\bin\Release\office.dll

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

     文件      26433  2011-01-12 22:02  BLL\BLLAttLog.cs

     文件       1254  2010-10-23 21:32  BLL\BLLAttparam.cs

     文件       2846  2010-10-18 22:07  BLL\BLLCompany.cs

     文件       3627  2010-10-18 22:07  BLL\BLLDepartments.cs

     文件       2972  2010-12-18 14:40  BLL\BLLHolidays.cs

     文件       5640  2010-12-29 21:03  BLL\BLLLeaveClass.cs

     文件       6624  2010-12-26 14:47  BLL\BLLMachines.cs

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

评论

共有 条评论