LK.WXAD.Dals/GetMaxID.cs

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

using Microsoft.ApplicationBlocks.Data;
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace LK.WXAD.Dals
{
    public partial class GetMaxID
    {
        public string sqlConnectionString = LK.WXAD.SqlConn.SqlConn.SqlConnectionString();

        /// <summary>
        /// 获取MaxID
        /// </summary>
        /// <param name="fieldName"></param>
        /// <param name="tableName"></param>
        /// <returns></returns>
        public int GetID(string fieldName, string tableName)
        {
            return GetID(fieldName, tableName, null);
        }

        /// <summary>
        /// 获取MAXID，带事物
        /// </summary>
        /// <param name="fieldName"></param>
        /// <param name="tableName"></param>
        /// <param name="trans"></param>
        /// <returns></returns>
        public int GetID(string fieldName, string tableName, SqlTransaction trans)
        {
            SqlParameter[] parameters = {
                    new SqlParameter("@TableName", SqlDbType.VarChar,100)   ,
                    new SqlParameter("@IDName", SqlDbType.VarChar,100) ,
                    new SqlParameter("@MaxID", SqlDbType.Int,4) ,
                                        };
            parameters[0].Value = tableName;
            parameters[1].Value = fieldName;
            parameters[2].Direction = ParameterDirection.Output;
            object o;
            if (trans == null)
            {
                o = SqlHelper.ExecuteNonQuery(sqlConnectionString, CommandType.StoredProcedure, "P_GetMaxID", parameters);
            }
            else
            {
                o = SqlHelper.ExecuteNonQuery(trans, CommandType.StoredProcedure, "P_GetMaxID", parameters);
            }
            int maxID = int.Parse(parameters[2].Value.ToString());
            return maxID;
        }
    }
}