Business/UsersBusiness.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using Entity;
using Business;
using DBAccess;
namespace Business
{
    public class UsersBusiness
    {

        public int InsertUsers(UsersEntity usersEntity)
        {
            string[] paraNames = { "@id", "@username", "@password", "@realname", "@sex", "@birthday", "@contact", "@address", "@regdate" };
            object[] paraValues = { usersEntity.Id, usersEntity.Username, usersEntity.Password, usersEntity.Realname, usersEntity.Sex, usersEntity.Birthday, usersEntity.Contact, usersEntity.Address, usersEntity.Regdate };
            object obj = Operations.ExecuteSQL("[sp_insert_Users]", CommandType.StoredProcedure, paraNames, paraValues);
            return Convert.ToInt32(obj);
        }

        public int DeleteUsersById(string id)
        {
            string[] paraNames = { "@id" };
            object[] paraValues = { id };
            object obj = Operations.ExecuteSQL("[sp_delete_Users]", CommandType.StoredProcedure, paraNames, paraValues);
            return Convert.ToInt32(obj);
        }

        public int UpdateUsers(UsersEntity usersEntity)
        {
            string[] paraNames = { "@id", "@username", "@password", "@realname", "@sex", "@birthday", "@contact", "@address", "@regdate" };
            object[] paraValues = { usersEntity.Id, usersEntity.Username, usersEntity.Password, usersEntity.Realname, usersEntity.Sex, usersEntity.Birthday, usersEntity.Contact, usersEntity.Address, usersEntity.Regdate };
            object obj = Operations.ExecuteSQL("[sp_update_Users]", CommandType.StoredProcedure, paraNames, paraValues);
            return Convert.ToInt32(obj);
        }

        public DataSet getALLUsers(string tableName)
        {
            string[] paraNames = { };
            object[] paraValues = { };
            DataSet ds = Operations.GetDataSet("[sp_query_Users]", CommandType.StoredProcedure, tableName);
            return ds;
        }

        public UsersEntity getUsersById(string id)
        {
            string[] paraNames = { "@id" };
            object[] paraValues = { id };
            object[] obj = Operations.GetValues("[sp_query_UsersByID]", CommandType.StoredProcedure, paraNames, paraValues);
            UsersEntity usersEntity = new UsersEntity();
            usersEntity.Id = obj[0].ToString();
            usersEntity.Username = obj[1].ToString();
            usersEntity.Password = obj[2].ToString();
            usersEntity.Realname = obj[3].ToString();
            usersEntity.Sex = obj[4].ToString();
            usersEntity.Birthday = obj[5].ToString();
            usersEntity.Contact = obj[6].ToString();
            usersEntity.Address = obj[7].ToString();
            usersEntity.Regdate = obj[8].ToString();