Dal/BusinessUsersManage.cs

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

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

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

namespace US.Dal
{
  public  class BusinessUsersManage
    {
      public int BusinessUsersAdd(BusinessUsersInfo g)
      {
          SqlParameter[] parameter;
          parameter = SQLHelper.GetCachedParameters("AddBusinessUsers");
          if (parameter == null)
          {
              parameter = new SqlParameter[] { 
                  new SqlParameter("@flag",SqlDbType.Int,4),
                  new SqlParameter("@i_BUId",SqlDbType.Int,4),
                  new SqlParameter("@vc_BUName",SqlDbType.VarChar,20),
                  new SqlParameter("@vc_BUPassWord",SqlDbType.VarChar,20),
                  new SqlParameter("@vc_Mobile",SqlDbType.VarChar,20),
                  new SqlParameter("@vc_BusinessName",SqlDbType.VarChar,50),
                  new SqlParameter("@vc_BAddress",SqlDbType.VarChar,100),
                  new SqlParameter("@vc_BIb",SqlDbType.VarChar,100),
                  new SqlParameter("@vc_BQuality",SqlDbType.VarChar,50),
                  new SqlParameter("@vc_BCity",SqlDbType.VarChar,50),
                  new SqlParameter("@vc_Manager",SqlDbType.VarChar,20),
                  new SqlParameter("@vc_Phone",SqlDbType.VarChar,20),
                  new SqlParameter("@vc_Email",SqlDbType.VarChar,50),
                  new SqlParameter("@dt_TaTime",SqlDbType.DateTime,8),
                  new SqlParameter("@vc_introduce",SqlDbType.VarChar,1000),
                  new SqlParameter("@vc_Web",SqlDbType.VarChar,50),
                  new SqlParameter("@ret",SqlDbType.Int,4)
              };
              SQLHelper.CacheParameters("AddBusinessUsers", parameter);
          }
          parameter[0].Value = 1;
          parameter[1].Value = 0;
          parameter[2].Value = g.Vc_BUName;
          parameter[3].Value = g.Vc_BUPassWord;
          parameter[4].Value = g.Vc_Mobile;
          parameter[5].Value = g.Vc_BusinessName;
          parameter[6].Value = g.Vc_BAddress;
          parameter[7].Value = g.Vc_BIb;
          parameter[8].Value = g.Vc_BQuality;
          parameter[9].Value = g.Vc_BCity;
          parameter[10].Value = g.Vc_Manager;
          parameter[11].Value = g.Vc_Phone;
          parameter[12].Value = g.Vc_Email;
          parameter[13].Value = g.Dt_TaTime;
          parameter[14].Value = g.Vc_introduce;
          parameter[15].Value = g.Vc_Web;
          parameter[16].Direction = ParameterDirection.Output;
          SQLHelper.ExecuteNonQuery(SQLHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "AddBusinessUsers", parameter);
          return Convert.ToInt32(parameter[16].Value);
      }
      public int BusinessUsersupdate(BusinessUsersInfo g)