ZSJ_BCY_Web_DAL/StaffService.cs

（开头部分） 5KB

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

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

namespace ZSJ_BCY_Web_DAL
{
    public class StaffService
    {
        /// <summary>
        /// 查询 员工
        /// </summary>
        /// <param name="name">登录名</param>
        /// <param name="pwd">登录密码</param>
        /// <returns></returns>
        public static Staff Select(string name, string pwd)
        {

            string sql = "select * from Staff where StaffAccount=@StaffAccount and Staffpassword=@Staffpassword";
            SqlParameter[] pame = {
            new SqlParameter("@StaffAccount",name),
            new SqlParameter("@Staffpassword",pwd)
            };
            SqlDataReader reader = DBHelper.ExecuteReader(sql, pame);
            Staff staff = null;
            if (reader.Read())
            {
                staff = new Staff()
                {
                    Id = Convert.ToInt32(reader["Id"]),
                    StaffIdcard = Convert.ToString(reader["StaffIdcard"]),
                    StaffAccount = Convert.ToString(reader["StaffAccount"]),
                    Staffpassword = Convert.ToString(reader["Staffpassword"]),
                    StaffName = Convert.ToString(reader["StaffName"]),
                    StaffSex = Convert.ToInt32(reader["StaffSex"]),
                    StaffStatus = Convert.ToInt32(reader["StaffStatus"]),
                    StaffBirthday = Convert.ToDateTime(reader["StaffBirthday"]),
                    StaffEducation = Convert.ToString(reader["StaffEducation"]),
                    StaffPosition = Convert.ToInt32(reader["StaffPosition"]),
                    StaffSalary = Convert.ToDouble(reader["StaffSalary"]),
                    StaffTelePhone = Convert.ToString(reader["StaffTelePhone"])
                };

            }
            reader.Close();

            return staff;

        }

        /// <summary>
        /// 按照id查询
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public static Staff SelectIId(int id)
        {
后面还有 93 行代码，解锁后查看完整代码

24 小时内免费解锁 3 个项目，之后 1 积分/个。 规则说明

AI 解读

登录后可用，每次 10 积分，解读结果公开显示在下面。

还没有人解读过这个文件。