Smokewinetea.DAL/BackstagModelsDAL.cs

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

微信扫码关注公众号，代码整理好后第一时间通知你。

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

namespace Smokewinetea.DAL
{
    public class BackstagModelsDAL
    {
        /// <summary>
        /// 加载后台员工表
        /// </summary>
        /// <returns></returns>
        public static List<BackstagModels> BackstagModels()
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select BkgNumber,BkgId,BkgPwd,BkgName,BkgSex,BkgPhone,BkgAddress from Backstag");
            SqlDataReader dr = DbHelper.ExecuteReader(strSql.ToString());
            List<BackstagModels> Bkm = new List<BackstagModels>();
            BackstagModels bkm;
            while(dr.Read())
            {
                bkm = new BackstagModels();
                bkm.BkgNumber = Convert.ToInt32(dr[0]);
                bkm.BkgId = dr[1].ToString();
                bkm.BkgPwd = dr[2].ToString();
                bkm.BkgName = dr[3].ToString();
                bkm.BkgSex = dr[4].ToString();
                bkm.BkgPhone = dr[5].ToString();
                bkm.BkgAddress = dr[6].ToString();
                Bkm.Add(bkm);
            }
            dr.Close();
            DbHelper.ConClose();
            return Bkm;

        }

        /// <summary>
        /// 加载当前员工信息
        /// </summary>
        /// <param name="tj"></param>
        /// <returns></returns>
        public static List<BackstagModels> listback(string tj)
        {
            StringBuilder sql = new StringBuilder();
            sql.AppendFormat("select * from Backstag where BkgId='{0}'",tj);
            SqlDataReader dr = DbHelper.ExecuteReader(sql.ToString());
            List<BackstagModels> list = new List<BackstagModels>();
            BackstagModels back;
            while(dr.Read())
            {
                back = new BackstagModels();
                back.BkgNumber=Convert.ToInt32(dr[0]);
                back.BkgId=dr[1].ToString();
                back.BkgPwd=dr[2].ToString();
                back.BkgName=dr[3].ToString();