大岛仓库看板接口修改

yl

2022-10-25 4f86b3b78b5b638b486b497221a2f1c8fbab3ef6

 VueWebApi/Tools/DapperHelper.cs

@@ -514,13 +514,13 @@


        /// <summary>
        /// Dapper插入 返回自增主键Id
        /// Dapper插入 返回自增主键Id（备份）
        /// </summary>
        /// <param name="sql"></param>
        /// <param name="parameter"></param>
        /// <param name="tableName">待插入数据的表名</param>
        /// <returns></returns>
        public static int insertReturnId(string sql, Object parameter, String tableName)
        public static int insertReturnId0(string sql, Object parameter, String tableName)
        {

            int result = 0;
@@ -548,5 +548,38 @@
            }
            return result;
        }

        /// <summary>
        /// Dapper插入 返回自增主键Id
        /// </summary>
        /// <param name="tableName">待插入数据的表名</param>
        /// <returns></returns>
        public static int insertReturnId(String tableName)
        {

            int result = 0;
            using (IDbConnection conn = sqlConnection())
            {
                try
                {
                    if (result == 0)
                    {
                        result = conn.Query<int>("select ident_current(@table)", new { table = tableName }).Single<int>();
                    }
                }
                catch (Exception ex)
                {
                    //创建日志记录组件实例
                    LogHelper.WriteLog(ex);
                    throw ex;
                }
                finally
                {
                    conn.Dispose();
                    conn.Close();
                }
            }
            return result;
        }
    }
}