資源簡介
.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\fr
?????文件??????65024??2011-03-18?14:59??BLL\bin\Debug\fr
?????文件??????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\fr
?????文件??????58880??2011-01-09?23:27??BLL\bin\Release\fr
?????文件??????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個文件信息
- 上一篇:sonarqube-6.7.7
- 下一篇:機器視覺綜述
評論
共有 條評論