Dal/AdminUser.cs

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

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

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using US.Model;
using US.DBUtility;


namespace US.Dal
{
   public class AdminUser
    {
       public int AddAdmin(AdminUsersInfo g)
       {
          SqlParameter[] parameter;
          parameter = SQLHelper.GetCachedParameters("AddAdminUsers");
          if (parameter == null)
          {
              parameter = new SqlParameter[]{
               new SqlParameter("@flag",SqlDbType.Int,4),
               new SqlParameter("@i_AUd",SqlDbType.Int,4),
               new SqlParameter("@vc_AdminName",SqlDbType.VarChar,50),
               new SqlParameter("@vc_AdminPassword",SqlDbType.VarChar,50),
               new SqlParameter("@i_GId",SqlDbType.Int,4),
               new SqlParameter("@ret",SqlDbType.Int,4)
           };

              SQLHelper.CacheParameters("AddAdminUsers", parameter);
          }
          parameter[0].Value = 1;
          parameter[1].Value = 0;
          parameter[2].Value = g.Vc_AdminName;
          parameter[3].Value = g.Vc_AdminPassword;
          parameter[4].Value = g.I_GId;
          parameter[5].Direction = ParameterDirection.Output;
          SQLHelper.ExecuteNonQuery(SQLHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "AddAdminUsers", parameter);
          return Convert.ToInt32(parameter[5].Value);

       }

       public int UpdateAdmin(AdminUsersInfo g)
       {
           SqlParameter[] parameter;
           parameter = SQLHelper.GetCachedParameters("AddAdminUsers");
           if (parameter == null)
           {
               parameter = new SqlParameter[]{
               new SqlParameter("@flag",SqlDbType.Int,4),
               new SqlParameter("@i_AUd",SqlDbType.Int,4),
               new SqlParameter("@vc_AdminName",SqlDbType.VarChar,50),
               new SqlParameter("@vc_AdminPassword",SqlDbType.VarChar,50),
               new SqlParameter("@i_GId",SqlDbType.Int,4),
               new SqlParameter("@ret",SqlDbType.Int,4)
           };

               SQLHelper.CacheParameters("AddAdminUsers", parameter);
           }
           parameter[0].Value = 2;
           parameter[1].Value = g.I_AUd;