Smokewinetea.DAL/MemberDAL.cs

（开头部分） 8KB

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

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

namespace Smokewinetea.DAL
{
   public class MemberDAL
    {
        /// <summary>
        /// 加载
        /// </summary>
        /// <returns></returns>
       public static List<MemberModelscs> ConnectionModel()
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select MemberName,MenberId1,MemberId2,MemberSex,MemberPhone,Corporation,Location,Ranks,Integratet,Frequency from Member");
            SqlDataReader dr = DbHelper.ExecuteReader(strSql.ToString());
            List<MemberModelscs> mem = new List<MemberModelscs>();
            MemberModelscs sta;
            while (dr.Read())
            {
                sta = new MemberModelscs();
                sta.MemberName = Convert.ToString(dr[0]);
                sta.MenberId1 = Convert.ToInt32(dr[1]);
                sta.MemberId2 = Convert.ToString(dr[2]);
                sta.MemberSex = dr[3].ToString();
                sta.MemberPhone = dr[4].ToString();
                sta.Corporation = Convert.ToString(dr[5]);
                sta.Location = Convert.ToString(dr[6]);
                sta.Ranks = Convert.ToString(dr[7]);
                sta.Integratet = Convert.ToInt32(dr[8]);
                sta.Frequency = Convert.ToInt32(dr[9]);
                mem.Add(sta);

            }
            dr.Close();
            DbHelper.ConClose();
            return mem;
        }



       /// <summary>
       /// 添加
       /// </summary>
       /// <param name="staff"></param>
       /// <returns></returns>
       public static int Membertinser(MemberModelscs staff)
       {

           StringBuilder sql = new StringBuilder();
           sql.Append("insert into Member  values(@MemberName,@MemberId2,@MemberSex,@MemberPhone,@Corporation,@Location,@Ranks,@Integratet,@Frequency)");
           SqlParameter[] sta = {//@MenberId1
                                    
                                    new SqlParameter("MemberName",SqlDbType.VarChar,50),
                                    new SqlParameter("MemberId2",SqlDbType.VarChar,50),
后面还有 157 行代码，解锁后查看完整代码

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

AI 解读 AI

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

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