App_Code/DAL/dalCusUsers.cs

（开头部分） 8KB

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

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

namespace DAL
{   
    public class dalCusUsers
    {
        public static string sql = "";

        public static bool AddUsersInfo(ENTITY.CusUsers u1)
        {
            string sql = "insert into CusUsers(Customername,customerpwd ,Realname,CustomerSfz,address,telphone,IsCusAdmin,CusType) values(@Customername,@customerpwd,@Realname,@CustomerSfz,@address,@telphone,@IsCusAdmin,@CusType)";
            SqlParameter[] parm = new SqlParameter[] { 
             new SqlParameter("@Customername",SqlDbType.VarChar),
             new SqlParameter("@customerpwd",SqlDbType.VarChar),
             new SqlParameter("@Realname",SqlDbType.VarChar),
             new SqlParameter("@CustomerSfz",SqlDbType.VarChar),
             new SqlParameter("@address",SqlDbType.NVarChar),
             new SqlParameter("@telphone",SqlDbType.VarChar),
             new SqlParameter("@IsCusAdmin",SqlDbType.Int),
             new SqlParameter("@CusType",SqlDbType.Int)
            };
            parm[0].Value = u1.Customername;
            parm[1].Value = u1.customerpwd;
            parm[2].Value = u1.Realname;
            parm[3].Value = u1.CustomerSfz;
            parm[4].Value = u1.address;
            parm[5].Value = u1.telphone;
            parm[6].Value = u1.IsCusAdmin;
            parm[7].Value = u1.CusType;
            return (DBHelp.ExecuteNonQuery(sql, parm) > 0) ? true : false;
        }

        public static ENTITY.CusUsers getSomeUserInfo(int userid)
        {
            string sql = "select * from CusUsers where customerid="+ userid;
            SqlDataReader DataRead = DBHelp.ExecuteReader(sql, null);
            ENTITY.CusUsers tempUser = new ENTITY.CusUsers();
            while (DataRead.Read())
            {
                tempUser.customerid = Convert.ToInt32(DataRead["customerid"]);
                tempUser.Customername = DataRead["Customername"].ToString();
                tempUser.customerpwd = DataRead["customerpwd"].ToString();
                tempUser.Realname = DataRead["Realname"].ToString();
                tempUser.CustomerSfz = DataRead["CustomerSfz"].ToString();
                tempUser.address = DataRead["address"].ToString();
                tempUser.telphone = DataRead["telphone"].ToString();
                tempUser.IsCusAdmin = Convert.ToInt32(DataRead["IsCusAdmin"]);
                tempUser.CusType = Convert.ToInt32(DataRead["CusType"]);
            }
            return tempUser;

        }

        public static bool EditUsersInfo(ENTITY.CusUsers u1)
后面还有 123 行代码，购买后查看完整代码

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

AI 解读 AI

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

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