HotelDAL/UserInfo.cs

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

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

using System;
using System.Collections.Generic;
using System.Text;
using HotelModels;
using System.Data;
using System.Data.SqlClient;

namespace HotelDAL
{ 
    public class UserInfo
    {
        //添加一条数据
        public void Add(HotelModels.UserInfo one)
        {
            string sqlstr = "insert into UserInfo(LoginName,LoginPass,UserName,Remark) values ('"+one.LoginName+"','"+one.LoginPass+"','"+one.UserName+"','"+one.Remark+"')";
            DBHelper.ExecuteNonQuery(sqlstr, CommandType.Text, null);
        }

        //修改一条数据
        public void Update(HotelModels.UserInfo one)
        {
            string sqlstr = "update UserInfo set LoginName='" + one.LoginName + "',LoginPass='" + one.LoginPass + "',UserName='" + one.UserName + "',Remark='" + one.Remark + "' where UserId='"+one.UserId+"'";
            DBHelper.ExecuteNonQuery(sqlstr, CommandType.Text, null);
        }
        //删除一条数据
        public void Delete(HotelModels.UserInfo one)
        {
            string sqlstr = "delete UserInfo  where UserId='" + one.UserId + "'";
            DBHelper.ExecuteNonQuery(sqlstr, CommandType.Text, null);
        }

        //通过Id获得一条数据(实体对象)

        public HotelModels.UserInfo GetModelById(int Id)
        {
            string sqlstr = "select * from UserInfo where UserId="+Id;
            DataTable dt = DBHelper.ExecuteGetDataTable(sqlstr, CommandType.Text, null);
            if (dt.Rows.Count > 0)
            {
                HotelModels.UserInfo one = new HotelModels.UserInfo();
                one.UserId = int.Parse(dt.Rows[0]["UserId"].ToString());
                one.LoginName = dt.Rows[0]["LoginName"].ToString();
                one.LoginPass = dt.Rows[0]["LoginPass"].ToString();
                one.UserName = dt.Rows[0]["UserName"].ToString();
                one.Remark = dt.Rows[0]["Remark"].ToString();
                return one;
            }
            else
            {
                return null;
            }
        }

        //根据条件获取分页数据
        public DataTable GetList(int pageSize, int pageIndex, string fldSort, bool Sort, string strCondition, out int pageCount, out int Counts)
        {
            string strSql;
            DataTable dt = DBHelper.PageList("UserInfo", null, pageSize, pageIndex, fldSort, Sort, strCondition, "UserId", false, out pageCount, out Counts, out strSql);
            return dt;
        }